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 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 4m
- Apply Cell Styles 4m
- Create and Modify Cell Styles 5m
- Change Workbook Themes 4m
- Create Custom Color Formats 5m
- Create and Modify Custom Themes 3m
- Insert Text Boxes 3m
- Insert Objects and Shapes 5m
- Insert Images 3m
- Modify Object Properties 4m
- Add Alternative Text to Objects 5m
- Filter Records 5m
- Change Sort Order 4m
- Sort Data by Multiple Columns 5m
- Remove Duplicate Records 4m
- Create a Table from a Cell Range 3m
- Add or Remove Table Rows and Columns 4m
- Insert Total Rows 2m
- Apply Styles to Tables 2m
- Configure Table Style Options 2m
- Convert a Table To a Cell Range 2m
- Name Cells 4m
- Name Data Ranges 3m
- Name Tables 2m
- Manage Named Ranges and Objects 6m
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.