Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
You can group numbers in Pivot Table to create frequency distribution tables. This helps in analyzing numerical values by grouping it into ranges. A simple example of this could be to analyze how many students scored marks between 40 and 50 and how many got marks between 50 and 60 and so on.. Another example …
One of my readers Donna sent me this query. She did some scoring in Excel and created Harvey balls using conditional formatting. She wanted to display the Harvey Balls as well as the score together. She also wanted to increase the font size of the Harvey Balls only and not the font size of the …
Having the data in the right format is a crucial step in creating a robust and error-free Pivot Table. If not done the right way, you can end up having a lot of issues with your pivot table. What is a good design for the Source data for Pivot Table? Let’s have a look at …
©trumpexcel.com – Free Online Excel Training
