Microsoft Excel Course: From Basic to Advanced

Teacher

Overview

Microsoft (MS) Excel was released in 1985 and has grown to become arguably the most essential computer program in workplaces around the world. Whether you are budgeting, organizing client sales lists, or need to plan an office social gathering, Microsoft Excel is a powerful tool that has become entrenched in business processes worldwide. Excel helps you to organize vast amounts of data and information and also helps you to prepare powerful reports from the recorded data/information. Thus this Microsoft Excel Course gives a huge value to any kind of organization and knowing this essential skill can make you valuable to your organization.

This Excel course starts with the most basic elements and functions you need to know and gradually steps forward to more advanced features and functions so that you can become really efficient working with Excel even if you are currently a beginner.

Why will you learn Excel?

To become employable in banks.
To have more time for the good things in life.
To have more value to employers.
To enhance your practical knowledge and management skills.

Who can learn from this Microsoft Excel Course?
Whether you are a tertiary level student having the need for research and managing a lot of data or you are a graduate looking for job opportunities or you are already a job holder or you are trying to start your own business, in all the situations mentioned above, you will be greatly benefited if you know Excel. So, anyone can learn from this Excel course.

Course Affiliation

This course is prepared by and affiliated with Excel School BD, a group run by enthusiastic and passionate professionals and experts of Microsoft Excel. Completing this course will allow the learners to join Excel School BD and continue their learning on Excel from this group.

Course Benefits

20 Exclusive Lessons in Bengali
Self Assessment Test
Course Completion Certificate
Opportunity to join Excel School BD group

GoEdu Learner’s Manual

Course Forum

Course Features

Lectures 22
Quizzes 1
Duration 1.5 Hours
Skill level All levels
Language Bengali
Students 1
Certificate Yes
Assessments Self

Curriculum

Course Introduction

2
- Lecture1.1
  
  Overview 02 min
- Lecture1.2
  
  Excel School BD Group Information
Basic Features

10
- Lecture2.1
  
  Format 03 min
- Lecture2.2
  
  Sorting 07 min
- Lecture2.3
  
  Filter 04 min
- Lecture2.4
  
  Transpose 02 min
- Lecture2.5
  
  Use of And 05 min
- Lecture2.6
  
  Use of Or 04 min
- Lecture2.7
  
  If Error 05 min
- Lecture2.8
  
  If and Nested If 10 min
- Lecture2.9
  
  Countif and Countifs 08 min
- Lecture2.10
  
  Sum and Sumifs 09 min
Advanced Features

10
- Lecture3.1
  
  Protection then Validation 05 min
- Lecture3.2
  
  Validation 09 min
- Lecture3.3
  
  Referencing 08 min
- Lecture3.4
  
  Statistics 03 min
- Lecture3.5
  
  Subtotal 06 min
- Lecture3.6
  
  Goal Seek 05 min
- Lecture3.7
  
  Data Table 06 min
- Lecture3.8
  
  V Lookup 08 min
- Lecture3.9
  
  Match Index 10 min
- Lecture3.10
  
  Pivot Table 10 min
Course Completion

1
- Quiz4.1
  
  Completion Examination 31 questionsFinal

Instructor

Md. Mohin Chowdhury

Mr. Chowdhury is working at the Finance Division of Eastern Bank Limited. His areas of expertise are Financial Management, Project Management, ERP, Accounting Information Systems, Financial Planning, Risk Management Business Planning, Investment Analysis, Project Evaluation, Product Pricing, and Statistical Analysis. He is certified on “Investment Climate of Bangladesh” from the International Finance Corporation (IFC). As a trainer, he is dedicated and knows the exact practical way of demonstrating usages of Microsoft Excel in marketing, finance, HRD, and manufacturing operations inside the business environment.

Zahirul Islam

Mr. Islam is currently working in Edotco Bangladesh Co. Ltd (A concern of Axiata Group) as Financial Planner & Analyst. Previously, he worked in Infinigent Consulting Ltd as Business Analyst, in Sky Telecommunication Limited (A concern of Partex Star Group, Metro Group & Karnaphuli Group) as a Business Planner & Analyst. Moreover, he worked in various national & multinational FMCG, manufacturing companies, Financial Institutions & Banks. He is a Certified Supply Chain Analyst (CSCATM) offered by the International Supply Chain Educational Alliance (USA). Moreover, he is a certified Business Analyst & Data Analyst from the Wharton School of Business of the University of Pennsylvania (USA). He was among the top 10 MS Excel experts of the national MS Excel competition called “Excelerious 2016”.

Mahbubur Rahman

Mr. Rahman is working at Card Division of Eastern Bank Limited. Previously, he worked in BRAC bank. His areas of expertise are Data Analysis, Project Management, Accounting Information Systems, Investment Analysis, Project Evaluation, Product Pricing, and Statistical Analysis. As a trainer, he is dedicated and knows the exact practical way of demonstrating the usages of Microsoft excel in marketing, finance, HRD inside the business environment.