Free computer Tutorials

HOME Stay at Home and Learn

Microsoft Excel 2007 Course

 
Computer Tutorials List

 

 

 

 

 

Our latest Home and Learn course is Excel 2007. We aim to make it as comprehensive as our previous Excel course, and will be adding more tutorials until it's a complete book. If you haven't yet seen Office 2007, Microsoft have a free 30 day trial version. Grab it while you can! (We recommend the Home and Student version - A Windows Live ID or Microsoft Passport account is needed to download the trial version.)

  > Section One - Make a Start with Excel 2007  
 
1 A first look at Excel 2007

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


7 How to change the colour of a Cell

8 How to Save your work in Excel 2007

9 Currency Symbols in Excel 2007

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

3 Entering Simple Addition Formula

4 The SUM Function in Excel 2007

5 The SUM Function Continued

6 Copy and Paste


7 How to use Paste Special

8 How to Multiply in Excel 2007

9 Finishing your spreadsheet for this section

10 How to Add a Comment to a Cell

11 Review Number Two

 
  > Section Three - Excel 2007 Charts  
 
1 How to Sort Data in Excel 2007

2 Create an Excel 2007 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


7 The Format Chart Panel

8 Create a Pie Chart in Excel 2007

9 Add Labels to a Pie Chart

10 Format Pie Chart Segments

11 Create a 2D Line Chart in Excel 2007

12 Format your Axis Titles

 
  > Formulas in Excel 2007  
 


1 The SUM Function in Excel 2007

2 How to Multiply in Excel 2007

3 Subtract and Divide


4 Combining the Arithmetic Operators

5 A Budget Spreadsheet in Excel 2007

 
  > Functions in Excel 2007  
 


1 The Average Function in Excel 2007

2 The Date Function

3 Time Functions in Excel 2007


4 A TimeTable Project

5 Financial Functions

6 The Student Averages Project

 
  > Conditional Logic in Excel 2007  
 


1 The IF Function

2 Conditional Formatting in Excel 2007


3 CountIF

4 SumIF

 

  > Processing Data in Excel 2007  
 


1 Data Tables in Excel 2007

2 A Second Data Table

3 Excel 2007 Scenarios

4 Goal Seek


5 Absolute Cell References

6 Named Ranges in Excel 2007

7 Excel 2007 Pivot Tables

8 Pivot Tables, Part Two

 
  > Advanced Excel 2007  
 
1 Quick Access Toolbar in Excel 2007

2 Data Forms

3 Drop Down Lists in Excel 2007

4 Add your own Error Messages

5 Excel 2007 and Web Integration


6 Hyperlinks in Excel 2007

7 Object Linking and Embedding

8 Reference other Worksheets

9 Insert Drawing Objects

All Course Material ©Copyright of Home and Learn