## Excel Finance Class 81: XNPV Function XIRR Function – See Algorithm That XNPV uses

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 […]

## How to Set Password or Encrypt in Excel Document 2018

In Excel Tutorial, I am going to show you, How to Set Password or Encrypt in Excel Document Go to File Menu and Click the Info, click the Encrypt with Password Set your password then click OK now your password is created Please Subscribe My Channel Thank you for watching

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 […]

## Encode Base64 in Excel VBA

Base64 is a way to encode a binary into a text string which comprise of 64 characters base64 is mostly used in data transfer to ensure that the transfered data is not corrupted by the protocol In this tutorial, we’ll show how to easily encode a string in cell A1 into a base64 string with […]

## 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 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 […]