Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
*This is a guest post by Ryan Wells, a fellow blogger, and a brilliant VBA developer.* If you work with Excel, you undoubtedly have been asked to create summaries of your work. Sales reports, invoices, forecasts, schedules, you name it. You know what all these documents have in common? They look great in PDF form. …
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 …
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 …
©trumpexcel.com – Free Online Excel Training
