Excel 2016 on Steroids e-learning

Directors, managers, and anyone else who uses MS Excel extensively for report writing, will benefit from this training.

This training will give you the tools and techniques required to utilize MS Excel to its full potential and beyond! It includes training on consolidating worksheets, data capturing by using the data validation function, understanding the definitions and layout of pivot tables, as well as creating formulae withing pivot tables.

Course outline:

• Data Analysis
• Sorting, Subtotaling and Filtering data
• Data Validation
• What If Data Analysis
• Forecast Sheet
• Macros
• Formulas and Functions
• Data consolidation
• Conditional formatting
• Managing and preparing data
• Lookup, Text and Logical functions
• Statistical and Mathematical functions
• PivotTables and Pivot Charts
• PivotTable Basics
• Formatting a PivotTable
• Calculated Items and Fields
• Sort and filter a PivotTable
• Consolidated PivotTable

This is a course created by Sage Intelligence Instructional Designers.

The certifications are not accredited, and we offer it on the basis of front-end financial reporting of our Sage Accounting software.