|
Learn how to use advanced functions of Excel® 2010 to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work. |
Course Outline |
|
Working with Custom and Conditional Formats |
|
Using Formulas and Functions |
|
Working with Range Name |
|
Using Advanced Functions |
|
Managing Tables |
|
Using Auto Filter |
|
Getting Most from your Data |
|
Working with Carts |
|
Working with Pivot Tables |
|
Creating and Using Shared Workbooks |
|
Working with Worksheet Protection |
|
Working with Multiple Workbooks |
|
Working with Macros |
|
Scenarios in Excel 2010 (Optional) |
|
|
|
Learn Excel easily in 2 days, hands-on workshop that will make your work you work faster, efficiently, and you will be able to do complex tasks in a matter of minutes or seconds. |
Course Outline |
|
Getting Started with Excel 2010 |
|
Managing Rows & Columns |
|
Managing Worksheets |
|
Formatting the Cell |
|
Working with Formulas and Functions |
|
Managing Tables |
|
Organizing Worksheet and Table Data |
|
Working with Charts |
|
Working with Graphics |
|
Managing Large Workbook |
|
Customizing & Enhancing Workbooks |
|
Finalizing your Workbook |
|
|