Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Watch Video – How to Lock Formulas in Excel Excel formulas are easy to create and edit in Excel. You can easily edit a formula through the formula bar or directly in the cell. While this makes it convenient to create formulas in Excel, it comes with a few disadvantages as well. Consider this. You are …
When you copy and paste formulas in Excel, it automatically adjusts the cell references. For example, suppose I have the formula =A1+A2 in cell B1. When I copy the cell B1 and paste it in B2, the formula automatically becomes =A2+A3. This happens as Excel automatically adjusts the references to make sure the rows and columns now …
As soon as you type a formula in Excel and hit enter, it would return the calculated result, and the formula would disappear. That’s how it’s supposed to work. But what if you want to show formulas in the cells and not the calculated values. In this Excel tutorial, I will cover the following topics: …
Yesterday, I got an email from one of my readers – June. She wanted to know how to apply bold font format to a specific part of a string within a cell. For example, apply the bold format to only the word ‘Hello’ from ‘Hello World’. And she wanted to do this for hundreds of …
*This is a guest post by Puneet Gogia, a fellow Excel blogger from India.* Excel has a Quick Access Toolbar that gives you instant access to your favorite/important options. However, not many people use the QAT efficiently. Last month I have asked 15 excel users about it, and only 7 were using it on frequent …
Often, once you create a Pivot table, there is a need you to expand your analysis and include more data/calculations as a part of it. If you need a new data point that can be obtained by using existing data points in the Pivot Table, you don’t need to go back and add it in …
Text to Columns is an amazing feature in Excel that deserves a lot more credit than it usually gets. As it’s name suggests, it is used to split the text into multiple columns. For example, if you have a first name and last name in the same cell, you can use this to quickly split these into two …
If you’re into and financial planning or analysis, you must have heard about the Compound Annual Growth Rate (or CAGR). In this tutorial, you’ll learn different ways to calculate the CAGR in Excel: But before we dive into how to calculate CAGR in Excel, let’s first understand what it means (feel free to skip this …
When working with large datasets full of formulas in Excel, it becomes difficult to keep a track of important cells and formula results. You may have a data set that spans across hundreds or even thousands of records, and going back and forth to know the result of important formulas could be a big waste …
©trumpexcel.com – Free Online Excel Training
