Learn your way! Get started

Excel 2013, Part 4: Modifying Workbook

with expert Leeanne McManus


Watch trailer

Excel 2013, Part 4: Modifying Workbook Trailer

Course at a glance

Included in these subscriptions:

  • Creative Design Power Pack
  • Power Pack Plus

Release date Release date 1/16/2017
Level Level Beginner
Runtime Runtime 2h 37m
Published eBooks Published eBooks N/A
Hands-on labs Hands-on labs N/A
Sample files Sample files Included
Exams Exams Included


Enterprise Solutions
Enterprise Solutions

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



Course description

Software expert LeeAnne McManus explains the graphics and objects available to users of Excel 2013. This course will show how these tools can help to illuminate the data in your workbook in order to give your audience the information they need in a more digestible, visual manner.

Prerequisites

This course assumes that students are familiar with the basic use of Windows and common use of the mouse and keyboard. No prior experience with Word is assumed.

Meet the expert

Leeanne McManus Leeanne is a nationally renowned trainer, facilitator, and productivity expert. For the past decade, she has trained, facilitated, and conducted thousands of sessions, helping clients to achieve their maximum potential. While being most well-known for helping end-users, departments, and organizations learn how to maximize their software products such as Office 365 and Adobe, Leeanne also facilitates sessions to enhance productivity and performance through soft skills. Leeanne consults clients on team building, leadership, succession planning, and more and utilizes a science-driven battery of assessments to help identify the uniqueness, skills, competencies, behavior, and drivers for each person. Leeanne's background includes Human Resources, Operations, and Talent and Development.


Course outline



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)