Collections     Essentials     Microsoft Office 2016: Beginning Excel

---

Microsoft Excel 2016 gives you many options for improving the presentation of your data. In this course, you will learn about adding visual impact to your data using Sparklines, linking to different locations using hyperlinks, and creating custom formatting rules. You will learn about the many tools Excel 2016 provides for visually enhancing the appearance of your data.

---

---

Objectives

Auto fill and Flash Fill start the course copy data using Auto Fill in Microsoft Excel 2016 fill a series using Auto Fill in Microsoft Excel 2016 complete data lists using Flash Fill in Microsoft Excel 2016 Hyperlinks create a hyperlink in an Excel 2016 workbook modify an existing hyperlink in an Excel 2016 workbook Conditional Formatting apply conditional formatting using Quick Analysis in Microsoft Excel 2016 create custom conditional formatting rules in Microsoft Excel 2016 Creating Sparklines create and edit basic sparklines in Microsoft Excel 2016 create custom sparklines in Microsoft Excel 2016 Practice: Presenting Your Data in Excel 2016 use hyperlinks, conditional formatting, and sparklines to customize the look of your data in Microsoft Excel 2016