Microsoft Excel 2010

What Alison says about this course

This course teaches you how to make full use of the revised 2010 version of Microsoft Excel. We explore the program’s menus and examine the different tasks it can perform.

What you will cover

Alison splits this short course into 16 modules across 125 topics, about 10 hours of study in total.

1. Module 1: Making the switch to Excel 2010 — 10 topics
2. Module 2: What's new in Excel 2010 — 16 topics
3. Module 3: Basic Tasks in Excel 2010 — 7 topics
4. Module 4: Create your first spreadsheet — 9 topics
5. Module 5: Create Formulas — 7 topics
6. Module 6: VLOOKUP - What it is and when to use it — 7 topics
7. Module 7: Understand Data at a glance with Conditional Formatting — 6 topics
8. Module 8: Sparklines - Use tiny charts to show data trends — 6 topics
9. Module 9: Use Excel tables to manage information — 6 topics
10. Module 10: The IF Function - What it is and how to use it — 5 topics
11. Module 11: How to create a basic chart in Excel 2010 — 9 topics
12. Module 12: Save time by creating and running macros in Excel 2010 — 6 topics
13. Module 13: Figure out dates by using formulas in Excel 2010 — 8 topics
14. Module 14: Plan payments and savings in Excel 2010 — 9 topics
15. Module 15: Keyboard shortcuts in Excel 2010 — 13 topics
16. Microsoft Excel 2010 - Course Assessment — 1 topic

The summary above is Alison's own wording, and the module list is theirs too. Confirm the details on their course page before you start.

How to start

The course is hosted by Alison. Use the “Start this course” button above to open it on their site, where you create an account with them and study at your own pace. There is no deadline and no fee to learn. The learning is free; Alison charges separately if you want a certificate at the end, and that is entirely optional.