Formatting Excel Objects
Learn how to take your Excel worksheets from average to awesome using advanced features of object formatting.
What you'll learn
Are you tired of boring Excel spreadsheets that are all text and numbers? In this course, Formatting Excel Objects, you'll learn how to take your Excel worksheets from average to awesome using advanced features of object formatting.
First, you’ll learn how to insert text boxes, shapes, and pictures. Next, you’ll explore how to format those objects to more effectively illustrate your data and messages, while taking accessibility into account. Finally, you’ll see how to work with charts—applying layouts and styles, adjusting size and location, and adding and modifying various chart elements.
When you’re finished with this course, you’ll have an advanced understanding of Excel objects and how to format them for maximum effect.
Table of contents
- Module Introduction 1m
- Inserting Text Boxes 2m
- Demo: Inserting Text Boxes 3m
- Inserting Shapes 1m
- Demo: Inserting Shapes 3m
- Inserting Pictures 2m
- Demo: Inserting Pictures 4m
- Modifying Object Properties 2m
- Demo: Modifying Object Properties 3m
- Demo: Building the Structure for the Dashboard 14m
- Adding Alt Text to Objects for Accessibility 1m
- Demo: Adding Alt Text to Objects for Accessibility 2m
- Module Summary 1m
About the author
Amber has been a software developer and technical trainer since the early 2000s. In recent years, she has focused on teaching AI, machine learning, AWS and Power Apps, teaching students around the world. She also works to bridge the gap between developers, designers and businesspeople with her expertise in visual communication, user experience and business/professional skills. She holds certifications in machine learning, AWS, a variety of Microsoft technologies, and is a former Microsoft Cer... more