TITLE: EXCEL SKILLS FOR PROFESSIONALS: Expert Level
DATE: 27th-28th August 2018
VENUE: Shangri-La Tanjung Aru Resort & Spa
INTRODUCTION
This course introduces Microsoft Excel users to the expert features of the software application
Master business intelligence modelling and analysis techniques with Microsoft Excel and transform data into bottom-line results. This hands-on, scenario-focused workshop shows you how to use the latest Excel tools to integrate data from multiple tables and how to effectively build a relational data source inside an Excel Workbook.
We will also show you how you can turn Excel into your own personal Business Intelligence tool. With a few fundamentals and some of the new BI functionality Microsoft has included in the latest versions of Excel, you can go from reporting data with simple tables, to creating meaningful dashboards that are sure to WOW everyone.
COURSE OBJECTIVES
At the end of this training, participants will be able to:
- Use Power Pivot to create powerful reporting mechanisms
- Get better visibility into data from different perspectives
- Use excel functions to analyze large amounts of data
- Use Interactive Controls within spreadsheets
- Create eye-catching visualizations and dashboards
- Use excel pivot tables to access and analyze data
- Automate repetitive tasks and processes
- Gain insight and analytical power with Data Mining Tools
- Publish dashboards and reports
For more information on this course, kindly contact Annette at 088-731409 or email at annette@cfrontier.com