SkillSoft Explore Course – Lambers, Inc.

Collections Essentials Microsoft Office for Mac 2016: Excel (No Assessments)

In large spreadsheets, it is not always easy to locate the data you need. DiscoverÂ the tools in Excel to find, replace, sort, and filter data. Also, learn how to create an outline, freeze panes, and hide duplicate values.

Asset ID	ds_msex16mc_07_enus
Course Type	Video Course
Course Category	Essentials

Objectives
Microsoft Excel 2016 for Mac: Finding, Sorting, and Filtering Data use the Find tool in Excel 2016 for Mac use the Replace tool in Excel 2016 for Mac sort your data in Excel 2016 for Mac filter your data in Excel 2016 for Mac sort and filter using colors in Excel 2016 for Mac use advanced filter options in Excel 2016 for Mac freeze and unfreeze panes in your worksheets create groups in Excel 2016 for Mac hide duplicate values in Excel 2016 for Mac

Objectives

Microsoft Excel 2016 for Mac: Finding, Sorting, and Filtering Data

use the Find tool in Excel 2016 for Mac
use the Replace tool in Excel 2016 for Mac
sort your data in Excel 2016 for Mac
filter your data in Excel 2016 for Mac
sort and filter using colors in Excel 2016 for Mac
use advanced filter options in Excel 2016 for Mac
freeze and unfreeze panes in your worksheets
create groups in Excel 2016 for Mac
hide duplicate values in Excel 2016 for Mac