Intermediate Microsoft Excel

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
1 Day
Who should attend
This course is primarily designed for people who need to know how to use Microsoft Excel. 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 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 2 Printing
  • To Print Active Sheets
  • Headers and Footers
  • Print Gridlines and Headings
Unit 3 Creating Complex Formulas
  • Order of Operations
  • Working with Relative, Absolute and Mixed Cell References
Unit 4 Working With Functions
  • Basic Functions
  • Function Library
  • Insert function Command
Unit 5 Sorting And Filtering Data
  • Custom Sorting
  • Sorting Multiple Levels
  • Filtering Data
  • Advance Filtering
Unit 6 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 LCCM ASIA SDN BHD

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.

Share This
WhatsApp WhatsApp LCCM