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.
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, …
I get this query all the time. People have huge data sets and someone in their team has highlighted some records by formatting it in bold font. Now, you are the one who gets this data, and you have to filter all these records that have a bold formatting. For example, suppose you have the …
Excel Filter is one of the most used functionalities when you work with data. In this blog post, I will show you how to create a Dynamic Excel Filter Search Box, such that it filters the data based on what you type in the search box. Something as shown below: There is a dual functionality to …
In Excel, there are two ways to combine the contents of multiple cells: If you’re using Excel with Office 365 subscription, I suggest you click here to skip to the part where the TEXTJOIN function is covered. If you’re not using Office 365, keep reading. In its basic form, CONCATENATE function can join 2 or …
©trumpexcel.com – Free Online Excel Training
