Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Advanced Sort and Filter: Intermediate Excel
Rating: 4.5 out of 5(1 rating)
3 students

Advanced Sort and Filter: Intermediate Excel

Take your Excel skills to the next level with this Excel Intermediate course.
Created bySimon Sez IT
Last updated 11/2024
English

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.

Course content

1 section • 12 lectures • 58m total length

  • Course Introduction5:28
  • WATCH ME: Essential Information for a Successful Training Experience2:11
  • DOWNLOAD ME: Course Files0:23
  • DOWNLOAD ME: Exercise Files0:23
  • Performing Sorts on Multiple Columns7:04
  • Sorting Using a Custom List3:37
  • The SORT and SORTBY Functions10:02
  • Using the Advanced Filter6:53
  • Extracting Unique Values - The UNIQUE Function5:19
  • The FILTER Function9:31
  • Exercise5:43
  • Course Close1:31
  • Course Quiz

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:

  1. 57 minutes of video tutorials

  2. 9 individual video lectures

  3. Course and Exercise Files to follow along

  4. Certificate of completion

Who this course is for:

  • 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.

Report abuse