×

×

Md. Ariful Islam Bhuiyan ACMA
Course Level
Advanced
Duration
Duration 5 hrs 33 min
Rating
Rating 3.8
Students
Students 67

Mastering Microsoft Excel

Welcome to the Microsoft Excel Masterclass, guided by the expert instructor Md. Ariful Islam Bhuiyan is a distinguished professional trainer with a track record of enlightening over 2000 professionals in the realm of Microsoft Excel. This masterclass is tailored for individuals with a basic understanding of Excel, aiming to elevate their skills to an advanced level.
Instructor: Md. Ariful Islam Bhuiyan.

This Microsoft Excel Masterclass is not just a series of lectures; it's a hands-on journey through the intricacies of Excel, led by an expert who has navigated its depths. The course is designed for those who already possess a foundational knowledge of Excel but aspire to delve into its advanced features and unlock the true potential of this powerful tool.


What You'll Learn:

  • Advanced Formulas: Explore practical applications of Paste Special, Sum Functions, Count Functions, Logical Functions, and more.
  • Data Management: Grasp the art of sorting, advanced filtering, and conditional formatting for efficient data handling.
  • Data Validation: Implement decimal, list, date, and time validations with conditional criteria.
  • Protection and File Formats: Secure your work with protection techniques and understand various file formats.
  • Advanced-Data Analysis: Dive into array formulas for complex calculations and effective error management.
  • Visual Representations: Learn to create insightful charts, pivot tables, and tables for data visualization.


Course Resources:

  • Excel templates enriched with real company data
  • Practical reports and analyses
  • Access to a variety of tools and functions
  • Step-by-step guidance from an Excel professional


Who Should Enroll:

  • Excel users with basic proficiency seeking advanced skills
  • Professionals aiming to streamline data analysis and reporting
  • Individuals aspiring to master Excel for enhanced productivity


Why Enroll:

Why should you join the Microsoft Excel Masterclass? It's not just about learning; it's about gaining real expertise. Imagine unlocking the full power of Microsoft Excel with an instructor who doesn't just teach but empowers you to excel in every aspect.

Embark on the Microsoft Excel Masterclass today and transform your Excel skills. This isn't just another course – it's your gateway to revolutionizing how you use Excel. Your journey to advanced proficiency is just a click away. Join now!
 

Complete This Course and Get Your certificate!
Certify Your Skills

Lead Academy accredited certifies the skills you’ve learned

Stand Out From The Crowd

Add your Lead Certification to your resume and stay ahead of the competition

What Will I Learn?
  • Formula Mastery
  • Data Manipulation
  • Advanced Functions
  • Data Validation
  • Advanced Filtering
  • Pivot Table Mastery
  • Visualization Skills
  • Array Formulas
Course content
  • 1 Chapters
  • 22 Lessons
  • 5 hrs 33 min

Course Overview

Free Preview 00:03:39

Data Introduction

Free Preview 00:07:09

Database Introduction

00:18:49

Name Manager

00:11:44

Data Validation

00:21:20

Excel File Protection

00:10:28

Excel File Formats

00:04:20

SUMIFS Function

00:11:53

Sales Report

00:21:48

Excel Sum Product

00:09:43

Count Function

00:20:01

Text Functions

00:18:02

Lookup and Reference Functions

00:32:56

Financial Functions

00:10:15

Statistical Functions

00:07:31

Round Functions

00:07:19

Excel Formula Errors

00:06:38

Excel Charts

00:20:38

Excel Pivot Tables

00:20:04

Excel Pivot Tables - Part 2

00:20:54

Excel Tables

00:21:47

VBA

00:26:48
Quiz

Final Quiz

Pre Requisites
  • Basic Computer Skill
  • Keep video resolution at 1080p
  • A computer
Meet Your Instructor

Md. Ariful Islam Bhuiyan ACMA

Professional Management Accountant
3.8 Instructor Rating
5 Reviews
67 Students
1 Course

As a seasoned professional with extensive expertise in Microsoft Excel, I am passionate about empowering professionals and organizations to maximize their efficiency through advanced Excel skills. With over 10 years of experience in Accounts & Finance, I have developed a deep understanding of how Excel is a powerful tool for data analysis, financial reporting, and process automation.

Having trained numerous teams and individuals, I focus on practical, hands-on learning that enhances productivity and decision-making. I specialize in Excel functions, pivot tables, data visualization, Power Query, Power BI, and VBA to help professionals unlock the full potential of this versatile tool. My training programs are tailored to meet the specific needs of different industries, ensuring participants can directly apply their learning to their day-to-day work.

Whether you want to improve team efficiency, automate reporting processes, or boost your analytical capabilities, I am dedicated to providing top-quality Excel training that drives results.

Review
3.8
Fariha Bhuiyan Erin

Fariha Bhuiyan Erin

2 months ago

There are only 3 files available in course resources..From where do i find the files mentioned in tutorials for practice purpose?

Shahadat Safait Hossain

Shahadat Safait Hossain

3 months ago

Reply from Shahadat Safait Hossain

3 months ago

Why can't I find any attached excel files with the videos as instructor said?

Zauad - Bin - Zahir

Zauad - Bin - Zahir

3 months ago

Shamima Afroz

Shamima Afroz

7 months ago

Why I can't go to the next lecture....

Reply from Instructor

Dear Learner, this might be a technical issue. We looked into it and solved it. Can you please try again?

Toufiqul Alam

Toufiqul Alam

8 months ago

Lesson exercise materials is not available.

Reply from Instructor

Dear Learner, Please try to to find the exercise materials in the "Resource File" and "Lesson Exercise Materials" sections. Thank you.

Total Price

BDT 1200 ৳1500

Buy Now

Helpline 01894988285

Secured with SSL

Hotline 1: +88 01894988285

Hotline 2: +88 01896177223

Pay with
© 2021 - 2024 Lead Academy, All Rights Reserved. Made with in Bangladesh.
App Version : v2024.1.8.2