Microsoft Excel

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

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. 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

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!