Excel 2021 Essential Training (Office 2021/LTSC)

Focused View

Jess Stratton

1:51:25

0 View

1. Introduction

01. Analyze data with maximum efficiency in Excel.mp4

00:55

02. Understanding Office versions.mp4

01:29

2. Work with Excel Files

03. Navigate Excel and the Ribbon.mp4

04:12

04. Create, open, and save a file.mp4

02:38

05. Enter text in a workbook.mp4

03:34

3. Work with Cells and Text

06. Format text in Excel.mp4

02:54

07. Autofill and edit text.mp4

04:35

08. Copying and deleting cell data.mp4

04:23

09. Change borders and background colors.mp4

04:42

010. Merge cells.mp4

01:18

011. Find and replace text and values.mp4

04:21

012. Work with cell data types.mp4

03:46

4. Work with Sheets

013. Rename, insert, and delete a sheet.mp4

02:23

014. Move and group sheets.mp4

02:53

5. Work with Rows and Columns

015. Adjust column and row height and width.mp4

05:04

016. Delete and hide rows and columns.mp4

03:36

017. Insert multiple rows and columns.mp4

02:15

018. Move and rearrange rows and columns.mp4

03:07

019. Freeze columns and rows.mp4

03:54

6. Work with Formulas and Functions

020. Build a formula and reference cells.mp4

03:52

021. Copy formulas and use AutoSum.mp4

03:29

022. Create a formula with XLOOKUP.mp4

04:18

023. Split text into two columns.mp4

03:06

7. Sort and Filter Data

024. Sort data in Excel.mp4

04:38

025. Filter data with a drop-down list.mp4

03:41

026. Create a PivotTable to group and summarize data.mp4

05:27

027. Use conditional formatting to see trends.mp4

03:45

028. Create and work with charts.mp4

05:12

8. Collaborate and Share

029. Print a workbook or sheet.mp4

05:28

030. Share a workbook or sheet.mp4

02:01

031. Protect your file from unwanted changes.mp4

03:56

9. Conclusion

032. Take Excel further.mp4

00:33

Description

Excel, the popular spreadsheet program from Microsoft, is an essential tool for many professional roles. In this course, Jess Stratton shows you the ins and outs of the 2021 release. Jess begins with how to navigate Excel and how to create, open, and save a file. Next, she shows you how to enter, format, autofill, and edit text, as well as how to copy and delete cell data, merge cells, and more. Jess explains how to work with sheets, then dives into the myriad adjustments and customizations you can apply to rows and columns. Formulas are at the heart of Excel’s ability to perform text or number calculations, so Jess concludes by walking you through formulas and functions, including AutoSum and the very useful XLOOKUP.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Jess Stratton

Instructor's Courses

I am an instructor with LinkedIn Learning - With over 300 hours of instructional content on Lynda.com, my courses are specialized for businesses, home office, social media, and personal use focusing on Google Apps, Microsoft Office, home tech, and productivity/mobile apps. My writings have been in computer textbooks, and I have several published articles in industry magazines and major websites including Lifehacker.org. I'm a frequent speaker at large industry conferences about productivity, web, and Lotus Notes/Domino. I used to own and operate a successful brick-and-mortar boutique style computer learning facility in downtown shopping district. I LOVE my job. I get to help people be the very best at their own jobs.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.