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
Workbooks and Security
Workbooks (18:29)
- Introduction (00:10)
- Linking Workbooks (05:42)
- Change Source Structure (04:23)
- Consolidate Workbooks (03:41)
- Consolidation Cont. (04:21)
- Summary (00:10)
Scenarios (14:02)
- Introduction (00:10)
- What-If Analysis (04:17)
- Using Scenarios (01:42)
- Merge Scenarios (02:40)
- Scenario Reports (05:01)
- Summary (00:10)
Security (24:10)
- Introduction (00:10)
- Data Tables (05:47)
- Alter Data Table (05:43)
- Workbook Password (05:35)
- Encryption (03:29)
- Lock and Unlock Cells (03:14)
- Summary (00:10)
Comments (18:28)
- Introduction (00:10)
- Working with Comments (05:19)
- Track Changes (05:10)
- History Sheet (04:32)
- Customizing Excel (03:06)
- Summary (00:10)
Macros & the Ribbon (21:19)
- Introduction (00:10)
- Ribbon Tabs (04:52)
- Ribbon Customization (05:39)
- Quick-Access Toolbar (04:00)
- Create Macro (04:12)
- Run Macro (02:13)
- Summary (00:10)