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.

Work efficiently

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

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.

Building basic functions

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

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.

Learn advanced functions

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

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.

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.

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.

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.