This sheet allows you to convert up to 20 characters to their Code, Decimal, Binary and Hexadecimal form. Enter your word or sentence, and the sheet will place each character in a separate cell. You can simply type it into the grey box. It will tell you if you’re exceeding the 20-character limit. When entering […]

This sheet allows you to en/decrypt messages, When encrypting a message, paste the text/numbers here, As you can see, the letters are all split up. This ten-digit code is the only combination that will allow you do decrypt the message again. This is all the receiver needs. Generate a random combination using the button. In […]

## Learn Excel SUMIFS and COUNTIFS Functions

Hi everyone! In this video tutorial, we will talk about SUMIFs and COUNTIFs formulas. So let’s dive in! In this worksheet, we have a sale report of drugs, buyers name, and country, order data and price of each drug. We want to write some formulas that will help us summarize the data based on specific […]

## How to use Excel ROWS and COLUMNS Functions

Hello everyone! In this video tutorial, we are going to talk about Excel ROWS and COLUMNS Formulas. So let’s dive in! First of all, let’s explain what these formulas are. The ROWS formula will give you the number of rows in a range of cells. For example, in this worksheet, if you parse the range […]

## Create an Excel Burndown Chart in Simple Steps

Hello Excel Funs, in this video tutorial we are going to build a Burndown Chart in Excel. Until now we learned how to create a Gantt Chart, helpful for a project progress. But a Burndown chart is a great project management tool which shows if a set of tasks are completed ahead of or behind […]

## Excel ROW Function – How to create a Unique Identification Number in Excel Table

If you need to create a column that will contain a unique value for each row in your table then you can do it easily with the help of ROW function. In this sheet the first column is the …ID which is unique. So to create a sequential number that is unique for each row, […]

## How to Transpose Cells using Do Until Loop VBA Code

Sometimes we need to create more complex macros. We will make an example in the workbook CombineMacros and in London Worksheet. We would like to copy these cells and paste them as columns. Transpose them to columns in other words. To make complex macros it’s better to record some of the code we need, check […]

## How to Create Notifications – Reminders in Excel using VBA Code

In this worksheet, we have two columns, the Domain Name and the expiration date of each domain. We want to create a notification when a domain expires in 1 week, so that the customer must renew it. There are a few ways to do that, like using formulas or conditional formatting. But we will use […]