In this online course, you will learn Microsoft Excel from the zero level to the expert level, in the shortest time possible, through an easy learning process. I designed the curriculum very carefully to maximize its effectiveness. After learning from this course, in sha Allah, you will have real and applicable competencies that can be utilized to skyrocket your business or your career.
About the author
Hi, my name is Widhi Muttaqien. I am an entrepreneur, who also an academic lecturer in the information system and computer graphics fields. By the time I record this video, I have more than 50,000 students globally around the world. In terms of formal education, I have a bachelor degree in IT with a concentration in software development. I also have a master degree in business management as well as information systems. For more than 20 years, I have been using Microsoft Excel for a variety of needs, be it for business or for academic purposes. I used Excel for bookkeeping or finance, student data management, academic research, project management, data analysis, and so on.
What you will learn
There are tons of things that you will learn in this online course. It would be too long to explain all of them in this short description text. To see the details, you can check the curriculum section of this course. I will only explain some of them briefly here. In the first chapter, you will get to know the basics of Microsoft Excel, such as how to work with files, exploring the user interface, how to navigate, and so on. Then you will learn the basics of working with data in Excel, such as using AutoFill, using formulas, understanding different types of copy-and-paste, learn to use various types of cell references, from the simplest to the complex ones, and so on. Next, you will learn the ins and outs of data presentation in Excel. From formatting basic texts, numbers, cells, borders, effects, styles, and so on. Then learn various techniques for structuring the table. In the next section, you will learn about various things related to graphics. Such as inserting and managing image files, creating shape and text box objects, creating Smart Art, creating Charts, and also Sparklines. In the next chapter, we will discuss advanced data processing techniques. We will discuss things like notes, comments, find and replace techniques, data sorting, filters, Freeze Pane, and so on. Then after that, we will discuss in detail everything related to tables, pivot tables, and how to combine the two features. We'll also cover a variety of "conditional formatting" features from the basic examples to more complex ones. And in the final chapter, we will cover different techniques related to printing and exporting, such as defining print areas, managing headers and footers, data protection, exporting to PDF or XPS, etc.
So, join this course now! And become the master of Excel.

Introduction

Conventions and information

Working with Excel files

Ribbon Menu and Quick Access Toolbar

UI theme, Background, and Options

The basics of inputting data

Data types

Contextual menus

Data structure

Navigation

Editing data and AutoFill

Creating custom AutoFill

Undo, Redo, Save, and Save As

The basics of Formula

Introduction to Function, SUM, and AVERAGE

XLOOKUP function

Cut, Copy, and Paste

Cell reference range

Relative vs Absolute cell references

Mixed reference and the ROUND function

External Worksheet reference

External Workbook Reference

Named reference

Formatting basics in Excel

Number formatting and Format Painter

Custom formatting

Basic date formatting

Advanced date formatting

Text formatting

Text color

Fill color

Border line settings

Border styles and colors

Column and row sizes

Text position and orientation

Cell Styles

Organizing table structure

Hiding columns and rows

Merging and splitting cells

Inserting images

Insert versus Link

Transformation and Snapping

Managing visual objects

Transparency and Cropping

Shape objects basics

Lock Drawing, Modifiers, and Alignment

Editing Shapes

Text box

Effects and Styles

Grouping

SmartArt in Excel

Creating Charts in Excel

Managing Charts objects and data

Chart design customization

Sparkline

Paste types

Notes and Comments

Find

Replace

Sorting data

Filters

Freeze panes

Excel Table basics

Advanced Excel Table

PivotTable basics

PivotTable Field, Filter, and Slicer

PivotTable Design

Connecting Excel Table to PivotTable

Conditional formatting basics

Conditional custom formatting

Advanced conditional rules

Rule stacking

Conditional formatting with graphics

Active cell in Excel

Conditional formatting with formulas

Basic printing techniques

Selective printing

Adding a Header or Footer

Header or Footer content and size

Managing Headers and Footers

Scale to fit

Sheet options

Locking data in Excel

Protecting Excel files

Print to PDF and XPS

Exporting with Insert Object

Exporting with Copy and Paste

Section 2 Exercise files and Curriculum

Online references

Understanding the syntax

Tips on navigation and selection

Flash Fill

Extend Format and Formula

Adding symbols using special fonts

Emoji and symbol shortcut

UNICHAR function

Splitting formula into multiple lines

Using helper columns or cells

Avoiding volatile functions

Working with Tables

Microsoft Excel from Basic to Advanced

Widhi Muttaqien gave you 1 free month of Skillshare

Get 1 free month of Skillshare

Microsoft Excel from Basic to Advanced

Creative Learning Made Easy

Company

Work With Us

Teach with Us

Shop

Mobile

English

English