SkillSoft Explore Course – Lambers, Inc.

BUY NOW! STARTING AT ONLY $299!

Productivity & Collaboration Tools Office 365 Excel Office 365 Microsoft Microsoft 365: Intermediate Excel

This 10-video course offers learners an in-depth exploration of Excel's sorting and filtering tools used to analyze data in a spreadsheet. You will learn how to control what is displayed in a data range, and how the values are organized in a worksheet. This course then demonstrates how to sort a data range by alphabetical order, and in value ranges. Learn how to include or exclude a header, and change the sort orientation from vertical to horizontal. Then learn how to create multiple sort levels to change how data are presented. You will learn how to create a custom sort list, and how to use column filters to show or hide different data values in your data range. You will learn to filter the data of a range and show values to meet specified criteria. This course demonstrates how to apply color coding to data items in a table, and how to use these codes to sort and filter data. Finally, learners observe how to create advanced filter criteria by using a separate table.

Asset ID	ds_msex365_10_enus
Course Type	Video Course
Course Category	Office 365

Objectives
Excel Office 365 (Windows): Sorting & Filtering Data sort data in a worksheet according to a specific data type customize sort options when sorting data in a worksheet sort data using multiple criteria and sort levels create and use custom sort lists to sort data use column filters to filter data in a worksheet use column filters to apply multiple filters to data in a worksheet create filter arguments using text and number data types sort and filter data using colors applied to data use the advanced filter tools to filter and extract data use filter tools to hide duplicate values in a data range

Objectives

Excel Office 365 (Windows): Sorting & Filtering Data

sort data in a worksheet according to a specific data type
customize sort options when sorting data in a worksheet
sort data using multiple criteria and sort levels
create and use custom sort lists to sort data
use column filters to filter data in a worksheet
use column filters to apply multiple filters to data in a worksheet
create filter arguments using text and number data types
sort and filter data using colors applied to data
use the advanced filter tools to filter and extract data
use filter tools to hide duplicate values in a data range