Wednesday, May 21, 2014

Excel 2013 tutorial: Creating PivotTables | lynda.com



Published on Feb 8, 2013
Find out how to create PivotTables to view and analyze data dynamically in Excel 2013. Watch more at http://www.lynda.com/Excel-tutorials/....

This tutorial is a single movie from the Excel 2013 Essential Training course presented by lynda.com author Dennis Taylor. The complete course duration is 6 hours and 8 minutes long and teaches you the basics of using Excel 2013 to enter and organize data, use functions, and build charts and PivotTables

1. Getting Started with Excel 2013
2. Entering Data
3. Creating Formulas and Functions
4. Formatting
5. Adjusting Worksheet Layout and Data
6. Printing
7. Introduction to Charting
8. Adjusting Worksheet Views
10. IF, VLOOKUP, and Power Functions
12. The Database Features of Excel
13. PivotTables
14. Data Analysis Tools
9. Multiple Worksheets and Workbooks
11. Security and Sharing
Introduction
15. Introduction to Macros
Conclusion



Source: http://www.youtube.com/watch?v=cLQ8A2889gk