How to Add Months to a Date in Excel
When working with dates in Excel, you may need to add months to a particular date to calculate a future date. For example, as a project manager, you might need …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to Filter Strikethrough in Excel
You can apply the strikethrough formatting to cells in an Excel dataset to indicate completed tasks, outdated information, etc. For example, in the dataset below completed tasks have a strikethrough …
How to Group Duplicates in Excel
Sometimes when you receive a dataset with duplicates you may need to group the duplicates so you can easily identify them and decide to remove or consolidate them. This way …
Delete Multiple Sheets in Excel
Sometimes you may need to delete multiple sheets in your workbook. For example, you may want to delete empty sheets or worksheets with outdated information. In this tutorial, I will …
How to Return to Normal View in Excel
Excel has three built-in workbook view options: Normal View, Page Break Preview, and Page Layout View. You can find these options on the Workbook Views group of the View tab. …
Point and Click Method in Excel
You can use the point-and-click method in Excel to create formulas by selecting cells with your mouse rather than typing cell references manually. With this method, you can create formulas …
XLOOKUP Vs INDEX MATCH in Excel
XLOOKUP and INDEX MATCH are Excel functions for performing lookups. The functions retrieve values from a table or range but differ in functionality, syntax, flexibility, availability, performance, ease of use, …
Find the Row Number of Matching Value in Excel
When working with a dataset in Excel, you may need to find the row number of a specific value to retrieve related information. For example, suppose you manage a list …
Calculate Log Base 2 in Excel
The log or logarithm of a number is the power (or exponent) to which a specific base must be raised to obtain that number. Logs answer the question, ‘To what …
Calculate the Population Mean in Excel
In Excel, you can use various methods to calculate the population mean or the average of all the values in an entire population. The population is the complete set of …
Unblock Macros in Excel Files Downloaded From the Web
Excel files you download from the web may contain malicious code or macros, so when you open such files, they open in Protected View and display a yellow ‘Protected View’ …
How to Remove Numbers From Text in Excel
Sometimes, you may receive Excel data where each cell in a column contains a mixture of numbers and text, as shown in the example below. If you’re only interested in …