Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
What are External Links or References? When you create formulas in Excel and refer to a data point in an another workbook, Excel creates a link to that workbook. So your formula may look like something as shown below: Note that the part highlighted in yellow is the external link (also called external reference). This …
There may be cases when you need to generate random numbers in Excel. For example, to select random winners from a list or to get a random list of numbers for data analysis or to create random groups of students in class. In this tutorial, you will learn how to generate random numbers in Excel (with …
What’s in the name? If you are working with Excel spreadsheets, it could mean a lot of time saving and efficiency. In this tutorial, you’ll learn how to create Named Ranges in Excel and how to use it to save time. Named Ranges in Excel – An Introduction If someone has to call me or …
If your work involves applying the same type of formatting to data sets, using Format Painter in Excel will save you a lot of time. What is Excel Format Painter? Excel Format Painter is a nifty tool that allows you to copy formatting from a range of cells and paste it somewhere else in the …
Flash Fill is an amazing tool that was added in Excel 2013 and is available in all version after that. You can use Flash Fill in Excel to make data entry easy. It’s a smart tool that tries to identify patterns based on your data entry and does that for you. Some simple examples of …
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 …
©trumpexcel.com – Free Online Excel Training
