GET THIS COURSE ONLINE
Do this course at home at your own pace
- Online videos 24x7 lifetime access
- Full written notes provided
- Ongoing support included
Ask for your money back within 30 days
for any reason if this isn't right for you !
This beginners Excel course is designed for users who have had little or no exposure to Microsoft Excel. It teaches the basic techniques that are required to put together a basic worksheet.
By the end of this 1 day course, participants will have the tools to enter a variety of data, create simple formulas, format the worksheet, create simple charts and be able to edit, save, retrieve and print their work.
Participants should be familiar with the Windows operating system and comfortable using a keyboard and mouse.
If you have used Excel before and you're not sure if you need this course then take our quick Beginners Excel Health Check
Our computers are always installed with the latest version of Office. The current version is Excel 2019 / Excel 365 (desktop).
If you have an earlier or Excel such as Excel 2016 or Excel 2013 we will explain any key differences during the training.
Still using Excel 2010 or earlier? It's time to say goodbye to an old friend and upgrade! Microsoft don't support this version any more.
Want To Customise Your Training Content?
Don't see exactly what you want in the topic list below?
You are welcome to swap topics in and out from the different courses available to create your own custom course.
We can accommodate all requests. Customisation is 100% free.
Let us deliver a powerful course with useful content that you or your staff will actually use. Tailor the training around your own needs and requirements.
- Creating, saving closing, opening and renaming a workbook
- Working with tabs and ribbons
- Using Excel's Help Tools
Working With Rows, Columns & Cells
- Working with text, numbers, dates and percentages
- Selecting a cell, cell-range, row or column
- Insert new rows or columns
- Deleting rows or columns
- Resizing rows or columns the smart way
- Moving around a worksheet
- Entering and editing a formula
- Rules for formulas
- Manipulating existing data
- All the mistakes to watch out for
- Formulas best practices
Using Basic Functions
- Five basic functions - SUM, AVERAGE, COUNT, MIN, MAX
- Adding together a group of numbers
- Averaging a set of numbers
- Counting how many numbers in a range
- Finding the largest/smallest number in a range
- Where to find and use other functions
Formatting a Worksheet
- The Format Cells dialog box
- Formatting a number or date
- Aligning text
- 45 degree text
- Controlling text with word wrap and shrink to fit
- Merging cells
- Formatting the font
- Superscript, subscript and strikethrough
- Setting borders and shading
- Using Format Painter to replicate cell formatting quickly
- Using the Format As Table feature
- Using AutoFill and the AutoFill oprions
- Inserting a picture or clipart
- Changing the background
Copying and Moving Data
- Cut, copy and paste
- Drag and drop
- The Windows Clipboard vs the Office Clipboard
- Identifying and fixing formula errors
- Spell check
- Find and Replace
- Using AutoCorrect and creating you own
Graphs and Charts
- Creating a chart with one key press
- Creating a chart using the Chart Ribbons
- Changing the chart type
- Setting the chart title
- Labelling the chart axes
- Turning the gridlines on or off
- Showing or hiding the legend
- Adding data labels
- Showing the data next to the chart
Formatting a worksheet for printing
- Setting a worksheet up for printing
- Setting the page size and orientation
- Setting the margins
- Creating a simple header and footer
- Printing column headers and rows labels on every page automatically
- Changing the page breaks
- Printing the whole worksheet or just a selection
- Previewing the worksheet before printing