How to Create a Balanced Scorecard #excel #microsoftexcel #excelbyromeocostillas

How to Create a Balanced Scorecard

What is a Balanced Scorecard?
The balanced scorecard is a strategy performance management tool – a semi-standard structured report, that can be used by managers to keep track of the execution of activities by the staff within their control and to monitor the consequences arising from these actions. (Wikipedia)

*********************
What you will learn in this video tutorial?

FORMULA
* Sum
* Networkdays.intl
* Eomonth (End of Month)
* Index Match
* Nested if

FORMATTING
* Custom format
* Named range
* Drop-down with error alert
* Locked/Unlock cells
* Conditional formatting
* Hide columns and rows

KEYBOARD SHORTCUT
* F4 (When use in formula - $ sign)
* F4 (To repeat previous action)
* Ctrl + D (Fill down)
* Ctrl + Shift + Arrow Keys (Right/down)
* Ctrl + 1 (Format cells)
* Ctrl + Home

Download Balance Scorecard file
drive.google.com/file/d/1NrnMV4xbbvnhu9JeX8AXz0…

Learning EXCEL is fun!

*************************************************
Want to learn more about Excel?

SUBSCRIBE NOW:
youtube.com/channel/UCqGtUgcTs7Ml3ZliCqUo-3Q?vi…

YouTube Playlist:
youtube.com/watch?v=QprmWzbyFJo&list=PL6u1_…

Or visit me on Facebook at facebook.com/ExcelbyRomeoCostillas

See you there!


Romeo Costillas
Microsoft Certified Solutions Associate BI Reporting
Microsoft Office Specialist Master
Microsoft Office Specialist Excel Expert


To EXCEL in the workplace, one must know how to use Excel!"
- Romeo

#excel #microsoftexcel #excelbyromeocostillas #excelonline #exceltraining #excelfreetraining #excelmasterclass #tagalogexcel #excelpinoy