Advanced Excel Techniques Pivot Tables And Macros

UAE, Sharjah
Dates flexible (4 days)
Course Type
Professional Training Course
Yes (Details)
Course Fee

Course Overview

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 use of Macros. The knowledge gap between this course and anyone who already has a 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.

Who should take this course



Certificate Awarded

Course content

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

About Course Provider

The Accountants & Auditors Association (AAA) is the national accountancy body of the United Arab Emirates. We are a not-for-profit organization and have Undertaken Key strategic initiatives to develop the accountancy and finance profession in the country. The Association was established in 1997 through a federal mandate with the key objective of building capacity of the national accountancy and finance profession in line with best global practices and standard. We actively work with related authorities to propose the accounting and auditing standards in the country , suggest new regulatory standards for the profession. We deploy the highest standards of ethical and professional conduct to our members.

AAA's mission is to serve our members, the profession and society. We support the Ministry of Economy ‘s vision of achieving 100 professionally qualified UAE nationals in the field of accounting practice by the year 2021. Our core values are: credibility and transparency, professionalism, continuing professional development, effective relationship and partnership management, and community & public service.

How to enroll?

Provide us with your contact details, course provider will get back to you.

A representative from Accountants and Auditors Association will contact you soon.