The Hidden Key to Excel Reporting and Charting - HKERC
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 ObjectivesUpon 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.
- Create Charts with 2 x-axis
- Using customized format for the axes, e.g. S$50K
- Summarize and sorting the results with Pivot Charts
- Changing the alignment of the y-axis description
- Creating a 3 dimensions charts using 2 axis
- Presenting the TOP 10 selling products using Pivot Table
Functions and formulas used
- NESTED IF
- INDEX
- MATCH
- SUMIF
- SUMIFS
- COUNTIF
- COUNTIFS
- VLOOKUP
- Advanced MS Query
- Dropdown list, etc.
In a typical Excel course, participants are just taught the A to Z on the formulas and functions, for the purpose of passing the certification tests. After attending these courses, the participants are left on their own to figure out how to apply the formulas and functions effectively in their unique work situations. Some took months and years to accomplish this, but many never ever discovered how. We decided to fill the gap by offering our courses tapping on our Excel experiences, from our Excel-related work experience accumulated over the years (since Lotus 1-2-3 days) and regular consulting work done with companies such as Discovery Asia, Johnson and Johnson, EQ Insurance, DP Architect, etc.
WHY SHOULD YOU CONSIDER OUR COURSES?Unlike the gamut of basic, intermediate and advanced Excel courses geared towards achieving high score for the test given at the end of the training, our solution-based Excel courses work through real-life business situations and problems that business users encounter daily in their jobs and share with them quality solutions aimed to improve their work productivity and efficiency. ...