Microsoft Excel: Basic & Intermediate

Course Dates:

19 & 20 Oct 2017
16 & 17 Nov 2017
14 & 15 Dec 2017

Course Specifications

Course length: 2.0 days

Course Fees: S$285.00 (Group Discount of 10% for 3 or more participants)

Course Objective:

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. You will also be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

Course Content

Getting Started with Excel

Explore the user interface and the ribbon
Navigate and select in Excel
Obtain help 
Enter Data and Save a workbook

Performing Calculation 

Create Basic Formulas 
Calculate with function 
Commonly used Function
Copy formula and function 
Auto fill 

Modifying a Worksheet 

Inserting, Renaming, Deleting, Hiding Worksheet
Inserting, Renaming, Deleting Rows and Columns
Moving and copying Worksheet 
Moving and copying Data’s 

Formatting a Worksheet (Appearance of Worksheet)

Modify Fonts
Add borders and colors cells
Change column width and row height 
Apply number formats 
Varying Decimal in Number Formats 
Cell Styles 
Find and Replace text and numbers on a worksheet 

Managing a Workbook 

Inserting Header and Footer 
Freeze, split options 
Arrange the windows 
Using Sorting, Custom AutoFill Lists 

Printing Workbooks

Printing Workbook 
Set Page break 
Print Area 

Calculating Data with Advanced Formulas

Using Range Names 
Creating & Define Range Names
Using Range Names in Formulas 
Consolidating data 
Using Text and Date Functions 
Using Logical Functions 
Using the Vlookup and Hlookup Functions 

Organizing Worksheet and Table Data

Format Tables 
Modify Tables 
Create a Data List in Excel 
Learn more about filtering 
Common filter 
Clear a filter 

Presenting Data Using Charts

Types of Charts 
Creating Charts and Modifying Charts 

Newsletter Subscription

Connect with VTeach by subscribing to our mailing list

WU EDGE - Western Union Business Solutions


Our Testimonials

During the Advanced Excel class, the trainer helped me to clarify my doubts especially the VLookup.
- Clarinda

A very engaging course that I really enjoyed. The tutor was very cheerful and helpful.
- Manisha

Good experience and thanks to the Trainer for her kind patient in teaching our company.
- Belle

Why choose us?

Hands-on Training Method
ACTA and Microsoft Certified Trainers
Small class size
Complete Course Material
Free One-Time Refresher
Affordable Price
Certification of Completion
Central Location

Our Training Location

10 Anson Road
#31-12 International Plaza
Singapore 079903
(Tanjong Pagar MRT Station)

Call: +65 6673 4479

Email: admin@vteach.com.sg

Privacy Policy