-
Course
- Core Tech
Excel 2019 Power Users
In Excel 2019 Power Users you’ll learn more advanced aspects of working with Excel 2019. Through this course you’ll learn how to format your data, work with workbooks and worksheets, print, begin work with tables, and use a few advanced functions.
What you'll learn
Learn more advanced aspects of Excel 2019. In this course, Excel 2019 Power Users, you will take your knowledge to the next level. First, you will learn how to format cells with borders, styles, shapes, and more. Next, you’ll discover how to work with workbooks, worksheets, and data. Then you’ll see more about printing workbooks (in whole or parts). Finally, you’ll explore a few advanced functions. When you’re finished with this course, you will have the skills and knowledge of Excel 2019 needed to format and work with more advanced spreadsheets (and continue your preparation for the Microsoft Office exams.)
Table of contents
- Format Cells and Ranges | 3m 49s
- Adding a Fill Color | 1m 44s
- Adding Borders to Cells and Ranges | 3m 5s
- Merge Cells | 1m 18s
- Wrap Text within Cells | 1m 40s
- Modify Cell Alignment | 3m 6s
- Changing the Orientation | 1m 36s
- Format Cells by Using the Format Painter | 4m 28s
- Apply Cell Styles | 4m 23s
- Create and Modify Cell Styles | 5m 14s
- Change Workbook Themes | 4m 1s
- Create Custom Color Formats | 5m 16s
- Create and Modify Custom Themes | 2m 37s
- Insert Text Boxes | 2m 37s
- Insert Objects and Shapes | 4m 33s
- Insert Images | 2m 34s
- Modify Object Properties | 3m 46s
- Add Alternative Text to Objects | 4m 56s
- Hide or Unhide Worksheets | 1m 20s
- Copy and Move a Worksheet | 4m 44s
- Change Worksheet Tab Color | 1m 37s
- Navigation Shortcuts | 2m 48s
- Change Magnification by Using Zoom Tools | 3m 13s
- Change Workbook Views | 4m 19s
- Change Window Views | 5m 31s
- Insert and Remove Hyperlinks | 6m 28s
- Save a Workbook as a Template | 3m 30s
About the author
Bill Kulterman is an educator, author, and a Microsoft Certified Trainer (MCT). Bill has been a trainer for more than a dozen years, educating students in Excel, Visio and a bevy of additional solutions. In recent years he has focused solely on SharePoint and SharePoint Online through Office 365. When he's not creating courses, he can usually be found riding his bike or relaxing near his Koi pond.
More Courses by Bill