Lynda - Excel for Mac 2011 - Charts in Depth

1. 01. Introduction/01_01-Welcome.mp46.62MB
2. 01. Introduction/01_02-Using the exercise files.mp4961.92KB
3. 02. Creating Basic Charts Quickly/02_01-Selecting data to display on a chart.mp412.09MB
4. 02. Creating Basic Charts Quickly/02_02-Creating charts with a keystroke or using ribbon icons.mp414.37MB
5. 03. Understanding Excel Chart Concepts/03_01-Identifying chart elements.mp48.55MB
6. 03. Understanding Excel Chart Concepts/03_02-Selecting the right chart type.mp421.26MB
7. 03. Understanding Excel Chart Concepts/03_03-Understanding chart terminology.mp412.59MB
8. 03. Understanding Excel Chart Concepts/03_04-Understanding the Charts Ribbon tab.mp45.27MB
9. 04. Creating and Adjusting Chart Appearances with Charts Tab Choices/04_01-Changing a charts type.mp48.51MB
10. 04. Creating and Adjusting Chart Appearances with Charts Tab Choices/04_02-Changing the location of a charts source data.mp47.81MB
11. 04. Creating and Adjusting Chart Appearances with Charts Tab Choices/04_03-Dealing with empty and hidden cells.mp415.81MB
12. 04. Creating and Adjusting Chart Appearances with Charts Tab Choices/04_04-Using Switch Plot for a different view of the data.mp49.48MB
13. 04. Creating and Adjusting Chart Appearances with Charts Tab Choices/04_05-Choosing a chart layout from the Chart Quick Layouts group.mp412.62MB
14. 04. Creating and Adjusting Chart Appearances with Charts Tab Choices/04_06-Choosing a chart style from the Chart Styles gallery of 48 variations.mp46.81MB
15. 04. Creating and Adjusting Chart Appearances with Charts Tab Choices/04_07-Saving a chart as a template for easy access later.mp47.36MB
16. 05. Using Chart Layout Tab Options/05_01-Adding, editing, and removing chart titles and axis titles.mp410.59MB
17. 05. Using Chart Layout Tab Options/05_02-Linking titles to content.mp45.41MB
18. 05. Using Chart Layout Tab Options/05_03-Adding, editing, and removing legends.mp410.81MB
19. 05. Using Chart Layout Tab Options/05_04-Adding and editing data labels.mp415.65MB
20. 05. Using Chart Layout Tab Options/05_05-Adding a data table.mp47.89MB
21. 05. Using Chart Layout Tab Options/05_06-Modifying axes.mp430.67MB
22. 05. Using Chart Layout Tab Options/05_07-Working with gridlines.mp414.36MB
23. 05. Using Chart Layout Tab Options/05_08-Analyzing existing and projected data with trendlines.mp417.55MB
24. 05. Using Chart Layout Tab Options/05_09-Adding drop lines and updown bars.mp416.44MB
25. 05. Using Chart Layout Tab Options/05_10-Adding error bars.mp413.66MB
26. 06. Using Format Tab Options and Other Visual Features/06_01-Adding color backgrounds to chart areas and other chart elements.mp48.94MB
27. 06. Using Format Tab Options and Other Visual Features/06_02-Exploring color and line effects for chart elements.mp48.64MB
28. 06. Using Format Tab Options and Other Visual Features/06_03-Altering chart text styles with fill and line effects.mp410.1MB
29. 06. Using Format Tab Options and Other Visual Features/06_04-Adding shapes and arrows.mp423.84MB
30. 06. Using Format Tab Options and Other Visual Features/06_05-Adding floating text and text boxes.mp411.64MB
31. 06. Using Format Tab Options and Other Visual Features/06_06-Selecting shape styles, fill, and line effects.mp415.21MB
32. 06. Using Format Tab Options and Other Visual Features/06_07-Using pictures and Clip Art as chart elements.mp49.79MB
33. 06. Using Format Tab Options and Other Visual Features/06_08-Using rightclick and doubleclick to quickly adjust formats.mp49.91MB
34. 07. Customizing Specific Chart Types/07_01-Customizing column and bar charts.mp419.83MB
35. 07. Customizing Specific Chart Types/07_02-Customizing line charts.mp417.73MB
36. 07. Customizing Specific Chart Types/07_03-Customizing pie charts.mp426.09MB
37. 07. Customizing Specific Chart Types/07_04-Customizing area, stock, and XY charts.mp434.83MB
38. 07. Customizing Specific Chart Types/07_05-Customizing doughnut, bubble, and radar charts.mp435.03MB
39. 08. Changing a Charts Data Source/08_01-Adding and deleting chart data series.mp413.63MB
40. 08. Changing a Charts Data Source/08_02-Creating charts from multiple data sources.mp411.18MB
41. 08. Changing a Charts Data Source/08_03-Adding new data to a chart using a table.mp413.67MB
42. 09. Specialized Excel Charts/09_01-Creating combination charts.mp413.71MB
43. 09. Specialized Excel Charts/09_02-Creating Gantt charts.mp418.32MB
44. 09. Specialized Excel Charts/09_03-Creating frequency charts.mp412.99MB
45. 09. Specialized Excel Charts/09_04-Using Form controls to create dynamic charts.mp420.17MB
46. 09. Specialized Excel Charts/09_05-Producing dynamic charts by using filters.mp412.03MB
47. 10. Printing and Sharing Charts/10_01-Printing charts.mp414.89MB
48. 10. Printing and Sharing Charts/10_02-Copying and linking charts with Word and PowerPoint.mp412.13MB
49. 11. InCell Chart Alternatives/11_01-Creating graphicincell charts with Sparklines.mp415.3MB
50. 11. InCell Chart Alternatives/11_02-Using Conditional Formatting options to create incell charts.mp49.11MB
51. 11. InCell Chart Alternatives/11_03-Using symbols and the REPT function for incell charts.mp411.93MB
52. 12. Chart Manipulation Tools/12_01-Changing the location of a chart.mp410.69MB
53. 12. Chart Manipulation Tools/12_02-Moving and resizing a chart within a worksheet.mp413.97MB
54. 12. Chart Manipulation Tools/12_03-Converting a chart to a graphic.mp412.6MB
55. 13. Conclusion/13_01-Next steps.mp42.54MB