Watch trailer
Course at a glance
| Release date | 3/18/2015 | |
| Level | ||
| Runtime | 1h 0m | |
| Closed captioning | N/A | |
| Transcript | N/A | |
| eBooks / courseware | Included | |
| Hands-on labs | N/A | |
| Sample code | Included | |
| Exams | N/A |
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
Introduction to Functions
Names & Conditional Formatting (18:23)
- Introduction (00:10)
- Naming Ranges (05:30)
- Name Manager (02:56)
- Conditional Formatting (04:20)
- Conditional Formatting Colors (05:16)
- Summary (00:10)
Tables (19:24)
- Introduction (00:10)
- Create a Table (05:36)
- Data Validation (02:49)
- Table Sorting (04:34)
- Table Tools (06:04)
- Summary (00:10)
Functions (23:02)
- Introduction (00:10)
- Working with Functions (04:59)
- Subtotals (01:20)
- Create Formula (04:24)
- Round Function (03:59)
- Histograms (03:34)
- Mode Function (04:25)
- Summary (00:10)