Class Start: January 18, 2020 (Saturday)
Seats Available: 10 only (First come first serve)
Admission Deadline: January 10, 2020
Duration: 10 Weeks
Class Time:  5:30 PM To 7:30 PM

Course Fees – 5,000/- Tk.

Early Bird Registration Going on Valid till 5 January, 2020 Tk. 4,000/-

MICROSOFT OFFICE FUNDAMENTALS: WORD, PPT, AND EXCEL (With Google Sheet & Slides)

In this Microsoft Office essential skills course I share with you the real-life skills people need to get the best from the software in the workplace, gathered over many years as a Microsoft Certified Trainer. By taking this course you will be able to:

  • Confidently use the core Microsoft Office programs in the workplace
  • Learn the skills employers expect you to have in Word, Excel and PowerPoint
  • Apply best practices to your work
  • Achieve confidence and job satisfaction through practice

Course Content

MS Word

Basic Options

Formatting Text

Editing Text

Paragraphs

Sorting, Bullets and Numbering

Spelling and Grammar

Table

Shapes

Footnotes and End notes

Inserting Citations and a Bibliography

Auto Table of Content Generator

Caption

APA Format

Watermark

Page Background

Page Setup

Margins

Orientation

Size

Columns

MS PowerPoint

Getting Started with PowerPoint

Navigate the PowerPoint Environment

View and Navigate a Presentation

Create and Save a PowerPoint Presentation

Developing a PowerPoint Presentation

Select a Presentation Type

Edit Text

Build a Presentation

Performing Advanced Text Editing Operations

Format Characters

Format Paragraphs

Format Text Boxes

Adding Graphical Elements to Your Presentation

Insert Images

Insert Shapes

Adding Tables to Your Presentation

Create a Table

Format a Table

Insert a Table from Other Microsoft Office Applications

Adding Charts to Your Presentation

Create a Chart

Format a Chart

 

Google Slides 

Google Slide’s basic functionality

MS Excel

Quick Access Toolbar

Tabs

 Ribbion

Name Box

Formula Bar

Rows, Columns, Cells

Sheets

Zoom

Work book VS Work Sheet

Cell VS Range

Simple Data Entry

Selecting Ranges

Saving workbook formats

Find & Replace

Font

Alignment

Number

Relative Reference

Absolute Reference

Mixed Reference

Concatenate

TRIM

PROPER

UPPER

LOWER

Hiding/ Unhiding Columns/Rows

Freezing Panes

Add/Subtract/Multiphy/Divide

BODMAS

Count Formula

Counta Formula

Countblank

Countif

Sum

Average

Max

Min

Sumif

Countif

Chart Management

Data Sorting

Conditional Formatting

VLOOKUP with Exact Match

VLOOKUP Approximate Match

VLOOKUP Rules

H-Lookup

Advanced Filters

Google Sheets

Create a Google Spreadsheet

Arithmetic Functions like SUM, COUNT, and AVERAGE

Charts & Beautiful Visualizations

Registration Process

To register your name inbox us for the following information;
Full Name:
Mobile Number:
E-mail ID:
Batch Number:
bKash Number / Trx ID:

(To confirm your seat, you need to send Tk. 1,000 through
#bKash or #Rocket or #Nagad)
bKash: 01733405068 (personal)
Rocket: 017334050682 (personal)
Nagad: 01670031946 (personal)

Contact us
+88 01733405068
E-mail: mhossain@icdb.info
Youtube Channel: Institute of Career Development, Bangladesh – ICDB

#Excel #Training #ICDB