Microsoft Excel Essentials

Course Objectives
The skills and knowledge covered in this course are sufficient for real-world applications such as budgeting, analysing sales, producing reports, creating charts, and managing small lists.
Course Duration
14 Hours (Part-time or Full-time available)
Who should attend
This course is primarily designed for people who need to know how to use Microsoft Excel 2010/13. It is ideal for people who work in offices, for clubs or charities where there is a requirement to produce reports, budgets, lists and charts.
Course Leader
Course Modules
Unit 1 Microsoft Excel
  • The Ribbon
  • The Quick Access Toolbar
  • Backstage View
  • Creating and Opening Workbooks
  • Workbook Views
  • Zoom
  • Compatibility Mode
Unit 2 Cells And Contents
  • To Insert, Delete, Cut, Copy and Paste Cell Content
  • To Access Formatting Commands by Right-Clicking
  • To Drag and Drop Cells
  • To Use the Fill Handle to Fill Cells
Unit 3 Working With Columns, Rows And Cells
  • To Modify Column Width and Row Height
  • To Insert and Delete Rows and Columns
  • Wrapping Text and Merging Cells
Unit 4 Formatting Text
  • To Change the Font, Font Size and Color
  • To Use the Bold, Italic and Underline Commands
  • To Add a Border and Fill Color
  • To Change Horizontal and Vertical Text Alignment
  • Formatting Numbers and Dates
Unit 5 Saving Workbooks
  • To Use the Save Command
  • To Save As an Excel 97-2003 Workbook
  • To Save As a PDF
Unit 6 Formulas
  • Creating Simple Formulas
  • To Edit a Formula
Unit 7 Introduction To Worksheets
  • To Insert, Delete and Rename Worksheets
  • To Copy and Move a Worksheet
  • To Color Code Worksheet Tabs
  • Grouping and Ungrouping Worksheets
  • Freeze and Unfreeze Worksheet Panes
  • Split and Unsplit the Worksheet
  • Hide and Unhide Columns or Rows
Unit 8 Printing
  • To Print Active Sheets
  • Headers and Footers
  • Print Gridlines and Headings
Unit 9 Creating Complex Formulas
  • Order of Operations
  • Working with Relative, Absolute and Mixed Cell References
Unit 10 Working With Functions
  • Basic Functions
  • Function Library
  • Insert function Command
Unit 11 Sorting And Filtering Data
  • Custom Sorting
  • Sorting Multiple Levels
  • Filtering Data
  • Advanced Filtering
Unit 12 Charts
  • To Create and Resize a Chart
  • To Change the Chart Type, Layout and Style
  • To Add Data Labels
  • To Change the Color of a Pie Chart Segment
  • To Move a Pie Chart Segment

For further enquiries, please call us at +6 (06) 8500888.

Register NOW!

Registration can be made by filling and submitting the online form below or email us at

Payment shall be made payable to LCCM ASIA SDN BHD (AmBank Account Number: 212-201-200360-6)

Type of Course Registration

PART A: For ALL Types of Course Registration:

Your Choice of Program (required)

I / We would like to register for the above choice of program for:
Public CourseIn-house CourseOne-to-one Intensive Program

Your Name (required)

Your Company/Organization


Tel. No. (required)

Email (required)

PART B: For Corporate Registration ONLY:
Please fill in Approving Manager details for attendee(s) below.

Authorised By

No. of Delegates you want to register?

*Note: Payment can be made before or on the commencement date.

Terms & Conditions

Registration & Fees Policy:
Registration is confirmed once registration form is received via online form/email/mail. Letter of Approval (For Corporate Registration ONLY) must be made available and presented prior to the course.

Cancellation Policy:
Any cancellation must be received in writing within 5 working days prior to the event else full payment will be imposed. Any no-show by registered delegates will be liable for full payment of the program fees.

Contact Person WhatsApp LCCM