Excel 2016 basics – Data presentation strategies

Overview

Microsoft Excel 2016 gives you many options for improving your data presentation. In this course, you’ll learn how to add visual impact to your data using Sparklines, including links to various locations, using hyperlinks, and creating custom formatting rules. You will learn about the many Excel 2016 tools for visually enhancing the appearance of your data.

Objectives

•  Copy data using AutoFill in Microsoft Excel 2016
• Fill a series using AutoFill in Microsoft Excel 2016
• \Fill in data lists using Quick Fill in Microsoft Excel 2016
• create a hyperlink in an Excel 2016 workbook
• edit an existing hyperlink in an Excel 2016 workbook
• apply conditional formatting using Quick Analysis in Microsoft Excel 2016
• create custom conditional formatting rules in Microsoft Excel 2016
• create and editing basic sparklines in Microsoft Excel 2016
• creating and editing custom sparklines in Microsoft Excel 2016