Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

How To Create a Balanced Scorecard From Scratch Using Excel

Name: How To Create a Balanced Scorecard From Scratch Using Excel
Rating: 4.3 (169 reviews)

Improve Your Organization's Performance By Building This Data-Driven Tool! Balanced Scorecard Template Included

Created byWarren Chalklen, PhD

Last updated 6/2017

English

What you'll 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

Course content

5 sections • 26 lectures • 3h 30m total length

Welcome to the course!1:56
Welcome to the Course :) By the end of this lecture you will have an understanding of the major pieces of the scorecard.
Purpose, Composition and Content for your Dashboard8:06
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.

Mission Perspective15:31
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.
Custumer Focus Part I6:58
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.
Customer Focus Part II12:57
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.
Brand New Lecture Demo: Identify your target audience5:06
Internal Processes14:18
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.
Professional Development11:58
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.
Brand New Lecture Demo: Conduct a skills audit3:13
Financial Perspective13: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.
Troubleshooting: A summary1:29

Input Sheet: The Fundamentals11:23
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 Client Focus Data11:36
We focus on departments in this lecture. You learn how to craft the input sheet for various sized departments.
How to Input Professional Development Data5:51
Input: Internal Processes Data11:51
By the end of this lecture students learn how to input data to manage their internal processes.
Show me the Money: Inputting Financial Data9:01
Applying what we Learned to a New Department3:35
Wrapping up the Input Sheet Section5:26
In this lecture we wrap up the key information needed to construct your input sheet.

Course Wrap Up: You built your own scorecard, now what?12:55
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.
Capturing our Client Focus Data9:36
Measuring our Internal Processes7:35
Professional Development and Financial Data18:36
Troubleshooting your scorecard--make it work for you.4:05
Congratulations! You have built your scorecard from scratch!3:57
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.

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 this course is for:

Anyone interested in improving their organization's performance

How To Create a Balanced Scorecard From Scratch Using Excel

What you'll learn

Explore related topics

Course content

Let's Get Started :)2 lectures • 10min

Unpacking Scorecard Perspectives9 lectures • 1hr 25min

Crafting The Input Sheets7 lectures • 59min

Linking everything back to the Dashboard6 lectures • 57min

Bonus Section2 lectures • 1min

Requirements

Description

Who this course is for: