Certification     Microsoft     Microsoft Office Specialist (MOS) on Microsoft Office 2016     77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation

---

A picture may paint a thousand words but Microsoft Excel 2016 makes adding both words and pictures to your workbooks very straightforward. In this course, you will learn how to insert and style text boxes, shapes, and SmartArt. You will also learn about applying and customizing themes and watermarks.

---

---

Objectives

Shapes, Text Boxes, and SmartArt start the course add a text box to a Microsoft Excel 2016 worksheet modify the look of a text box in Microsoft Excel 2016 add shapes and lines to a worksheet in Microsoft Excel 2016 insert SmartArt into a Microsoft Excel 2016 worksheet edit SmartArt you have added to a Microsoft Excel 2016 worksheet Practice: Customizing a Worksheet add text, shapes, and SmartArt to a Microsoft Excel 2016 worksheet Watermarks and Themes use WordArt and images to create watermarks in Microsoft Excel 2016 apply a theme to a Worksheet in Microsoft Excel 2016 modify and save a theme in Microsoft Excel 2016 Splitting Text convert text to columns in Microsoft Excel 2016 Practice: Visual Effects apply a theme and a watermark to a Microsoft Excel 2016 worksheet