### PMT Function Calculating a Loan Payment

June 27, 2016

In this video, learn how to calculate the payment for a loan based on constant payments and a constant interest rate. You need Read More

### Dependent Data Validation Lists in Microsoft Excel

May 16, 2016

This video will walk you through the process of setting up and using dependent data validation lists with Microsoft Excel. You could refer to this Read More

### Using Navigation Tools in Microsoft Excel

May 13, 2016

Learn about essential training in Microsoft Excel, one of the first tools that you have to begin to use, the navigation. Save a lot of Read More

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

1 2 3 4 12