Microsoft Excel
Courses for every skill level covering the basics of spreadsheets and formulas to formatting, managing and summarising data through to expert functions and VBA macro programming.

Microsoft Excel Foundation

Duration:
1 Day
Aims:

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.

Objectives:

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.

Pre-Requistites

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

Versions

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
Comments
  • - 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 Offer Prices  
1 February 2018 St Albans   £245 Book
Now
2 May 2018 St Albans   £245 Book
Now
16 August 2018 St Albans   £245 Book
Now
1 November 2018 St Albans  £195 £245 Book
Now

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
Related Courses
Next Available Course Date

1st February 2018

Venue

St Albans

Price

£245

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

call

0333 344 6630

or visit our

Online Chat
Trustpilot