How to Print Comments in Excel?
Threaded comments are like conversations within the Excel worksheet. They allow team members to have a discussion about the data they are working on. Below is an example of comment …
Steve Scott
How to Calculate Year-Over-Year (YOY) Growth in Excel (Formula)
Year Over Year (YOY) growth is a common comparison metric that is considered when analyzing the growth of our business It compares the growth in a certain period of time …
How to Sort a Pivot Table in Excel?
Pivot Table is a very handy feature in Excel to calculate, analyze and summarize data. Using Pivot Table, we can see comparisons, patterns, and trends in our data. However, when …
Show Negative Numbers in Parentheses/Brackets in Excel
Excel by default displays negative numbers with a minus sign. In some instances, for example, when dealing with financial data, you may want to display negative numbers in parentheses or …
How to Remove Table Formatting in Excel?
Excel Table is an amazing built-in feature that allows us to easily work with the data. When you convert a data set into an Excel Table, you’re able to use …
How to Count Unique Values in Excel (Formulas)
Sometimes we may want to know the number of unique values in a dataset. For example, if you have a list of names with repetition, you may want to find …
How to Refresh Pivot Table in Excel? (Shortcut + VBA)
A Pivot Table is the simplest data analysis tool that provides a summary of large and complex data. Moreover, Pivot Tables are flexible and we can transform the table as …
How to Highlight Dates Before Today in Excel?
There may be instances in which you will need to call attention to dates before today’s date. This could be to capture payments that were due but were not received …
Calculate Days Between Two Dates in Excel (Workdays/Weekends)
Calculating the number of days between two dates in Excel is a popular operation performed in different scenarios. For example, project managers use it to measure performance against milestones, and …
How to Rearrange Rows In Excel
While working in Microsoft Excel, you may have a need to rearrange rows in order to show the data the right way. In this tutorial, I will show you some …
How to Add Border to a Chart in Excel?
A border makes a chart in Excel stand out and attract the readers’ attention. If you have multiple charts on the same sheet, adding a border also makes them look …
How to Calculate the Number of Months Between Two Dates in Excel?
Sometimes you may want to find out the number of months between two dates. For example, if you are a project manager, you may want to find out how many …