Excel Tutorials

Trying to hard-code phone numbers in Excel from a list of phone values that were not correctly formatted can be tricky (if you don’t want to do it manually!). This is because Excel’s phone number formatting options don’t actually change the contents in the cell, they only make them look like phone numbers. But what […]

By knowing how to format phone numbers in Excel, you can make your phone number values easier to read – with dashes, parentheses, periods, country codes, etc. In this tutorial, we’ll look at ways that you can apply phone number formatting to your Excel sheet. Important Note About Formatting in Excel When we apply formatting […]

Using the UNIQUE function in Excel is one of the easiest ways to find unique values in your data. Currently only available to Office 365 users, this function works by returning a list of unique values from your data. Oh, and you can use it with numbers, letters, and most other characters! How to Use […]

Tracking the progress of your goals is key to achieving your goals. Below, you’ll see, step-by-step, how to track goals in Excel to make sure you’re getting them done! You’ll even see how to create a chart to help track the progress you’re making on your goals. How to Make a Goal Tracker in Excel […]

Did the data in your pivot table change??? Here’s how to update pivot table data (even when its source data changes!). How to Refresh a Pivot Table in Excel WATCH: How to Update Pivot Table When Source Data Changes in Excel – Tutorial If the data linked to your pivot table has changed, you may […]

You likely know the stress of needing to recover an earlier version of an Excel file you’ve worked on. Was it overwritten? I mean, how is it even possible that the data looks different today than it did last week when you last updated it??? A friend recently called me in a panic after she […]