Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Date and Time in Excel are stored as numbers. This enables a user to use these dates and time in calculations. For example, you can add a specific number of days or hours to a given date. However, sometimes you may want these dates to behave like text. In such cases, you need to know …
A Heat Map in Excel is a visual representation that quickly shows you a comparative view of a dataset. For example, in the dataset below, I can easily spot which are the months when the sales were low (highlighted in red) as compared with other months. In the above dataset, the colors are assigned based on …
Excel Dashboards can be very useful when you need to assess the performance of some key metrics over a period of time. This Call Center Performance Dashboard enables the user to analyze the performance on a weekly basis and track key call center metrics. Call Center Performance Dashboard Here’s a how the dashboard looks: Click …
If you have a dataset and you want to transpose it in Excel (which means converting rows into columns and columns into rows), doing it manually is a complete NO! Transpose Data using Paste Special Paste Special can do a lot of amazing things, and one such thing is to transpose data in Excel. Suppose …
There can be situations when you have to split cells in Excel. These could be when you get the data from a database or you copy it from the internet or get it from a colleague. A simple example where you need to split cells in Excel is when you have full names and you …
If you’re a teacher or a trainer, creating groups of students/participants is a common task. For example, you may want to create groups to conduct a quiz or a team building activity. And in most of the cases, you need these groups to be random. Today, I am sharing a random group generator template that will …
There are different ways you can filter data in a Pivot Table in Excel. As you’ll go through this tutorial, you’ll see there are different data filter options available based on the data type. Types of Filters in a Pivot Table Here is a demo of the types of filters available in a Pivot Table. Let’s …
If you work with Excel day in and day out, Excel Keyboard Shortcuts can help you shorten your workday and save a lot of time. Additionally, it also has the power to enchant your co-workers and boss into thinking you’re an Excel Wizard. When I started my career as an analyst, I was completely in awe …
Sometimes you may want to lock cells in Excel so that other people can’t make changes to it. It could be to avoid tampering of critical data or prevent people from making changes in the formulas. How to Lock Cells in Excel Before we learn how to lock cells in Excel, you need to understand …
©trumpexcel.com – Free Online Excel Training
