Excel Foundation
Delivered Face to Face or Virtually
Who should attend?
Our Excel Foundation course is perfect for both beginners and those who are self-taught in Microsoft Excel and are looking to learn skills that will transform how they work on a day-to-day basis. Each course is designed and delivered by industry leading trainers, giving you the confidence, you are receiving the highest quality of training available.
Prerequisites
Delegates will need to be familiar with using personal computers and should have experience using a keyboard and mouse. We would expect delegates to know how to: launch and close applications, navigate, save and open files.
Course Objectives
Upon completion, all delegates will receive a certificate of attendance, an extensive manual and the confidence to use features such as creating formulas, formatting and entering data quickly and comfortably. All of which will benefit you on a day-to-day basis.
This course can be customised to incorporate other features of Office 365.
To find out more about our training options or to find out whether this course is right for you, please speak to our team today.
Course Duration
1 Day Classroom Training or Online.
Our course timings are 09:30 - 16:30, however timings can be customised to meet your needs.
Getting started with Microsoft Excel
Introduction to Excel
Navigating the Excel Screen and Ribbon
Tips and Tricks for Selection and Movement around the screen
File Management
Creating and Saving Workbooks
Opening Workbooks
Data Input and Selection
Typing and Formatting for Text, Dates and Numbers
Selecting Cells, Rows and Columns using the Mouse and Keyboard shortcuts
Using Functions
Using the Sum, Average, Min, Max, Count Functions
Understanding and working with the Function Wizard
Working with Dates
Date Calculations
Formatting Dates
Copying and Moving Data/Formulae
Using Cut, Copy and Paste
AutoFill
Drag and Drop
Copy and Drop
Editing Worksheets
Adding Rows and Columns
Sizing Rows and Columns
Hiding/Unhiding Rows and Columns
Formatting Worksheets
Working with Fonts, Sizes and Colours
Adding Borders and Fill Colour to Cells
Aligning the Content of a Cell
Applying Number Formatting
Using the Format Painter
Merge and Unmerge Cells
Working with Large Worksheets
Freezing Panes
Working with Split Pane View
AutoFilter
Printing
Using Print Preview
Setting the Print Range
Sizing Spreadsheets to Fit
Working with Margins, Headers and Footers and other useful print settings
Multiple Sheets
Creating new Sheets
Colouring Sheet Tabs
Navigating Sheets
Deleting Sheets
Charts and Graphs
Creating Charts and Graphs alongside data
Creating Charts and Graphs on a new sheet
Changing the Chart Types
Basic Formatting of Charts and Graphs
