|
Learn how to use Advanced functions of Excel 2013 to improve productivity with Lookup Functions, 2-Axis charts, Macros, Formulas & streamline your operational work. |
Advanced Excel 2013 Outline |
|
Working with Advanced Formatting |
|
Advanced Formulas & Functions |
|
Lookup (Vloopup, Hlookup) |
|
2 Axis Charts, Adv Chart Formatting |
|
Advanced Sorting, Custom Filtering |
|
Using Advanced Filtering Tricks |
|
Advanced Charting Options |
|
Summarizing With Pivot Tables |
|
Using Shared Workbooks |
|
Working with Worksheet Protection |
|
Working with Macros |
Learn Advanced Excel 2013 Features |
|
|
|
Learn Excel 2013 easily in 2 days, hands-on workshop that will improve your Excel Skills, Enhance Productivity, Efficiency & you will be able to do complex tasks in a matter of minutes. |
Basic Excel 13 Course Outline |
|
Editing Your Workbook |
|
Formulas - AutoSum, Check Errors |
|
Printing and Viewing your Workbook |
|
Multiple Worksheets |
|
Working with Functions and Formulas |
|
Formatting the Cells & Tables |
|
Functions and Addressing |
|
Formatting Charts |
|
Learn New Features of Excel 2013 |
|
|
|