Quick Start Excel

Are you a complete and utter Excel novice?

?You are feeling utterly stupid and out of your depth.

?You have never opened a spreadsheet in your life.

?No, that's not true. You did once and it just looked like a bunch of boxes.

?You have looked at the beginners syllabus and it's all just gobbledegook.

?It all just seems too hard, too much but yet you know that somehow you have to get to grips with it.

So, what's in it for you?

The course is an hour long. You could do it in your lunch break.

Every video is less than 5 minutes and you can do it when it suits you.

It assumes no prior knowledge of Excel. One of the first things you learn is how to escape and undo. It even shows you how to save a file.

You have lifetime access so you can revisit as many times as you want - even if you just want to remind yourself of how far you've come.

Course Curriculum

Introduction and meet your instructor
2 Lessons
- Introduction and welcome to the Course
  Start
- List of the books I've written
  Start
1. First things first - know your keyboard
4 Lessons
- 1.1 Identify these keys: Ctrl, Shift, Enter, Backspace, Delete
  Start
- 1.2 Know your F4 key and the Fn key
  Start
- 1.3 Get out of jail keys: Learn ESC and Undo.
  Start
- 1.4 Quiz on knowing your keyboard
  Start
2. Say Hello to Excel
4 Lessons
- 2.1 Open Excel
  Start
- 2.2 Identify rows, columns and cell references
  Start
- 2.3 Try out the ribbon - notice the tool tips
  Start
- 2.4 Quiz on Say Hello to Excel
  Start
3. Working With your Files
5 Lessons
- 3.1 How to save a file
  Start
- 3.2 How to open a file you have already saved
  Start
- 3.3 How to pin a file so you can access it again
  Start
- 3.4 How to save a file with a new name
  Start
- 3.5 Module 3 - Resources
  Start
4. Entering and Breaking
4 Lessons
- 4.1 Practice entering numbers and undo - notice they are on the right
  Start
- 4.2 Practice entering text and undo - notice they are on the left
  Start
- 4.3 Practice entering dates and undo. Reference ###
  Start
- 4.4 Module 4 - Practice
  Start
5. Know How to Use Your Mouse
3 Lessons
- 5.1 Copying down and across (black cross and white cross)
  Start
- 5.2 Help, I don't have a cross
  Start
- 5.3 Module 5 - Practice
  Start
6. Copying and Formatting
4 Lessons
- 6.1 Entering, copying and formatting a day/month
  Start
- 6.2 Entering, copying and formatting numbers
  Start
- 6.3 Entering, copying and formatting dates
  Start
- 6.4 Module 6 - Practice
  Start
7. Cut, Copy and Paste
4 Lessons
- 7.1 Enter some text and move it by cutting and pasting - ribbon and keyboard
  Start
- 7.2 Enter some text and copy it by copy and paste - ribbon and keyboard
  Start
- 7.3 Enter some dates and experiment with moving/copying
  Start
- 7.4 Module 7 - Practice
  Start
8. Meet Some Formulas
7 Lessons
- 8.1 Enter two numbers and add them together, then copy them down
  Start
- 8.2 Enter two numbers and subtract from each other, then copy them down
  Start
- 8.3 Enter two numbers and multiply them together, then copy them down
  Start
- 8.4 Enter two numbers and divide them, then copy them down
  Start
- 8.5 Fixing a Cell
  Start
- 8.6 Module 8 - Resources
  Start
- 8.7 Quiz on Formulas
  Start
9. Data Setup
6 Lessons
- 9.1 Rules about data entry
  Start
- 9.2 How to set up a list
  Start
- 9.3 How to do a basic sort
  Start
- 9.4 How to do a basic filter and clear it
  Start
- 9.5 Module 9 - Resources
  Start
- 9.6 Quiz on data entry
  Start
YOU DID IT - WELL DONE!
1 Lesson
- Conclusion and Congratulations
  Start