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.
With a lot of data…comes a lot of duplicate data. Duplicates in Excel can cause a lot of troubles. Whether you import data from a database, get it from a colleague, or collate it yourself, duplicates data can always creep in. And if the data you are working with is huge, then it becomes really …
Since I have started this blog, the Excel timesheet calculator template has been one of the most requested templates. I often get queries on how to calculate regular hours and overtime hours of employees based on the ‘In time’ and ‘Out time’. I also couldn’t find a good Excel timesheet template online, so I decided to …
This is the third and final article of the three-part tutorial series on Creating a KPI Dashboard in Excel. Part 1: Creating a Dynamic Scatter Chart in Excel Part 2: Spotting the Data Point and Creating a Dynamic Interpretation for the Chart Part 3: Extract List of Companies from the Scatter Chart + Company comparison( using …
This tutorial is a part of a three-part Excel KPI Dashboard tutorial series: In the previous article of this 3 part ‘KPI Dashboard in Excel’ series, we learned how to create a dynamic scatter chart. Something as shown below: KPI Dashboard in Excel – Part 2/3 In this article, I will show you: Click here …
Learn the exact steps I take to create World Class Dashboards in Excel. Join the Excel Dashboard Course. A Key Performance Indicators (KPI) dashboard is one of the most used dashboards in business. Its primary objective is to show the performance of key KPIs and provide a comparative view of other KPIs or companies. In this tutorial, …
Do you suffer from Forgot-to-change-chart-titles syndrome? I do. Worry not. Today’s prescription includes an article and a video on how to create dynamic chart titles in excel. Linking a Cell Value to the Chart Title Suppose you have the data as shown below and you have created a chart using it. If you want to …
A chart gets difficult to read if it has a lot of data plotted on it. While it is a good practice to plot only the relevant data, there are situations where you need to show a lot of data points on a single chart. If you are stuck in such a situation, it is a good …
Starting this month, I have decided to create and share an Excel Template every month. I already have a ready-to-download Excel Templates section on this blog, and I will keep on adding these new templates to this section. Before I come to this month’s template, I have a favour to ask. If you have any ideas …
In my last article, I wrote about mouse double-click tricks. In this tutorial, I will show you some amazing things you can do in Excel by using a combination of mouse and keyboard. Shift Rows/Columns/Cells Suppose you have three cells, and you want to shift the content of cell A1 to cell A3 (as shown …
©trumpexcel.com – Free Online Excel Training
