Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
If you are in the sales department and your life is all about targets, this charting technique is for you. And if you are not, read it anyway to learn some cool excel charting tricks. In this blog post, I will show you a super way to create a dynamic target line in an Excel …
©trumpexcel.com – Free Online Excel Training
