Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
Excel chart data labels are quite boring. While there is not much you can do with these, a bit of excel trickery can add some glamor to it. In this post, I will show you how to show trends in chart labels in a bar chart. Something as shown below: Show Positive/Negative Trend Arrows in Excel Chart …
If there is one thing that unites us all, it has to be the frustration to keep up with a slow excel spreadsheets. While the impact on the performance may be negligible when there is less data, it becomes more profound as you add more and more data/calculations to the workbook. 9 out of 10 …
©trumpexcel.com – Free Online Excel Training
