MAWbiz ad

Professional Training

Pathway to be a Business Analyst through MS Excel

Date: Sep 27, 29 & Oct 02, 04, 06, 2021

Time: 07:00 PM - 09:00 PM

No. of Classes/Sessions: Total 4 classes with additional 1 Q & A class

Total Hours: 08

Venue: Online (Live Class on Zoom)

Class Schedule: Mon- Wed- Sat- Mon at 07:00 PM - 09:00 PM

Registration deadline: 26th September 2021

Price: BDT 1000

Enrol

Contents of Training

Overview

The program will be delivered using formal lectures combined with practical and interactive case studies and exercises. There will be a great emphasis on gaining practical experiences.

Who should attend the course?

  • 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

Detailed Contents of Training:

Introduction
  • Introduction to Microsoft Excel
  • Tabs, Ribbons and Commands
  • Accessing Commands with Keyboards
  • Backstage File Management

Options & Customization
  • Excel Options
  • Quick Access Toolbar 
  • Menu Customization
  • View Tab

Data and Numbers
  • Data Entry Basics and Tips
  • Clipboard, Font and Alignment
  • Number and Styles
  • Cells and Editing

Number Basics
  • Introduction to Quantitative Analysis
  • Arithmetic
  • Fractions and Decimal 
  • Percentages and Ratios

Algebra, Equations and Formulae
  • Introductory Definitions
  • Algebraic Notations
  • Solving Equations
  • Formulae

Excel Functions and Formulas
  • Defined Names
  • Formula Auditing
  • Calculation and Formula Protection

Data Management
  • Sorting and Filtering
  • Data Tools 
  • Data Validity
  • External Data

Advanced Functions
  • Introduction to Database
  • Vlookup Function 
  • IF
  • Sum IF
  • Count If

Data Presentation
  • Charts and Sparkline
  • Pivot Table
  • Pivot Charts

Extras
  • Cases
  • Example Files
  • Practical Problem Solution
  • Reporting Dashboard


Share On

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

Benefits of the Training

  • Understanding Fundamentals of Quantitative Analysis.
  • Essential Data Recording and Management Skills in Excel.
  • Numeric Data Analysis, Reporting and Presentations using Visuals.
  • Knowing Essential and Advanced Functions and Formulas.
  • Essential Office Skills – Page Layout, Printing, View, Sharing and Protection.
  • Learning Advance templates, tools and applications.

Certificate Preview

Left Ads
MAwbiz.com
Left Ads