Excel 2021 Essential Training (Office 2021/LTSC)
1h 52mBeginner2021-12-10
Authors
Jess Stratton
LinkedIn Learning Staff Author, Tech Consultant
Course details
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.
Skills covered
Microsoft OfficeSpreadsheetsMicrosoft ExcelEssential TrainingBusiness Software and ToolsMicrosoft
Concepts
Introduction
- Analyze data with maximum efficiency in Excel
- Understanding Office versions
Work with Excel Files
- Navigate Excel and the Ribbon
- Create, open, and save a file
- Enter text in a workbook
Work with Cells and Text
- Format text in Excel
- Autofill and edit text
- Copying and deleting cell data
- Change borders and background colors
- Merge cells
- Find and replace text and values
- Work with cell data types
Work with Sheets
- Rename, insert, and delete a sheet
- Move and group sheets
Work with Rows and Columns
- Adjust column and row height and width
- Delete and hide rows and columns
- Insert multiple rows and columns
- Move and rearrange rows and columns
- Freeze columns and rows
Work with Formulas and Functions
- Build a formula and reference cells
- Copy formulas and use AutoSum
- Create a formula with XLOOKUP
- Split text into two columns
Sort and Filter Data
- Sort data in Excel
- Filter data with a drop-down list
- Create a PivotTable to group and summarize data
- Use conditional formatting to see trends
- Create and work with charts
Collaborate and Share
- Print a workbook or sheet
- Share a workbook or sheet
- Protect your file from unwanted changes
Conclusion
- Take Excel further