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.

Adding a trendline to your chart helps your audience better understand the data by way of visualization. Not only can you add a trendline to your already-existing chart in Excel, but you can also format it, too….

We’re not all mathematicians, but some tasks in Microsoft Excel are best done using formulas. Maybe you’re new to writing formulas or are trying but keep getting confusing errors. Here, we’ll cover the basics of structuring …

The Status Bar in Microsoft Excel allows you to quickly see the average, sum, or count of selected cells. But what’s better than viewing those values is being able to use them. Here’s how copy directly from the Status Bar….

To replace a string of text, numbers, or symbols, Microsoft Excel offers a function called SUBSTITUTE. This function replaces the specified string with your choice of string. We’ll show you how to use it in your spreadsheets….