Excel 365 in 30 Minutes – Manage Data (Intermediate 1 of 8)

In this Bigger Brains course, you’ll learn how to streamline your workflow by using Excel 365’s most helpful data management tools. You’ll see how Flash Fill can instantly recognize patterns and auto-populate values, and you’ll explore how to split information into multiple columns using Text to Columns. management tools. 

You’ll learn how to use essential commands for navigating large datasets and updating information efficiently. You’ll also learn practical techniques for sorting your lists by multiple columns and applying filters so you can focus on the information that matters most. Designed for users who already understand the basics of Excel, this course helps you take the next step in managing data more effectively. 

Topics covered include: 

• Using Flash Fill to auto-populate data 

• Splitting text into multiple cells using the Text to Columns feature 

• Using the Find and Find All commands to locate specific data or values in cells. 

• Using Replace and Replace All commands to locate and replace data in cells. 

• Replacing formats 

• Using the Go To and Go To Special commands to select specific cells. 

• Sorting a list by multiple columns 

• Describing the effect of filtering on a list 

Enjoy award winning HD content in the “Uniquely Engaging”™ 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.