Advanced Microsoft Excel

Advanced Microsoft Excel Training Course Summary

Advanced Microsoft Excel 2016 training course is conceptualized to build the skills required to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. By using its advanced features like formulas, you can crunch data, analyze and get simple solutions to most complex questions.


Advanced Microsoft Excel Training Course Objective

The purpose of this course is provide students the necessary skills to use Advanced functions of 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  more effective in thier workplace and also an attractive candidate in the job market.

Who Can Benefit from Advanced Microsoft Excel Training Course Outline

  • Anyone who has intermediate skills with Microsoft Excel who wants to learn more advanced skills
  • Students who want to learn the topics covered in this course in the 2016 interface

Advanced Microsoft Excel Training Course Outline

Module 1: Creating Advanced Formulas

  • Use Range Names in Formulas
  • Use Specialized Functions
  • Use Array Formulas

Module 2: Analyzing Data with Functions and Conditional Formatting

  • Analyze Data by Using Text and Logical Functions
  • Apply Advanced Conditional Formatting

Module 3: Organizing and Analyzing Datasets and Tables

  • Create and Modify Tables
  • Sort Data
  • Trimming of Data
  • Filter Data
  • Use of Subtotal and Groups

Module 4: Visualizing Data with Basic Charts

  • Create Charts
  • Modify and Format Charts

Module 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with Pivot Charts
  • Filter Data by Using Slicers

Module 6: Working with Multiple Worksheets and Workbooks Simultaneously

  • Use 3-D References
  • Use Links and External References
  • Consolidate Data

Module 7: Sharing and Protecting Workbooks

  • Protect Worksheets and Workbooks

Module 8: Automating Workbook Functionality

  • Apply Data Validation
  • Work with Forms and Controls
  • Work with Macros
  • Indirect Functions

Module 9: Applying Conditional Logic

  • Use Lookup Functions
  • V-Lookup and H-Lookup
  • Nesting of Functions

Module 10: Auditing Worksheets

  • Trace Cells
  • Search for Invalid Data and Formulas with Errors Watch and Evaluate Formulas

Module 11: Using Automated Analysis Tools

  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature

Module 12: Presenting Your Data Visually

  • Use Advanced Chart Features
  • Create Sparklines

Module 13: Customizing the Excel Environment

  • Configure Excel Options
  • Customize the Ribbon and the Quick Access Toolbar
  • Enable Excel Add-Ins

Coporate Clients

Contact Us

Suite #101, AL-Tawhidi 1 Building, Next to ADCB Bank, Bank Street, Khaled Bin Waleed Road, Bur Dubai - Dubai. U.A.E. P.O.Box: 94743 Dubai, UAE

Follow Us

News & Events

Professional training on FICO, MM, SD, HR modules covering Basic Inter...

Read More

Join now the advance level courses and get trained with our industry e...

Read More

Do you have desire to work, study or migrate to English Speaking Count...

Read More

Locate Us