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

  > Section One - Make a Start with Excel  
 
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

3 Entering Simple Addition Formula

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

9 Finishing your spreadsheet for this section

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

7 The Format Chart Panel

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

12 Format your Axis Titles

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  
 


1 The SUM Function

2 How to Multiply in Excel

3 Subtract and Divide


4 Combining the Arithmetic Operators

5 A Budget Spreadsheet

 
  > Section Five - Functions in Excel 2007 to 2016  
 


1 The Average Function

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  
 


1 The IF Function

2 The AND and IF Functions

3 Conditional Formatting in Excel

4 Conditional Formatting - Averages

5 Data Bars in Cells


6 Colour Scales in Cells

7 Icons in Cells

8 CountIF

9 SumIF

 

  > Section Seven - Processing Data in Excel  
 


1 Flash Fill - your new best friend!

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


8 Absolute Cell References

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  
 


1 Reference other Worksheets

2 The LOOKUP Function

3 The VLOOKUP Function in Excel

4 Searching with MATCH and INDEX


5 Create a Business Invoice, Part One

6 Excel Business Invoice, Part Two

7 Business Invoice, Part Three

 
  > Section Nine- Advanced Excel  
 
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

5 Add your own Error Messages

6 Array Formulas Intermediate Excel


7 Frequency Distribution Intermediate Excel

8 Excel and Web Integration

9 Hyperlinks in Excel

10 Object Linking and Embedding

11 Insert Drawing Objects

© All course material copyright Home and Learn