Explore professional courses at ASET Academy
Home›Courses›Microsoft Excel: Beginner to Advanced
ASET ACADEMY · PROFESSIONAL LEARNING

Microsoft Excel: Beginner to Advanced

Learn Excel from the basics to practical formulas, data cleaning, charts and PivotTables for study and office work.

12 lessonsApproximately 6–10 hours durationBeginner levelOnline learning mode
START HERE

About this course

Learn Excel from the basics to practical formulas, data cleaning, charts and PivotTables for study and office work.

Microsoft Excel: Beginner to Advanced is a practical, beginner-friendly ASET Academy course. Learners build foundational knowledge through guided lessons, examples, practice activities and a final task. The course is designed to support study, employability, workplace productivity and small business development.

STEP BY STEP LEARNING

Course curriculum

12 lessons in 4 learning sections

12 lessons
01Excel Foundations3 lessons⌄
▣Getting started with the Excel interfaceVideo / Lesson · 20 minEnroll to unlock
▣Entering and managing spreadsheet dataVideo / Lesson · 20 minEnroll to unlock
▣Formatting cells, rows, columns and tablesVideo / Lesson · 25 minEnroll to unlock
02Formulas and Functions3 lessons⌄
▣Basic arithmetic formulas and cell referencesVideo / Lesson · 20 minEnroll to unlock
▣SUM, AVERAGE, MIN, MAX and COUNTVideo / Lesson · 20 minEnroll to unlock
▣IF, COUNTIF and SUMIF for practical tasksVideo / Lesson · 25 minEnroll to unlock
03Data Management and Visualisation3 lessons⌄
▣Sorting, filtering and data validationVideo / Lesson · 20 minEnroll to unlock
▣Cleaning text and removing duplicatesVideo / Lesson · 20 minEnroll to unlock
▣Creating charts and conditional formattingVideo / Lesson · 25 minEnroll to unlock
04Analysis and Practical Project3 lessons⌄
▣Relative, absolute and mixed referencesVideo / Lesson · 20 minEnroll to unlock
▣Creating and analysing PivotTablesVideo / Lesson · 20 minEnroll to unlock
▣Practical office expense and sales reportVideo / Lesson · 25 minEnroll to unlock
YOUR LEARNING OUTCOMES

What you will learn

Navigate workbooks and worksheets confidently
Format and organise spreadsheet data
Use essential formulas and logical functions
Clean data and create charts and PivotTables

BEFORE YOU START

What you need

Basic computer operation

MEET YOUR INSTRUCTOR

Course instructor

admin

Questions & reviews

Examinations

Log in to access examinations.

Student reviews

No approved reviews yet.

Only enrolled students can review this course.

Share Course:FacebookWhatsAppLinkedInEmail