Microsoft Excel Basics

The topics listed under this level of training are a snapshot only of the skills which fall under the Microsoft Excel Basics category. If you are interested in this level of training, please contact us to register your interest using the form below. As we provide customised training, for multi-student training sessions the next step after you contact us involves us assessing your current skills to determine exactly which topics you require training in. After you have completed this level of training, you may want to up-skill to the next level: Microsoft Excel Intermediate.

The Office Expert offers Customised Computer Training and Administrative Support in the comfort of your home or office for Cairns in far North QLD.

This level includes:

Navigating around the Excel environment

  • Customising & moving the Quick Access toolbar
  • Adding icons to the ribbon
  • Customising the ribbon
  • Showing the Developer ribbon
  • Viewing layouts
  • Creating new spreadsheets
  • Adding & deleting worksheets
  • Saving files
  • ‘Save’ vs ‘Save As’
  • Finding your saved files in Explorer
  • Opening existing spreadsheets through Excel

Basic Excel Features

  • Selecting cells for formatting purposes
  • Bold/italic/underline/strike-through/superscript/subscript
  • Font size & styles
  • Formatting numbers
  • Text alignment & indentation
  • Text direction
  • Cell borders
  • Undo & redo
  • Applying shading/patterns/gradients to cells

Page Setup & Preparing for Printing

  • Margins
  • Orientation (Portrait/Landscape)
  • Page Size
  • Insert basic headers & Footers
  • Setting & resetting the Print Area

Fill Series

  • AutoFill
  • Fill Series options
  • Formula filling
  • Right-Click filling

Spreadsheet Navigation

  • Inserting cells/rows/columns
  • Deleting cells/rows/columns
  • Merging cells/rows/columns
  • Shading cells/rows/columns/entire spreadsheet
  • Selecting cells/rows/columns/entire spreadsheet
  • Selecting non contiguous cell ranges

Basic Formulas

  • Operators
  • AutoSum
  • MIN
  • MAX
  • AVERAGE
  • BODMAS
  • Simple Functions

Spelling & Grammar

  • How to customise the dictionary language
  • AutoCorrect
  • Spelling/Grammar checking

Finding Word Help

  • Searching the Help Index
  • Online Help
  • Tutorial Help
  • Customised Help using F1

Printing

  • Selecting your printer
  • Setting a default printer
  • Specifying the amount of copies
  • Setting the print area
  • Clearing the print area
  • Print preview
  • Scaling page to fit
  • Orientation
  • Printing only the formulas
  • How to make all data fit onto a page
  • Adjusting margins/headers/footers

Sorting & Filtering

  • Sorting data A-Z
  • Sorting data Z-A

Basic Charts

  • Types of built-in Excel charts
  • Selecting data to include in a chart
  • Moving a chart
  • Deleting a chart
  • Printing only a chart

Request for Training

Your Name (required)

Your Email (required)

Your Contact Number (required)

Any prior experience with Excel?

Motivation for Training? (upskilling / applying for a job...)

How soon do you need this Excel Basics training?

How many people require this training?