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 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 …
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
