Free computer Tutorials

HOME

# Microsoft Excel 2007 to 2016 Course

 Computer Tutorials List
This is a full and free computer course for Microsoft Excel 2007 to 2016. If you're not sure whether or not you're in the right place take a look at Section 1.1 below, A First Look at Excel. By the time you've finished the course you'll be an intermediate Excel user. So good luck!

For those who have older versions of Excel (versions up to 2003) then your tutorials are here: Excel 2000 to 2003

1 A first look at Excel 2007 to 2016

2 Excel Rows and Columns

3 Enter text and numbers in a Cell

4 How to Edit text in a Cell

5 How to Centre text and numbers

6 Font Formatting in Excel 2007 to 2016

7 How to change the colour of a Cell

8 How to Save your work in Excel

9 Currency Symbols in Excel 2007 to 2016

10 How to Merge Cells

11 Review Number One

> Section Two - A more complex spreadsheet

1 Introduction to Section Two

2 How to use AutoFill in Excel 2007 to 2016

4 The SUM Function in Excel

5 The SUM Function Continued

6 Copy and Paste

7 How to use Paste Special

8 How to Multiply in Excel 2007 to 2016

10 How to Add a Comment to a Cell

11 Review Number Two

> Section Three - Excel 2007 to 2016 Charts

1 How to Sort Data in Excel

2 Create an Excel Chart

3 Move and Resize your Chart

4 Chart Styles and Layouts

5 Chart Titles and Series Titles

6 Chart Layout Panel in Excel

9 Add Labels to a Pie Chart

10 Format Pie Chart Segments

11 Create a 2D Line Chart in Excel

13 Predict the future with a Trendline Chart

14 Sparkline Charts

15 Replace boring bars with images

> Section Four - Formulas in Excel 2007 to 2016

2 How to Multiply in Excel

3 Subtract and Divide

> Section Five - Functions in Excel 2007 to 2016

2 The Date Function

3 Time Functions in Excel

4 A TimeTable Project

5 Financial Functions

6 The Student Averages Project

> Section Six - Conditional Logic in Excel

2 The AND and IF Functions

3 Conditional Formatting in Excel

4 Conditional Formatting - Averages

5 Data Bars in Cells

7 Icons in Cells

8 CountIF

9 SumIF

> Section Seven - Processing Data in Excel

2 Simple Excel Tables

3 Automatically Update a Chart

4 Data Tables in Excel

5 A Second Data Table

6 Excel Scenarios

7 Goal Seek

9 Named Ranges in Excel

10 Create a Custom Name in Excel

11 More on Named Ranges

12 Excel Pivot Tables

13 Pivot Tables, Part Two

> Section Eight - Searching Excel

2 The LOOKUP Function

3 The VLOOKUP Function in Excel

4 Searching with MATCH and INDEX

6 Excel Business Invoice, Part Two

1 How to Create an Excel Template

2 Data Forms in Excel

3 Drop Down Lists in Excel

4 Add a Spin Button to a Cell

6 Array Formulas Intermediate Excel

7 Frequency Distribution Intermediate Excel

8 Excel and Web Integration