-
Course
- Core Tech
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 | 3m 55s
- Adding a Fill Color | 1m 50s
- Adding Borders to Cells and Ranges | 3m 9s
- Merge Cells | 1m 26s
- Wrap Text Within Cells | 1m 46s
- Modify Cell Alignment | 3m 13s
- Changing the Orientation | 1m 45s
- Format Cells by Using the Format Painter | 5m 19s
- Apply Cell Styles | 4m 28s
- Create and Modify Cell Styles | 3m 34s
- Change Workbook Themes | 4m 7s
- Create Custom Color Formats | 5m 16s
- Create and Modify Custom Themes | 2m 44s
- Insert Text Boxes | 2m 41s
- Insert and Modify Illustrations | 11m 38s
- Hide or Unhide Worksheets | 1m 27s
- Copy and Move a Worksheet | 4m 53s
- Change Worksheet Tab Color | 1m 43s
- Navigation Shortcuts | 3m 5s
- Change Magnification by Using Zoom Tools | 3m 18s
- Change Workbook Views | 3m 18s
- Create Custom Workbook Views | 4m 2s
- Use Sheet View | 4m 39s
- Change Window Views | 5m 42s
- Insert and Remove Hyperlinks | 7m 38s
- Save a Workbook as a Template | 5m 11s
- Import Data From a Delimited Text File | 6m
- Using the Text to Columns Tool | 3m 20s
About the author
Windows/Office/Office 365 and Security task-based end-user training videos.
More Courses by ClipTraining