Excel

Excel Charts | Bubble Charts | Video

April 30, 2011

Make Sound Business Decisions with Excel Bubble Charts

How a powerful Excel Chart can help you make superior business decisions! Excel Bubble Charts integrate 3 different data elements into one. They are a great way to get a visual overview of your business, allowing you to understand and evaluate key aspects and how they relate to each other. In this video tutorial I talk about Barbara, [...]

Read the full article →

Excel Pivot Tables – Make your numbers talk with Calculated Items | Video

February 3, 2011

Make your numbers talk with Calculated Items in Pivot Table Reports When you have an Excel list or another data source that does not contain all the data you need to produce a meaningful report, you can use the Calculated Items or Calculated Field Pivot Tables options to obtain new results. This video tutorial introduces [...]

Read the full article →

Excel Pivot Tables – Make your numbers talk with Calculated Fields | Video

February 3, 2011

Make your numbers talk with Calculated Fields in Pivot Table Reports When you have an Excel list or another data source that does not contain all the data you need to produce a meaningful report, you can use the Calculated Fields or Calculated Item Pivot Tables options to obtain new results. This video tutorial introduces [...]

Read the full article →

Compare Excel Lists with the VLOOKUP Function | Video

January 13, 2010

This is video 5/5 in our series “Advanced IT Skills Refreshers for Connoisseurs” Compare Excel lists with the VLOOKUP function. This is an advanced feature made easy. Avoid manual work – let the computer do the legwork!

Read the full article →

65 Look up data in an Excel database with VLookup

November 16, 2009

This is video 4/5 in our series “Advanced IT Skills Refreshers for Connoisseurs” Look up information in an Excel List, with the VLOOKUP Function. Useful for calculating salaries, making invoices, searching employee details, and much more! This video tutorial may be viewed by Premium Members only. If you wish to watch it, please click here [...]

Read the full article →

Excel Charts | Compare two sets of data with a Secondary Axis

August 6, 2009

This is video 1/5 in our series “Advanced IT Skills Refreshers for Connoisseurs” We show you how to compare different types of data in the same EXCEL chart, by adding a SECONDARY AXIS

Read the full article →