Excel Video tutorials 2010
Excel Video tutorials 2010 Essential Training (Chapter 11- Chapter 15 + Exercise Files)
Chapter 11 Advanced Analysis with Pivot Tables
1101 Discovering PivotTables
1102 Creating a basic PivotTable
1103 Modifying a PivotTable
1104 Creating and modifying a PivotChart
Chapter 12 Creating and Using Charts
1201 Choosing chart types
1202 Inserting Sparklines
1203 Creating a column chart
1204 Modifying a column chart
1205 Creating and modifying a pie chart
1206 Placing Excel charts into other Office applications
Chapter 13 Creating and Using Macros
1301 Understanding macros
1302 Recording and using a simple macro
1303 Editing a macro
Chapter 14 Customizing Excel
1401 Customizing the Quick Access toolbar
1402 Customizing the Ribbon bar
1403 Setting Excel options
Chapter 15 Conclusion
Exercise Files
Chapter 1 to Chapter 14 All files including excel sheets included.