Excel Not Responding – How To Fix It!
Sometimes when you launch Excel or are in the process of working with Excel, Excel freezes and returns a message box indicating that Microsoft Excel is not responding. This tutorial …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
VLOOKUP Not Working – 7 Possible Reasons + Fix!
The VLOOKUP Function allows you to retrieve information from a vertically arranged table or dataset. It’s an extremely popular Excel function that automates looking up information from large datasets. However, …
How to Edit Document Properties in Excel?
Document Properties in Excel are a set of data that describe the document. This information includes the author, title, company name, and other information about the document (such as the …
How to Link Cells in Excel (Same Worksheet, Between Worksheets/Workbooks)
Linked cells in Excel refer to the contents of other cells. The other cells may be in the same worksheet, other worksheets in the same workbook, or worksheets in other …
How to Add Zero In Front of Number in Excel?
If you try to add a leading zero in front of a number in Excel, Excel removes it immediately after you press Enter. This is because a zero before a …
How to Calculate the Interquartile Range in Excel?
The Interquartile Range is commonly used in statistics as it helps us identify the natural seasonality and monthly trends in a dataset. It gives you insight into the spread of …
How To Combine Date and Time in Excel?
Sometimes you may have a dataset in Excel that has date and time values in separate columns. You may want to combine those values in one column. In this tutorial, …
How to Get the First Day Of The Month In Excel?
Sometimes, you may want to get the first day of the month when you already have a date. For example, if you have 15 Jan 2023, you can use a …
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 …
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 …