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

Microsoft Excel: Basic

Course Dates:

7 Jun 2018
21 Jun 2018
11 Jul 2018
1 Aug 2018
10 Sep 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 perform calculation, create and modify Excel worksheets.

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.

Training Methodologies

  • Training is hands-on using easy-to-follow step-by-step instructions.
  • Instructor-Led Training (ILT) on live exercises of each topic.

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

 

Newsletter Subscription

Connect with VTeach by subscribing to our mailing list