Formatting Excel Objects
Take your Excel worksheets from average to awesome using advanced features of object formatting. This course will guide you through formatting for text boxes, shapes, pictures, and charts.
What you'll learn
Microsoft Excel is one of the most commonly-used tools in business today. Whether running calculations, creating reports, or keeping things organized, skills in this area will be in high demand for years to come.
In this course, learn how to take your Excel worksheets from average to awesome using advanced features of object formatting. You’ll first learn how to insert text boxes, shapes and pictures. From there, you’ll explore how to format those objects to more effectively illustrate your data and message, 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 4m
- Inserting Pictures 2m
- Demo: Inserting Pictures 3m
- Modifying Object Properties 2m
- Demo: Modifying Object Properties 15m
- 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