How to Change the X and Y axis in Excel 2007 when Creating Supply and Demand Graphs

Title:
How to Change the X and Y axis in Excel 2007 when Creating Supply and Demand Graphs


Video:


Description:Footnotes: Turn up your volume (it's low, sorry) Simple example shown first then 3 column Column A is normally the X axis (horzizontal) Column B is normally the Y axis (vertical) Description: This video will show you how to change/switch the X and Y axis. This video will also show you how to make supply and demand 3 column scatter graph in Excel 2007.This method will manly help you in microeconomics.

Published:
09/Feb/2011

Excel Macro Tutorial - The Digital Sea Cow

Title:
Excel Macro Tutorial - The Digital Sea Cow


Video:


Description:Here I show a quick way to highlight cells using recorded macros.

Published:
09/Feb/2011

VBA and Macros 2010- Tint and Shade: Podcast #1336

Title:
VBA and Macros 2010- Tint and Shade: Podcast #1336


Video:


Description:Today, in Episode #1336, Bill discusses the new color themes in Excel 2010. The new themes come with six (6) accent colors - but today, Bill shows us how to take those six theme colors and turn them into 1200 colors using Tint and Shade.

Published:
08/Feb/2011

Excel Developer Tab Tutorial - The Digital Sea Cow

Title:
Excel Developer Tab Tutorial - The Digital Sea Cow


Video:


Description:In this tutorial I show how to locate/show the Developer tab in Excel 2010 and then show the basic features of the tab.

Published:
08/Feb/2011

Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)

Title:
Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)Video:


Description:Download files at: people.highline.edu The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. PivotTables are easy: Just envision the table in advance 2. Field list has fields and areas that you can drag fields to 3. Column Labels -- Column Headers 4. Row Labels -- Row Headers 5. Value Area -- this is where the calculation goes 6. Cross tabulation (row label and column label) 7. Double Click to create new sheet with data 8. Filter area -- filters whole report 9. Slicers 10. Value Field Settings Dialog box 11. Number Format For Value Field in Value Field Settings Dialog box 12. SUM function 13. Change Function in Value Field Settings Dialog box 14. Average Function 15. Format PivotTable 16. Layout For PivotTable 17. Multiple calculations: just drop field into value area multiple times and change function 18. Change Field Names in Value Field Settings Dialog box 19. Frequency Table to Count 20. Group By Dates

Published:
06/Feb/2011

Learn Excel - "Map Data": Podcast #1335

Title:
Learn Excel - "Map Data": Podcast #1335


Video:


Description:Today, in Episode #1335, Lisa Marie asks if you can get Excel data on to a map. In this episode, Bill shows us how to create a Shaded Region Map using Microsoft MapPoint "Excel 2010 In Depth", by Bill Jelen aka MrExcel.

Published:
04/Feb/2011

Excel 2010 Tutorial HD Charts

Title:
Excel 2010 Tutorial HD Charts


Video:


Description:

Published:
03/Feb/2011