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 colleague asked me if she could quickly extract usernames from Email Ids. She had more than 1000 records and less than 2 minutes to do it. In this tutorial, I will show you 2 methods to do this. And none of it would take more than a minute. Method 1 – Using Text to …
This is one awesome Excel Tab Numbering tip and the credit goes to Scott of Excel Zoom. He has some amazing articles on his website, and I am going to copy this tip shamelessly here [with his permission of course] If you have a workbook where the tab’s names are numbers (for example 1, 2, …
In this tutorial, I cover how to do a multi-level sorting in Excel. You can watch the video below, or you can read the tutorial below it. When working with data in Excel, sorting the data is one of the common things you might have to do. In most of the cases, you need to …
Yes, it’s true! You can send emails from Excel by using the HYPERLINKÂ function. In this blog post, I will show you various ways to use the HYPERLINK function to send emails from Excel. There is also a bonus Email Generator Excel Template available for download at the end of this post. Let me first explain …
This is the 100th blog post from Trump Excel. I have loved every bit of this journey, and I hope to continue to contribute and share all that I learn about Excel Spreadsheets. If you wonder what was my first post, here it is – Trump Excel’s First Post. Now coming back to cool Excel stuff, in …
Excel is an amazing tool with fascinating capabilities to analyze data (be it using functions, charts or dashboards). The ease with which data can be entered and stored in Excel makes it a compelling choice. In this blog post, I have listed 10 useful Excel Data Entry tips that will make you more efficient and save a lot of …
Data forms the backbone of any analysis that you do in Excel. And when it comes to data, there are tons of things that can go wrong – be it the structure, placement, formatting, extra spaces, and so on. In this blog post, I will show you 10 simple ways to clean data in Excel. #1 …
Excel Drop Down Lists are intuitive to use and extremely useful in when you are creating an Excel Dashboard or a data entry form. You can create multiple drop-down lists in Excel using the same source data. However, sometimes, it is needed to make the selection exclusive (such that once selected, the option should not appear …
What do we do when we have to go to an Excel Cell in some other worksheet (or a cell far away in the same worksheet). Normally, we select the worksheet tab, then spot the cell (which may involve scrolling) and then click on it. In this blog post, learn 2 quick methods to do this. #1 …
©trumpexcel.com – Free Online Excel Training
