Watch trailer
Course at a glance
| Release date | 4/6/2017 | |
| Level | Beginner | |
| Runtime | 2h 5m | |
| Closed captioning | N/A | |
| Transcript | N/A | |
| eBooks / courseware | N/A | |
| Hands-on labs | N/A | |
| Sample code | Included | |
| Exams | Included |
Course description
It isn’t uncommon for new users of Excel to face challenges when it comes to selecting and formatting content. In this course, Microsoft Office expert LeeAnne McManus will demonstrate the various methods and tools available in Excel to search for data and to 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 Excel is assumed.
Learning Paths
This course is part of the following LearnNowOnline SuccessPaths™:
Microsoft Office Fundamentals
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
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)