98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
Excel Introduction Training Course
Designed for Excel 365, 2016, 2013, 2010, 2007
Who is this course for?
Our Microsoft Excel Introduction course is suitable for complete beginners to Microsoft Excel.
A working knowledge of Windows is required, or our Microsoft Windows Introduction course. No experience of MS Excel is required.
- At the end of this course you will have a good working knowledge of Excel basics.
- You will feel more confident using Excel and be able to create a spreadsheet from scratch.
- Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments.
- Spreadsheets that you create will be easier to use and look more presentable.
- After completing this course you will be prepared to attend the Excel Intermediate training course.
What's new in Excel
Exploring the Excel window
Opening and navigating workbooks
Entering and Editing data
Entering and editing labels and values
Entering and editing formulas
Saving and updating workbooks
Modifying a Worksheet
Moving and copying data
Moving and copying formulas
Using absolute references
Inserting and deleting ranges
Using AVERAGE, MIN, and MAX
Formatting rows and columns
Using Format Painter and AutoFormat
Preparing to print
Page Setup options
Prices & Dates
What you get
Training is held in our modern, comfortable, air-conditioned suites
Modern-spec IT, fully networked with internet access
"What do I get on the day?"
Lunch is provided at a local restaurant or pub. Browse the sample menus:
Breaks and timing
Courses start at 9:30am.
Please aim to be with us for 9:15am.
Joining information (how to get to our venues)
Available throughout the day:
- Hot beverages
- Clean, filtered water
Training formats & Services
I feel really confident about the course subject after this training.
ERA Technology Ltd
None. Marius covered our needs and always asked if we needed anything further and made sure we understood what he had just taught
The course was really helpful and covered the areas that I was hoping to touch upon and gain knowledge of. I feel confident that I will be able to use the information learnt in my role. Elaborating on formulas and associated rules might be useful.
The beginners Excel course is a fantastic starting point for professionals with a basic knowledge of Excel.
Example training manuals
Below are some extracts from our free Excel training manuals.
Module 6: Using Time Saving Tools
This module introduces some time saving tools to make basic worksheet creation even easier. The AutoFill feature can help you quickly repeat formulas or do things like fill in the days of the week or months of the year. The AutoComplete feature can help you to quickly write functions. This module will also look at sorting and filtering your data to efficiently find the data you need. Finally, this module will introduce Sparklines - a feature in Excel that allows you to create cell-sized graphs that can be helpful in showing trends.
AutoFill is a feature that quickly creates copies of a cell based on that cell’s contents. If the cell contains a formula, the formula is repeated with relative references. If the cell contains a date, AutoFill creates a list with that date as the starting point.
To use AutoFill, simply select the AutoFill handle and drag to fill the contents of consecutive rows or columns. The AutoFill handle is present for the active cell. It is a small square at the bottom right corner of the cell.
You can only fill in one direction at a time.
Use the following procedure to copy a formula using the AutoFill handle. This example uses the formula in the "# Left to reorder" column in the Inventory sample worksheet.
- Click on the cell with the formula you want to copy. Excel displays a handle around the cell.
- Drag the handle at the bottom right corner of the cell to the end of the range of cells where you want to copy the formula.
- Release the mouse button at the end of the range. Excel displays a menu to help determine you AutoFill options. For this example, we want to Copy Cells.
Use the following procedure to create a list using AutoFill. This example creates new columns in the Budget worksheet to cover the second six months.
- Create a new column heading with the text "July" in cell J4.
- Click on that cell to make it active. Excel displays a handle around the cell.
- Drag the handle across the columns. Excel displays a screen tip showing what AutoFill will place in those cells.
- Release the mouse button at the end of the range. Excel versions 2016, 2013 and 2010 display a menu to help determine you AutoFill options. For this example, you can choose either Fill Series or Fill Months. For Excel versions 2007, 2003, 2002/XP, 2000 and 97, please consult our other free training manuals.
AutoComplete is an Excel feature that helps you save time. You can begin typing the name of a function that you want to use in a cell. Excel displays a list of functions that start with those letters. Then you can simply select the appropriate function from the drop down list. This helps save time for the functions you use frequently. It also helps ensure accuracy for your arguments in the function.
Use the following procedure to use the AutoComplete feature.
- Begin typing the SUM function. As soon as you type the Equals sign and the letter S, Excel displays a possible list of matching functions.
- To select the SUM Function from the list, double-click on the SUM function.
- Excel enters the function, but you must still enter the arguments. You can simply click on multiple cells, or click and drag to select a cell range. You can also type in the cell references.
- Enter the final parenthesis mark to end the function.
- Press ENTER to enter the function in the cell.
Sparklines are tiny charts that are actually in the background of a cell. Sparklines can be used to visually display trends that might be harder to spot just from the data alone. Sparklines provide valuable information at just a glance.
Use the following procedure to create a sparkline. This example shows a sparkline for the "heat" category on the budget.
- Click on the cell where you want to create the sparkline.
- Click the Insert tab.
- Click the type of Sparkline you want to include from the Sparklines group. For this example, line or bar chart work best.