### Sensitivity Data Analysis in Excel

December 1, 2017

Sensitivity data analysis Excel is a method that allows us to immediately visualize the economic advantages and disadvantages of a project. This method is widely used Read More

### Excel Custom Format for Numbers

November 24, 2017

The Excel custom format of numbers allow us to create different types of format. Those are adapt to our needs. When none of the preset Read More

### Insert Watermark in Excel

November 18, 2017

To insert a watermark in Excel you need to use an alternative technique. This is because the tool does not have an integrated functionality for this Read More

### VBA Logical Operators in Microsoft Excel

June 7, 2017

The most common logical operators in VBA are: AND and OR. Each of these operators is very useful for evaluating conditions and Read More

### What is the PRICE Excel Function Used for?

April 21, 2017

Now we are going to learn all about formulas and functions. This is the best way to learn them:   PRICE Returns the 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

1 2 3 9