Microsoft Excel 2013/2016 Level 1 Training Course

Fundamentals

Course length – 1 day

Pre-requisites:

There are no pre-requisites for this course apart from general computer knowledge.

Objectives:

  • Understanding the concept of spreadsheets
  • Create a spreadsheet
  • Working with different types of data
  • Formatting
  • Using calculations and statistical functions
  • Setting up a worksheet to print
  • Create charts / graphs
  • Manage multiple worksheets
  • Use the help feature

Topics detailed below:

Introducing Excel
  • The Excel screen
  • Using the ribbon
  • Quick access toolbar
  • Working with backstage view
  • Worksheets and workbooks
  • Creating a workbook
  • Zoom
  • Excel views
  • Help
 Working With Data
  • Entering, editing and deleting data
  • Saving, opening and closing workbooks
  • Navigating around the workbook
  • Selecting data
  • Moving, copying
  • Inserting and deleting rows/columns
  • AutoFill
  • Search and replace
  • Spell check
Formatting
  • Numbers, dates and text
  • Cell borders and shading
Using Calculations & Functions
  • Simple calculations (plus, minus, multiply
    and divide)
  • Absolute and relative referencing
  • AutoCalculate
  • AutoSum
  • Common functions (Average, Max, Min, Count)
  • Moving and copying formulas
Setting Up A Worksheet To Print
  • Headers and footers
  • Paper size and orientation
  • Page breaks
  • Print preview
Manage Multiple Worksheets
  • Insert, delete, move, copy worksheets
  • Rename worksheets
  • Worksheet tab colours
Create Charts / Graphs
  • Inserting a chart
  • Changing the chart type
  • Formatting

Topics not what you require? More information required? Contact us to discuss.

The topics in this course can be mixed and matched with Excel Level 2 and/or Excel Level 3 if required.


Prices

1 to 1 training: £299 + VAT per day
Each additional person: £40 + VAT per day

We come to you.  Courses take place at your offices.