New user? Register as member

Advanced Excel Workshop

Knowing more formulas is good. But if the formulas learned are not leading you to towards a goal, they may get forgotten in a few days after the course.

Pre-requisite
Participants must have experience in using

• Simple worksheets functions
• Simple Pivot Table
• Works with multiple worksheets of data

Objective

At the end of this course, you will be equipped with the skills to

• Generate Pivot table using different data sources.
• Generate a Pivot Table with multiple sources of data
• Visualize your data using Pivot Chart and Conditional Formatting

Outline

Mastering formula and functions

1. Consolidate two worksheets into one using VLOOKUP
2. Extract data using Excel AI function
3. Working with multiple rows at the same time
4. Effective use of FIND ALL to save time

Analyze and Summarize your data with Pivot Table

1. Create a Pivot Table using Tables
2. Create a Pivot Table using a CSV file
3. Create a Pivot Table using the files in a folder
4. Using more than one summation value in Pivot Table
5. Changing Summary Calculations
6. Grouping values in Pivot Table
7. Grouping dates in Pivot Table
8. Counting unique records
9. Add and use Slicers for presentation
10. Using a timeline in Pivot Table

Mastering presentation of data

1. Visual presentation of your data using Pivot chart
2. Impress your audience with customize charts
3. Effective use of visuals to attract attention.

Who should attend

The training is ideal for those (such as Directors, Head’s, Leaders, Managers and executives across all industries and all professionals) who have intermediate Excel skills.

Testimonials

Profile of Jason Khoo

Jason Khoo is a Microsoft Certified Trainer (MCT), ACTA certified trainer of 20 years. He is a Microsoft Certified Power BI Data Analyst Associate and a data analytics practitioner of 30 years. During his time of employment, he has worked in Tibs (currently SMRT), MobileOne Ltd, 3M and Virgin Mobile.

During his tenure, he has worked with multiple databases, extracted and downloaded information from systems and run numerous analysis. These analyses spanned across many departments such as Finance, Sales, Marketing, Human Resources, Payroll, etc.

After his employment, he worked as a data analytics consultant for many companies, including Discovery Asia, 3M, Tanah Merah Country Club, Johnson and Johnson Vision Care, National Environmental Agency, Timberland, etc.
His data analytics skills combined with Excel allowed him to deliver many reports to the clients without them having to incur software cost. These reports include Dashboards, Top 10 charts, Risk Analysis, Business Models, KPIs, etc.

As a trainer, he is passionate about transferring his knowledge and imparting his skills to his participants. To day, he has trained thousands in his face to face workshops and had conducted talks for thousands as well.

Trans-Island Bus Services Ltd (Tibs) –Operations and Revenue Analytics, Passengers Travelling Behaviour Analytics
• Daily tracking of revenue,
• Prepare KPI for LTA,
• Fare revision analysis

Mobile One Asia Ltd (M1) – Financial analytics, Customer Call Usage Analytics
• Full company budgeting and business planning,
• Monthly Analysis,
• KPI reporting

3M – Sales, Cost and Inventory analytics
• Daily and Monthly Sales Forecasting,
• Analysis of Marketing Budget,
• Analysis of Inventory and shipments.
• Cost Analysis for new products (BOM analysis)

Virgin Mobile – Retail, Marketing, Payroll, Admin, IT, Finance Analytics
• Daily KPI reporting,
• Monthly Analysis for Finance, Payroll,
• Developed Fully Automated Business Model driven by KPI