Master Course on Microsoft Excel For Professionals

Master Course on Microsoft Excel For Professionals

Categories: MS Excel
Wishlist Share
Share Course
Page Link
Share On Social Media

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.

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

Show More

What Will You Learn?

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

Course Content

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