Excel Tips
Calculate percent of total in one click
If you’re reading this (cue Drake's album), it’s not too late to learn how to calculate critical insights, even if they require complex formulas. If you feel late to the...
Calculate percent of total in one click
If you’re reading this (cue Drake's album), it’s not too late to learn how to calculate critical insights, even if they require complex formulas. If you feel late to the...
Bring values to life with 3D formulas
Why watch a regular movie when you could upgrade to 3D? The same goes for Excel formulas! 3D formulas allow you to quickly calculate data across multiple tabs! Our boss...
Bring values to life with 3D formulas
Why watch a regular movie when you could upgrade to 3D? The same goes for Excel formulas! 3D formulas allow you to quickly calculate data across multiple tabs! Our boss...
Calendar Dropdowns in GSheets 📆
Tired of manually typing dates into your spreadsheet? There's a better way! Google Sheets has a nifty calendar date picker tool that lets you select dates from a popup calendar...
Calendar Dropdowns in GSheets 📆
Tired of manually typing dates into your spreadsheet? There's a better way! Google Sheets has a nifty calendar date picker tool that lets you select dates from a popup calendar...
Get your (Formatting) Ducks in a Row 🦆
One of the most tedious little tasks in Excel that no one ever talks about? Extending your data table formatting as you enter new rows!! Let's learn a conditional formatting...
Get your (Formatting) Ducks in a Row 🦆
One of the most tedious little tasks in Excel that no one ever talks about? Extending your data table formatting as you enter new rows!! Let's learn a conditional formatting...
Skewed Images 🔶
Are you ready for this? Excel is the new Photoshop…yes really. Today we’ll learn how to fit a skewed image into a screen frame in Excel. Let’s say, for example,...
Skewed Images 🔶
Are you ready for this? Excel is the new Photoshop…yes really. Today we’ll learn how to fit a skewed image into a screen frame in Excel. Let’s say, for example,...
Color-Coded Drop-Downs 🌈
What's better than a drop-down menu in a worksheet? A color-coded drop-down! Let's learn how to take our drop-down menus to the next level by adding dynamic color rules to...
Color-Coded Drop-Downs 🌈
What's better than a drop-down menu in a worksheet? A color-coded drop-down! Let's learn how to take our drop-down menus to the next level by adding dynamic color rules to...