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.
Course Location
About everydayExcel Business Lab Pte Ltd
everydayExcel Business Lab is a training company offering Professional Microsoft® Excel CThierses with a Business Perspective. They tailor-made Excel cThierses for busy Executives and Managers who do not have the time to explore the various uses of formulas and functions to solve real business problems in sales and marketing, human resThierce, administration, business development, etc.
See all everydayExcel Business Lab Pte Ltd courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Office 2016 Complete Diploma The Teachers TrainingAED 47
AED 955Duration: Upto 7 Hours - Advanced Excel for Real World Course LineAED 89Duration: Upto 4 Hours