Udemyallja

[Excel基礎]表データ操作の機能と関数で、表を効率的に整形・加工する|フィルター、並べ替え、重複削除、順位づけ

Master Excel 2021: Efficiently sort, filter, and clean data. Learn new functions & streamline your spreadsheet workflows. Boost your data skills!

127students
1h 25m
ピタッと カレッジ
ピタッと カレッジIT・デジタル技術

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 FILTER function.
  • Duplicate Removal: Effectively eliminate redundant data using the UNIQUE function and other methods.
  • Data Sorting: Learn to sort data using the SORT and SORTBY functions for precise organization.
  • Data Ranking: Understand and apply ranking functions like RANK.EQ, RANK.AVG, LARGE, and SMALL to 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 FILTER Function & Advanced Conditions
    • [Exercise] Filtering
  • Removing Duplicates:
    • Duplicate Removal Functionality
    • The UNIQUE Function
    • [Exercise] Removing Duplicates
  • Sorting:
    • Sorting Functionality
    • SORT and SORTBY Functions
    • [Exercise] Sorting
  • Ranking:
    • RANK.EQ and RANK.AVG Functions
    • LARGE and SMALL Functions
    • [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.
$ whoami — the devs behind tutorialsearch.io

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.