604, Al Falah Tower, Near Al Falah Plaza, Al Falah Street, Abu Dhabi.

+971 56 664 8104

Advanced Excel

Advanced Excel
Microsoft Advanced Excel Training course has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering, and financial needs. In addition, it can display data as line graphs, histograms, and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager).

Annex Training Institute in Abu Dhabi providing advance excel course by teaching valuable tips and tricks; enhance your skills with applied spreadsheet, calculation, graphing tools, pivot tables, and a macro-programming or Visual Basic for Applications language. Advanced excel course is for all kind of professionals those who is looking to increase their quality productivity with advanced functions, calculation, graphing tools, pivot tables, formulas, VBA, and data process.

Course Overview

Course Content:

Microsoft Advanced excels training course content will cover the below portions:

Content of the course includes:

Understanding Excel files and Templates
Using Formulas for Common Mathematical Operations
Working with Formulas and Functions
Using Formulas for Matching and Lookups
Using Formulas for Financial Analysis
Using Advance Charting Techniques
Using Formulas with Tables and Conditional Formatting
Linking and Consolidating Worksheets
Analyzing Data with PivotTables
Transforming Data with Power Query
Managing and Analyzing Data
Enable and Examine Macros
Introducing Visual Basic for Applications
Understanding Power Pivot and Power Query
Visualizing with Custom Number Formats and Shapes
Importing and Cleaning Data
Printing Your Work


Course Duration is 40 Hours, which can be completed by 20 Days.

Take the right step,
do the big things.

Experienced Trainers
Satisfied Students
Flexible Timing

The Flexible Working Hours
Policy allows students of a
any category.

Individual Attention

We are giving individual
learning and individual
attention of every students.

Affordable Fees

Our fee structure is very less
compare to other training

Experienced Trainers

Authorized Trainers are
appropriately qualified,
skilled in teaching.

Sign up for email alerts

Stay current with our latest insights

© Copyright 2020 Annex Training Institute.