How To Create a Balanced Scorecard From Scratch Using Excel
3.9 (41 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.
2,216 students enrolled
Wishlisted Wishlist

Please confirm that you want to add How To Create a Balanced Scorecard From Scratch Using Excel to your Wishlist.

Add to Wishlist

How To Create a Balanced Scorecard From Scratch Using Excel

Improve Your Organization's Performance By Building This Data-Driven Tool! Balanced Scorecard Template Included
3.9 (41 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.
2,216 students enrolled
Last updated 3/2017
English
Current price: $10 Original price: $95 Discount: 89% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 3 Articles
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Build a Balanced Scorecard from scratch using Excel
  • Use click method and formulas to change color of cells to visually see results
  • Link cells and sheets to enhance your dynamic tool
View Curriculum
Requirements
  • Speak English
  • Ready to learn and engage in a community committed to excellence
Description

  • Learn using a real Balanced Scorecard Example!
  • FREE Balanced Scorecard Template Included! (with additional formulas for Mac and PC added for easier use!)

*2 BRAND NEW* demo lectures added below

See FOUR FREE Preview lectures below!

+++++++++++

Improve your organizational performance! Everything you need to build a Balanced Scorecard from scratch using Excel!

+++++++++++

Every organization seeks to improve its performance. Having worked with organizations around the world I found a pattern: Many are spending thousands of dollars on software and consultants to track performance each year. A team and I used our education and experience to build the same scorecard using Excel—the results speak for themselves.

And now…I want to share this process with you so you can have a tool to make better decisions and improve your organization’s performance.

++++++++++++

21+ Lectures and Over 3.5 hours of content!

✔ Easy to Learn Material—free template download available to get started

Project Based Learning—Build your scorecard to fit your organization

Use data to manage your organization’s performance

Follow the Best Practices of Top Corporations For Your Context

Five-Star Review: Perfect for beginners.

The Balanced Scorecard is the best practice to improve your organizations performance. Here's some stats that prove that using a scorecard in your business will produce positive results:

  • The Advanced Performance Institute reports that about half of major companies in the US, Europe and Asia are using Balanced Scorecard Approaches. The exact figures vary slightly but the Gartner Group suggests that over 50% of large US firms had adopted the BSC by the end of 2000
  • ClearPoint Strategy put together a list of the top companies using the Balanced Scorecard:
  • Private Sector: (Banking: Wells Fargo, Energy: Mobil North America Marketing and Refining (NAM&R), Electronics: Philips Electronics, Financial: Thomson Reuters)
  • Public Sector: (Local Government: City of Charlotte, NC, U.S. Government: Defense Logistics Agency and Higher Education: University of Virginia


There is no better time to build a Balanced Scorecard for your organization--big or small.

Here's what we will cover in this course...

Learn how to build your Balanced Scorecard from scratch using Excel. We start with the dashboard, formulate the perspectives and then craft the input sheets. Finally, we tie it all together and use it to track organizational performance.

BONUS PDF REPORT – links to important articles and blogs to learn from other experts - Must finish the course to access this free report. 21+ Informative Videos including:

  • What is a Balanced Scorecard?
  • Basics of the Dashboard
  • How to formulate your perspective sheet
  • What does an input sheet look like for my departments?


Don't forget to check out the free preview lectures to sample my course. Are you ready to learn with me? By the end of this course students will know:

  • Basics of the Balanced Scorecard 
  • How to design you own dashboard
  • Manipulate Excel to craft your perspective sheets
  • Formulate input sheets
  • Link sheets to capture trends
  • Use the tool to increase revenue
  • Much More!


Don't wait another day to begin building your Balanced Scorecard.

CLICK "TAKE THIS COURSE" TO GET STARTED NOW!

Who is the target audience?
  • Anyone interested in improving their organization's performance
Students Who Viewed This Course Also Viewed
Curriculum For This Course
26 Lectures
03:30:46
+
Let's Get Started :)
2 Lectures 10:02

Welcome to the Course :) By the end of this lecture you will have an understanding of the major pieces of the scorecard.

Preview 01:56

After downloading the Excel template and the Explanation sheet, this lecture will introduce you to the Dashboard--the heart of the scorecard. We will discuss the purpose, composition, and content of the dashboard and guide you to tweak it to your needs.

Preview 08:06
+
Unpacking Scorecard Perspectives
9 Lectures 01:24:47

A perspective is a lens through which to view your organization. By the end of this lecture you will be able to formulate your own mission, and design the scorecard to measure your journey to this goal.

Mission Perspective
15:31

Serving customers is critical to the bottomline. In this lesson we use formulas to integrate what we know about the customers with what we do to serve them better.

Custumer Focus Part I
06:58

By the end of this lecture, you will know how to use formatting to create a visual of your organizations performance, measure customer satisfaction and new customer referral.

Customer Focus Part II
12:57

Brand New Lecture Demo: Identify your target audience
05:06

Internal processes are critical to success. This lecture outlines the basic components of measuring internal processes and makes suggestions as to how to increase efficiency. Students will learn some Excel tricks to include in their scorecards.

Internal Processes
14:18

In this lecture, we dive into learning and knowledge. After this lecture, students will learn about learning plans, skill level assessments and integrate them into their workplace.

Professional Development
11:58

Brand New Lecture Demo: Conduct a skills audit
03:13

Money talks--in this scorecard we discuss the language of money--how to measure in an effective way the financial health of your organization. By the end of this lesson, the student will have updated their financial perspective and used an efficiency ratio to map financial status.

Financial Perspective
13:13

Troubleshooting: A summary
01:33
+
Crafting The Input Sheets
7 Lectures 58:43

If the dashboard is the heart, perspectives limbs, then the input sheet are the organs that keep your scorecard running. At the end of this lecture students will build their own input sheet and learn how to link it to the perspective and dashboard.

Input Sheet: The Fundamentals
11:23

We focus on departments in this lecture. You learn how to craft the input sheet for various sized departments.

Input Client Focus Data
11:36

By the end of this lecture students learn how to input data to manage their internal processes.

Input: Internal Processes Data
11:51

How to Input Professional Development Data
05:51

Show me the Money: Inputting Financial Data
09:01


In this lecture we wrap up the key information needed to construct your input sheet.

Preview 05:26
+
Linking everything back to the Dashboard
6 Lectures 56:44

In this lecture we link all the components of the scorecard. By the end of this lecture students will learn how to link the mission to the perspective and input sheets.

Course Wrap Up: You built your own scorecard, now what?
12:55

Capturing our Client Focus Data
09:36

Measuring our Internal Processes
07:35

Professional Development and Financial Data
18:36

Troubleshooting your scorecard--make it work for you.
04:05

We tie the course together in this lecture. By the end of the of this lecture students will have full scorecard. They will be proficient in building, updating, and utilizing the scorecard tool in their daily organizational life.

Congratulations! You have built your scorecard from scratch!
03:57
+
Bonus Section
2 Lectures 00:38
Bonus: More Courses from Warren
00:35

Helpful resources
00:03
About the Instructor
Warren Chalklen, PhD
4.3 Average rating
475 Reviews
36,762 Students
17 Courses
Education Innovator | 36,000+ Students on Udemy

Dr. Warren Chalklen is an education innovator who has taught over 36,000+ students across 165 countries using online and face to face platforms. He is passionate about building individual and organizational capacity in the fields of diversity, policy analysis, and data driven performance with softwares such as Excel, Salesforce and Balanced Scorecard tools. In his spare time he loves to travel and recently returned from a vacation in Brazil!