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.
A comma is commonly used when working with both text and numbers in Excel. With text, a comma can be used as a separator (such as a separator between the first and last name or address) or as a part of regular grammar. And with numbers, it often used to make the numbers more readable …
If you work with formulas in Excel, sooner or later, you will encounter the problem where Excel formulas don’t calculate and give the result (or give the wrong result). It would have been great had there been only a few possible reasons for malfunctioning formulas. Unfortunately, there are too many things that can go wrong …
While working with Excel formulas, you may sometime see the following warning prompt. This prompt tells you that there is a circular reference in your worksheet and this can lead or an incorrect calculation by the formulas. It also asks you to address this circular reference issue and sort it. In this tutorial, I will …
Excel is a great spreadsheet tool, but there are a few things about it that may irritate you sometimes. For example, if you add a plus sign before a number in a cell in Excel, that plus sign would just go away. The same happens when you try and add leading zeros before a number. …
Excel has some amazing text functions that can help you when working with the text data. In some cases, you may need to calculate the total number of characters in a cell/range or the number of times a specific character occurs in a cell. While there is the LEN function that can count the number …
Excel has some useful features that allow you to save time and be a lot more productive in your day-to-day work. One such useful (and less-known) feature in the Custom Lists in Excel. Now, before I get to how to create and use custom lists, let me first explain what’s so great about it. Suppose …
When you have to select a block of cells, the easiest way is to use a mouse, click on a cell and then drag to cover all the cells that you want to select. Or if you’re a keyboard person, you can hold the shift key and move the cursor to make the selection. But …
Conditional Formatting in Excel enables you to quickly format a cell (or range of cells) based on the value or the text in it. For example, below I have an example where I have student’s scores and I have used conditional formatting to highlight all the scores that are above 80. If you’re interested in …
Excel is a really thought out spreadsheet tool and has so many simple tricks that can boost your productivity and save time. But at the same time, there are some simple things that are missing and often leads to a lot of frustration. For example, there are so many ways for you to quickly select …
©trumpexcel.com – Free Online Excel Training
