Skip to content

Microsoft Excel Training: Level 1

This beginner's Microsoft Excel training course aims to give the new spreadsheet user fundamental skills in creating and working with Excel.

Classroom: 1 day | Remote: 4 x 2 hour sessions

Overview

This is a beginner’s Microsoft Excel training course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Excel.

Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Key Topics

  • Getting to know Microsoft Excel
  • Creating A New Workbook
  • Working With Workbooks
  • Selecting Ranges
  • Formulas And Functions
  • Copying Data
  • Formula Referencing
  • Font Formatting
  • Cell Alignment
  • Row And Column Formatting
  • Number Formatting
  • Printing
  • Creating Charts

When the participant completes this course they will be able to:

  • navigate your way around Microsoft Excel 2016
  • create and work with a new workbook
  • open and navigate within workbooks and worksheets
  • make changes to data in a workbook
  • understand and work with ranges in a worksheet
  • copy and paste data in Excel
  • use the fill operations available to fill a data series
  • move the contents of cells and ranges within and between workbooks
  • understand, create and work with formulas and functions
  • understand and use formula cell referencing
  • use font formatting techniques
  • align the contents of cells in a number of ways
  • understand and use the number formatting features in Excel
  • format rows and columns in a worksheet
  • work with elements that make up the structure of a worksheet
  • sort data in a list in a worksheet
  • filter data in a table
  • print your workbook data
  • create effective charts in Microsoft Excel
  • obtain help for Excel whenever you need it
  • understand points to consider to avoid problems in your worksheets

Request More Information