Excel is often described as a spreadsheet application that allows you to do all kinds of fancy intricate things like create formulas, graphs, pivot tables, macros and whole host of other stuff. How is that for a high powered definition? While this is true when you distill Excel down to it’s pure essence please recognize Excel is nothing more than a big, fancy electronic calculator.

Excel is an incredibly powerful application and the key to learning Excel is to learn the fundamentals- from there realize the things you learn are topical not progressive.  Meaning that when you learn Excel the key is to look at each lesson as it’s own separate entity that can be blended (or strung together) with other topics.  Phrased differently excel is just a smorgasbord of parts you can mix together however you wish.

NOTE: This is a “legacy class” and is intended for people who are not overly concerned about specific software versions since the changes between one release to another are largely negligible.  This course was created with Excel 2010, but the content is applicable to Excel 2013, 2016/ Office 365 and to some extent 2007.  Just be aware there may be some minor differences between versions yet nothing so extreme that you’ll be totally lost.

Download Student Files (in zipped format)

Course Running Time: 12 hrs 14 min

 

 

Take this Course

Course Content

Lessons Status
1

Module 1 Overview of All the Common Pieces in MS Office (19 Lessons)

2

Module 2 Excel Fundamentals | The Need To Know Topics (15 Lessons)

3

Module 3 Dress Up Your Data And Make It Look Nice (22 Lessons)

4

Module 4 So How Do You Print Everything (7 Lessons)

5

Module 5 Starting Down The Road Of Math | The Heart Of Excel (30 Lessons)

6

Module 6 List Management: Sorts, Filters, Pivot Tables & More (14 Lessons)

7

Module 7 Charting and Some Miscellaneous Stuff Excel Has To Offer (16 Lessons)

8

Module 8 Macros and Creating Interactive Charts (4 Lessons)

9

Module 9 Creating Dashboards (1 Lesson)

10

Module 10 Wrap Up (1 Lesson)