Microsoft Excel Beginners

Versions: All earlier versions, 2013 and 2016 available

Corporate in-house training or public courses available in Paulshof, Sandton

Description

You will learn how to create, edit, format and print a spreadsheet.

Duration

1 day

NQF level 2

Prerequisites

A knowledge of Windows and understanding of how to use the personal computer

 

Module 1: Excel Essentials

  •  The Excel 2010 screen 
  •  Understanding the Ribbon, contextual tabs and dialog box launchers
  •  Customise the Quick Access Bar
  •  Use Help in Excel 2010
  •  Workbooks and Worksheets
  •  Select cells and ranges
  •  Move and scroll through the worksheet

Module 2: Create a spreadsheet

  •  Types of data
  •  How to enter date
  •  How to use AutoFill
  •  How to edit data
  •  File management including file compatibility
  •  Formulas
  •  Absolute and Relative addressing

Module 3: Edit a spreadsheet

  •  Change column/row widths
  •  Alignment of cell entries
  •  Centre headings over a group of cells
  •  Insert and delete rows/columns
  •  Insert new worksheets
  •  Move and Copy

Module 4: Format a spreadsheet

  •  Change number formats
  •  Borders and Fill (shading)
  •  Change character fonts, sizes and colours
  •  Copy a format to other cells 
  •  Freeze panes
  •  Zoom the display

Module 5: Spell check and print a spreadsheet

  •  Spell check the worksheet
  •  Print preview
  •  Use the Page Layout ribbon
  •  Insert manual page breaks
  •  Change Orientation and Scaling
  •  Select a print area
  •  Print repeating headings (print titles) 

Request a quotation

Full Name(*)
Please type your full name.

E-mail(*)
Invalid email address.

Phone Number
Invalid Input

Individual or company?(*)
Individual or company?

How many people require training?(*)
How many people require training?

Download course details