Advanced Excel With Dashboard Analysis

Business professionals are frequently required to prepare management reports scorecards and dashboards. We will equip you with the required Excel skills to help you produce such reports with ease. You will not only learn practical advanced skills which will help increase their productivity you will also be enhancing their value as finance professionals. You will also learn to identify and sort various data into a useful business presentation - Dashboard. You will understand what data is and why it is important and maximize its value using analytic applications. From this course you will improve your decision making processes via analytic and predictive analysis. You will learn about the visual displaying of data combining aesthetics data visualization charts structure functionality and real life examples of good and bad designed dashboards.

Adults

Certificate Awarded

Dashboard Reporting. Advanced Formatting Techniques. Excel New Feature: Sparklines. Chartless Visualization Techniques. Advanced Charting Techniques. Processing the Data Model. Enhancing Interactivity. Automating Reports. Pivot Tables. Building the Dashboard. Summarizing and Analyzing Large Data. Conditional Formatting. Advanced Charts and Graphs. Pivot Tables. What-IF Analysis. Data Validation. Enhancing Interactivity. Automating Reports. Introduction to Spreadsheets and Its Terminology. Formatting Techniques. Working with Dates and Time.

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.