(0.00 Reviews)

All In One Excel Masterclass

  • user By Mohammad Saleh Rabbi
  • Globe Excel
  • Calendar Last updated 30/Sep/2025

Course Description

 

From Beginner to Pro — Master Excel for Work, Business & Career

 

🔍 āϕ⧋āĻ°ā§āϏ āϏāĻŽā§āĻĒāĻ°ā§āϕ⧇

 

āφāϜāϕ⧇āϰ āϝ⧁āϗ⧇ Excel āĻļ⧁āϧ⧁ āĻāĻ•āϟāĻž āϏāĻĢāϟāĻ“ā§Ÿā§āϝāĻžāϰ āύ⧟ — āĻāϟāĻž āĻāĻ•āϟāĻŋ āĻ¸ā§āĻ•āĻŋāϞ!

āĻāχ āϕ⧋āĻ°ā§āϏāϟāĻŋ āĻāĻŽāύāĻ­āĻžāĻŦ⧇ āϤ⧈āϰāĻŋ āĻ•āϰāĻž āĻšā§Ÿā§‡āϛ⧇ āϝāĻžāϤ⧇ āĻāĻ•āĻĻāĻŽ āĻļ⧁āϰ⧁ āĻĨ⧇āϕ⧇ āφāĻĒāύāĻŋ āϧāĻžāĻĒ⧇ āϧāĻžāĻĒ⧇ Excel-āĻāϰ āĻĒā§āϰāϤāĻŋāϟāĻŋ āϗ⧁āϰ⧁āĻ¤ā§āĻŦāĻĒā§‚āĻ°ā§āĻŖ āĻŦāĻŋāώ⧟ āĻļāĻŋāĻ–āϤ⧇ āĻĒāĻžāϰ⧇āύ — āĻāϕ⧇āĻŦāĻžāϰ⧇ Basic āĻĨ⧇āϕ⧇ Advanced Level āĻĒāĻ°ā§āϝāĻ¨ā§āϤāĨ¤

 

āφāĻĒāύāĻŋ āϚāĻžāĻ•āϰāĻŋ āĻ•āϰ⧁āύ, āĻŦā§āϝāĻŦāϏāĻž āĻ•āϰ⧁āύ āĻŦāĻž āĻĢā§āϰāĻŋāĻ˛ā§āϝāĻžāĻ¨ā§āϏāĻžāϰ āĻšā§‹āύ — Excel āφāĻĒāύāĻžāϰ āĻ•āĻžāĻœā§‡āϰ āĻ—āϤāĻŋ, āĻĻāĻ•ā§āώāϤāĻž āĻāĻŦāĻ‚ āĻĒā§āϰāĻĢ⧇āĻļāύāĻžāϞ āĻ­ā§āϝāĻžāϞ⧁ āĻ•ā§Ÿā§‡āĻ•āϗ⧁āĻŖ āĻŦāĻžā§œāĻŋā§Ÿā§‡ āĻĻ⧇āĻŦ⧇āĨ¤

 

🚀 āϕ⧋āĻ°ā§āϏ⧇ āϝāĻž āϝāĻž āĻļāĻŋāĻ–āĻŦ⧇āύ

 

✅ Excel Basic to Advanced Concepts

āϏ⧇āϞ, āϰ⧋, āĻ•āϞāĻžāĻŽ, āĻĢāĻ°ā§āĻŽā§āϞāĻž, āĻĢāĻžāĻ‚āĻļāύ, āĻĄā§‡āϟāĻž āϟāĻžāχāĻĒ, āĻāĻŦāĻ‚ āĻĢāϰāĻŽā§āϝāĻžāϟāĻŋāĻ‚—āϏāĻŦ āĻ•āĻŋāϛ⧁ āϏāĻšāϜāĻ­āĻžāĻŦ⧇ āĻļāĻŋāĻ–āĻŦ⧇āύāĨ¤

 

✅ Data Analysis & Visualization

āϚāĻžāĻ°ā§āϟ, āĻ—ā§āϰāĻžāĻĢ, āĻĄā§āϝāĻžāĻļāĻŦā§‹āĻ°ā§āĻĄ āϤ⧈āϰāĻŋ, āĻ•āĻ¨ā§āĻĄāĻŋāĻļāύāĻžāϞ āĻĢāϰāĻŽā§āϝāĻžāϟāĻŋāĻ‚, āĻāĻŦāĻ‚ āĻĄā§‡āϟāĻž āχāύāϏāĻžāχāϟ āĻŦ⧇āϰ āĻ•āϰāĻžāϰ āĻŸā§‡āĻ•āύāĻŋāĻ•āĨ¤

 

✅ Powerful Excel Functions

SUMIF, COUNTIF, VLOOKUP, HLOOKUP, INDEX-MATCH, IFERROR, TEXT, DATE, LOGICAL, āĻāĻŦāĻ‚ āφāϰāĻ“ āĻ…āύ⧇āĻ• āϗ⧁āϰ⧁āĻ¤ā§āĻŦāĻĒā§‚āĻ°ā§āĻŖ āĻĢāĻžāĻ‚āĻļāύāĨ¤

 

✅ Pivot Table & Power Query Mastery

āĻŦ⧜ āĻĄā§‡āϟāĻž āĻŦāĻŋāĻļā§āϞ⧇āώāϪ⧇āϰ āϜāĻ¨ā§āϝ Pivot Table āĻ“ Power Query āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻ•āϰ⧇ āĻ•āĻžāϜāϕ⧇ āĻ•ā§Ÿā§‡āĻ• āĻŽāĻŋāύāĻŋāĻŸā§‡ āĻļ⧇āώ āĻ•āϰāĻž āĻļāĻŋāĻ–āĻŦ⧇āύāĨ¤

 

✅ Automation with Excel Shortcuts & Productivity Hacks

āĻĻā§āϰ⧁āϤ āĻ•āĻžāϜ āĻ•āϰāĻžāϰ āϜāĻ¨ā§āϝ āĻĻāϰāĻ•āĻžāϰāĻŋ āĻļāĻ°ā§āϟāĻ•āĻžāϟ āĻ“ āĻ…āĻŸā§‹āĻŽā§‡āĻļāύ āϟāĻŋāĻĒāϏāĨ¤

 

✅ Data Cleaning & Reporting Skills

āϰāĻŋāĻĒā§‹āĻ°ā§āϟ āϤ⧈āϰāĻŋ, āĻĄā§‡āϟāĻž āϏāĻžāϜāĻžāύ⧋, āĻĢāĻŋāĻ˛ā§āϟāĻžāϰāĻŋāĻ‚, āĻāĻŦāĻ‚ āĻĒā§āϰāĻĢ⧇āĻļāύāĻžāϞ āĻĒā§āϰ⧇āĻœā§‡āĻ¨ā§āĻŸā§‡āĻļāύ āϤ⧈āϰāĻŋ āĻ•āϰāĻž āĻļāĻŋāĻ–āĻŦ⧇āύāĨ¤

 

✅ Business & Job-Oriented Projects

āĻĒā§āĻ°ā§āϝāĻžāĻ•āϟāĻŋāĻ•ā§āϝāĻžāϞ āĻĒā§āϰāĻœā§‡āĻ•ā§āĻŸā§‡āϰ āĻŽāĻžāĻ§ā§āϝāĻŽā§‡ āϰāĻŋā§Ÿā§‡āϞ āϞāĻžāχāĻĢ āĻĄā§‡āϟāĻž āύāĻŋā§Ÿā§‡ āĻ•āĻžāϜ āĻ•āϰāĻŦ⧇āύ—āϝ⧇āĻŽāύ:

 

  • āϏ⧇āϞāϏ āϰāĻŋāĻĒā§‹āĻ°ā§āϟ

  • āĻāĻ•ā§āϏāĻĒ⧇āĻ¨ā§āϏ āĻŸā§āĻ°ā§āϝāĻžāĻ•āĻžāϰ

  • HR Attendance Sheet

  • Business Dashboard

  • Data Analytics Report

 

đŸŽ¯ āĻāχ āϕ⧋āĻ°ā§āϏāϟāĻŋ āĻ•āĻžāĻĻ⧇āϰ āϜāĻ¨ā§āϝ

 

👩‍đŸ’ģ āϚāĻžāĻ•āϰāĻŋāĻĒā§āϰāĻžāĻ°ā§āĻĨā§€ āĻ“ āĻ…āĻĢāĻŋāϏ āĻĒā§āϰāĻĢ⧇āĻļāύāĻžāϞ

📈 āĻŦāĻŋāϜāύ⧇āϏ āĻŽāĻžāϞāĻŋāĻ• āĻ“ āωāĻĻā§āϝ⧋āĻ•ā§āϤāĻž

🧾 āĻĢā§āϰāĻŋāĻ˛ā§āϝāĻžāĻ¨ā§āϏāĻžāϰ āĻ“ āĻĄā§‡āϟāĻž āĻ…ā§āϝāĻžāύāĻžāϞāĻŋāĻ¸ā§āϟ

🎓 āĻ›āĻžāĻ¤ā§āϰāĻ›āĻžāĻ¤ā§āϰ⧀ āϝāĻžāϰāĻž āĻ•ā§āϝāĻžāϰāĻŋ⧟āĻžāϰ⧇ āĻ¸ā§āĻ•āĻŋāϞ āϝ⧋āĻ— āĻ•āϰāϤ⧇ āϚāĻžāύ

 

📘 āϕ⧋āĻ°ā§āϏ āĻĢāĻŋāϚāĻžāϰāϏ

  • āĻŦāĻžāĻ‚āϞāĻž āĻ­āĻžāώāĻžā§Ÿ āĻŦāĻŋāĻ¸ā§āϤāĻžāϰāĻŋāϤ āĻŦā§āϝāĻžāĻ–ā§āϝāĻž

  • āϞāĻžāχāĻ­ āĻĄā§‡āϟāĻž āĻĒā§āĻ°ā§āϝāĻžāĻ•āϟāĻŋāϏ āĻĢāĻžāχāϞ

  • āϰāĻŋā§Ÿā§‡āϞ āĻĒā§āϰāĻœā§‡āĻ•ā§āϟ āĻāĻ•ā§āϏāĻžāĻŽā§āĻĒāϞ

  • āϞāĻžāχāĻĢāϟāĻžāχāĻŽ āĻ…ā§āϝāĻžāĻ•ā§āϏ⧇āϏ

  • āϏāĻžāĻ°ā§āϟāĻŋāĻĢāĻŋāϕ⧇āϟ āĻ…āĻĢ āĻ•āĻŽāĻĒā§āϞāĻŋāĻļāύ

  • ⧍ā§Ē/ā§­ āϏāĻžāĻĒā§‹āĻ°ā§āϟ

 

🏆 āϕ⧋āĻ°ā§āϏ āĻļ⧇āώ⧇ āϝāĻž āĻ•āϰāϤ⧇ āĻĒāĻžāϰāĻŦ⧇āύ

  • Excel āĻĻāĻŋā§Ÿā§‡ āĻĒā§āϰāĻĢ⧇āĻļāύāĻžāϞ āϰāĻŋāĻĒā§‹āĻ°ā§āϟ āĻ“ āĻĄā§āϝāĻžāĻļāĻŦā§‹āĻ°ā§āĻĄ āϤ⧈āϰāĻŋ āĻ•āϰāϤ⧇ āĻĒāĻžāϰāĻŦ⧇āύ

  • āϝ⧇āϕ⧋āύ⧋ āĻ…āĻĢāĻŋāϏ āĻĄā§‡āϟāĻž āϏāĻšāĻœā§‡ āĻŽā§āϝāĻžāύ⧇āϜ āĻ“ āĻ…ā§āϝāĻžāύāĻžāϞāĻžāχāϜ āĻ•āϰāϤ⧇ āĻĒāĻžāϰāĻŦ⧇āύ

  • Freelancing āĻ“ Remote Job-āĻ Excel āĻĻāĻŋā§Ÿā§‡ āĻ†ā§Ÿ āĻ•āϰāϤ⧇ āĻĒāĻžāϰāĻŦ⧇āύ

  • āύāĻŋāĻœā§‡āϕ⧇ āĻāĻ•ā§āϏāĻĒāĻžāĻ°ā§āϟ āĻšāĻŋāϏ⧇āĻŦ⧇ āĻĒā§āϰāϤāĻŋāĻˇā§āĻ āĻŋāϤ āĻ•āϰāϤ⧇ āĻĒāĻžāϰāĻŦ⧇āύ

 

📌 āϏāĻ‚āĻ•ā§āώ⧇āĻĒ⧇:

 

āĻāĻ•āϟāĻŋ āϕ⧋āĻ°ā§āϏ⧇āχ āϏāĻŦ āĻ•āĻŋāϛ⧁ – Basic, Advanced, Dashboard, Data Analysis, Pivot Table, Shortcut, Automation, Project!
āĻāϟāĻŋāχ āĻšāĻŦ⧇ āφāĻĒāύāĻžāϰ āĻ•ā§āϝāĻžāϰāĻŋ⧟āĻžāϰ⧇āϰ One-Stop Excel Solution.

Course Curriculum

  • What is Excel?

    0h 03m
  • History of Excel

    0h 01m
  • Facts of Excel

    0h 02m
  • What is Excel Automation?

    0h 02m
  • Uses of Excel Automation & its Importance

    0h 02m

  • Conditional Formatting

    0h 18m
  • Number Formatting

    0h 05m
  • Cell Styles

    0h 03m
  • Format Painter/Brushing

    0h 03m
  • Custom Formatting

    0h 08m
  • Format as Table

    0h 03m
  • Theming & Fonts

    0h 03m
  • Text Alignment & Orientation

    0h 07m

  • Drop-Down List

    0h 07m
  • Data Restrictions

    0h 09m
  • Text Length Limits

    0h 02m
  • Custom Formulas

    0h 10m
  • Input Message & Error Alerts

    0h 07m
  • Cell, Sheet & Workbook Lock/Unlock

    0h 06m
  • How to Unlock Cell, Sheet & Workbook without Password (If Forgotten)

    0h 13m

  • Shortcuts in Keyboard

    0h 06m
  • Flash Fill

    0h 05m
  • Remove Duplicates

    0h 03m
  • Data Filters

    0h 03m
  • Advance Filter

    0h 05m
  • Data Sorting

    0h 03m
  • Find & Replace

    0h 03m
  • Name Ranges

    0h 09m
  • Protect Sheet

    0h 03m
  • Group/Ungroup

    0h 06m
  • Text to Columns

    0h 09m
  • Paste Special

    0h 05m
  • Go to Special

    0h 10m

  • Addition ( + )

    0h 02m
  • Subtraction ( - )

    0h 01m
  • Multiplication ( * )

    0h 01m
  • Division ( / )

    0h 01m
  • Squaring Number ( ^ )

    0h 03m
  • ROUND

    0h 04m
  • ROUNDUP

    0h 02m

  • SUM

    0h 01m
  • SUMIFS

    0h 08m
  • AVERAGE

    0h 03m
  • MIN

    0h 01m
  • MAX

    0h 01m
  • COUNT

    0h 02m
  • COUNTA

    0h 02m
  • COUNTIFS

    0h 05m
  • LARGE

    0h 02m
  • SMALL

    0h 02m

  • CONCATENATE

    0h 02m
  • TEXT

    0h 07m
  • PROPER

    0h 01m
  • UPPER

    0h 01m
  • LOWER

    0h 01m
  • LEN

    0h 03m
  • LEFT

    0h 03m
  • RIGHT

    0h 02m
  • MID

    0h 08m

  • IF

    0h 06m
  • IF ERROR

    0h 03m
  • AND

    0h 05m
  • OR

    0h 03m
  • NOT

    0h 05m
  • ISBLANK

    0h 03m

  • NOW

    0h 03m
  • WEEKDAY

    0h 02m
  • HOUR

    0h 01m
  • TODAY

    0h 02m
  • DAY

    0h 01m
  • MONTH

    0h 01m
  • YEAR

    0h 01m
  • DATE

    0h 03m
  • EDATE

    0h 07m
  • DATEDIF

    0h 08m
  • EOMONTH

    0h 05m
  • NETWORKDAYS

    0h 09m
  • NETWORKDAYS.INTL

    0h 07m
  • WORKDAY

    0h 04m
  • Date Formatting with Text

    0h 08m

  • TIME

    0h 02m
  • HOUR

    0h 01m
  • MINUTE

    0h 02m
  • SECOND

    0h 01m
  • Time Formatting with Text

    0h 07m

  • Basics of Lookup Function

    0h 07m
  • LOOKUP

    0h 13m
  • VLOOKUP

    0h 05m
  • HLOOKUP

    0h 04m
  • XLOOKUP

    0h 03m

  • Basics of INDEX & MATCH Function

    0h 05m
  • INDEX

    0h 05m
  • MATCH

    0h 03m
  • INDEXMATCHING

    0h 06m

  • Introduction to Pivot

    0h 03m
  • Preparing Data for Pivot Tables

    0h 03m
  • Creating Pivot Tables

    0h 05m
  • Customizing Pivot Table Layout & Design

    0h 12m
  • Grouping & Ungrouping Data

    0h 03m
  • Using Slicer

    0h 03m
  • Customizing Values

    0h 05m

  • What is Power Pivot

    0h 04m
  • Uses of Power Pivot & its Importance

    0h 05m
  • Difference between Pivot & Power Pivot

    0h 03m
  • Demonstration

    0h 11m

  • Guideline to Create Logic

    0h 09m
  • IF(AND)

    0h 05m
  • IF(OR)

    0h 04m
  • IF(NOT)

    0h 04m
  • Demonstration

    0h 10m

  • What is Dashboard Reporting & Its Importance?

    0h 03m
  • Combining Functions to Dashboard (i.e. VLOOKUP, COUNTIFS, SUMIFS etc.)

    0h 02m
  • Demonstration

    0h 11m

  • What is Marco?

    0h 03m
  • Uses of Macro & its Importance

    0h 02m
  • Demonstration

    0h 11m

  • Introduction to Graph and Chart

    0h 01m
  • Uses of Graph and Chart & its Importance

    0h 03m
  • Understanding the Elements of Graph and Chart

    0h 02m
  • Data Visualization using Graph and Chart

    0h 02m
  • Demonstration

    0h 06m
  • Inserting Picture or Creating Shape

    0h 04m

  • What is Mail Merge?

    0h 02m
  • Uses of Mail Merge & its Importance

    0h 03m
  • Connecting Excel and Word Document

    0h 02m
  • Demonstration

    0h 07m

  • Print Area Setup

    0h 02m
  • Page Setup

    0h 03m
  • Header & Footer

    0h 03m
  • Page Number

    0h 03m
  • Repeat Title

    0h 02m

Instructor Details

Instructor

Mohammad Saleh Rabbi

  • 0 Reviews
  • 0.0 Rating
  • book 1 Courses

Customer Reviews

0.00

0 Reviews

5

0

4

0

3

0

2

0

1

0

Reviews

This course has no reviews yet.
Video

Price: ā§ŗ3999ā§ŗ999

  • clock Course Duration

    7h 05m
  • network Skill Level

    Advanced
  • Language Language

    Bangla
Enroll Now

This Course Includes

  • video 7h 05m Video Lectures
  • Certificate Certificate of Completion
  • Certificate Course Lifetime Access
Instructor

Mohammad Saleh Rabbi

Instructor

Messenger