মাইক্রোসফট অফিস লাইভ বান্ডেল কোর্স

Class no

Topic

Key Skills Covered

Practical Use on Class

1

Introduction to Excel

Interface, Ribbon, Workbook/Worksheets, Saving Files

Data entry and storing

Data Entry & Formatting

Cell formatting, Number formats, Borders, Alignment, Conditional Formatting

Basic Formulas & Functions

SUM, AVERAGE, MIN, MAX, COUNT, Autofill

2

Charts & Data Visualization

Column, Bar, Line, Pie Charts, Basic Layouts

Graphical Reporting, Business Plan with chart

Printing & Page Layout

Print area, Page breaks, Headers/Footers

Class

Topic

Key Skills Covered

Practical Use on Class

3

Logical & Lookup Functions

IF, AND, OR, VLOOKUP, HLOOKUP

Inventory management

4

Data Tools

Data Validation, Drop-down lists, Text to Columns

Work monitoring

Tables & Filtering

Excel Tables, Sorting, Filtering, Subtotals

Named Ranges & Error Handling

Define Names, IFERROR, ISERROR

5

PivotTables & Pivot Charts

Creating, Customizing, Filtering

Sales and Revenue Analysis Report

Class

Level

Topic

Key Skills Covered

Duration

6

Advanced Formulas

INDEX/MATCH, XLOOKUP, INDIRECT, OFFSET

Combining Data from Multiple Files

Power Query Basics

Import data, Clean & Transform data

7

Dashboard Design

Interactive charts, Form controls, KPI visualizations

Company operation dashboard making

Class

Course Level

Topics Covered

Practical use on Class

1^st Class

Basic Level

Introduction to PowerPoint Interface
Creating and Saving Presentations
Using Templates and Themes,
Adding and Formatting Text
Inserting Images, Shapes, and Icons
Slide Layouts and Design Tips

Educational Presentations

2^nd Class

Intermediate Level

Using SmartArt and Charts
Inserting and Formatting Tables,
Adding Transitions and Animations,
Slide Master and Layout Customization,
Hyperlinks and Action Buttons,
Creating Sections and Managing Slides

Job Interviews & Portfolios Presentation

3^rd Class

Advanced Level

Embedding Videos and Audio,
Custom Animations and Motion Paths,
Advanced Slide Master Techniques
Interactive Presentations and Navigation.

Making Professional Business Reports Presentation

4^th Class

Advanced Level

Cameo, Designer enhancements, Co-Authoring & Collaboration in Real Time, Co-Authoring & Collaboration in Real Time, Record Presentation with Narration + Video, Tips for Delivering Powerful Presentations

Making Video and Multimedia Content

Class

Topic

Learning Objectives

Practical Use on Class

1

Introduction to MS Word

Interface, Ribbon, Quick Access Toolbar, Creating & Saving documents

Making a Cover letter/ Application/Assignments

Text Editing & Formatting

Font styles, Paragraph alignment, Bullets & Numbering, Line spacing

Page Layout Basics

Page margins, Orientation, Size, Columns, Page breaks

Making Meeting Minutes & Agendas/Project report/design a certificate

2

Working with Lists & Indentation

Multilevel lists, Custom bullets, Tabs, Indents

Proofing Tools & Printing

Spell check, Thesaurus, Find & Replace, Print preview, Page setup

Class

Topic

Learning Objectives

Practical Use on Class

3

Working with Tables

Insert tables, Format cells, Merge/split, Sort & calculate in tables

Making a complete modern resume/CV

Inserting & Formatting Objects

Pictures, Shapes, SmartArt, Text Boxes, WordArt

Section Breaks & Page Formatting

Section breaks, Headers & Footers, Page numbering

Styles & Themes

Applying built-in styles, Creating custom styles, Using themes for formatting consistency

Templates & Document Management

Using and creating templates, Version control, Compare documents, Track changes

Class

Topic

Learning Objectives

Practical Use on Class

4

Mail Merge

Letters, Labels, Emails using Excel data source

Show a mail merge process, design a e-book

References & Citations

Footnotes, Endnotes, Table of Contents

Forms & Content Controls

Checkboxes, Drop-downs, Restrict editing