Excel 2010 for Accountants and Business Professionals

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.

Accountants, senior accountants, business analysts, accounting and finance professionals, supervisors, general business professionals and staff from any function who need to learn and apply state-of-the-art reporting techniques to their daily business reporting, reconciliations, and analysis. This program is worth 25 NASBA CPEs.

Certificate

By the end of the program, participants will be able to:

• Boost Excel reporting expertise in business, finance, and accounting.
• Perform automated reconciliation for speedy weekly and monthly reporting.
• Design and create calculated columns using the new 2010 Data Analysis Expressions tool.
• Control multiple Pivot Table elements on one worksheet using the new 2010 slicer tool.
• Apply data reporting techniques to real-life business situations.
• Link their Excel with PowerPoint for dynamic data update.
• Use macros to perform repetitive tasks and generate reports.

Global economics proves to us on a daily basis the organisational need for ‘fore-most’ and ‘leading’ talent in order to succeed in increasingly complex and competitive global markets. In order to achieve the ‘best’ possible result for organizations, developing the right talent is as much a necessity as hiring and retaining employees.

Who are we?

ZOE Talent Solutions is a global training and consulting firm that has been serving leading businesses in many countries. We specialise in capacity building and talent development solutions for individuals and organisations, through our highly customised courses and training sessions, in a wide array of disciplines.

What do we do?

ZOE assists organisations in identifying their most important goals, and guides management teams by working closely with each member, in making lasting improvements to their performance. This process thus promises a definite increase in revenue and savings and a higher Return On Investment (ROI). Over nearly a decade, our team has built a globally recommendable enterprise uniquely equipped skills including and not limited to coaching, facilitation , counselling and strategising.