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.
Combination charts in Excel let you present and compare two different data-sets that are related to each other (in a single chart). When you create a regular chart in Excel, it usually has only one X-axis and one Y-axis. But with combination charts, you can have two Y-axis, which allows you to have two different …
A lot of times we have charts that have to handle empty data cells. Excel gives you the flexibility to decide how the empty cells should be treated. Suppose I have the data for date-wise sales of a product from a shop. Assuming that the shop is closed on Sunday and national holidays, there are …
It is possible to create a multi-category chart in Excel (as shown below). The trick is to arrange the data in a certain way, that makes Excel interpret as having multiple categories. Suppose I have the data for the monthly expenses I make on the food items (as listed below). The idea to create a chart …
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). …
©trumpexcel.com – Free Online Excel Training
