Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
One of the challenges while creating a dashboard is to present the analysis in limited screen space (preferably a single screen). Hence, it is important to make smart choices while creating the right chart. And here is where Bullet Charts score over others. Bullet charts were designed by the dashboard expert Stephen Few, and since …
As the world goes crazy (including me) over the new season of Game of Thrones, I thought it would be a good idea to visualize its data by creating an Excel Dashboard. Using my substandard secondary skills, I was somehow able to find enough data points to create an awesome Excel dashboard. There are many …
I am currently working on creating a sales pipeline management dashboard. I have all the data in place and now I am looking for some visualization to create the dashboard. One of the charts that I absolutely want in there is a sales funnel chart. What is a Sales Funnel? In any sales process, there …
Four years ago, I was sharing an apartment with 3 of my friends. At the end of every month, we would sit together, jog our memory to remember expense details, and use a calculator to get each person’s share. And we used to get it wrong every time. Today I am here with a Shared …
One of my teammates has the responsibility of creating a leave tracker template in Excel for the entire team. This tracker template is then used to track vacations/holidays and planned leaves of the team members. Till now, she used a simple Gantt chart in Excel but wanted something better with more functionalities. So, I created this …
WUHOOOO.. we are past the 2000 subscribers mark. You can imagine me doing the Happy Dance right now 🙂 This is a huge milestone for me and I am completely overwhelmed by the love and support I have got from my readers. I started this journey ~2 years ago and it has been a heck …
Last week I wrote an article on how to create a Dynamic Pareto Chart in Excel. With the charting fever still riding high, today I will show you how to create a Gantt Chart in Excel. Gantt Chart is a simple yet powerful project management tool that can be used for creating a schedule or tracking the …
Pareto Chart is based on the Pareto principle (also known as the 80/20 rule), which is a well-known concept in project management. According to this principle, ~80% of the problems can be attributed to about ~20% of the issues (or ~80% of your results could be a direct outcome of ~20% of your efforts, and so …
Excel built-in data sorting is amazing, but it isn’t dynamic. If you sort data and then add data to it, you would need to sort it again. Sort Data in Alphabetical Order In this post, I will show you various ways to sort data in alphabetical order using formulas. This means you can add data, …
©trumpexcel.com – Free Online Excel Training
