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

Jennifer Lye

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

← Microsoft Office Microsoft PowerPoint →

WELCOME TO LCCM ASIA

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