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.
Excel has many functions where a user needs to specify a single or multiple criteria to get the result. For example, if you want to count cells based on multiple criteria, you can use the COUNTIF or COUNTIFS functions in Excel. This tutorial covers various ways of using a single or multiple criteria in COUNTIF …
I was never into sports. I tried my hands at a number of sports, but I was always below average in most of it (you got to give me some credit for trying at least). In 2010, my roommate got me addicted to watching football. We would keenly follow all the matches in English Premier League and …
When creating a drop-down list in Excel, it takes a range of cells as input and shows it as a list. There is not much you can do with how your list looks in the drop-down. For example, you can not give a background color or change font color, font type, font size, etc. Despite …
Wouldn’t it be great if there was a function that could count colored cells in Excel? Sadly, there isn’t any inbuilt function to do this. BUT.. It can easily be done. How to Count Colored Cells in Excel In this tutorial, I will show you three ways to count colored cells in Excel (with and without …
Counting is one of the most common tasks people do in Excel. It’s one of the metric that is often used to summarize the data. For example, count sales done by Bob, or sales more than 500K or quantity of Product X sold. Excel has a variety of count functions, and in most cases, these …
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 …
©trumpexcel.com – Free Online Excel Training
