Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
I often use scroll bars in an Excel dashboard, which gives a user the freedom to change its values and play with the data. If you have multiple scroll bars in your dashboards, it is helpful to display the current value of each scroll bar. Something as shown below: The idea is to display the value …
Excel Custom Number formatting is the clothing for data in excel cells. You can dress these the way you want. All you need is a bit of know-how of how Excel Custom Number Format works. With custom number formatting in Excel, you can change the way the values in the cells show up, but at the …
Someone recently asked me if it was possible to get a main category and subcategory in a drop-down list in Excel, (something as shown below): My first thought was to do this using VBA (if possible), but the answer is so easy, it surprised me. Creating Subcategory in Drop Down List in Excel All you need …
Data Entry in Excel could be a very boring task. Suppose you have a template as shown below, and you have to enter data in excel in all the cells highlighted in red, in the order specified by the arrows. While this seems easy enough, it could be nerve-wracking when you have many such non-contiguous …
You would have seen this in various online forms, where you must fill a cell before moving to the other. This makes sure that you’re restricted unless you make certain data entry (or fill a certain field). For example, you may not be able to choose the state unless you have selected the country first. …
Excel has its own limitations, and in this blog post, I will show you how we can use one of the limitations to our advantage. Get the Last Number in a List in Excel using Excel VLOOKUP Function The largest positive number that you can use in Excel is 9.99999999999999E+307 (I tried this in Excel 2010). …
There are many lookup functions in Excel (such as VLOOKUP, LOOKUP, INDEX/MATCH, XLOOKUP) that can go and fetch a value from a list. But you can’t look-up images using these formulas. For example. if I have a list of team names and their logos, and I want to look up the logo based on the …
Conditional Formatting is one of the most simple yet powerful features in Excel Spreadsheets. As the name suggests, you can use conditional formatting in Excel when you want to highlight cells that meet a specified condition. It gives you the ability to quickly add a visual analysis layer over your data set. You can create …
There are only 3 Excel wildcard characters (asterisk, question mark, and tilde) and a lot can be done using these. In this tutorial, I will show you four examples where these Excel wildcard characters are absolute lifesavers. Excel Wildcard Characters – An Introduction Wildcards are special characters that can take any place of any character (hence …
©trumpexcel.com – Free Online Excel Training
