The management and reporting of data is an important function of any modern business organisation. Business data is often available in the form of tables or data lists, which is a convenient format for Excel’s very considerable collection of powerful analytical and organisational tools. Building an Interactive Dashboard from these data sets help making informed business decisions easier. A typical dashboard consists of a collection of graphs, tables, statistical calculations and significant data, enabling management to monitor critical processes in a business or organisation.
This workshop will focus on Excel tools that you can employ for report building such as charting techniques, logical functions, tables and PivotTables. Also, learn how to effectively use drop-down lists and combo boxes, in combination with database functions. Understand how these features provide a convenient and flexible method of displaying key information using a simple mouse-click. This workshop will also show you a range of techniques for automatically updating dashboards when new data becomes available.
This workshop has been designed for professionals working with this application daily. It will provide you with a deeper knowledge of Excel, including many of the newer features introduced in Microsoft Excel.
Learning Objectives
At the end of this workshop, participants will be able to:
- Use specialist Functions and Formulas
- Manage Data in lists.
- Use PivotTables to display and chart data
- Use Power Pivot to create powerful reporting mechanisms
- Create eye-catching visualizations and Dashboards with Power View
- Design unique charts for Dashboard Visualisation
- Automate Dashboards and Reports
- Use Interactive Controls within Dashboards
100% HRD Corp Claimable Course: Skim Bantuan Latihan Khas
For more information, please contact the following Program Consultant:
Mr. Azrul / email: azrul@cfrontier.com / Tel: +6088731410
Ms. Tracy / email: tracy@cfrontier.com / Tel: +6088731570
Ms. Emily / email: emily@cfrontier.com / Tel: +6088731412
Ms. Joan / email: joan@cfrontier.com / Tel: +6088731575