+92 (51) 8480360

Advanced Excel

The purpose of this course is provide students the necessary skills to use MS Excel in the workplace as an analysis
Course Info

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.

Course Detail:

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:

  • Protecting data
  • Circular references
  • Range names
  • Functions
  • Data Validation
  • What-if analysis tools
  • Importing data
  • Workbook linking
  • Data consolidation
  • Exporting Data
  • Pivot table reports
  • Pivot Charts
  • Macros

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.