All business professionals are required to prepare some kind of a scorecard or a dashboard. Attending this course will help you reach advanced levels in Excel which you will need to produce such an important tool.. The course starts with pivot tables, the most important tool ever created to perform data reporting, analysis and reconciliation. It then continues with high level modeling techniques, integration and report visualization, and it ends with automation. You will take away practical tools that are guaranteed to add value to your daily and periodic tasks.
15% of the course is theory based. 85% uses MS Excel as a powerful tool to design and prepare dynamic business dashboards and scorecards. Groups and individuals will be required to complete exercises, case studies and projects on a daily basis.
Accountants, finance analysts, senior and junior accountants, business analysts, accounting and finance professionals, research professionals, marketing and sales, administrative staff, supervisors, general business professionals and staff from any function who need to learn and apply state-of-the-art techniques to their daily business reporting, reconciliations, and analysis. Pre-requisite: Intermediate level Excel knowledge or attendance of Meirc’s Next Generation Excel course.
This is a hands-on training course using laptops which will be made available by Meirc for the duration of the training. For courses outside the UAE, participants will be required to bring their own laptops with a fully working version of Microsoft Excel 2010/2013.
National Association of State Boards of Accountancy (NASBA) : Meirc Training & Consulting is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website www.learningmarket.org