[Excel基礎]表データ操作の機能と関数で、表を効率的に整形・加工する|フィルター、並べ替え、重複削除、順位づけ
Master Excel 2021: Efficiently sort, filter, and clean data. Learn new functions & streamline your spreadsheet workflows. Boost your data skills!
Course Content
[Excel基礎]表データ操作の機能と関数で、表を効率的に整形・加工する|フィルター、並べ替え、重複削除、順位づけ is an all-levels Udemy course taught by ピタッと カレッジ. It runs 1h 25m and is taught in Japanese. 127 students have enrolled. It is free to enroll, last updated April 2025.
Master Excel Data Manipulation: Filtering, Sorting & Advanced Functions
Unlock the power of Excel with this comprehensive course focused on efficient data manipulation techniques. Learn to expertly filter, remove duplicates, sort, and rank your data for insightful analysis. This course is designed for Excel 2021 and 365 users, covering the latest features including spill ranges for powerful table operations.
Key Skills You'll Gain:
- Data Filtering: Master various filtering techniques to isolate specific data subsets. Learn to use the built-in filter functionality and the versatile
FILTERfunction. - Duplicate Removal: Effectively eliminate redundant data using the
UNIQUEfunction and other methods. - Data Sorting: Learn to sort data using the
SORTandSORTBYfunctions for precise organization. - Data Ranking: Understand and apply ranking functions like
RANK.EQ,RANK.AVG,LARGE, andSMALLto determine data position. - Table Manipulation: Explore advanced table operations using spill ranges, enabling powerful data transformations.
Course Features:
- Expert Instruction: Benefit from over 10 years of experience in data utilization, delivered by an instructor known for clear, practical explanations.
- Hands-on Learning: Downloadable exercise data allows you to practice alongside the instructor's demonstrations.
- Up-to-Date Content: The course is based on Microsoft Excel 365 information as of November 2024 and has been tested on Windows 11.
- Practical Application: Focus on real-world scenarios to immediately apply your new skills.
Course Outline:
- Data Manipulation Fundamentals: An overview of common table operations.
- Filtering:
- Filter Functionality
- Filter Options & Conditional Filtering
- The
FILTERFunction & Advanced Conditions - [Exercise] Filtering
- Removing Duplicates:
- Duplicate Removal Functionality
- The
UNIQUEFunction - [Exercise] Removing Duplicates
- Sorting:
- Sorting Functionality
SORTandSORTBYFunctions- [Exercise] Sorting
- Ranking:
RANK.EQandRANK.AVGFunctionsLARGEandSMALLFunctions- [Reference] Utilizing 0-100% Position
- [Exercise] Ranking
- Additional Table Operations:
- Concatenating Tables
- Swapping Rows and Columns
- Extracting Numbers
Important Notes:
- This course is optimized for Windows users. macOS users may need to adapt instructions.
- The instructor will not read all on-screen text; pause as needed.
- Content is based on Microsoft Excel 365 as of November 2024 and has been tested on Windows 11.
Need a web app built? Hire the team behind TutorialSearch.io
We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.