All articles with 'videos' Tag

Last week we have posted a simple to understand excel pivot table tutorial here. Today I am going to supplement the tutorial with a 15 second video tutorial on Making excel pivot tables.

Two most commonly asked or searched queries when it comes to charting are,

• How to combine two chart types in one chart, like a line chart combined with bar chart?
• How to add a secondary axis to the chart so that one or more data series are plotted on the secondary axis?

Watch this video tutorial to learn how to do both in less than 15 seconds.

Watch it on youtube: Creating combination charts and adding secondary axis – video tutorial

It is very surprising that so many of us are still not aware of this extremely powerful tool in Excel 2007. Just with a click of the button, you can remove all the duplicate values from a list / table. To remove duplicates, (1) Just select the list of values from which you want to remove duplicates (2) Go to Data ribbon (3) Hit the Remove Duplicates button (4) Bingo…

Look at the power of conversation. A fan posted on youtube showing an apparent glitch in Tiger Woods 08 video game that you can walk on water to hit a golf ball. What did Electronic Arts and Tiger Woods do? They post a response to that video advertising Tiger Woods 09 saying that “its not […]