Microsoft Office 2016 Intermediate Excel: Creating Custom Visual Effects

End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016


Expected Duration
55 minutes

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.


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





Multi-license discounts available for Annual and Monthly subscriptions.