Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
Excel functions can be extremely powerful if you get a hang of combining different formulas. Things that might have seemed impossible would suddenly start looking like a child’s play. One such example is to find the closest match of a lookup value in a dataset in Excel. There are a couple of useful lookup functions …
Want to get the word count in Excel? Believe it or not, Excel does not have an inbuilt word counter. But don’t worry. A cool bunch of excel functions (or a little bit of VBA if you’re feeling fancy) can easily do this for you. In this tutorial, I will show a couple of ways to count …
One year ago I started Trump Excel to share what I know about MS Excel, and to continue to learn and share. Today (proud as I write this post) marks one year of this initiative. Today there is no excel tip in this message. Just a plain and simple THANK YOU!! It is you who …
In many situations, you may want to insert a watermark in Excel (such as your company’s logo or an image) before sharing it with others. In case you are sharing a WIP (work-in-progress) version of the report, you may want to place a WIP/Draft as the watermark in it. While Excel does not have a …
If you create an Excel chart that represents YoY change, it is a good formatting technique to highlight chart data labels with a negative value in red. And at the same time, if you could also add upward/downward arrows to the data labels, then that’s icing on the cake. With a simple number formatting trick, you …
Do you think you know Excel Formulas? Here is a fun way to test it!! This blog post has a downloadable file (at the end) that has an Excel Formula Crossword in it. Go ahead and test your formula knowledge. Since I am a nice guy, I did not put a timer in it. Solve it at …
©trumpexcel.com – Free Online Excel Training
