Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
Excel has made our life easier in so many ways. However, there are some Excel Issues that continue to waste our time and pump up the frustration levels. These are small issues that can be fixed in a few seconds, but to not know the right way to do it can cost a lot of time. …
I am proud to share that I have been awarded the Excel MVP (Most Valuable Professional) status by Microsoft. I am thrilled to join an amazing group of talented MVPs across the globe. What does MVP mean? MVP is an award that is given by Microsoft to individuals that share the passion for its technology (Excel …
Embedding a Youtube video in Excel could be helpful if you want the user to go through some instructions in the video before using the spreadsheet/model/dashboard. I sometimes use it during excel training session with live examples. In this blog post, I will show you how you can embed youtube video in Excel. Step 1 – …
Last month, one of my colleagues got a data set in Excel, and he was banging his head to clean it. Since I was the only one in the office at that wee hour, he asked me if I could help. I used a simple technique using Find and Replace in Excel, and his data was …
Watch Video – How to Multiply in Excel Using Paste Special Excel Paste Special functionality can save a lot of time. One of its features is ‘Operations’, which allows us to quickly perform mathematical calculations (such as addition, subtraction, multiplication, and division) on a range of cells. In this tutorial, I will show you how to multiply …
In the projects I have worked so far, Milestone Charts (also known as timeline charts) are often one of the most discussed parts. A commitment to delivering is as important as the project itself. A milestone chart is an effective tool to depict project scope and timelines. In this post, I will show you a simple …
©trumpexcel.com – Free Online Excel Training
