The Bigger Brains course, Excel 365 in 30 Minutes – Data Manipulation & Validation (Advanced 5 of 11), is designed to turn chaotic data into a well-oiled machine. You’ll start by learning how to use criteria ranges for advanced filtering, letting you zero in on exactly the data you need without sifting through irrelevant rows. You’ll also learn to filter a list in place using multiple criteria. Whether you’re copying filtered data to another location or sorting it directly in your worksheet, these techniques will save you time and reduce errors. When it comes to sorting, you’ll learn how to sort by multiple columns at once using the dialog box, organize data by custom lists, or even sort by colors and icons for a visual edge.
This course dives deep into data validation, explaining its purpose and teaching you how to apply rules to numeric, text, and date cells so that only the correct information is entered. You’ll learn how to create validation lists that guide users toward the right choices, preventing mistakes before they happen. You’ll learn to remove duplicates from a range and use the UNIQUE function to generate clean lists when you need fresh, unique data. You’ll also discover how to add error alerts to cells, so users get clear feedback when something doesn’t meet the rules.
Watch the course sample below!
In this course you’ll learn how to find invalid data on a worksheet and fix it quickly. Need to remove validation rules entirely? This course will teach you to handle that effortlessly. By the end of this course, you’ll be working faster whether you’re managing budgets, tracking inventory, or organizing customer records.
