Learn your way! Get started

Excel 2013: Fundamentals

with expert Leeanne McManus


Watch trailer


Course at a glance


Release date 1/2/2016
Level
Runtime 9h 25m
Closed captioning N/A
Transcript N/A
eBooks / courseware N/A
Hands-on labs N/A
Sample code Included
Exams Included


Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More



Course description

Master course Excel 2013

Meet the expert

Leeanne McManus is a nationally renowned trainer, facilitator, and productivity expert who has conducted thousands of sessions over the past decade. While widely recognized for helping end-users, departments, and organizations learn how to maximize their software products, most notably Office 365 and Adobe, Leeanne also facilitates sessions to enhance productivity and performance through soft skills development. Her professional background includes Human Resources, Operations, and Talent and Development.

Course outline



Getting Started

Getting Started (32:44)
  • Introduction (00:23)
  • Description of Excel 2013 (03:32)
  • Audience (00:58)
  • The Excel Interface (01:27)
  • Documents (01:01)
  • Navigating the Ribbon Tabs (01:48)
  • The Quick-Access Toolbar (00:49)
  • Contextual Ribbon Tabs (01:36)
  • Status Bar (00:53)
  • Changing Views (00:37)
  • Demo: Ribbon Tabs (05:21)
  • Demo: More Ribbon Tabs (04:21)
  • Demo: Quick Access Toolbar (03:45)
  • Demo: Status Bar (05:27)
  • Summary (00:40)
Sign in to Office 365 (07:45)
  • Introduction (00:19)
  • Sign in to Office 365 (02:11)
  • Demo: Office 365 (04:56)
  • Summary (00:17)
Drop Down, Dialog, & Gallery (10:28)
  • Introduction (00:29)
  • Understanding Drop Downs (01:25)
  • Opening a Dialog Box (00:55)
  • Expanding Galleries (00:48)
  • Demo: Cell Formatting (04:27)
  • Demo: Other Drop Downs (02:01)
  • Summary (00:20)
Understanding the Backstage (13:19)
  • Introduction (00:33)
  • Understanding the Backstage (01:42)
  • Demo: Backstage (05:34)
  • Demo: More Backstage (05:07)
  • Summary (00:21)

Customization

Templates (09:51)
  • Introduction (00:24)
  • Start New or with a Template (00:38)
  • Demo: Template (04:35)
  • Demo: Finding Templates (03:58)
  • Summary (00:15)
Customization (27:56)
  • Introduction (00:18)
  • Customizing the Environment (00:48)
  • Show or Hide the Ribbon (00:44)
  • Customize the Ribbon (00:27)
  • Customize the QAT (00:32)
  • Options Dialog Box (00:25)
  • Demo: Show/Hide Ribbon (02:45)
  • Demo: Quick Access Toolbar (06:17)
  • Demo: More Commands (06:07)
  • Demo: Customize the Ribbon (03:14)
  • Demo: Other Excel Options (05:55)
  • Summary (00:17)
Select, Edit, and Modify (12:23)
  • Introduction (00:18)
  • Select, Edit & Modify Content (00:40)
  • Mini Toolbar Formatting (01:19)
  • Quick Clicks for Fast Modify (00:41)
  • Quick Preview (00:58)
  • Demo: Mini Toolbar (04:13)
  • Demo: Quick Preview (03:52)
  • Summary (00:18)

Exploring the Workbook

Exploring the Workbook (19:51)
  • Introduction (00:18)
  • Exploring the Workbook (03:06)
  • Demo: Adding a Worksheet (06:41)
  • Demo: Views (05:24)
  • Demo: Arrange All (04:05)
  • Summary (00:14)
Working with Excel (20:23)
  • Introduction (00:20)
  • Working with Excel (02:13)
  • Demo: Rows and Columns (05:04)
  • Demo: Selections (04:31)
  • Demo: Selection Cont. (04:45)
  • Demo: Modifying Content (02:52)
  • Summary (00:36)
Common Excel Features (21:01)
  • Introduction (00:17)
  • Common Excel Features (00:42)
  • Demo: Merge Cells (05:46)
  • Demo: Merge Cells Cont. (04:26)
  • Demo: Formatting Text (02:59)
  • Demo: Paste Special (03:47)
  • Demo: Show and Hide (02:29)
  • Summary (00:31)

Excel Features

Find, Replace, and Select (10:54)
  • Introduction (00:19)
  • The Editing Group (00:27)
  • Demo: Find and Replace (05:52)
  • Demo: Other Selections (03:48)
  • Summary (00:27)
Fill or Series (11:36)
  • Introduction (00:19)
  • The Editing Group (00:39)
  • Demo: Fill (05:50)
  • Demo: Fill Example (04:32)
  • Summary (00:14)
AutoSum (16:37)
  • Introduction (00:16)
  • The Editing Group (01:43)
  • Demo: Adding Numbers (03:07)
  • Demo: AutoSum (04:18)
  • Demo: Other Calculations (03:58)
  • Demo: More Functions (02:45)
  • Summary (00:27)
Clear, Sort, and Filter (25:08)
  • Introduction (00:35)
  • The Editing Group (00:29)
  • Demo: Clear (04:52)
  • The Editing Group (01:07)
  • Demo: Sort (06:58)
  • Demo: Sort Levels (04:14)
  • Demo: Filter (03:51)
  • Demo: Multi Filter (02:38)
  • Summary (00:22)

Calculations

Creating Calculations (11:06)
  • Introduction (00:18)
  • Creating Calculations (04:19)
  • Demo: Calculations (03:18)
  • Demo: Entering Calculations (02:46)
  • Summary (00:22)
Formulas (16:24)
  • Introduction (00:23)
  • Formulas (03:42)
  • Demo: Formulas (05:11)
  • Demo: Parentheses (05:22)
  • Demo: Parentheses Cont. (01:23)
  • Summary (00:21)
Functions (23:20)
  • Introduction (00:15)
  • Functions (02:47)
  • Demo: Functions (05:59)
  • Demo: Text Functions (04:01)
  • Demo: Convert to One Field (06:10)
  • Demo: If (03:37)
  • Summary (00:29)
AutoComplete (07:54)
  • Introduction (00:15)
  • AutoComplete Functions (01:28)
  • Demo: AutoComplete (05:48)
  • Summary (00:21)
AutoFill (05:32)
  • Introduction (00:24)
  • AutoFill (00:40)
  • Demo: AutoFill (04:10)
  • Summary (00:16)
FlashFill (11:12)
  • Introduction (00:18)
  • FlashFill (01:44)
  • Demo: FlashFill (04:48)
  • Demo: Forcing FlashFill (04:04)
  • Summary (00:16)
Cell Reference (16:08)
  • Introduction (00:22)
  • Cell References (02:23)
  • Relative, Absolute, Mixed (02:21)
  • Demo: Cell Reference (04:55)
  • Demo: Absolute Cell Reference (05:48)
  • Summary (00:16)

Formatting

Common Formatting (29:37)
  • Introduction (00:30)
  • Common Formatting (01:32)
  • Demo: Common Formatting (05:08)
  • Demo: Format Cells Dialog Box (04:10)
  • Demo: Cell Styles (05:14)
  • Demo: Alignment (04:53)
  • Demo: Alignment Cont. (02:14)
  • Demo: Number Formatting (05:34)
  • Summary (00:19)
Borders and Fill (12:39)
  • Introduction (00:18)
  • Borders and Fill Formatting (00:41)
  • Demo: Borders (02:34)
  • Demo: Fills (05:10)
  • Demo: More Formatting (03:30)
  • Summary (00:23)
Move, Copy, & Color Sheets (16:08)
  • Introduction (00:18)
  • Sheets (01:16)
  • Demo: Color Sheets (02:31)
  • Demo: Hide and Unhide Sheets (05:00)
  • Demo: Move or Copy (06:44)
  • Summary (00:17)
Format as a Table (20:09)
  • Introduction (00:22)
  • Format as a Table (01:36)
  • Demo: Format as a Table (05:14)
  • Demo: Table Styles (04:19)
  • Demo: Table Tricks (03:51)
  • Demo: Delete Table Rows (04:29)
  • Summary (00:16)

Using Objects

Conditional Formatting (18:16)
  • Introduction (00:20)
  • Conditional Formatting (01:01)
  • Demo: Conditional Formatting (04:43)
  • Demo: Top/Bottom Rules (02:04)
  • Demo: More Conditional Formats (05:14)
  • Demo: Editing Rules (04:21)
  • Summary (00:31)
Text Effects (18:19)
  • Introduction (00:22)
  • Text Effects (01:19)
  • Demo: Insert Objects (05:37)
  • Demo: Styling Objects (03:24)
  • Demo: WordArt (04:22)
  • Demo: Grouping (02:42)
  • Summary (00:29)
Inserting Charts (24:15)
  • Introduction (00:34)
  • Inserting Charts (02:25)
  • Demo: Recommended Charts (04:22)
  • Demo: Recommended Charts Cont. (04:53)
  • Demo: Chart Formatting (04:20)
  • Demo: Chart Types (05:25)
  • Demo: Objects and Charts (01:53)
  • Summary (00:20)
Inserting Graphics (18:11)
  • Introduction (00:30)
  • Inserting Graphics (01:03)
  • Demo: Screenshot (03:21)
  • Demo: Screen Clipping (03:00)
  • Demo: SmartArt (04:20)
  • Demo: Images from the Web (05:28)
  • Summary (00:28)

Finishing Touches

Inserting Headers and Footers (12:56)
  • Introduction (00:25)
  • Headers and Footers (01:15)
  • Demo: Headers and Footers (06:00)
  • Demo: More Headers And Footers (04:48)
  • Summary (00:26)
Views (16:53)
  • Introduction (00:16)
  • Workbook Views (02:59)
  • Demo: Views (05:12)
  • Demo: Print Preview (02:52)
  • Demo: Page Setup (05:02)
  • Summary (00:28)
Print Preview And Print (11:06)
  • Introduction (00:27)
  • Print Preview and Print (03:05)
  • Demo: Print Preview (02:15)
  • Demo: Print Settings (04:54)
  • Summary (00:24)
Sharing (10:44)
  • Introduction (00:19)
  • Sharing Your Workbook (04:02)
  • Demo: Sharing (05:46)
  • Summary (00:35)
Sparklines (14:02)
  • Introduction (00:21)
  • Sparklines (01:54)
  • Demo: Sparklines (02:45)
  • Demo: Sparklines Design (05:12)
  • Demo: Other Sparklines (03:26)
  • Summary (00:21)
Quick Analysis (10:33)
  • Introduction (00:26)
  • Quick Analysis (02:29)
  • Demo: Quick Analysis (04:29)
  • Demo: More Quick Analysis (02:42)
  • Summary (00:24)