VTeach Training Partner
Your Training Partner
Follow Us:
Contact VTeach Training
Register for Training

Microsoft Excel: Basic

Course Dates:

16 Apr 2018
9 May 2018
6 Jun 2018
11 Jul 2018

Course Specifications

Course Lenght: 1 Day (9.00am to 5.00pm)

Course Fees: S$185.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 perform simple calculation. You will be also able to create a simple chart.

Target Audience

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel that is necessary to create and work with electronic spreadsheets.

Course Content

Lesson 1: Getting Started with Excel

  • Explore the User Interface and the Ribbon

Lesson 2: Overview of Workbooks

  • Creating Workbooks
  • Saving Workbooks
  • Closing Workbooks
  • Opening Workbooks
  • Selecting Cells, Rows, and Columns
  • Using Templates

Lesson 3: Modifying a Worksheet

  • Entering Data
  • Editing Data
  • Moving and Copying Cells
  • Using Paste Special
  • Clearing Cells
  • Undoing and Redoing Changes

Lesson 4: Working with Rows and Columns

  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Changing Row Heights
  • Changing Column Widths
  • Hiding and Unhiding Rows and Columns

Lesson 5: Formatting Worksheet

  • Changing the Font and Font Size
  • Changing the Font Color and Fill Color
  • Applying Font Styles
  • Adding Cell Borders
  • Formatting Numbers
  • Positioning Cell Contents
  • Copying Cell Formatting
  • Applying Cell Styles

Lesson 6: Performing Calculation

  • Using Formulas and Functions
  • Using Cell References in Formulas
  • Entering Formulas
  • Displaying Formulas
  • Using Functions in Formulas
  • Using the AutoSum Button
  • Inserting Functions
  • Using Formula AutoComplete

Lesson 7: Visualizing Data with Charts

  • Creating Charts
  • Selecting Chart Elements
  • Changing the Chart Type

Lesson 8: Getting Help and Exiting Excel Document

  • Getting Help
  • Exiting Excel

Newsletter Subscription

Connect with VTeach by subscribing to our mailing list