Sorting And Filtering Lists In Excel For Beginners

Sorting And Filtering Lists In Excel For Beginners - Printable Version

+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: Sorting And Filtering Lists In Excel For Beginners (/Thread-Sorting-And-Filtering-Lists-In-Excel-For-Beginners)

Sorting And Filtering Lists In Excel For Beginners - AD-TEAM - 03-17-2025

[Image: 0814d85121ca4e2fe210a39d9eb04ac9.jpg]

Sorting And Filtering Lists In Excel For Beginners
Published 3/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 684.07 MB | Duration: 0h 58m

A beginner's guide to Excel spreadsheets, formulas, and fundamental data analysis.

What you'll learn

Organize data effectively by structuring lists with appropriate headings and formatting.

Apply single-level sorting to arrange data in ascending or descending order.

Demonstrate proficiency in sorting data across multiple levels.

Use custom sorting and custom lists to tailor sorting options in Excel.

Requirements

Microsoft Excel 2021 installed - You need Excel 2021 to follow along with the course.

Basic computer skills - Familiarity with using a computer and managing files.

No prior Excel experience required - This course is beginner-friendly.

Access to the internet - For downloading materials and accessing resources.

Willingness to practice - Practicing the techniques will reinforce your learning.

Description

**This course includes downloadable course instructor files and exercise files to work with and follow along.**Welcome to the Microsoft Excel Beginner course. This short course is designed to teach you how to effectively use lists in Excel. This course demonstrates how to structure data sets for maximum efficiency and introduces sorting techniques to streamline analysis. From understanding different data layouts, like Flat Files and Tabular Format, to mastering sorting tools.Each lesson includes video tutorials and downloadable exercises, ensuring hands-on practice for comprehensive learning.Whether you are taking your first steps into spreadsheet management or seeking to solidify your beginner-level skills, this course will equip you with the skills to create high-quality spreadsheets that meet the needs of your audience. Join us, continue your learning journey, and elevate your Excel proficiency today.In this course, you will learn how to:Organize data effectively by structuring lists with appropriate headings and formatting.Apply single-level sorting to arrange data in ascending or descending order.Demonstrate proficiency in sorting data across multiple levels.Use custom sorting and custom lists to tailor sorting options in Excel.This course includes:57 minutes of video tutorials10 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion

Overview

Section 1: Using Lists

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 How to Structure a List

Lecture 6 Sorting a List (Single-Level Sort)

Lecture 7 Sorting a List (Multi-Level Sort)

Lecture 8 Sorting Using a Custom List (Custom Sort)

Lecture 9 Using Autofilter to Filter a List

Lecture 10 Format as a Table

Lecture 11 Creating Subtotals in a List

Lecture 12 Exercise

Lecture 13 Course Close

Students seeking to build essential Excel skills for coursework or entry-level job opportunities.,Individuals who need to organize data, manage lists, and streamline workflows efficiently in their daily tasks.,Professionals looking to manage business records, customer lists, or inventory effectively using Excel.,Those working on projects requiring data management and analysis in Excel, such as virtual assistants or data entry professionals.,Anyone new to Excel.

[Image: t8dRvNts_o.jpg]