The Hidden Key excel Reporting And Charting Jurong West, West

Course details

Managers and Executives who have to prepare monthly, weekly or daily dashboards, balance scorecards, KPI reports using data downloaded from systems. They must know how to format cells, auto-filter, sort, create a simple template and enter simple formulas (e.g. SUM) into the worksheet

Learning Objectives

Upon completion of the course, participants will be able to:

• Apply useful built-in functions in Excel to pick up and compute the results automatically
• Advanced skills and techniques to create charts and tables in Excel.
• Making use of the special features in Excel to enhance users interactivity with the report.
• Prepare impressive reports that get noticed.

Course Outline

• Create an Interactive Title for your report
• Pulling Data from another Excel file using Advanced MSQuery techniques
• Create Charts with 2 x-axes displaying 2 different measurements
• Create a 2-in-1 chart
• Using customized format for the axes, e.g. S$50K
• Application of Advanced Formula such as INDEX and MATCH
• Using Thermometer chart to compare current year performance with Prior year
• Presenting the TOP 5 selling products WITHOUT using Pivot Table.
• The hidden key to the Excel Camera for presentation

Functions and formulas used

• NESTED IF
• INDEX
• MATCH
• SUMIF
• SUMIFS
• COUNTIF
• COUNTIFS
• VLOOKUP
• Advanced MS Query
• Dropdown list, etc.