Microsoft Excel has proven to be an essential tool in today's fast-paced, technical business environment world, accurate accounting, and calculations can mean the difference between success and failure.

This 2-day Excel: Intermediate training program is a follow up to our Excel Basic course with greater emphasis on data management skills and the features required for it.

AGENDA
DAY 1: 9:00am - 5:00pm

9:00 - 10:30am
Module 1 : Main Excel objects
What are worksheets & workbooks?
Columns, row, cells & ranges
Navigating, important shortcut keys
The Backstage
The Ribbon

Module 2 : Worksheets & workbooks
Creating a worksheet
Creating a workbook
Save & save as

Module 3 : Formulas
What are excel formulas
The formula bar
Common mathematical operators
The order of operations

10:30- 11:00AM TEABREAK

11:00AM - 1:00PM
Module 4 : Insert functions
The Excel function
The function library
Important excel functions

Module 5 : Formula references
Absolute & relative references
References when copying formulas in an array

Module 6 : Important Excel functions
IF, VLOOKUP, SUMIF, COUNT


1:00- 2:00PM LUNCH

2:00- 3:30PM
Module 7 : Important excel aspects
Undo & redo
Autofill feature
Autofill options
Dragging & dropping cells
Cut, copy, & paste cells
How to cut, copy, & paste multiple cells
Using the clipboard
Paste special
The transpose option
Live preview
The Clear button
Excel spellchecking

Module 8 : Rows & columns
Inserting & deleting
Important shortcut keys
Adjusting width of rows & columns
Hiding & unhiding rows & columns

Module 9 : Finding & replacing data
The Find command
The Replace command
The Go to command

3:30PM - 4:00PM TEABREAK

4:00PM - 5:00PM
Module 10 : Excel fonts
Fonts & font type
The font group
The format cells dialog box
The format painter
Live preview & formatting
The mini toolbar

Module 11: Drawing borders & coloring cells
Border optins
Fill options
Sheet backgrounds
End of Day 1

Day 2: 9:00am - 5:00pm
9:00AM - 10:30AM
Module 12 : Apply number formats
Number formats
Excel number formats
Customizing number formats

Module 13: Cell alignment & cell styles
Alignment options
The indent command
Orientation options
The merge & center options
Cell styles
The style dialog box

10:30 - 11:00AM TEABREAK

11:00AM - 1:00PM
Module 14 : Printing excel worksheets
Print options in backstage view
Page setup dialog box
Print preview options
Inserting headers & footers
Header & footer settings
Page margins
Margins tab options
Setting page orientation

Module 15 : Page layout & other print options
Zoom options
Page breaks
Page break options
Setting the print area
Print titles
Scaling options

Module 16 : Worksheet tabs
Renaming worksheet tabs
Changing tab color
Hiding & unhiding worksheets
Deleting worksheets
Copying tabs
Moving tabs

1:00PM -2:00PM LUNCH 

2:00PM - 3:30PM
Module 17 : Worksheet views
Split command
Freeze panes options
Arrange all command
Arrange windows dialog box
View side by side command
Switch windows command
New window command

Module 18 : Formula Auditing
Tracking Dependents and Precedents
Showing formulas
Error checking and tracing errors

Module 19 : Sorting & Filtering
Working with lists
Applying Sorting and Filtering to a list
Simple sorting
Sorting by multiple columns
Using AutoFilter
Using custom filter
Using Advanced Filter
Removing duplicates from data

3:30PM - 4:00PM TEABREAK

4:00 - 5:00PM
Module 20 : Data Tools
Text to Columns
Flash Fill
Remove Duplicates
Data Validation
Consolidate

Module 21 : Introduction to Excel charts
Types of Excel charts
Data ranges and selecting data
The bar graph
The pie chart
Advanced chart formatting

END OF DAY 2 

This is an activity-based workshop to cover Excel features and commands to jump start productivity for existing Excel users. Laptops required.

VINCENT CHIN YUEN CHOON
Chartered Accountant, FCCA
Microsoft Certified Trainer
Certified Six Sigma Black Belt
HRD Corp Certified trainer

Vincent has held financial, continuous improvement, and I.T. positions in the banking, shared services and hospitality industries. He is a FCCA, Certified Six Sigma Black Belt, Microsoft Certified Trainer, Microsoft Office Specialist, and HRD Corp accredited trainer.

His previous roles include being an internal change consultant of a global team, a financial shared-services local head, and a finance regional head. He currently trains professionals in Excel and Lean Six Sigma covering topics related to finance, business intelligence tools, pivot tables, dashboards, VBA, and process improvement. 

Vincent brings to you his 20+ years of work and training experience in multiple industries where he was in charge of financial and business reengineering functions.

He also develops complex VBA applications regularly in process improvement projects which require his expertise.

One of his highest achievements in the role of Financial Controller for several multinational conglomerates was being able to turn a loss-making company into a profitable one within the year. Vincent has also managed a portfolio of business improvement projects with realized benefits of USD2 million in the prior year in an international bank

Vincent has trained employees from Genting Group, Dell, Motorola, Technip, CIMB, Malakoff, Digi, IBM, Starwood Hotels & Resorts, Petronas ICT, and HSBC.
Vincent adapts a highly practical approach in his training and relates topics he conducts to real-life scenarios. Because he is a no-nonsense person, his solid background in financial operations and process re-engineering experience aid him to create a unique training methodology that mimics closely the solutions that are needed in his participants’ organizations. 


To contact Vincent , please call +6012 6869 628, +603 8074 9056, +603 -8082 3707, email to info@itrainingexpert.com

Or 

We have a faculty of specialists that can cater to your organisation's different levels and specific needs.

For training and advisory services, feel free to contact us at info@itrainingexpert.com or call us at +603 8082 3707 | +603 8074 9056 | +6012 6869 628 | +6018 2175 123