Don’t need a specific worksheet in your spreadsheet anymore? If so, Microsoft Excel offers two easy ways to delete sheets from your workbook. We’ll show you how to use them, as well as what to do if you can’t delete your shee…

If you’d like to use the same formula across multiple cells, copy the formula instead of typing it individually in each cell. You can use both dynamic cell reference and absolute cell reference while doing this, and we’ll sho…

Do you want to find and optionally delete the duplicate entries in your spreadsheets? If so, use Microsoft Excel’s conditional formatting option to highlight duplicates and then select an option to remove those items. We’ll s…

Whether you want to make structural changes or modify the content in your Microsoft Excel workbooks, you’ll have to unprotect those items first. We’ll show you how to do just that.

To avoid getting your formulas messed up, you can lock the cells that contain formulas while keeping all other cells unlocked in your Microsoft Excel spreadsheets. We’ll show you how to do just that.

If you’ve ever had to decide between two or more financial situations, you may have done some spreadsheet manipulation. You might have entered different numbers to see the varying outcomes. But did you know you can use Excel’…

If you use Microsoft Excel for keeping track of your money, you might use it for calculating loan amounts or budgeting your finances. To go along with these, you might track your investments too, which means using the FV func…

If you don’t use a specific PivotTable in your spreadsheet anymore, you have two ways to remove the table in Excel. There’s a keyboard method as well as a ribbon menu option to delete PivotTables. Here’s how to use them….

If you’re collaborating on a spreadsheet, you may want to break down a formula someone entered. While many times this easy, there are others where the formula is more complicated. Excel provides a tool to evaluate formulas st…

If you want to extract a substring from the left, right, or middle of your text, you can use Microsoft Excel’s LEFT, RIGHT, MID, LEN, and FIND functions to do that. We’ll show you how.

To keep track of an investment such as a mutual fund, you likely want to calculate the CAGR (compound annual growth rate). You can do so in Microsoft Excel using the RRI function and it’s much easier than you might think….

If you and your team use versions of Excel in different languages, check out the Functions Translator. This Microsoft add-in can translate entire formulas or help you find the function you want in the language you need….

Have you ever had a financial goal you sought but weren’t exactly sure how to get there? Using Goal Seek in Microsoft Excel, you can determine what you need to accomplish your goal.

When you want to display three data series on a type of scatter plot, then a bubble chart is the ideal choice. We’ll show you how to organize your data and create a bubble chart in Microsoft Excel.

If you use Microsoft Excel for financial data where exchange rates are part of what you need, check out the Currencies data type. This gives you various exchange details that you can include in your spreadsheet….

Using Microsoft Excel’s sorting feature, you can sort your cells that are either manually colored or conditionally colored by their color. This works for multiple colors and we’ll show you how to implement it in your spreadsh…

While you can easily share an Excel workbook or spreadsheet, you might want to make it available to a larger audience. If you have a blog or website, you can embed the file by copying and pasting the embed code….

If text is a big part of the data in your spreadsheet, you may need to adjust it to fit properly. The TRUNC function in Microsoft Excel works only with numbers. So if you want to truncate text, here’s how….

Lookup functions in Microsoft Excel are ideal for finding what you need when you have a large amount of data. There are three common ways to do this; INDEX and MATCH, VLOOKUP, and XLOOKUP. But what’s the difference?…

Whether you use Microsoft Excel for managing monthly bills or tracking time for work, you likely use dates or times. With these functions, you can enter or obtain the dates and times you need.