With new chart types and improvements to PivotTables and business intelligence, Microsoft Excel 2016 makes it easier to work with large amounts of data and give it even more meaning. Unlock insights, and tell the story in your data by organizing it in spreadsheets (workbooks). View your data in context, and use the analytic capabilities of Microsoft Excel to make more informed decisions.
Target Audience:
This course is intended for delegates who want to learn the fundamentals skills of working with Microsoft Excel 2016, such as creating, editing, and formatting documents; inserting and formatting tables and creating charts; Creating formulas and functions; and employing a variety of techniques for improving the appearance and accuracy of an Excel spreadsheet.
The course then moves on to cover some of the more advanced features such as IF, VLOOKUP, and Power Function; Pivot Tables; Data Management and Analysis Tools as well as macros.
On successful completion of the course learners will receive an attendance certificate as well as a transcript on what was covered.