Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Predict to Win in Business with Excel (or Numbers)
Introductions, Expectations and What Will Be Covered
Introduction (2:10)
Introductory Review (2:18)
Review of Income Statements Revealed (4:02)
What Hurts: Personally and Professionally!
Review of Single Datapoints and Limited Comparisons (3:30)
Hurt'n to Learn (2:14)
Rapid Pain Relief Through Visual Reporting
The National Pastime REDUX (for review) (14:52)
The Rest of the World's Pastime (6:13)
Nature and Human Nature
How our Humanity Trips Us Up (6:06)
Nature Varies! (14:28)
Signals in the Noise (0:48)
Shewharts Rules for Presenting Data Visually
The Pragmatic Approach
Real Life Examples (11:15)
Changing your Glasses (0:46)
How to Do Them
Finding the Meaning with Pencil and Paper (26:50)
Charts by Excel® (Only after doing by hand) (16:43)
Charts by Excel® Continued (6:58)
By Hand Looking into the Future: The Power of Prediction (8:51)
A Thermometer Allegory (1:21)
A bit of Software to Streamline Your Work and help with Seasonal Fluctuations (9:31)
Putting it Together and Making it Work for You in a Few Minutes a Day
The Problem with Targets: A Better Way! (0:47)
The Fable of Jack and Jill (4:01)
Setting up an Integrated Report: The Charts (3:25)
What Matters: Settting up the Integrated Report (3:23)
Instant Visual Understanding: Doing It! (6:07)
With Your New Free Time: An Improvement Project (13:10)
The Home Stretch
Connectedness (1:39)
Pragmatism aka Reality Testing (6:52)
How Cost Cutting Can Put You Out of Business (15:56)
Cut Costs, Down the Drain You Go Continued... (7:01)
A Selective Timeline of Management History (16:21)
Further Reading and Study (3:01)
Congratulations! You Made It! (1:28)
Practice Exercises
Learn by Copying Along: Old fashioned but effective (26:19)
By Hand vs. By Machine (7:34)
Another Excel® Example (11:41)
An Examples in Apple iWork Numbers® (17:07)
Exercises (14:21)
More Exercises (13:04)
Even More Exercises (5:29)
Teach online with
Introductory Review
A quick review of what is covered.
Complete and Continue
