Looking for some awesome Excel tips and tutorials? You’re at the right place.
Here you’ll find a collection of amazing excel tips that will make you an Excel Ninja and save a lot of time.
All the Excel tips are covered in detail with supporting images and a video (in most of the cases).
If you’re a beginner in Excel, you can start from out Learn Excel section.
You also find tips and tutorials on various Excel topics such as charting, dashboards, and VBA. In addition to the tutorials, you will also find some useful Excel templates that you can download for free.
You will also find Excel formula tips to get common tasks done using the formulas. You can also visit the Excel Functions section to learn about most commonly used Excel functions such as VLOOKUP, INDEX, OFFSET, COUNTIF, IFÂ and so on..
Also check out our Online Excel Training courses on Excel (Basic to Advanced), Dashboard, and VBA.
In my first job, we had to go through a rigorous 3-week training before we got any real work. One of the trainers was a 40 something guy with awesome Excel skills. I used to call him the Excel Superman. I still remember the first thing that he told us was to avoid the use …
There is no one size that fits all. When it comes to Excel, the default settings work fine in most of the cases. But if need be, you can easily customize many of the Excel Options. In this blog post, I will show you how to use Excel Options to customize your workbooks and get a …
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 …
©trumpexcel.com – Free Online Excel Training
