Excel level 1

Back   Book Now

Microsoft Excel training courses


Microsoft Excel is the world's most commonly used spreadsheet programme. Used to organise and manipulate data, it is a critical tool in business decision making.

Just about every office job requires some degree of skill in Excel.  We offer Microsoft Excel courses, from beginner to advanced, will ensure that you and your team can make the most of this powerful tool, whether you still operate on 2003, or have recently made the switch to Excel 2013.

In this course, you will create and edit basic Microsoft Excel worksheets and workbooks.

Target Audience:

This course is designed for those who wish to gain the necessary skills to create, edit, format and print basic Microsoft Excel worksheets.

Prerequisites

  • Use a mouse
  • Type and use a keyboard
  • Navigate through Windows files and folders
  • Work with windows - minimise, maximise, open and close


Delegates will learn how to

  • At the end of this course you will be able to:
  • Get started with Excel
  • Create a basic worksheet
  • Modify a workbook
  • Use formulas and functions
  • Format an Excel worksheet
  • Manage worksheets and workbooks
  • Set up printing options

Outline

Module 1: Getting Started with Excel

  • Excel and the Excel Environment
  • Navigate and Select in Worksheets
  • Create a Basic Workbook
  • Open, Save and Close Workbooks
  • Use Microsoft Help

Module 2: Modifying a Workbook

  • Cut, Copy and Paste Commands
  • Flash Fill
  • AutoFill Options
  • Find and Replace
  • Spelling
  • Undo and Redo
  • Insert and Delete Options
  • Column Width and Row Height
  • Hide and Unhide Options

Module 3: Using Formulas and Functions

  • Create Relative Formulas
  • AutoCalculate
  • Insert Functions
  • Use AutoSum
  • Copy Formulas
  • Create Absolute Formulas

Module 4: Formatting an Excel Worksheet

  • Font Group
  • Add Borders and Fill Colours
  • Cell Alignment
  • Number Formatting
  • Cell Styles and Galleries

Module 5: Managing Worksheets and Workbooks

  • Manage Worksheets
  • View Worksheets and Workbooks

Module 6: Printing Options

  • Print Pane
  • Print Worksheets and Workbooks
  • Page Setup
  • Print Layout View