Learn your way! Get started

Excel 2013, Part 2: Excel Basics

with expert Leeanne McManus


Watch trailer

Excel 2013, Part 2: Excel Basics 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 5m
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

New users of Excel often face challenges when it comes to selecting and formatting content. Microsoft Office expert LeeAnne McManus will demonstrate how the different tools present in Excel can be used to search for data and format it into cells, columns, rows and sheets.

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



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)