Excel Tips
Stay current on currency
When working with international clients, pulling up the latest currency exchange rates can be a real peso in the ruble. But you Google Sheets users out there can tap the...
Stay current on currency
When working with international clients, pulling up the latest currency exchange rates can be a real peso in the ruble. But you Google Sheets users out there can tap the...
Bring the heat
Feeling dull and need to spice up your spreadsheets? Bring the heat by creating a geographical heat map to visualize data variation by region. A geographical heat map uses color...
Bring the heat
Feeling dull and need to spice up your spreadsheets? Bring the heat by creating a geographical heat map to visualize data variation by region. A geographical heat map uses color...
What day is it?
Has it been one of those weeks when you’re so busy you forget what day it is? Let Excel help you out! The TEXT function allows you to change the...
What day is it?
Has it been one of those weeks when you’re so busy you forget what day it is? Let Excel help you out! The TEXT function allows you to change the...
Hide your Excel mistakes
Ex-boyfriends, late night eBay purchases: We all wish we could hide from our mistakes. While I can’t offer a solution to these problems, I can help you hide your errors...
Hide your Excel mistakes
Ex-boyfriends, late night eBay purchases: We all wish we could hide from our mistakes. While I can’t offer a solution to these problems, I can help you hide your errors...
Spring Clean your Worksheet
There is nothing worse than needing to scroll through a worksheet to find data that’s overflowed from the spreadsheet window 🫠. Check out the example gif above - we...
Spring Clean your Worksheet
There is nothing worse than needing to scroll through a worksheet to find data that’s overflowed from the spreadsheet window 🫠. Check out the example gif above - we...
Go Sorty, It’s Your Birthday
Today we’re going to get a little wild and learn a non-traditional sorting filter 🔥. Sure, we can sort data in Excel by putting numbers in descending or ascending order,...
Go Sorty, It’s Your Birthday
Today we’re going to get a little wild and learn a non-traditional sorting filter 🔥. Sure, we can sort data in Excel by putting numbers in descending or ascending order,...