The purpose of this course is provide students the necessary skills to use MS Excel in the workplace as an analysis and presentation tool, above and beyond the average skill level of most users, thus making the student a more attractive candidate in the job market. Those interested in Excel as an advanced analytical tool can attend this course.
This course exposes several advanced features of Excel for What-if analysis, database analysis and how to build calculations using advanced functions as well as how to automate processes.
The topics covered in this course will be:
Pre-requisite for course is students will need to be familiar with all the topics of Microsoft Excel Intermediate course.
The learning outcomes of this course are Build complex calculations with advanced functions, Link, export and consolidate data, Limit data entry and build complex models with Lookup functions, Analyze data with simple PivotTables and PivotCharts, Create and modify Macros, View, arrange and import data from other sources, Leverage the power of formulae for data analysis, Protect data and forms, Create and run macros to automate number-crunching, Perform other Excel tasks and tricks that are useful in the business world.