- CPA to Cybersecurity
- Posts
- Pointy Clicky Excel, Power Query, Fabric Workshop PART3
Pointy Clicky Excel, Power Query, Fabric Workshop PART3
Oct 31, 2024 Pre-SIMPLY CYBERCON #GRC Workshop

Agenda
Step 17: Add scores to your template with XLOOKUP
=XLOOKUP([@Category], tblEquifax2021[[#All],[CSF Outcome ID]], tblEquifax2021[[#All],[Actual Score]], "No Match")
XLookup to tblEquifax2021 actual scores

Step 18: Add formulas for Gap to Target Columns


Step 19: Add Conditional Formatting



Step 20: Make a Pivot Table and Bar Chart, by CSF Function
Insert > Pivot Table




Step 21: Make a Radar Pivot Chart, by CSF Function



Adjust the series bounds to range from 0 to 8

Colo(u)r Palate for Charts
Green B2D9B2 ![]() | Yellow FFFFB3 ![]() | Red FFB3B5 ![]() |
Adjust the order of the layers and the opacity


Step 22: Copy the Tab, and Present by Category


Step 23 (Bonus): 2-D Column Chart with 100% Series Overlap





Step 24: 🗣️ Communicate Your Top Five Cyber Risks!
Scorecard Template
