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.
When you work with Excel charts, it rarely happens that you use the same default chart that Excel creates for you. In most of the cases, you have to change its formatting based on your brand, project, or audience. Now, if there is a fixed format that you have to use for many charts, it …
Text to Columns is an amazing feature in Excel that deserves a lot more credit than it usually gets. As it’s name suggests, it is used to split the text into multiple columns. For example, if you have a first name and last name in the same cell, you can use this to quickly split these into two …
If you’re into and financial planning or analysis, you must have heard about the Compound Annual Growth Rate (or CAGR). In this tutorial, you’ll learn different ways to calculate the CAGR in Excel: But before we dive into how to calculate CAGR in Excel, let’s first understand what it means (feel free to skip this …
When working with large datasets full of formulas in Excel, it becomes difficult to keep a track of important cells and formula results. You may have a data set that spans across hundreds or even thousands of records, and going back and forth to know the result of important formulas could be a big waste …
There are situations when you need to add leading zeroes to a dataset in Excel. This could be the case if you maintain records in Excel, such as Employee Ids or Transaction Ids. For example, you may want to get a consistent look in your data set as shown below: In this tutorial, you’ll learn …
If you work with a lot of numbers in Excel, it’s a good practice to highlight negative numbers in red. This makes it easier to read the data. There are various techniques you can use to highlight negative numbers in red in Excel: Let’s explore each of these techniques in detail. Highlight Negative Numbers in …
A timestamp is something you use when you want to track activities. For example, you may want to track activities such as when was a particular expense incurred, what time did the sale invoice was created, when was the data entry done in a cell, when was the report last updated, etc. Let’s get started. …
If you have a list of numbers, it easy to rank it using the RANK function. However, if you have these numbers within various groups, it could be a challenge to find the rank within the groups. For example, as shown below, there are two groups (A and B) with 5 items in each group. Each item …
If you have a lot of hyperlinks and these are scattered in the worksheet, it could be a herculean task to find these. Doing it manually can take you forever. In this tutorial, you’ll learn how to quickly: Find All Hyperlinks in Excel Suppose you have a dataset as shown below: Using Find and Replace …
©trumpexcel.com – Free Online Excel Training
