Intermediate Microsoft Excel

Course Objective

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

WELCOME TO LCCM ASIA

Master new skills, LCCM Asia simply empowering everyone with a growth mind-set in today’s digital world.

Want to learn more about our corporate training programs?

Contact us today!