How to Changing KPIs or Create New KPIs in the HSE Performance Monitoring Tool

Описание: DOWNLOAD IT HERE 👉 https://www.sheqxel.com/sheqxel-perfo...

Hello guys👋 In this video, I show you how to change KPIs and create your own KPIs. I show you how to correct any #REF errors on the objectives and target sheet and the daily HSE report template, and then again update the HSE statistics sheet and the individual KPI report. This video is a special request from Mohsin, our user from Pakistan

Below are the timestamps for the tutorial, click on the specific timestamp to watch the content.

0:00 - Intro
0:11 - Overview of the Tutorial
1:26 - Request from our User - a Case Study
2:44 - Unprotecting Worksheet and Workbook
4:26 - Changing the Two(2) KPIs in Actual Source Data Sheet
5:03 - Changing the Two(2) KPIs in Target Source Data Sheet
6:34 - Refresh All Leading to #REF Errors
7:37 - Locating the Connecting Sheets to Unhide
8:54 - Selecting the New KPIs from the Pivot tables
10:08 - Fixing #REF Errors on all Affected Sheets
14:16 - Updating HSE Statistics with New KPIs
15:22 - Correcting Each KPI Reports
18:48 - Updating KPI Target Charts
22:28 - Outro for Changing KPIs

Next - Creating your Own KPIs

23:04 - Intro
23:43 - Inserting a New Column of KPI - Target Source Data Sheet
24:06 - Inserting a New Column of KPI - Actual Source Data Sheet
24:27 - Refresh All to Update the Workbook & Pivot Tables
25:00 - Inserting New KPI on Relevant Sheets
25:46 - Selecting the New KPI from Respective Pivot tables
30:44 - Updating the HSE Statistics with New KPI
31:35 - Updating the Trend Dashboard
33:27 - Creating New KPI Report
35:06 - Inserting a Target of the KPI in the Actual Source Data
39:37 - Connecting the Slicers to all the Pivot Tables
40:17 - Outro for Changing KPIs

At SHEQXEL, we build Quality, Health, Safety, and Environmental (QHSE) spreadsheet software to improve the efficiency of QHSE professionals. We also provide support to organizations on QHSE Management System to enable them to achieve ISO certification.

Our list of QHSE Working Solutions💫
https://www.sheqxel.com/hse-excel-das...

Our price List & Quick Search 💫
https://www.sheqxel.com/price-list/

Our Blog Posts Explaining all our Templates 💫
https://www.sheqxel.com/66-best-healt...

Book a Meeting with Sel 💫
https://calendly.com/sheqxel/30min

Customize your QHSE Template 💫
https://www.sheqxel.com/custom-services/

Check our 213+ Reviews from Safety Professionals around the World
https://www.trustpilot.com/review/she...

🔸Spreadsheet software is the best solution for you if you can’t afford all the expensive web-based applications on the market…Pros of Spreadsheet Software 🎯

Cheapest software on the market
Open-source knowledge to all
Easy to customize with good excel know-how
Perfect for data gathering, data analysis, and reporting
Available to you already on your computer

🔸Pros of our 66+ QHSE Dashboard Templates 🚀

User experience and ergonomics in mind
Result of massive QHSE research
Result of a shared experience of great minds
Close substitutes to web-based applications
Support Plan, Do, Check and Act cycle in QHSE processes
Support ISO certification through the adequacy of reports.
Password is shared for you to take a deep dive

🔸PDCA Cycle for Continual Improvement Using SHEQXEL 💯

PLAN your health and safety activities using your work instructions, forms, checklists, policies, and procedures
DO your activities, log them and build a database of activities using SHEQXEL
CHECK by analyzing data and measuring results, tracking performance, and establishing trends using SHEQXEL.
ACT by identifying areas of improvement and implementing preventive and corrective actions using SHEQXEL

Gain Control with SHEQXEL...💪
#SafetyDashboard #HSEExcelDashboardTemplate #HSEKPIs #HSEDashboard