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.
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.