Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
In VBA, looping is used when you need to perform the same task multiple times until a condition is met (or until a condition is true). In this tutorial, you’ll learn how to use the For Next Loop in Excel VBA. If you’re interested in learning VBA the easy way, check out my Free Excel …
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
