🔐 Simply Cyber Course Materials - Community Access Welcome! This content is shared with enrolled students as part of our commitment to inclusion and value delivery in cybersecurity education. We believe in supporting each other's learning journey through ethical collaboration. Please help us maintain this open educational environment by keeping this URL within our course community. Sharing this link publicly undermines our ability to freely provide these materials. Questions? Reach out to your instructor—we're here to support your success!
Table of Contents
Spreadsheets (Like GRC) Are Awesome and Underrated, for Fit-For-Purpose Data Analysis
Ah, here we go. Be still my heart - the spreadsheet. This is, you know, like if a cowboy has a pistol and a holster on his hip, a GRC professional has a spreadsheet in the holster on the hip. I know there's all sorts of fancy tools, but I'm telling you right now, the spreadsheet - and once you pick up pivot tables, oh my goodness, slow down!
It’s so great to find Dr. Auger sharing not just contrarian view point that GRC can make an outsided impact, but Excel too for fit-for-purpose tasks!
With GRC it’s about interfacing between the business and technical teams to prioritize limited resources against unlimited cyber threats. With spreadsheets its about ad hoc data analysis to extract actionable insights from large and disparate data sets. There’s a reason Excel is one of the most searched for topics in e-learning.
Just make sure it’s the right tool for the job.
To learn about Excel Tables, Slicers, Formulas like XLOOKUP, Pivot Tables, Charts and Power Query so you can “invert the power dynamic between yourself and executives,” check out my Simply CYBERCON workshop that demonstrates these capabilities, and don’t hesitate to let me know if you have any questions.
Or if you just want to know the top 2 highest Return On Investment Data Analytics techniques in Excel, here they are:
1. XLOOKUP
XLOOKUP is an easier and more powerful, adaptable approach for joining data sets than VLOOKUP, if you’ve heard of that very popular formula.
2. Pivot Tables
Once you have clean and comprehensive underlying data, Pivot tables can quickly extract insights from it, by rolling up, drilling down, slicing and dicing for analysis.
