The Ultimate MS Office Journey

Excel Basics & Data Handling

Excel Interface

Workbook এবং Worksheet কী?

Data Input ও Cell Formatting

Excel Shortcut Keys

Creating Invoices or Sales Reports

Cut, Copy, Paste, Paste Special

Move Or Copy (Tab and Sheets)

Insert ও Delete

Find & Replace, Go to Special

Flash Fill ও Autofill ব্যবহার

Date এবং Serial No Insert টেকনিক

Freeze Panes ও Split

Print & Page Setup

Page Layout View এবং Print Preview

Orientation, Size, Margins

Set Print Area

Fit Sheet to One Page

Page Break এবং Print Titles

Header/Footer, Watermarks, Page No

Multiple Sheets একসাথে প্রিন্ট করা

Cell References & Basics Functions

Relative Cell Reference (A1, B2...)

Absolute Cell Reference ($A$1, $B$2...)

Mixed Cell Reference (A$1, $A1)

Cell Reference-এর ব্যবহার কবে কোথায়?

Practical Examples: Discount, Commission Calculation

ফর্মুলা কীভাবে কাজ করে?

Basic Arithmetic (+, -, *, /)

Rand between, Sum, Average, Min, Max, Count, Counta, Small, Large, Product, Indirect, Rank, Upper, Lower, Proper

Logic & Text Functions Mastery

If, And, Or, Not

Nested If, Switch, If Error

Isnumber, Istext, IsBlank

Sumif, Sumifs, Countif, Countifs

Dsum, Dcount

Concatenate, Left, Right, Mid

Len, Find, Clean, Trim, Indirect

TextJoin, Textsplit, Textafter, Textbefore,Text Function

ToCol, ToRow, ByRow, ByCol, ChooseCol, ChooseRow

Time Calculation and Time Function

Today, Now, Yearfrc, Datedif, Year, Month, Day, Date, Edate, Eomonth, Workday.Intl, Weekday

Real-World Examples

Lookup Functions & Dynamic Tools

Lookup, Vlookup, Hlookup

Xlookup (Modern Excel Lookup)

Vlookup and Xlookup Examples

Dget Function

Index And Match

Choose, Offset and Take

Real-World Examples

Sorting, Filtering, Grouping, Protection & Analysis

Sorting (Single Level & Multi-Level)

Filtering (Basic & Advanced)

Text, Number & Date Filters

Filter By Cell Color or Font Color

Custom Filters with Conditions

Grouping And Ungrouping Data

Subtotals With Automatic Grouping

Expand/Collapse Grouped Sections

Subtotal, GroupBy and Aggregate Function

Real-World Examples

শীট ও ওয়ার্কবুক পাসওয়ার্ড দিয়ে সুরক্ষা

নির্দিষ্ট রেঞ্জ লক/আনলক করা

ফর্মুলা লক করে রক্ষা করা

What-If Analysis: Scenario Manager, Goal Seek

Conditional Formatting & Validation

Applying Built-In Rules

Highlighting Duplicate & Unique Values

Using Data Bars

Applying Color Scales

Utilizing Icon Sets

Conditional Formatting with Formulas (AND, OR)

Multiple Condition Formatting

Managing & Clearing Rules

Real-World Use Cases

Drop-down List Creation (Static & Dynamic)

Number, Date & Text Length Restriction

Custom Formula Validation

Dependent Drop-down Lists

Preventing Duplicate Entries

Input Messages & Error Alerts

Named Ranges for Validation

Conditional Input Based on Other Cells

Validation with Conditional Formatting

Apply, Edit & Remove Validation Rules

Hyperlink & Data Visualization

Hyperlink কী এবং এর ব্যবহার

Excel-এ Hyperlink তৈরি করার পদ্ধতি

ওয়েবসাইট, ফাইল, এবং ইমেইলে লিংক দেওয়া

একই ফাইলে Sheet বা Cell-এ লিংক করা

Table of Contents তৈরি করার জন্য Hyperlink ব্যবহার

Hyperlink Edit ও Remove করা

Hyperlink-এর নিরাপত্তা বিষয়ক সতর্কতা

Column চার্ট, Line চার্ট, Pie চার্ট, Bar চার্ট

Area চার্ট, Scatter Plot, Combo চার্ট

Histogram, Waterfall চার্ট

ডিজাইন ও ফরম্যাটিং: কাস্টমাইজ

Sparklines

Real-World Examples

Pivot Table & Advanced Analysis

Pivot Table Introduction

Creating A Basic Pivot Table

Pivot Table Field List Explained

Rearranging Row & Column Fields

Adding Values and Summarizing Data

Changing Summary Functions (Sum, Count, Average, Etc.)

Grouping Data (By Date, Numbers, Or Text)

Using Label Filters and Value Filters

Sorting Pivot Table Data

Using Slicers and Timeline

Drill Down (Double-Click to View Underlying Data)

Show Values As

Calculated Fields and Calculated Items

Refreshing Pivot Table Data

Connecting Pivot Table to Dynamic Data Range

Using Tables as Pivot Data Source

Creating Pivot Table from Multiple Sheets

Changing Pivot Table Layout and Design

Creating Pivot Charts from Pivot Table

Grouping Dates into Months, Quarters, And Years

Managing Multiple Pivot Tables on the Same Report

Using Power Pivot with Pivot Table

Best Practices for Large Data Sets

Real-Life Scenarios with Pivot Table

Excel Automation

Macros কী ও কিভাবে কাজ করে?

Record Macro & Run

Vba Overview (Basic Introduction)

Control Groups (Buttons, Dropdown)

Excel-এ AI এর ব্যবহার

Excel এর মধ্যে Ai-চালিত ফিচারসমূহ (Ideas, Data Types, Smart Lookup)

Chatgpt/Ai Tools দিয়ে Excel Task Automation

Ai দিয়ে রিপোর্ট লেখা ও ডেটা ব্যাখ্যা

Excel for HR

Employee Database তৈরি ও Maintain

Attendance Tracker & Leave Management Sheet

Payroll Calculation: Basic Salary, Allowance, Bonus

Overtime Calculation

Hr-র জন্য প্রয়োজনীয় ফাংশন

Excel for Accounts & Finance

Income & Expense Tracker

Monthly Budget Sheet

Profit & Loss Statement

Pmt: Emi বা কিস্তি হিসাব করা

Fv: ভবিষ্যৎ মূল্যের হিসাব

Pv: বর্তমান মূল্যের হিসাব

Npv: নেট বর্তমান মূল্য (Investment Analysis)

Irr: Internal Rate of Return

Rate: কিস্তির সুদের হার নির্ণয়

Loan Calculator তৈরির প্রজেক্ট

Excel for Sales & Marketing

Sales Tracker Sheet

Target Vs Achievement Dashboard

প্রয়োজনীয় ফাংশন

Sales Forecasting Using Trendline & Chart

Career Tips & Next Steps

Excel দিয়ে কিভাবে চাকরি পাওয়া যায়?

Freelancing Vs Job: কোনটা আপনার জন্য উপযোগী?

ভবিষ্যতের জন্য করণীয়: Power Bi, Sql, Ai Tools

Materials

Practice Files

Class-Wise Assignment

Excel Templates

Add-Ins

Final Exam

কোর্স সার্টিফিকেট

Basic Document Formatting

Font and Paragraph Formatting (Alignment, Spacing, Indentation)

Using Styles and Themes for consistent design

Page Layout, Margins, Breaks, and Columns

Working with Tables and Visuals

Creating and Formatting Tables, Merging Cells, Formulas

Inserting and Positioning Images, Shapes, and SmartArt

Using Captions, Table of Contents, Footnotes, Endnotes

Advanced Features & Automation

Track Changes and Comments for collaboration

Mail Merge for personalized letters and labels

Creating templates and forms

Introduction to PowerPoint

Interface, Ribbon, Quick Access Toolbar, Backstage View

Creating, Saving, Opening Presentations, Slide Views & Layouts

Using Themes and Templates, Adding/Formatting Text

Enhancing Presentations with Visuals

Inserting and Formatting Images, Shapes, and Charts

Using SmartArt for diagrams, Grouping and Layering Objects

Inserting and Formatting Tables, Audio, and Video

Advanced Design & Animation

Understanding and Customizing Slide Master

Applying Slide Transitions and Animation Effects

Using Animation Pane, Custom Animations, and Motion Paths

Presentation Techniques & Collaboration

Adding Hyperlinks and Action Buttons for interactivity

Setting Slide Timings, Creating Custom Shows, Using Presenter View

Sharing, Co-authoring, Comments, and Exporting (PDF, video)

🟢 Beginners (Basic Users) 

Introduction to Microsoft Outlook

What is Outlook?
Features and benefits
Overview of interface (Ribbon, Navigation Pane, Reading Pane)

Email Basics

Composing and sending emails
Reply, Reply All, Forward
Adding attachments
Email formatting (font, signature)
Using CC and BCC properly

Managing Inbox

Organizing emails into folders
Deleting and recovering emails
Marking emails as read/unread
Flagging emails
Searching emails

🟡 Intermediate Users

Email Organization & Productivity

Creating rules for automatic sorting
Using Categories
Creating Quick Steps
Managing Focused Inbox
Archiving emails

Calendar Management

Creating appointments and meetings
Scheduling meetings with attendees
Using Scheduling Assistant
Recurring meetings
Calendar sharing

Contacts & Tasks

Creating and managing contacts
Creating contact groups
Assigning tasks
Tracking task progress

🔵 Advanced Users / Power Users

Advanced Email Management

Mailbox cleanup tools
Managing large mailboxes
Using advanced search filters
Conversation view settings
Using templates

Collaboration & Integration

Integrating with Microsoft Teams
Integrating with Microsoft OneDrive
Shared mailboxes
Delegating mailbox access

Security & Best Practices

Email encryption basics
Phishing awareness
Safe attachment handling
Setting automatic replies (Out of Office)
Backup and archiving best practices