Udemybeginnerja

Excelの使い方【2024年版】初心者にわかりやすいエクセルの使い方を完全解説。基礎から表・テーブル作成

Learn Excel basics fast! Master essential Excel skills in just one day with easy-to-follow video tutorials. Perfect for office work & beginners.

4.5(17)
104students
1h 34m
Certificate
よこやま 良平
よこやま 良平Wordpress・システム開発・WEBマーケティング・SEO・Ruby・PHP・Bootstrap・Heroku

Course Content

Excelの使い方【2024年版】初心者にわかりやすいエクセルの使い方を完全解説。基礎から表・テーブル作成 is a beginner-level Udemy course taught by よこやま 良平. It runs 1h 34m, is taught in Japanese, and includes a certificate of completion. Learners rate it 4.5 out of 5 from 17 reviews, with 104 students enrolled. It is a paid course, last updated December 2024.

Are you struggling with Excel? Do you find yourself asking "I just bought a Windows computer – where do I start?" or wanting to understand Excel better? Do you need to create reports, charts, and graphs for printing? Perhaps you're looking to create professional-looking invoices or need help with basic calculations? Or maybe you want to enhance your spreadsheets with shapes and images?

If you answered yes to any of these questions, you've come to the right place! This course is designed as the ultimate Excel guide for beginners. Our single, clear goal is to solve your Excel problems.

Many Excel resources – books and online courses – cover similar ground. However, we focus on what truly matters to beginners: how to independently resolve your Excel challenges and how to learn practical Excel skills you can use in a real-world setting.

This course takes a hands-on approach, building a strong foundation in Excel while actively applying your knowledge. We're confident that by completing this course, you'll gain the skills to confidently tackle your Excel challenges.

Who is this course for?

Meet your instructor: I'm Yokoyama, an IT engineer with over 15 years of programming experience. I'm a company representative, but I also actively teach computer and programming courses to over 1140 students aged 4 to 85. I also author programming resources and WordPress books, and have developed over 3000 apps and services. I'll explain everything in a way that's easy to understand, drawing on my extensive experience.

Course Outline: Your Path to Excel Mastery

This course is structured to guide you from beginner to confident Excel user. Here’s a breakdown of what you’ll learn:

Step 1: Excel Fundamentals

  • Getting Started: Learn how to launch Excel and navigate the interface (cells, tabs, worksheets).
  • Basic Data Entry: Master text input, deletion, copying, and pasting.
  • Formatting Text: Control font size, color, alignment, and apply bold, italic, and underline.
  • Working with Rows & Columns: Insert, delete, copy, and resize rows and columns.
  • Undo & Zoom: Utilize the undo function and adjust the screen zoom for optimal viewing.

Step 2: Building Effective Tables

  • Creating Tables: Enter headers, customize colors, and freeze the first row.
  • Essential Formulas: Use basic functions like SUM, AVERAGE, MAX, MIN, and COUNT for automatic calculations.
  • Table Design: Apply borders to create visually appealing tables.
  • Autofill: Leverage the autofill feature for efficient data entry.
  • Worksheet Management: Create new worksheets and rename existing ones.

Step 3: Advanced Excel Techniques

  • Working with Tables: Utilize functions within tables, modify table styles, and sort/filter data.
  • Filtering Data: Master the use of filters to extract specific data.
  • Creating Charts: Generate compelling bar charts and line graphs.
  • Chart Customization: Add titles, images, shapes, and SmartArt to enhance your charts.
  • Printing & Saving: Configure print settings and page layouts, and learn how to save and reopen your Excel files.

This is a general roadmap. The order may shift slightly, and we may add additional topics to ensure you gain comprehensive Excel skills. Let's learn together!

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