Free computer Tutorials

HOME

Stay at Home and Learn

Microsoft Excel Tutorials

Contents Page

Computer Tutorials List

Exam Section

For those new to the world of Microsoft Excel spreadsheets, this course is for you! We've put the entire course online, for you to dip in as you please. Or why not buy the entire course as a printed book? It will make your life easier!

> Section One - Getting Started with Excel

2 Launching and Exploring Excel

3 Entering data into a Spreadsheet

4 How to Widen Rows and Columns in Excel

6 Font formatting in Excel

7 Saving your work

> Section Two - Entering Data into Cells

4 Adding up with SUM

> Section Three - Extending the Spreadsheet

2 Copy and Paste in Excel

5 Adding Comments to Cells

> Section Four - Excel charts

2 Create a Bar Chart

3 Formatting the Chart

5 Creating a Pie Chart

6 Project Three

> Section Five - math operators in Excel

2. Combining mathematical Operators

> SectionSix - An introduction to Functions

1. The Average Function

2. Date Functions in Excel

3. The Time Function

4. Financial Functions in Excel

> Section Seven - Conditional Logic

1.Conditional Logic

2. Conditional Formatting

3. The CountIF Function

2. The AND and SUMIF functions in Excel

> Section Eight - Tables, Scenarios, Goal Seek

1. Excel Tables, Part One

2. Excel Tables, Part Two

3. Scenarios in Excel

4. How to use Goal Seek

> Section Nine - reference, range, Pivot table

2. Named Ranges in Excel

3. Using Named Ranges

5. How to Create a Pivot Table in Excel

6. Extending the Pivot Table

> Section Ten - Input Forms, Data Validation

1. Data Input Forms in Excel

2. Data Validation in Excel (Drop down lists)

> Section Eleven - Web Integration

1. Web Integration and Excel

2. How to Create a Web Query in Excel

3. Web Query, Part Two

4. How to Add Hyperlinks in Excel

> Section Tweleve - Extras

1. Insert a spreadsheet into a Word document

3. Insert drawing objects into spreadsheets

4. Insert images into Excel