### VLOOKUP to 36 Different Tables with CHOOSE or OFFSET or INDIRECT function

May 5, 2016

Learn how to: CHOOSE Function Solution, with VLOOKUP and MATCH functions and the asterisk wild card (zero or more characters) OFFSET Function Solution, with VLOOKUP Read More

### Using OFFSET Function in Microsoft Excel

April 29, 2016

Now we are going to see how works the OFFSET function. With the OFFSET function you can returns a reference that is a number of Read More

### Using MATCH Function to Manage Databases in Excel

April 28, 2016

In the following video, we are going to use the MATCH function, this functions used with another useful function the OFFSET function, allows you to Read More

### List of Reminders and Future Tasks in Microsoft Excel

April 26, 2016

In Microsoft Excel, you can manage all your tasks, or to-do lists in an easy way. With the following video you can see how easy Read More

### Present Value and Future Value in Microsoft Excel

April 24, 2016

One of the most commonly used financial functions in Excel are Present value (PV) and Future Value (FV). Both functions use similar arguments so it Read More

### Multi Page Userform in Microsoft Excel

April 20, 2016

This is an Employee Database VBA Code in Microsoft Excel. Here you can learn how to construct the code in VBA that allows you to Read More

### Using Microsoft Excel as a Database

April 19, 2016

Use the Microsoft Excel program to manipulate databases. You can make filters to only get one unique person. In this video, we are going to Read More

### Create a simple Userform in Excel

April 18, 2016

To create interactive Workbooks, to allow a good experience for the users of a Workbook or a Worksheet, create Userforms, that allows you to get Read More

### Workbooks and Worksheets in Microsoft Excel

April 17, 2016

The main sections in Microsoft Excel are: The Workbooks and the Worksheets, there are where you are going to work.

### Using the Excel Range Functions

January 19, 2016

Learn to use the Min and Max functions in Excel to find the highest and lowest values and to use the Small and Large functions Read More

1 2 3 4 10