|
Learn how to use advanced functions of Excel® 2007 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 2007 (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 |
|
Excel Basics |
|
Editing Your Workbook |
|
Printing and Viewing your Workbook |
|
Advanced File Tasks |
|
Working with Functions and Formulas |
|
Managing Tables |
|
Enhancing your Workbook |
|
Finalizing your Workbook |
|
|
|