### Good Looking Gauges in Microsoft Excel

May 12, 2016

Show really cool gauges to show indicators in your work. Let’s make good presentations of data learning with this video. Microsoft Excel has a lot Read More

### How To Show Negatives In A Chart In A Different Color Using The Invert If Negative Feature In Excel

May 7, 2016

With this video we are going to use the “Invert If Negative” feature in the charts. This is useful to show the negative values in Read More

### 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

1 2 3 4 10