5.00(1)

Master Course on Microsoft Excel For Professionals

  • Categories MS Excel
  • Duration 10h
  • Total Enrolled 5
  • Last Update March 22, 2021

About Course

Microsoft Excel is the industry-standard spreadsheet program used for data calculations, analysis, visualization and much more. It can be programmed to access data from external databases and is an excellent tool for data modeling, statistics and financial calculations with built-in functions to quickly and easily perform common tasks.

Description

Microsoft Excel is the industry-standard spreadsheet program used for data calculations, analysis, visualization and much more. It can be programmed to access data from external databases and is an excellent tool for data modeling, statistics and financial calculations with built-in functions to quickly and easily perform common tasks.

Who is this course for?

This online course is suitable for anyone who wants to learn Excel. No prior knowledge of Excel is required. Whether you are a business professional, student, teacher, freelancer, this training can benefit you and help you take your Excel skills to the next level. Excel is the most used spreadsheet software across the globe and is considered essential in many industries like administration, accounting, construction, real estate, sales, and marketing to name a few.

Trainer

Md. Manik Hossain

Trainer Profile

What Will I Learn?

  • Data Management, Spreadsheet Management, Microsoft Excel, Problem Solving.

Topics for this course

31 Lessons10h

Lecture File

Lecture File

Introduction of Microsoft Excel?

This video is meant for Excel beginners. In this video, I will show you the different parts of Excel working area. In this video, you’ll learn about the following topics: Structure of the Excel working area, How to navigate in Excel, Ribbons and tabs, Quick Access Toolbar (QAT)

Microsoft Excel Essentials Part – 1

Microsoft Excel Essentials Part – 2

Microsoft Excel Essentials Part – 3

Microsoft Excel Essentials Part – 4

Quiz 1

Microsoft Excel Data Entry Part – 1

Microsoft Excel Data Entry Part – 2

Quiz 2

Formatting in Microsoft Excel

Number Formatting in Microsoft Excel

Introduction of Function

Cell References in Microsoft Excel?

Relative Reference Absolute Reference Mixed Reference

Regular Short Keys

Text Formatting in Microsoft Excel

Text to Columns in Microsoft Excel

Paste Special in Microsoft Excel

Viewing Worksheet in Microsoft Excel

Viewing Worksheet in Microsoft Excel Part – 2

Quiz 3

Custom Views in Microsoft Excel

Basic Calculation & Function in Microsoft Excel

Basic Function in Microsoft Excel Part -2

Quiz 4

Charts in in Microsoft Excel

IF Functions in Microsoft Excel

IF Functions in Microsoft Excel Part – 2

Quiz 5

VLOOKUP Function in Microsoft Excel Part – 1

VLOOKUP Function in Microsoft Excel Part – 2

HLOOKUP Function in Microsoft Excel

Quiz 6

Data Short and Filter in Microsoft Excel

Advanced Filter

Table

Pivot Table

Dashboard Making with Pivot Table

Final Quiz

About the instructor

5.00 (1 ratings)

3 Courses

5 students

Student Feedback

5.0

Total 1 Ratings

5
1 rating
4
0 rating
3
0 rating
2
0 rating
1
0 rating

Such an amazing institute where the efficiency and proficiency meet. Really liked their service and teaching style. Keep it up!

৳ 1,500 ৳ 500

Material Includes

  • Lecture File, Quizzes, Exam, Notes

Requirements

  • Microsoft Office Software 2010 / 2013 / 2016 / 2019

Target Audience

  • Anyone who wants to learn Excel