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.
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 …
If you want to apply superscript or subscript format to the text in a cell, you may not find anything for it in the ribbon. This is one of those things where you need to go a level deep to make it happen. In this tutorial, you’ll learn how to apply the superscript and subscript format …
Sometimes you may have a need to embed a PDF file within the Excel workbook. This could be the case when you are creating a catalog and want to embed product specific PDFs. In this tutorial, you’ll learn how to insert a PDF file in an Excel Worksheet. How to Embed a PDF File in …
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 …
©trumpexcel.com – Free Online Excel Training
