Microsoft Excel Pelajaran Summary


Excel is the most powerful tool to manage and analyze various types of Data. This Microsoft Excel kursus for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process. This Excel for beginners course will help you learn Excel basics.

What should I know?


Nothing! This Free Excel training course assumes you are a beginner to Excel.

Microsoft Excel Syllabus

Introduction

👉

Lesson 1
Introduction to Microsoft Excel 101

— Bloknot About MS Excel
👉

Lesson 2
Excel Basic Formulas

— Add, Subtract, Multiply & Divide in Excel
👉

Lesson 3
Excel Data Validation

— Filters & Grouping in Excel
👉

Lesson 4
Excel Formulas & Functions

— Learn with Basic Examples
👉

Lesson 5
Logical Functions in Excel

— IF, AND, OR, Nested IF & Titinada
👉

Lesson 6
How to Create Charts in Excel

— Types & Examples
👉

Lesson 7
How to make Budget in Excel

— Personal Finance Les

Advance Stuff

👉

Lesson 1
How to Import XML Data into Excel

— Learn with Example
👉

Lesson 2
How to Import CSV Data into Excel

— Learn with Example
👉

Lesson 3
How to Import SQL Database Data into Excel

— Learn with Example
👉

Lesson 4
How to Create Pivot Table in Excel

— Beginners Pelajaran
👉

Lesson 5
Advanced Excel Charts & Graphs

— Learn with Template
👉

Lesson 6
Microsoft Office 365 Cloud

— Benefits of MS Excel Cloud
👉

Lesson 7
CSV vs Excel

— What is the Difference?
👉

Lesson 8
Excel VLOOKUP Tutorial for Beginners

— Learn with Examples
👉

Lesson 9
Excel ISBLANK Function

— Learn with Example
👉

Lesson 10
Sparklines in Excel

— What is, How to Use, Types & Examples
👉

Lesson 11
SUMIF function in Excel

— Learn with EXAMPLE
👉

Lesson 12
Microsoft Excel Interview Questions

— Top 40 MS Excel Interview Q & A
👉

Lesson 13
Top Excel Formulas

— Top 10 Excel Formulas Asked in an Interview
👉

Lesson 14
Best Excel Course

— 15 Best Excel Course & Classes Online
👉

Lesson 15
BEST Excel Alternatives

— 20 BEST Free Excel Alternatives Software
👉

Lesson 16
BEST Excel Books

— 15 BEST Excel Books
👉

Lesson 17
Best Microsoft Courses

— 13 Best Free Microsoft Courses & Certification
👉

Lesson 18
Excel Tutorial PDF

— Download Excel Tuntunan for Beginners PDF

Macros & VBA in Excel

👉

Lesson 1
Macro Cak bimbingan

— How to Write Macros in Excel
👉

Lesson 2
VBA in Excel

— What is Visual Basic for Applications, How to Use
👉

Lesson 3
VBA Variables

— Data Types & Constants in VBA
👉

Lesson 4
Excel VBA Arrays

— What is, How to Use & Types of Arrays
👉

Lesson 5
VBA Controls

— VBA Form Control & ActiveX Controls in Excel
👉

Lesson 6
VBA Arithmetic Operators

— Multiplication, Division & Addition
👉

Lesson 7
VBA String Operators

— VBA String Manipulation Functions
👉

Lesson 8
VBA Comparison Operators

— Not equal, Less than or Equal to
👉

Lesson 9
VBA Logical Operators

— AND, OR, Not, IF Titinada in Excel
👉

Lesson 10
Excel VBA Subroutine

— How to Call Sub in VBA with Example
👉

Lesson 11
Excel VBA Function Cak bimbingan

— Return, Call, Examples
👉

Lesson 12
Excel VBA Range Object

— Range Property in VBA