Advanced Excel
Sponsored links
By the end of this workshop, course attendees will have gained confidence in some of the more advanced features of Excel, such as Macros, Pivot Tables, Consolidations and more.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
This course covers:
Autofill
Error-trapping (IS functions)
Advanced Filters
Outlining
IF statements
Nested functions
Advanced text and data manipulation
Protecting Cells, Worksheets and Workbooks
Auditing Worksheet Content
Pivot Tables and Pivot Charts
Consolidating Worksheet Data
Error Trapping (IS Function)
IF Functions and Nested Functions
Data and Text Manipulation
Advanced Hints & Tips
