Why Attend
The fact is that Excel is the accountant's, finance and business professional's best friend. Companies everywhere are overwhelmed by the abundance of unstructured and unclean data. Monthly, quarterly and annual closings are immensely data driven and require moving and exporting data from 'ERPs' and databases to Excel. This hands-on course will advance your data massaging, modeling, integration and automation skills to new levels. You will also master normalization and massaging of noisy data, preparation of reports, analysis and reconciliation.
This is an Excel-based course that will help you develop an exclusive level of expertise that adds immediate value to your job and company.
Course Methodology
20% of the course is ‘design and structure’ focused while 80% uses MS Excel as a powerful tool to perform daily, monthly and periodic tasks. Groups and individuals will be required to complete exercises, case studies, and projects on a daily basis.
Course Objectives
By the end of the course, participants will be able to:
Apply Excel reporting expertise in business, finance, and accounting by enhancing data slicing and dicing, data massaging, and data analysis skills Use pivot tables and pivot charts to perform automated report writing, analysis and reconciliation most efficiently Develop special flash and management reports by linking-up Excel with Access, web, text, SQL, and other databases Repeat tasks and generate reports efficiently by recording, running and editing macros Acquire numerous tips and tricks that will improve working efficiency
Target Audience
Business, finance and accounting professionals, senior and junior accountants, business analysts, research professionals, marketing and sales professionals, 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.
Target Competencies
Reporting, analysis, and reconciliation
Data modeling
Integration with external data sources
Automation and macros
Massaging of unstructured and noisy data
Course Outline
Data massaging: tools and techniques
INFORMATECH is the region’s leading provider of in-house custom-designed courses. We have been tailoring in-house solutions for our clients aimed at helping them achieve short term training wins or long term strategic requirements. In addition to being significantly cost effective, these courses are constantly in demand because they:
If you did not find the appropriate date or venue suitable for you, or you would like to join the course online, you can request a custom course from the link below.
We offer group and corporate discounts on many courses. These discounts are available for clients who want to maximize their return on investment.
We offer individual discounts on many courses for people who are self-sponsored and make their payment in full and upfront at the time of registration.
Nominations to our public courses are to be processed by the client’s HR/Training department except for self-nominations which are to be paid in advance using the “payment by self” option on the online registration form. A refund will be issued back to the client in the event of course cancellation or seat unavailability. Registration confirmation is subject to INFORMATECH's review of registration request and seat availability.
Clients are responsible for any type of tax levied in their country.
If you are interested in having a course custom-designed for your organization, please submit a request using the link below. Once we receive your duly completed request, one of our business development professionals or consultants will get in touch with you to understand your requirements with more detail and answer any relevant questions you may have. After all pertinent information has been exchanged, we will work on the custom-designed request and send you the proposal you require and work with you to identify the ideal period and place for delivering the custom-designed solution.