If you've never used Excel before then this course is the ideal starting point.

If you currently use Excel, but are not confident using basic calculations or everything takes longer to do than it should this course will show you the techniques and shortcuts to make you more efficient.

• The Excel screen - The proper names for components of the screen and how to use them
• Spreadsheet basics - Entering and editing information along with saving as various file types
• AutoFill - Filling calculations, dates and text based lists such as months of the year
• Calculations - Add, subtract, multiply, divide and percentages
• Functions - Sum, Average, Min and Max
• Formatting - Column & row, numbers, date and time as well as text
• Printing - Scaling up and down to fit a page along with headers and footers
• Working with larger spreadsheets - Freezing and splitting the screen

Introduction to Microsoft Excel

• What is a spreadsheet used for?

Getting Started

• Starting Excel
• The Excel screen and The Ribbon
• Quick Access Toolbar and shortcut keys
• Formula bar and name box
• Sheet tabs and the status bar
• Active cell, column and row headers
• Moving around the spreadsheet
• Exiting Excel

Spreadsheet Basics

• Creating a new workbook
• Data types
• Entering and editing data
• Entering dates and times
• Deleting data
• Undo
• Selection techniques
• Saving and closing a workbook
• Opening a workbook
• File Formats and Working in Compatibility mode

Cut, Copy and Paste

• The clipboard
• Using cut, copy and paste
• Drag and drop
• AutoFill
• Custom lists and Excel Options

Entering Basic Calculations

• Entering calculations
• AutoSum
• Auto Complete
• Statistical functions

Formatting the Worksheet

• Home and Page Layout Tab
• Working with columns and rows
• Number formats
• Date and time formats
• Alignment and orientation
• Borders and patterns
• Cell Styles
• Format painter

Printing

• Print preview
• Page Layout View
• Page setup
• Page breaks
• Print titles
• Printing

Working with Larger Spreadsheets

• Splitting the screen
• Freezing panes

Introduction to Charting

• Creating a chart
• Printing a chart

The course runs from 9:30am through to 4:30pm.

You will learn in a relaxed environment with a small group of people. A specialist tutor will guide and encourage you through all the learning necessary to develop your skills and questions are always welcome.

Included with your course
We provide the following with online and training centre delivered courses.

• Course notes
• Certificate of attendance
• 90 days post course support

Online Delivery
A link to the online training platform will be sent before the course, simply click the link and follow the instructions.

• See Virtual / Remote training information for more details
• Contact us if you'd like to test the platform before the morning of the course
• You can be located anywhere in the world with an internet connection and your computer

Our Training Centres
For training courses run at one of our training centres we include.

• Free onsite parking
• Lunch and refreshments
• Notepad, pen and Polos

Our Norwich on-site parking (NR3 1UB) is free and situated 5 minutes walk along the river to our training centre at St James Mill. If you arrive by train it is about 20 minutes on the Riverside walk or a short taxi ride to get to us. View full directions for Norwich and all our other venues.

• Excel Intermediate
• Excel Advanced Level 1
• Word Introduction