Professional Training

MS Excel - আপনার পেশাজীবনে এগিয়ে যাবার হাতিয়ার

25 ratings

Date: 30 Dec 2021 & 01, 02, 04 Jan 2022

Time: 7:30 PM - 9:30 PM

Total Hours: 08

Class Schedule: Thu-Sat-Sun-Tue

Registration Deadline: 04 January 2022

No. of Classes/Sessions: Total 4 classes

Venue: Online (Live Class on Zoom)

What you will learn

The program will be delivered using formal lectures combined with practical and interactive case studies and exercises.

The attendees will understand fundamentals of quantitative analysis, essential data recording, and management skills in excel.

Moreover, they will learn essential office skills – Page Layout, Printing, View, Sharing, and Protection.

There will be a great emphasis on gaining practical experiences.

Also, the participants will understand numeric data analysis, reporting and presentations using visuals and know essential and advanced functions and formulas.

In addition, they will learn advance templates, tools, and applications.

Who should attend the program?

Last year graduating students
Fresh graduate
People who want to be a “Business Analyst”
People who want to sharpen his/her MS Excel skill
People who are in corporate and want to play with date in next level

Training content

Detailed Contents of Training: Introduction

Introduction to Microsoft Excel

Tabs, Ribbons and Commands

Accessing Commands with Keyboards

Backstage File Management

Detailed Contents of Training: Options & Customization

Excel Options

Quick Access Toolbar

Menu Customization

View Tab

Detailed Contents of Training: Data and Numbers

Data Entry Basics and Tips

Clipboard, Font and Alignment

Number and Styles

Cells and Editing

Detailed Contents of Training: Number Basics

Introduction to Quantitative Analysis

Arithmetic

Fractions and Decimal

Percentages and Ratios

Detailed contents of training: Algebra, Equations and Formulae

Introductory Definitions

Algebraic Notations

Solving Equations

Formulae

Detailed contents of training: Excel Functions and Formulas

Defined Names

Formula Auditing

Calculation and Formula Protection

Detailed contents of training: Data Management

Sorting and Filtering

Data Tools

Data Validity

External Data

Detailed contents of training: Advanced Functions

Introduction to Database

Vlookup Function

Sum IF

Count If

Detailed contents of training: Data Presentation

Charts and Sparkline

Pivot Table

Pivot Charts

Detailed contents of training: Extras

Cases

Example Files

Practical Problem Solution

Reporting Dashboard

Instructor's Profile

Asad Zaman

Asad Zaman is a Professional MS Excel Trainer and has years of experience in designing and delivering training courses. Currently, he is working at SC Johnson Bangladesh. Before that, he worked for Coca-Cola. ...

Mentor Details