New user? Register as member

Productivity Boost - 100+ Excel Tips and Tricks

Are you the slave or the master of Excel?
Most business people are slave to Excel because they use Excel the wrong way. They only learned the basic of Excel and jumped right in, doing lots of copying and pasting jobs in Excel. If you feel that you are a slave to Excel, it is time to cross over and become the master of Excel, conquering what seems to be time-consuming tasks to you. I will share with you 100+ Tips and Tricks, each takes only one to two minutes to learn.

This course is not a compilation of keyboard shortcuts from Ctrl A to Z. In this course, I am going to show you tips and tricks in different categories so that you could save up to 90% of the time you are currently spending in Excel.

Objective

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

• Use shortcuts to save time on cleaning up the data downloaded from their system
• Enhance their use of Pivot Table
• Create beautiful and engagin charts for their reports and presentation

Outline

You will learn the tips and tricks in the following categories

• Selection and navigation (37 tips)
• Data management (9 tips)
• Tables (4 tips)
• Worksheets (2 tips)
• Formula (17 tips)
• Chart (14 tips)
• Pivot table (9 tips)
• Power query (8 tips)
• Shortcuts (1 tip)
• Macro (1 tip)
• Images (3 tips)

Who should attend

Managers and Executives who crunch lots of data and prepare reports regular for their companies. They must have basic knowledge of Excel i.e. open Excel files, simple auto filter, etc.

Testimonials

I have always been clueless about the power of Excel, doing many things the manual way like counting amount in cells and doing manual layouts. To me Excel has always been just another program I layout my reports with. But after attending this Excel course, I realised that there is so much more power stored in Excel to help enhance and make efficient daily work reports that I have to do especially with ensuring accurate details in figures in big amounts. I'm sure as I continue to explore what has been taught, I will be able to save alot more time and stop pulling my hair out while I face my reports again.
Rachelle Low (Medical), Johnson & Johnson Pte Ltd

This course is extremely useful for intermediate users of Excel. Through this course, I learnt to use MS Query and Pivot table for consolidating huge amount of crucial data. It will definitely save me a lot of precious time to focus on other job roles, I would recommend it to anyone who would like to save time and still be able to be productive when processing and analyzing data.
Melanie Low (Sales and Marketing), 3M Asia Pacific

Recent feedback
The 100+ tips were very useful.

Jason is friendly and approachable. Also tries hard to link the course to our daily work.

Easy to understand.

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