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.
When working with text data in Excel, you may have the need to remove the text before or after a specific character or text string. For example, if you have the name and designation data of people, you may want to remove the designation after the comma and only keep the name (or vice-versa where …
Excel is an awesome tool. The more I learn about it the more I fall in love with it. The team that has built Excel has put in a lot of thinking behind it and they continuously work on improving the user experience. But there are still somethings that I find irritating and often need …
Excel has some wonderful formulas that can help you slice and dice the text data. Sometimes, when you have the text data, you may want to extract the first word from the text string in a cell. There are multiple ways you can do this in Excel (using a combination of formulas, using Find and …
Using VBA Macros in Excel can be a huge time saver. You can automate a lot of repetitive tasks and create new functions and functionalities in Excel with simple VBA macro codes. But in some cases, you may want to remove all the macros from an Excel workbook (or delete specific macros only). This may …
When you work with numbers in Excel, you often need to conditional add the data. One common example of this is when you have to sum the positive numbers in Excel (or only sum the negative numbers). And this can easily be done using the in-built formulas in Excel. In this tutorial, I will show …
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. …
©trumpexcel.com – Free Online Excel Training
