Predict to Win in Business with Excel and Numbers

Don't just "keep the books," see the future, know what to do and when, using every day data from existing reports
5.0 (2 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,199 students enrolled
$19
$65
71% off
Take This Course
  • Lectures 45
  • Length 6 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2013 English

Course Description

If you use spreadsheets in your work, this course will revolutionize the way you look at data. If you "were" a startup, and are finding that Run is not the same as Start Up when money now has to come from cash flow, not investors, take this course!

Working hard in your business, there can be precious little time to work ON it, to make things better. When you do find time, trying to see what matters in columns and rows packed with too much data but too little meaning bites!

Do I have the cure? Not just how to keep the books, but how to know their meaning: everything you need to know to know when, whether, and where to act, and predict what will happen in the near future with confidence, so you can anticipate problems before they happen.

Starting with an overview of what will be learned, the course includes:

  • An entertaining Primer on Financial Reports and Accounting Principles, if that is possible...
  • In depth look at the problems of these reports as tools for operating a business
    • The Flaw of Averages
    • The Foibles of Percentages
    • And the Dangers in Limited Comparisons
  • Then how to create reports that do work, quickly and easily using the same data, only transforming it visually to allow you to see the real context, what the data means and what is mostly likely to happen, so you manage it with your eyes on the road in front of you, not stuck in the rear view mirror.
  • Many examples from real people like you.
  • Lots of working together, in virtual real time, like the Khan Academy
  • Independent exercises and study to help you nail how to do them.
  • AND MORE

Based on a proven system with more than 80 years of successful application in a wide variety of businesses, packed with examples from sports, healthcare, retail, manufacturing and more, and step by step hands on practice, guided by a Master, you will learn to transform data from your existing reports in a few minutes with a flick of a pen or a mouse.

If Simon Sinek helps with the why, this course helps with the how. How to know with precision what you need to make things not bite, as in earn more, be more productive and have more time in your life and enjoy it.

You will need a pencil, an eraser, some graph paper preferably, a straight edge, a calculator, a computer and spreadsheet software would be nice, but most of all, your uncomputer... your mind.

The course is made up of 45 classes, with over 6 hours of video, plus pdf's for study, supplementary materials, and an hour or two of independent practice to move you from first exposure to mastering the art of making wonderfully useful reports and how to apply them for breakthrough, magical results.

What are the requirements?

  • Some familiarity with the Profit and Loss report in particular, though there is a primer on the fundamental business reports so someone with focus could dominate the course from scratch with dedication, a pencil and eraser, some paper, preferably graph paper, a copy of either Excel® or Numbers® (or OpenOffice®), a computer, some time for practice and your UNcomputer... your mind!

What am I going to get from this course?

  • By the end of the course you will be able to take available data, and in a few minutes a day, squeeze the meaning out of it creating real, actionable knowledge for your business, while at the same time eliminating wasted time and effort spent on chasing things that in the end don't make a difference.
  • For those more well versed in Corporate MBA Accounting Speak, or anyone else who prefers bulletpoints to step by step practice, jumping around is recommended.

What is the target audience?

  • Anyone who uses spreadsheets and/or report data in their work

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Introduction
Preview
02:19
02:40

A more detailed overview of the course and what will be covered.

Section 1: Introductions, Expectations and What Will Be Covered
01:56
An Introduction to me, what I need from you and what you can expect from me.
16:23

Demystifying with humor the Profit and Loss and Balance Sheet (if accounting can be humorous), a short primer on the basics of two of the three main reports in GAAP, or Generally Accepted Accounting Principles. Great for those who want to bone up on the subject, or those who have used it for years, perhaps, secretly, wondering why.

Section 2: A Review of Financial Reports: What they were really designed for and why
05:27

It's not you! Why the common reports like the P&L do not provide context, are hard to connect with what really happened, or in other words, how can you know without enough context.

09:58

Why the flaws of averages and "apples and orange" percentage comparisons muddle understanding.

08:06

Why single datapoints and limited comparisons are so dangerous.

Review of Single Datapoints and Limited Comparisons
03:30
02:14

A short inspirational...

Section 3: Fourth Dimensional Visual Reporting
14:52

Moving from 2D to 4D reporting using the age old controversy, who is the greatest home run hitter of all time. (Thank you, Dr. Wheeler)

06:13

Another example from Football, (the one played with the feet, known as Soccer in the US), comparing Pele and ...

Section 4: Nature and Human Nature
06:06

What science explains about why we so easily find connections in data that may not be real, and other revolutionary tidbits.

14:28

The little known but utterly important law of nature they didn't teach you in school, and how it profoundly effects everything we do. Knowing it can provide a leg up on the competition; mastering it lead to almost magical success.

00:48

Short but sweet, including my priceless impression of white noise.

5 pages
Dr. Shewharts'rules for the visual presentation of data with meaning.
Section 5: The Pragmatic Approach
08:42

From driving looking in the rear view mirror (the common management reports) focused by what happened, not what is or will, to looking at the road in front of you.

Examples
11:15
00:46

A short but sweet call to action.

Section 6: Practice Doing Them
26:50

"All you need is 30 minutes and a pencil and paper to get what you need from the data..." We begin DOING, using the UNcomputer...

08:51

Turning our eyes from the past to looking forward from the present to the near future, so you can manage it.

16:44

Only after doing by hand, we move do doing in Excel: (I can't stop you, but thorougly encourage you to learn to do them by hand first. It will lead to a greater depth of understanding before you enlist the computer power that can multiply mistakes at the speed of light. What we learn by doing with our hands with pencil and paper, sticks with us, even if it feels a bit "heavy metal" sometimes.

06:58

The second part of the lecture before.

09:31

A look at more advanced work using a simple, affordable program from the Deming Collaboration Website, allowing you to look at seasonal and other effects without having to create a new chart every time. A great tool for understanding businesses like retail, agriculture, or any other business that changes seasonally.

Section 7: Putting it Together and Making it Work for You in a Few Minutes a Day
01:21

Another important allegory... burn it into your mind, it is elegant, simple and profound!

00:48

Short, sweet and will lead to breakthrough improvement, if you take it to heart. Why objectives fail.

04:01

A fable about managing with and without targets.

03:25

Creating the charts needed for a more or less universal report that measures how well your whole business is running, and lets you get a clear picture, practically in real time, of the health of your business, and how well you are managing your TRUE costs, the overall costs of the system.

What Matters: Settting up the Integrated Report
03:23
06:07

The application of the report created in the last lecture, to create instant, relevant, effective understanding in a way you could never dream of doing when seeing only in two dimensions as in the common financial reports.

13:10

What to do with your newly found time from your newly acquired knowledge: build a better system... in this case an ordering system as an example.

Section 8: More Practice Exercises
26:19

An age old technique from the days of apprenticeship for ensuring you burn the basics in... working alongside me. "Pedagogical" power technique.

07:34

An Uncomputer vs Computer smack down!

11:41

More hands on practice in Excel

17:07

An example for the "rest of us." (those using Macs) For Linux you are on your own, sorry, but I don't have a Linux computer.

14:21

hands on practice

13:04

More practice!

05:29

Even more practice

Section 9: The Home Stretch and the Heavy Stuff!
01:39

The importance of how things inter-relate.

06:52

How to really learn if something is useful and true. The missing link in most of today's management system: a good theory and reality testing, some say, the application of science to everyday life, I say making it relevant to every day life for profound breakthroughs in productivity and quality of production and personal life: introducing PDSA, a simple tool for profound learning and improvement. (enough superlatives?)

How Cost Cutting Can Put You Out of Business
Preview
15:56
07:01

Cost cutting vs. True Cost continued...

A Selective Timeline of Management History
16:21
03:01

Recommendations for awesome books on which much of this course was based, with supplementary pdf written by Dr. Donald Wheeler, Mr. Process Behavior himself, on why the charts work (Process Behavior Charts are officially called XmR charts.)

01:28

An inspirational slap on the back... just for you...

01:04

Some suggestions for next steps, if I succeeded in helping you change your glasses and you are thirsty for more!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Dan Strongin, Past President of the American Cheese Society-Chef and Coach

I bring many years of experience along every step of the food chain from farm to table, sharing my experiences, making people smile, helping people enjoy life more, and make great products profitably. My life's work has been about enjoying, nurturing, collaborating and cultivating in harmony with Nature.

A former 5 Star Chef, including 8 years with the prestigious Ritz Carlton Corporation, in the 1980's I pioneered the introduction of restaurant quality food to the Supermarket Industry in Northern California.

I was President and Chairman of the Board of the American Cheese Society, and am a founding member of the Deming Collaboration. In the 1990's I worked behind the scenes helping to plant the seed and cultivate the renaissance of high quality, local foods, from family farms in the US, working with, among others, the California Milk Advisory Board, The Extra Virgin Olive Oil Alliance (EVA), and the Dairy Business Innovation Center.

He blogs on productivity in harmony with Nature and is a monthly columnist for the Cheese Reporter.

Ready to start learning?
Take This Course