Overview
Physical classes are available.
Learning Outcomes
This is a 2-day program covering all important aspects of Excel from the foundation to intermediate level.
Upon completion of this course, you will have a good overview of important Excel functions and be prepared to start utilizing Excel in your work.
Who Must Attend
This is a basic to intermediate level Excel training course which starts at the basic level and progresses on to the intermediate level on the second day. The training is designed to suit clerks, operations personnel, security personnel, customer officers, front-end facing staff and other groups of people who are interested in starting off Excel as a work tool.
Course Details
2 DAYS Training
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
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
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
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 options
- Fill options
- Sheet backgrounds
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
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
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
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
Methodology
Webinar & Online Training
Course Leader
Testimonies
"The trainer was very clear in this explanation on how to use the excel functions to enhance my work. Great job. Thanks" Farhan, Rail Transit
“I have learned a lot of knowledge from this course, Micorsoft Excel – Intermediate. Both the training and the trainer are equally good. I would like to join other Microsoft Office course.”– Secretary, NUR Power Sdn Bhd
“Thanks to my trainer, Mr. Vincent, I learned to apply Microsoft Excel in my future work. He is good and expressive. He is able answer all my questions immediately. I hope to join for Microsoft Excel – Advanced Level.”– Accounts, Hiraki Timur Sdn Bhd
“During the course, I learned to simplify my work using Microsoft Excel. After the course, I am so excited and can’t wait to apply the knowledge that I learned from this course. Mr Vincent is an excellent and knowledgeable trainer. I hope to join Microsoft Excel – Advanced Level conducted by him.”– Accounts, Hiraki Timur Sdn Bhd
Investment
| Normal fee |
| Sign up 1 pax |
| Pay before course starts |
| MYR 2,590.00 |
| USD 760.00 |
| Early Bird |
| Sign up 1 person |
| Pay 14 days before course starts |
| MYR 1990.00 |
| USD 580.00 |
| Group Fee |
| Sign up 3 pax or more |
| Pay 14 days before course starts |
| MYR 1890.00 |
| USD 560.00 |
E-Certificate
Upon successful completion of this program, you will receive a e-Certificate of Achievement.
Payment mode:
1. ONLINE PAYMENT by Credit card: You can opt to register and pay online with our latest payment integration system through our website.
2. Telegraphic Transfer- You can also opt to use GIRO or telegraphic transfer of payment via international banks.
Contact us: ITRAININGEXPERT GLOBAL PLT
Tel:+603 8074 9056 | +603 8082 3707
Mobile: +6012 6869 628 | +6018 2175 123
Email: info@itrainingexpert.com
Website: www.iTrainingExpert.com
