Looking for some awesome Excel tips and tutorials? You’re at the right place.
Here you’ll find a collection of amazing excel tips that will make you an Excel Ninja and save a lot of time.
All the Excel tips are covered in detail with supporting images and a video (in most of the cases).
If you’re a beginner in Excel, you can start from out Learn Excel section.
You also find tips and tutorials on various Excel topics such as charting, dashboards, and VBA. In addition to the tutorials, you will also find some useful Excel templates that you can download for free.
You will also find Excel formula tips to get common tasks done using the formulas. You can also visit the Excel Functions section to learn about most commonly used Excel functions such as VLOOKUP, INDEX, OFFSET, COUNTIF, IFÂ and so on..
Also check out our Online Excel Training courses on Excel (Basic to Advanced), Dashboard, and VBA.
In this blog post, I will show you a formula to get a list unique items from a list in excel that has repetitions. While this can be done using Advanced Filter or Conditional Formatting, the benefit of using a formula is that it makes your unique list dynamic. This means that you continue to get …
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
