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.

SIGN-UP EARLY TO AVOID DISAPPOINTMENT!
Register NOW!


Registration can be made by filling and submitting the online form below or email us at hello@lccm.asia

Payment shall be made payable to LOGICA CENTRE OF COMPUTER & MANAGEMENT SDN BHD (AmBank Account Number: 212-201-200360-6)

Type of Course Registration
IndividualCorporate

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

Address

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.