Begin with the basics, but learn quickly

Hello, Excel Creator MyCallIt's. In this class, you'll learn the basic functions of Excel in a systematic way. At the same time, I will proceed with a curriculum without any clutter centered on what is necessary for the job.

Edit Image Info

Work efficiently

There are small, but there are shortcuts to shortening work hours. You'll learn these methods first.

Edit Image Info

Useful features to help you work

By pressing F2, you can activate a cell so that you can type functions without a mouse. Knowing these small functions will help you a lot when working with Excel.

Edit Image Info

Building basic functions

Functions form the foundation of Excel. Therefore, an accurate understanding of how to use it is essential.

Edit Image Info

SUBTOTAL, IFERROR

We'll practice getting familiar with frequently used functions such as SUBTOTAL and IFERROR. It is a basic course for dealing with vast amounts of data.

Edit Image Info

Learn advanced functions

Once you've learned the basics, you'll learn advanced functions. This is the step of becoming a business Excel expert.

Edit Image Info

XLOOKUP, SUMIF

We'll cover new functions that can be used starting with Office365. You'll also learn essential functions for handling large amounts of data, such as SUMIF.

Edit Image Info

More comfortable and faster

After learning like this, you'll be able to handle all the data you can handle. Now I'm going to finish learning functions by learning extended functions and pivots.

Edit Image Info

Mixed graphs linked to data

There are many cases where multiple data are organized and reported in a graph. I'll try to link the figures with the graph so that they are automatically reflected.

Edit Image Info

Now it's time to practice

With what I've learned so far, I'm going to deal with data used in actual work. It will be a time to go through some trial and error and make it completely your own.

Use Excel as a tool to your heart's content

You have completed all courses. Use Excel as a tool without getting stuck:)

Some of the lessons in this course include content on Office 365 and above.

Begin with the basics, but learn quickly

Work efficiently

Useful features to help you work

Building basic functions

SUBTOTAL, IFERROR

Learn advanced functions

XLOOKUP, SUMIF

More comfortable and faster

Mixed graphs linked to data

Now it's time to practice

﻿Use Excel as a tool to your heart's content

Use Excel as a tool to your heart's content

From the basics of Excel to how to use it

From the basics of Excel to how to use it