Microsoft Office Excel Lesson Topics List

Excel Basics:

Understanding The User Interface

Navigating The Workbooks

to Understanding The User Interface, click :

• Fungsi Menu Pada Microsoft Excel 1

• Fungsi Menu Pada Microsoft Excel 2

• Fungsi Menu Pada Microsoft Excel 3

• Microsoft Excel Terms 1

• Microsoft Excel Terms 2

• Microsoft Excel Terms 3

• Microsoft Excel GUI Parts

• Ribbon Yang Ada Di Microsoft Office Excel

Cell and Data Management:

Entering different types of data (text, numbers, dates).

Inserting And Deleting cells, rows, and columns.

Using Cut, Copy, and Paste functions.

Using the Fill Handle.

Formatting:

Adjusting column width and row height.

Applying font styles, borders, and cell shading.

Using Number Formats (currency, percentage, date).

Saving and Sharing:

Saving Workbooks

Printing Workbooks

Sharing Workbooks with others.

Introduction to Formulas - Formulas and Functions:

Understanding the formula syntax (starting with =).

Performing basic calculations (addition, subtraction, multiplication, division).

to learn Understanding the formula syntax (starting with =), click:

• Microsoft Excel Function Categories
• Some Of Microsoft Excel Function
• Contoh Rumus Excel 1

Cell References - Formulas and Functions:

Understanding Relative vs. Absolute cell references ($).

Using Mixed cell references.

Essential Functions - Formulas and Functions:

SUM(), AVERAGE(), COUNT(), COUNTA(), MAX(), MIN().

IF() statements for logical tests.

VLOOKUP() and HLOOKUP() for finding data.

to learn SUM(), AVERAGE(), COUNT(), COUNTA(), MAX(), MIN(), click Fungsi MIN Pada Excel

More Advanced Functions - Formulas and Functions:

INDEX() and MATCH() as a powerful alternative to VLOOKUP.

TEXT(), CONCATENATE(), and other text functions.

Date and Time functions.

Sorting and Filtering - Data Management and Analysis:

Sorting data by one or multiple columns.

Applying filters to show only specific data.

Creating Tables

Charts and Graphs:

Creating various chart types (bar, line, pie).

Customizing chart elements like titles, labels, and axes.

Conditional Formatting: Highlighting cells based on specific rules (e.g., values greater than 100).

PivotTables: Creating a PivotTable to summarize and analyze large datasets.

Advanced Topics

Data Validation: Setting rules for data entry in a cell to prevent errors.

What-If Analysis: Using tools like Goal Seek and Data Tables.

Macros and VBA:

Recording a macro to automate repetitive tasks.

Introduction to the Visual Basic for Applications (VBA) editor.