Microsoft Excel Foundation

Microsoft Excel Foundation

1 Day

This course is designed for those delegates who wish to acquire the basic skills to use Excel effectively. It would benefit anyone wishing to learn the basics of creating spreadsheets.


On completion of this course, attendees will be able to create a spreadsheet, format text and numbers, perform basic calculations and present data in a graphical format.


Attendees do not need any previous experience of Excel but must have a basic understanding of PCs, including familiarity with a keyboard and mouse.


Courses are delivered in 2007, 2010, 2013, 2016.

What will I learn?
The Excel Screen
  • - Spreadsheet terminology explained
  • - Navigate the Excel environment
  • - How to get help
Create Basic Spreadsheets
  • - Enter and edit text, numbers and dates
  • - Delete and clear data and formats
  • - Different methods of selecting cells
  • - Change column widths and row heights
  • - AutoFill and custom lists
  • - Use cut, copy and paste
Work with Flash Fill
  • - Allow Excel to complete data entry for you
  • - Change Case
  • - Split data into columns
Format a Spreadsheet
  • - Apply different formatting to text
  • - Apply different number formats
  • - Apply borders and shading
  • - Merge cells and wrap text
  • - Insert and delete rows and columns
  • - Hide and unhide rows and columns
Create Basic Formulae
  • - Create basic calculations (add, subtract, multiply and divide)
  • - Understand the use of brackets () within formulas
  • - Copy formulae
  • - Relative and Absolute Cell References
Introduction to Functions
  • - The AutoSum Function
  • - The Max, Min, Average & Count Functions
Worksheet Views and Print Settings
  • - Workbook views
  • - Page Set-up options
  • - Print worksheets/workbooks
Manage Worksheets
  • - Insert and delete worksheets
  • - Copy and move worksheets
  • - Rename worksheets
  • - Reorder worksheets
  • - Apply Tab Colour
Work with Larger Spreadsheets
  • - Use the zoom control
  • - Apply Freeze Panes
  • - Sort and Filter a list
  • - Print Titles
  • - Set Print Areas/Print Selection
  • - Insert and edit Comments
  • - View and print Comments
Introduction to Charts
  • - Create a chart such as Pie, Column or Line
  • - Print Charts
Open course dates
Keep me informed of future dates and offers Keep me informed
Dates Venue Price  
4 December 2018 St Albans £245 + VAT Book

We offer with all our public scheduled courses:

  • Free pre-course skills assessment
  • Lunch and refreshments
  • Course reference guide
  • Attendance certificate
  • Lifetime post training support
  • Small groups of up to 8 people

Courses start at 9:30am and finish at 4:30pm

Related courses
Next Available Course Date

4th December 2018


St Albans


£245 + VAT

Book now View more dates
Run this
course at
your offices
Request a quote
which course
Which level do you need?
Take our online skills assessment
Find out more
Speak to a friendly advisor


0333 344 6630

or visit our

Online Chat