Excel Tips
0 to 100 (rows) Real Quick
If you’re still using the Autofill handle to create number series, keep reading - we can’t have you being bullied at work for your outdated Excel skills 😛 Today we’re...
0 to 100 (rows) Real Quick
If you’re still using the Autofill handle to create number series, keep reading - we can’t have you being bullied at work for your outdated Excel skills 😛 Today we’re...
QR Codes…Not Just for Decoration
We’ve all scanned a handy QR to get instant access to a restaurant menu or log in to Netflix when we’re away from home, but did you know Excel can...
QR Codes…Not Just for Decoration
We’ve all scanned a handy QR to get instant access to a restaurant menu or log in to Netflix when we’re away from home, but did you know Excel can...
VLOOKUP…Who?
It’s time to settle one of the most heated debates in Excel: VLOOKUP, INDEX MATCH, or XLOOKUP? Well friends, I’m officially Team XLOOKUP ✖. Sorry to all my die-hard Index...
VLOOKUP…Who?
It’s time to settle one of the most heated debates in Excel: VLOOKUP, INDEX MATCH, or XLOOKUP? Well friends, I’m officially Team XLOOKUP ✖. Sorry to all my die-hard Index...
#nofilter needed, except in Excel
Have you heard the news? Excel has a new FILTER function, and this isn’t your momma’s Instagram filter. If you want to be able to quickly #filter your data in...
#nofilter needed, except in Excel
Have you heard the news? Excel has a new FILTER function, and this isn’t your momma’s Instagram filter. If you want to be able to quickly #filter your data in...
Drop it like it's hot
Dropping it low in Excel is easy (and easier on the knees) thanks to drop down lists. These are great tools to use if you’re entering values that repeat...
Drop it like it's hot
Dropping it low in Excel is easy (and easier on the knees) thanks to drop down lists. These are great tools to use if you’re entering values that repeat...
Count(a) on Excel
Calculating counts in Excel is a simple task, as long as we know the difference between counting functions. Let’s take a deeper look into the difference between COUNT and COUNTA...
Count(a) on Excel
Calculating counts in Excel is a simple task, as long as we know the difference between counting functions. Let’s take a deeper look into the difference between COUNT and COUNTA...