Udemybeginnerja

[Excel入門]初心者のための関数入門〜基本関数と集計・計算を中心に〜

Learn essential functions in just 1.5 hours! Perfect for beginners building a foundation or refreshing your skills in math functions, calculations & data analysis.

4.3(13)
197students
1h 25m
ピタッと カレッジ
ピタッと カレッジIT・デジタル技術

Course Content

[Excel入門]初心者のための関数入門〜基本関数と集計・計算を中心に〜 is a beginner-level Udemy course taught by ピタッと カレッジ. It runs 1h 25m and is taught in Japanese. Learners rate it 4.3 out of 5 from 13 reviews, with 197 students enrolled. It is free to enroll, last updated December 2024.

Learn Excel Functions in 1.5 Hours: Master the Essentials!

This course focuses specifically on Excel functions, giving you a fast track to proficiency. Developed by an expert with over 10 years of experience teaching and working with Excel, you'll gain a solid understanding of fundamental functions in just 1.5 hours. Downloadable exercise data and hands-on exercises allow you to practice and build practical skills.

What You'll Learn:

  • Core Statistical Functions: Quickly grasp the power of key functions for data analysis.
    • SUM, AVERAGE, MAX, MIN: Learn how to easily calculate totals, averages, maximums, and minimums in your spreadsheets.
  • Counting Functions: Efficiently count cells and data.
    • COUNTA & COUNTBLANK: Discover how to count non-empty and empty cells, respectively.
    • COUNT: Understand the basics of counting cells.
  • Mathematical Functions: Perform essential mathematical operations.
    • QUOTIENT & MOD: Learn to calculate quotients and remainders.
    • ROUND, ROUNDUP, ROUNDDOWN: Master rounding numbers to different levels of precision.
    • MROUND, CEILING.MATH, FLOOR.MATH: Control number rounding with specific intervals.
  • Advanced Function Techniques: Take your Excel skills to the next level.
    • Nested Functions (Function Nesting): Learn to combine functions for complex calculations.
    • Absolute Referencing: Understand and utilize absolute cell references for accurate formulas.

Course Structure & Important Notes:

The course progresses logically, starting with basic functions and building towards more advanced techniques. Each section includes practical exercises to reinforce your learning.

  • Note: While the instructor demonstrates each step, not all text on the screen will be read aloud. Please pause as needed.
  • Compatibility: This course content is based on Microsoft Excel 365 as of November 2023 and has been tested on Windows 11 and Microsoft 365 Excel.
  • macOS Users: This course is designed for Windows users. Please adjust your workflow accordingly if you are using macOS.
$ 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.