Advanced Sort And Filter: Intermediate Excel

Take your Excel skills to the next level with this Excel Intermediate course.

What you'll learn

Utilize custom lists for specialized data sorting.

Implement advanced sorting techniques using SORT and SORTBY functions.

Learn to filter data effectively using Advanced Filter and FILTER function.

Sort data using multiple columns efficiently.

Requirements

Familiarity with basic Excel functions like selecting cells, entering data, and using simple formulas.

Basic sorting experience.

Familiarity with Excel's Ribbon.

Microsoft Excel (preferably Excel 2021 or later) installed.

Description

**This course includes downloadable course instructor and exercise files to work with and follow along.**Welcome to Microsoft Excel Intermediate. In this course, you will learn sorting and filtering data to enhance your data analysis skills. This training will teach you how to sort data by more than one column and create custom orders for specific needs. You'll also explore powerful new functions, like the SORT and SORTBY functions, that make sorting faster and more flexible. Mastering these sorting techniques will save you time and improve your ability to interpret data.Each lesson includes video tutorials and downloadable exercises, ensuring hands-on practice for comprehensive learning.Whether you're a beginner or an experienced Excel user, this course will equip you with the skills to create high-quality spreadsheets that meet the needs of your audience. Join us and elevate your Excel proficiency today.In this course, you will learn how to:Utilize custom lists for specialized data sorting.Implement advanced sorting techniques using SORT and SORTBY functions.Learn to filter data effectively using the Advanced Filter and FILTER functions.Use VLOOKUP to find exact matches in data.This course includes:57 minutes of video tutorials9 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion

Overview

Section 1: Advanced Sort and Filter

Lecture 1 Course Introduction

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Course Files

Lecture 4 DOWNLOAD ME: Exercise Files

Lecture 5 Performing Sorts on Multiple Columns

Lecture 6 Sorting Using a Custom List

Lecture 7 The SORT and SORTBY Functions

Lecture 8 Using the Advanced Filter

Lecture 9 Extracting Unique Values - The UNIQUE Function

Lecture 10 The FILTER Function

Lecture 11 Exercise

Lecture 12 Course Close

Students and learners who want to understand how to sort and filter data in Excel to make sense of large datasets.,Business professionals who need to analyze sales, customer, or financial data and organize it in a way that helps them make informed decisions.,Data analysts who want to enhance their ability to use Excel’s sorting and filtering tools for more complex data analysis tasks.,Anyone looking to improve Excel skills to be more productive in organizing and interpreting data, especially when dealing with large amounts of information.