Top 10 Excel Skills for Business Professionals

Through this 2 day intensive workshop, you will master essential Excel functions and formula that are most used in workplace. Not only will you use the functions correctly, you will learn when not to use them, avoid common mistakes and reduce non-value adding time in MS-Excel and quickly create fast reports in MS-Excel.

Participants who seek a power-overview on essential MS-Excel functions and learn how to apply them effectively at their workplace.

• Anyone who is interested in increasing his or her productivity and skills in Excel.
• Anyone who wants to be a better Excel user.
• This course covers some introductory functions such as LARGE and SMALL, but also some intermediate
  skills such as VLOOKUP.
• Some advanced techniques such as PIVOTABLE is also covered.

Day 1: 9.00am - 5.00pm Module 1: Look up Functions-focus on VLOOKUP

• VLOOKUP Function
• IF Function
• Match types-looking up an exact match and looking up a range
• INDEX, MATCH Functions

Module 2: Summing Functions

• SUMIF and SUMIFS Functions
• How these Functions work and their limitations
• Customizing the Status Bar & using Auto Calculate

Module 3: Counting Functions

• COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS Functions

Module 4: TEXT Functions

• LEFT, RIGHT, MID, TEXT Functions

Module 5: Grouping and Outlining

• Manual Grouping, Auto Outlining
• SUBTOTAL, AGGREGATE Functions

Module 6: Database and Autofilters

• What is an Excel Database?
• Creating a Table Manipulating Tables
• What is AutoFilter?

Module 7: Excel Database Functions

• DSUM Function
• DSUM vs SUMIF/ SUMIFS

Module 8: Conditional Formatting

• What is Conditional Formatting?
• Conditional Formatting Rules, Data Bars, ColorScales and Icon Sets
• Creating and Managing Rules
• Sparklines(Excel 2010 and above only).
• Advance Formatting

Day 2: 9.00am - 5.00pm Module 9: Pivot Table

• Pivot Table basics
• Building Effective Pivot Tables
• Using Pivot Table Filters
• Sorting, Formatting Pivot Tables
• Calculations and Inserting Formulas
• Pivot Table charts
• Creating Pivot Table from external sources
• Grouping Function in Pivot Tables

Module 10: How to use PowerPivot

• Downloading huge datasets
• Flattening the PivotTable
• Relational Database basics
• Managing and Creating Relationships in PowerPivot

This program is conducted with practical exercises and interactive discussions.

“Vincent is an excellent trainer with excellent knowledge in the subject subject.” - Badrun Berahim, Westin Langkawi.

“Before this I never understood what Six Sigma was. Vincent crystalised it and clarified it for me so well.” - Betty Yu, HSBC.

“I’ve many times been told that PivotTable is the most useful function which help me great at work. This is a great course! ” - David Chiang, Telecommunication. 

(Fee inclusive of Training Materials & Certificate of Achievement)

Upon successful completion of this program, you will receive a Certificate of Achievement.

1. ONLINE PAYMENT by Credit card: You can opt to register and pay online with our latest payment integration system through our website.

2. BANK IN CHEQUE
Bank in and then scan the Bank-in slip and email to us before the course commence to confirm your seat.
Courier your cheque payment to our Finance HQ.
* Note that we DO NOT take any payments during the event.
3. BANK IN CASH:You can also pay by cash through bank-in our company bank account
4. Telegraphic Transfer- You can also opt to use GIRO or telegraphic transfer of payment via international

We'd happy to help.
Feel free to talk to us today, however most suitable for you.
Mobile call/ whatsapp: +6012 6869 628 | +6018 2175 123
Office: +603 8074 9056
Email: info@itrainingexpert.com
Website: www.itrainingexpert.com