From the course: The Data Skills Survival Kit

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Auditing data and spreadsheets

Auditing data and spreadsheets

From the course: The Data Skills Survival Kit

Start my 1-month free trial Buy for my team

Auditing data and spreadsheets

“

- [Instructor] I have told people for years, you're only as secure as the next person's skillset. And here's a prime example. Someone has this InvoiceTotals document. It has all this invoicing information on here for each month. Not a big deal, but I feel like there may be more to this data than what I believe. Let me show you how I would audit it. So I'm going to click in the table here, and one of the very first things I know to look for is the table design and query. Because I have the table design, I know that a table is applied, but because I have Query, I know that there is some embedded Power Query here that maybe you didn't expect me to see. I don't see these tabs across the bottom. So one of the very first things I'm going to do is right click and unhide, and then all of a sudden, I see tons of information. I'm not even going there yet. Let me choose cancel. Let me go and choose edit. So this shows me…

Contents