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 2007 to 2016

8 Create a Pie Chart 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

> 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 Conditional Formatting in Excel

3 CountIF

4 SumIF

> Section Seven - Processing Data in Excel

2 A Second Data Table

3 Excel Scenarios

4 Goal Seek

5 Absolute Cell References

6 Named Ranges in Excel 2007 to 2016

7 Create a Custom Name in Excel

8 Excel Pivot Tables

10 Reference other Worksheets

11 The LOOKUP Function

12 The VLOOKUP Function in Excel

13 Create a Business Invoice, Part One

14 Excel Business Invoice, Part Two

> Section Eight - Advanced Excel 2007 to 2016

1 How to Create an Excel Template

2 Data Forms in Excel 2007 to 2016

3 Drop Down Lists in Excel