Course description
In this seven part learning series you’ll see to use Microsoft Excel 2013 to organize, visualize and calculate your data. Get to know the Excel 2013 window and terminology, and create, edit, and manage cells, worksheets, and workbooks. Apply styles and themes to worksheets and adjust cell formatting with various fonts, colors, and borders. Work with formulas and functions to analyze data then present that data in a Pivot Table or visually with charts and graphs.
Prerequisites
This course assumes some familiarity with Microsoft Excel. This course is part of 7 courses; Excel 2013: Introduction; Excel 2013: Formatting; Excel 2013: Printing and Formulas; Excel 2013: Formatting, Tables and Functions; Excel 2013: Functions; Excel 2013: Charts and Pivot Tables and Excel 2013: Workbooks and Security. Please be sure to view the courses in order if you are new to the material.
Meet the expert
Our Creative Design courses are presented by experts from Wiley Publishing. Wiley is a global provider of knowledge and knowledge-enabled services that improve outcomes in areas of research, professional practice, and education. They are the publisher of award-winning journals, encyclopedias, books, and online products and services.
Course outline
Charts and Pivot Tables
Charts (19:48)
- Introduction (00:10)
- Create a Chart (05:33)
- Using Charts (05:53)
- Chart Changes (02:05)
- Chart Sheets (00:23)
- Chart Styles (05:32)
- Summary (00:10)
Chart Elements (24:28)
- Introduction (00:00)
- Chart Elements (05:06)
- Axis & Source (02:58)
- Legend & Labels (09:03)
- Shape Styles (04:02)
- More Shape Properties (03:08)
- Summary (00:10)
Sparklines & Pivot Tables (22:02)
- Introduction (00:10)
- Sparkline Chart (05:41)
- PivotTables (04:33)
- PivotTable Fields (05:29)
- Non-Numeric Pivot Tables (01:23)
- PivotTable Values (04:35)
- Summary (00:10)
PivotTables Continued (15:38)
- Introduction (00:10)
- PivotTable Styles (05:23)
- Hiding Values (02:45)
- Summarizing Data (05:02)
- PivotTable Charts (02:06)
- Summary (00:10)