Excel 365 in 30 Minutes – Working with Data (Basics 2 of 10)

In this Bigger Brains course, you’ll see how Excel handles different data types. You’ll learn how to enter, edit, and manage information efficiently in your worksheets. You’ll also learn how to cut, copy, paste, and clear data, how to use Undo and Redo to correct mistakes quickly, and how to use AutoFill to populate series and speed up repetitive tasks.  

For organizing information, you’ll see how to sort data using both the Ribbon and the rightclick menu, how to follow key sorting guidelines, and how filtering affects what you can view in a list. You’ll learn how to turn on AutoFilter, filter one or more columns, and clear filters when you’re ready to view everything again. Designed for users who are comfortable with basic tasks, this course helps you take the next step toward working more efficiently and effectively with your Excel data.

Topics covered include: 

• Describing how Excel handles different data types. 

• Cutting, copying, and pasting data in a cell. 

• Using the Undo and Redo commands. 

• Clearing data from a cell. 

• Using AutoFill to populate series 

• Sorting a list using the Ribbon 

• Sorting a list using the right-click menu 

• Listing guidelines for sorting 

• Describing the effect of filtering on a list 

• Turning on AutoFilter 

• Filtering one or more columns using AutoFilter 

• Clearing one or all filters 

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.