Introduction to Microsoft Excel

Course Objectives

After the course, delegates will be able to navigate an excel spreadsheet, create/manipulate simple formulae and create charts.

Prerequisites

A basic understanding of Microsoft Windows is recommended.

Course Duration

1 day

Course Content

  • Introduction
    • Tour of the Screen
    • The Ribbon
    • Quick Access Toolbar
    • Setting Options
  • Excel Basics
    • Spreadsheet Concepts
    • Moving Around / Selecting Cells
    • Entering Text and Numbers
    • Using Pre-defined Lists
    • Defining a Custom List
    • Summing Rows and Columns
  • Calculations & Corrections
    • Entering Formulae
    • Correcting Mistakes
  • Moving, Copying and Inserting
    • Moving Cells
    • Copying Cells
    • Inserting Rows
    • Inserting Columns
    • Inserting Cells
  • Formatting Worksheets
    • Formatting Basics
    • Simple Number Formatting
    • Custom Number Formatting
    • Alignment of Entries
    • Changing Fonts
    • Adding Borders to Cells
    • Removing Formatting Changes
    • Column Width / Row Height
  • Basic Printing
    • Previewing the Printout
    • Fitting a Spreadsheet on a Page
    • Altering Page Margins
    • Headers and Footers
    • Printing the Worksheet
  • Charting Basics
    • Creating Charts
    • Chart Settings
    • Formatting Chart Elements
    • Chart Options

Download Course Content PDF

Acrobat-PDF

Download Full Course Schedule PDF

Acrobat-PDF

Ask a question

Please contact us to make a booking or book now on-line.

All courses are available for both scheduled (open) and dedicated (bespoke) delivery. Please contact us for details and pricing.

If you can’t see the course you are looking for – contact info@base2.co.uk