Excel 2021 Power Users
In this course, Excel 2021 Power Users, you will take your Excel knowledge to the next level. When youíre finished with this course, you will have the skills to format and manage more advanced spreadsheets (and continue preparation for the Microsoft Office exams).
What you'll learn
In this course, Excel 2021 Power Users, you will take your Excel knowledge to the next level. First, you will learn how to format cells with borders, styles, shapes and more. Next, youíll learn how to work with workbooks, worksheets and data. Then youíll learn more about printing workbooks (in whole or parts). Finally, youíll learn about tables and a few advanced functions. When youíre finished with this course, you will have the skills to format and manage more advanced spreadsheets (and continue preparation for the Microsoft Office exams).
Table of contents
- Format Cells and Ranges 4m
- Adding a Fill Color 2m
- Adding Borders to Cells and Ranges 3m
- Merge Cells 1m
- Wrap Text Within Cells 2m
- Modify Cell Alignment 3m
- Changing the Orientation 2m
- Format Cells by Using the Format Painter 5m
- Apply Cell Styles 4m
- Create and Modify Cell Styles 4m
- Change Workbook Themes 4m
- Create Custom Color Formats 5m
- Create and Modify Custom Themes 3m
- Insert Text Boxes 3m
- Insert and Modify Illustrations 12m
- Hide or Unhide Worksheets 1m
- Copy and Move a Worksheet 5m
- Change Worksheet Tab Color 2m
- Navigation Shortcuts 3m
- Change Magnification by Using Zoom Tools 3m
- Change Workbook Views 3m
- Create Custom Workbook Views 4m
- Use Sheet View 5m
- Change Window Views 6m
- Insert and Remove Hyperlinks 8m
- Save a Workbook as a Template 5m
- Import Data From a Delimited Text File 6m
- Using the Text to Columns Tool 3m
- Filter Records 5m
- Change Sort Order 4m
- Sort Data by Multiple Columns 5m
- Remove Duplicate Records 4m
- Create a Table From a Cell Range 4m
- Add Table Rows and Columns 4m
- Insert Total Rows 2m
- Apply Styles to Tables 2m
- Convert a Table To a Cell Range 2m
- Name Cells 4m
- Name Data Ranges 3m
- Name Tables 2m
- Manage Named Ranges and Objects 8m
About the author
ClipTraining, an industry leader in affordable cloud-based training and support, is a provider of Windows/Office/Office 365 and Security task-based end-user training videos. Our goal is to provide engaging training that ensure the learner can succeed in mastering new skills or enhancing existing ones.