Advanced Excel Techniques, Pivot Tables & Macros

by Accountants And Auditors Association

Advanced Excel is a must- learn and the most requested topic for most finance professionals as in some point of your career

AED 2500

Contact the Institutes

Fill this form
Accountants And Auditors Association Logo

img Duration

Upto 3 Days

Course Details

Advanced Excel is a must- learn and the most requested topic for most finance professionals as in some point of your career, you will have to deal with big data and offer solutions to problems which cannot be solved through basic excel knowledge.

In this course, we will be covering advanced excel areas such as Power Pivots and automating excel reports through the use of Macros. The knowledge gap between this course and anyone who already has basic knowledge in working with excel will uncover a professional who can analyze meaningful data and automate excel reports which is not just productive, but also a part of modernized and well-planned management reporting process.

We aim to create and develop all rounded finance professionals who will be smart and self-sufficient in creating and presenting management reports in a competitive age of Information Technology.


A key function is to prepare data for the pivot table.
- Creating and customizing within pivot tables
- Performing calculations 
within a pivot table
- Advanced techniques
- The new world of
Power Point

Benefits Of Attending:

AAA Certificate of Completion will be awarded to the participants along with CPD credits.
Analyze big data tables using the latest excel feature of Data Model and Power Pivot
Apply key excel functions to prepare data for analysis using Power Pivot
Create and customize pivot tables to reconcile and analyze accounts efficiently.
Use advanced excel techniques in data analysis and reporting and run macros to speed up work.

Who Should Attend:

- Senior and Junior Accountants
Accounting and finance professionals
Business Analysts
Research professionals and anyone who need to master and upgrade their skills in excel pivot tables, macros and working with big data.

Special Message

We are Federal Chartered Accountancy Body of UAE.

AAA, The Accountants & Auditors Association (AAA) is the national accountancy body of the United Arab Emirates. It is a not-for-profit organization which has taken keen strategic steps to develop and helped in growing the finance and accountancy profession across UAE. It follows the best global practices and works actively with several authorities to propose accounting and auditing standards in the country.


Accountants And Auditors Association was established in 1997 with an ambition to build the capacity of the national accountancy and finance profession across UAE. 

  • Al Qasba Branch

    Block-F ,3rd Floor, Al Qasba, Sharjah

Check out more MS Excel courses in UAE

Premier Genie FZ LLC Logo

Performing Basic to Advanced (MS Excel)

These sessions focus on teaching you about Performing Basic to Advanced by using MS Excel. It covers a wide array of topics assisted by many assignment and homework tasks to make the learning and practice process more in-depth.

by Premier Genie FZ LLC
MyCampus Institute of Management and Technology Logo

Excel Advanced

This course is designed for those with experience of working regularly with Excel's spreadsheets and wish to understand and adopt the most complex tools and functions in order to increase their knowledge and productivity.

by MyCampus Institute of Management and Technology
Ace it Training Logo

Microsoft Office Word Advanced

This is an advanced MS Word training course designed to give you knowledge of more complex features and options of MS Word. You will learn about hyperlinks, references, using Macros, mail merging and much more.

by Ace it Training
Lynchpin Financial Training Centre Logo

Microsoft PowerPoint

This course will teach you about making presentation slides with sections to address advanced charting techniques and complex diagrams. You will learn about adding smartArt and multimedia to different presentations, creating stylish presenta

by Lynchpin Financial Training Centre
  • Price
  • Start Date
  • Duration
Delphi Star Training Institute Logo

Basic Microsoft Excel (Online Video)

At the end, a certificate will be provided to you from Delphi Star recognizing your achievement with the software and showing your grade hence specifying your mastery level at it. You will be taught about different skills and techniques to w

by Delphi Star Training Institute
  • Price
  • Start Date
  • Duration

© 2024 All Rights Reserved. Terms and Conditions of use | Privacy Policy