Course Title : Advanced Data Analytics & Reporting with Excel
Date : 30th - 31st October, 2017
Venue : IES Square Dzorwulu, Accra
This intensive, hands-on course demonstrates the full capabilities of the MS-Excel program for a wide range of Business Applications including Macro Creation, Advanced Analysis, Data Importing, KPI monitoring and Enhanced Management Reporting.
The course has been developed and is delivered by an experienced Microsoft Excel Consultant, and focuses purely on the practical applications of Excel that can be used in everyday work. Each delegate will have the opportunity to set up advanced spreadsheets during the course, and experiment with conducting a wide range of business analysis and reporting under controlled conditions.
During the intensive 2-days seminar, participants will learn how to;
- Set up Excel databases and advanced pivot tables to effectively use the same data for different purposes
- Develop advanced projection and trend analysis spreadsheets to assist with management decision making and managing external factor risk.
- Import data directly from other applications to make a wider range of information available for analysis
- Conduct advanced analysis, KPI tracking, sensitivity and margin analysis to help highlight problems before they occur
- Take advantage of Excel’s many specialized features to produce management reports, quickly and easily
- Master automatic creation of graphs and charts to help illustrate key business issues and trends
- Utilize Macros and advanced functions to save time when manipulating data and automating the production of management reports and charts
Call +233 - 302 926339 | +233 - 24 1000 318