Microsoft Excel 2016 Foundation

Duration: 1 Day
Costs: Open courses: From £245 + VAT
In-house: Price on application - request a quote >>
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-requisites: Attendees do not need any previous experience of Excel but must have a basic understanding of PCs, including familiarity with a keyboard and mouse.

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

In-House Training

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

We pride ourselves on delivering training that is relevant to your business – ensuring staff see the benefits and how they can save time and work more efficiently.

We can deliver both tailored training sessions or the more traditional Foundation, Intermediate and Advanced levels.

Delivery Methods

Training can be delivered at your offices or we can help to select a suitable venue. We can deliver training in various different ways with the more popular being:

  • Group classroom training
  • 1-to-1 training sessions to address individual needs
  • Webinars/Online training

Laptop Hire

Laptop hire is available for most of our courses. We provide PC laptops with the appropriate software pre-loaded as well as projectors, mice and power extension leads.

Pre-Course Skills Assessments

Our focus is always on providing the most relevant training for each client. Before any course we offer pre-course assessments in order for us to ascertain your exact requirements, so you don't waste any time or money on training that isn't right for you and your business.

Course Materials

We provide electronic step by step training reference manuals and issue attendance certificates on completion of the training. That way once we finish, you'll still have everything you've learned at your fingertips.

Post Training Support

In order to make sure you get the best service and expertise from TrainingU, we offer unlimited lifetime post training support giving you peace of mind, should you need help with anything.

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