Microsoft Excel
Foundation

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 Charts
  • - Create a chart such as Pie, Column or Line Print Charts
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
Open course dates
Keep me informed of future dates and offers Keep me informed
Dates Venue Price  
17 May 2018 Milton Keynes £195 + VAT Book
Now
16 August 2018 St Albans £245 + VAT Book
Now
1 November 2018 St Albans £245 + VAT 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
Next Available Course Date

17th May 2018

Venue

Milton Keynes

Price

£195 + 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

call

0333 344 6630

or visit our

Online Chat
Trustpilot
How we deliver learning
Your Offices (in-house)
Your Offices
(in-house)

If you have a number of people in your organisation with the same training need, in-house training programmes are an ideal, collaborative learning solution.

Our Training Venues
Our Training
Venues

Ideal for single/few staff member(s) that need development in a certain area. Sharing ideas and experiences with people from other organisations can be a huge benefit.

Virtual Learning
Virtual
Learning

Enabling staff to join live classroom training via web conferences. Ideal for organisations with multiple offices or where staff are geographically spread.

Sprint Learning
Sprint
Learning

High impact 90-minute training sessions delivered either face-to-face or virtually in targeted subjects, to boost performance whilst reducing your staff time out of the business.

Managed Learning Services
Managed
Learning Services

As an extension to your in-house L&D team, we will look after all the planning and organisation of your staff training needs, from assessment of needs through to delivery and evaluation.

We provide
Laptop Hire
Laptop Hire
Lifetime Support
Lifetime Support
Monthly Tips & Tricks
Monthly Tips
& Tricks
Contact Us


If you need any help with finding
the best course for you, please call us on

0333 034 6630


How did you hear about us?

TrainingU will not pass your contact details onto any third parties, and will only contact you in relation to your enquiry.

Our commitment to quality

We are an accredited training provider with the Learning and Performance Institute which gives you the assurance that we conform to a professional Code of Practice.

Learning and Performance Institute