Excel Tips
Finding a needle in a haystack
When auditing formulas in Excel, tracing the cells referenced in a formula can be like finding a needle in a haystack. Save yourself the hassle and use these keyboard shortcuts...
Finding a needle in a haystack
When auditing formulas in Excel, tracing the cells referenced in a formula can be like finding a needle in a haystack. Save yourself the hassle and use these keyboard shortcuts...
How to highlight formulas
Welcome back to part three of my Go To Special’s Hidden Treasure series. So far, we’ve learned how to delete blank rows and fill blank cells in a data table....
How to highlight formulas
Welcome back to part three of my Go To Special’s Hidden Treasure series. So far, we’ve learned how to delete blank rows and fill blank cells in a data table....
Keep your sheets stylin’
Formatting can make or break your spreadsheet. You can write the most advanced formulas to calculate data insights, but if they aren’t formatted, no one will be impressed. And if...
Keep your sheets stylin’
Formatting can make or break your spreadsheet. You can write the most advanced formulas to calculate data insights, but if they aren’t formatted, no one will be impressed. And if...
Uniquely excellent
Manually removing duplicate values in a list can be a dull, tedious task. Luckily, Excel has a “unique” function that can remove duplicates in seconds. If you’re unfamiliar with the...
Uniquely excellent
Manually removing duplicate values in a list can be a dull, tedious task. Luckily, Excel has a “unique” function that can remove duplicates in seconds. If you’re unfamiliar with the...
How to create scannable barcodes
A scannable barcode is a powerful tool for businesses. Let’s say you have a list of products along with their product codes and want to streamline the inventory process. Creating...
How to create scannable barcodes
A scannable barcode is a powerful tool for businesses. Let’s say you have a list of products along with their product codes and want to streamline the inventory process. Creating...
How to replace errors
When working with averages, or any formulas in general, it’s possible for the formulas to return an error. Instead of replacing the errors individually to clean up the table, you...
How to replace errors
When working with averages, or any formulas in general, it’s possible for the formulas to return an error. Instead of replacing the errors individually to clean up the table, you...