Excel 365 in 30 Minutes – Data Manipulation & Validation (Advanced 5 of 11)

In this Bigger Brains course, you’ll learn advanced techniques for filtering and sorting data in Excel 365 to build well-structured datasets. You’ll explore advanced filtering to send results to another location  and apply multiple criteria in place. Additionally, you’ll see how to sort data by multiple columns at once, manipulate sort levels, and customize sort behavior using options in the Sort dialog box. 

You’ll learn how to use data validation to maintain accuracy and consistency across your worksheets and how to apply and remove validation rules to numeric, text, and date values. You’ll see how to create, copy, and update validation lists using tools like the UNIQUE function. You’ll also explore how to remove duplicates, add input messages and error alerts, modify alert styles, and quickly identify invalid data—giving you greater control over advanced Excel data workflows. 

Topics covered include: 

• Using a criteria range for advanced filtering 

• Using advanced filtering to filter a list in place using multiple criteria 

• Using advanced filtering to copy data to another location 

• Sorting by multiple columns at once using the dialog box 

• Sorting data by a custom list 

• Sorting data by colors and icons 

• Describing the purpose of data validation 

• Applying data validation to numbers, text, and date cells 

• Removing data validation  

• Removing duplicates from a range 

• Creating a data validation list 

• Using the UNIQUE function to generate list items 

• Adding error alerts to cells 

• Finding invalid data on a worksheet 

Enjoy award winning HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style! Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives and include captions and transcripts, downloadable handouts, and optional LinkedIn digital badges on course completion.