Microsoft Excel 2016 Essentials: Data Presentation Strategies

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
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.

Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification

Prerequisites
None

Expected Duration (hours)
0.8

Lesson Objectives

Microsoft Excel 2016 Essentials: Data Presentation Strategies

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

create a hyperlink in an Excel 2016 workbook

modify 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 edit basic sparklines in Microsoft Excel 2016

create custom sparklines in Microsoft Excel 2016

use hyperlinks, conditional formatting, and sparklines to customize the look of your data in Microsoft Excel 2016

Course Number:
mo_beel_a03_dt_enus

Expertise Level
Intermediate