Md's profile and their contact details have been verified by our experts
Md
- Price $7
- Answer 1h
$7/h
More Microsoft Excel teachers
This teacher is currently unavailable
- Microsoft Excel
CERTIFIED MS EXCEL EXPERT || Classes in BENGALI, ENGLISH & HINDI || EXCEL MASTERCLASS: Beginner to Advanced (180 Lessons in 19 days) || Complex Formulas Explained In EASY Language || EXCERCISE FILES
- Microsoft Excel
Lesson location
About Md
I am an expert in Microsoft Excel and train Excel from Beginner to Advanced in LIVE classes . With a focus on efficiency and practical learning, I can help you master Excel's functionalities quickly and effectively. I've the experience of teaching students in very effective way.
Nowadays, Excel is one of the most demanding skills in the Corporates.
Businesses need Excel Experts to analyse their business and you can even get a high paying job by mastering the Excel. Even you can do freelancing and earn through excel.
So, what are you waiting for.
Unlock the full potential of Excel with my comprehensive training -"Excel Masterclass : Beginner to Advanced.". From this beginner to advanced Course, gain practical skills for increased productivity and data analysis. Join us now to become an Excel expert. Enroll today!
Other Experiences -
1. Taught, Motivated Students
2. Public Speaker
3. Conducted Webinars
4. Conducted Students Career Counseling
see more
About the lesson
- All Levels
- English
All languages in which the lesson is available :
English
Here's how I generally teach.
Master Microsoft Excel from Beginner to Advanced.
What you'll learn...
1. Learn all about syntax, arguments and logic.
2. How to create custom and nested functions.
3. Learn the fastest and smartest ways of cleaning the raw data
4. Create dynamic reports by mastering one of the most popular tools, PivotTables.
5. Learn which chart/graph to use and when.
6. How to automate repetitive tasks in Excel using Macros.
7. Learn various 'must have' Excel shortcuts.
8. Learn how to manage heavy Excel files.
9. Amazing Bonus tricks that save tons of time and effort.
This Course will include
1. Live ZOOM Classes
2. Recordings of the Previous Classes (In case You Can't Attend LIVE Classes)
4. One Live QnA Session every Week to clear all your doubts
5. Downloadable Excel Files for Practice
6. Access on Laptop, mobile and TV
Course Duration - 21-28 days (can be customized accordingly)
Language - Hindi, English, Bengali, Urdu (Any Language Preferred by Student)
Here is my Detailed Course Plan and Chapters
1. EXCEL FROM SCRATCH
Touring the interface
Enter data & saving the workbook
Applying Formulas
Changing a worksheet's structure
Find, Replace & Spell Check
Applying fonts, background colors, and borders
Formatting numbers and dates
Making the pieces fit
Inserting headers & footers and Repeating Rows
Managing Large Workbooks
Quiz 1
2. EXCEL ESSENTIALS
Formula Writing (Don't Miss This)
Exercise of Formula Writing (Don't Miss This)
Excel Files for practice(Please Download)
Quiz 2
3. SUM COUNT AVERAGE FUNCTIONALITY (WITH CONDITIONS)
SumIf & SumIfs
Exercise of SumIf & SumIfs
Count Functions
Exercise of Count Functions
AverageIf & AverageIfs
Exercise of AverageIf & AverageIfs
Excel files for practice (Please Download)
4. TEXT FUNCTIONS (MANIPULATING TEXT)
Change Case (Upper, Lower, Proper)
Exercise of Change Case (Upper, Lower, Proper)
Separating Text on Symmetrical Data
Exercise of Separating Text on Symmetrical Data
Separating Text on Non-Symmetrical Data
Exercise of Separating Text on Non-Symmetrical Data
Excel Files for Practice (Please Download)
5. LOGICAL FUNCTIONS (WORKING WITH CONDITIONS)
If Functionality
Ex IF Functionality
If with AND
Ex If with AND
If with OR
Ex If with OR
If with AND & OR, IF with Countif
Ex If with AND & OR
Nested If (A Genie with 3 wishes)
Ex Nested If
Excel Files for Practice(Please Download)
6. LOOKUP FUNCTIONALITY (BURN SIMPLE FIND TECHNIQUE)
Vlookup (Exact Match) # 1
Exercise Vlookup (Exact Match) # 1
Type of References (Use of $ Sign)
Vlookup (Exact Match) # 2
Exercise Vlookup (Exact Match) #2
Double Vlookup
Exercise Double Vlookup
Vlookup on Duplicate Values
Exercise Vlookup on Duplicate Values
Vlookup (Approximate Match)
Exercise Vlookup (Approximate Match)
Vlookup with IF (Conditional Vlookup)
Exercise Vlookup with IF (Conditional Vlookup)
Hlookup (Exact Match)
Exercise Hlookup (Exact Match)
Hlookup (Approximate Match)
Exercise Hlookup (Approximate Match)
Lookup (Don't Use This)
Exercise Lookup (Don't Use This)
Vlookup & Match (Create magical Vlookup)
Exercise Vlookup & Match ( Create a Magical Vlookup)
Match (Gives us Column & Row Number)
Exercise Match (Gives us Column & Row Number)
Index & Match (Made for each other)
Exercise number 1 of Index & Match (Made for each other)
Exercise number 2 of Index & Match (Made for each other)
Excel Files for Practice (Please Download)
7. DATE & TIME FUNCTION (A TRICKY GAME)
How Excel Records Date & Timer
Now, Today & Autofill
DateValue & TimeValue
Calculate WorkingDays
DatedIf
Excel Files for Practice (Please Download)
8. FINANCIAL FUNCTIONS (USEFUL FOR NON-FINANCE GUYS TOO)
Loan Calculation (PMT, PPMT, IPMT etc.)
Ex Loan Calculation (PMT, PPMT, IPMT etc.)
Creating a Loan Table
Ex Creating a Loan Table
Calculate Depreciation
Ex Calculate Depreciation
Excel Files for practice (Please Download)
9. SORT & FILTER (COMMON FOR ALL)
Basic Sorting & Shortcut keys
Ex Basic Sorting & Shortcut Keys
Sorting Using Custom List
Ex Sorting Using Custom List
Horizontal Sorting
Ex Horizontal Sorting
Basic Filter & Shortcut Keys
Ex Basic Filter & Shortcut Keys
Filter Problem # 1 (Copy Filtered Data without hidden rows)
Ex Filter Problem # 1 (Copy Filtered Data without hidden Rows)
Filter Problem # 2 (Pasting Values on Filtered Data)
Ex Filter Problem # 2 (Pasting Values on Filtered Data)
Filter Problem # 3 (Performing Calculation on Filtered Data)
Ex Filter Problem # 3 (Perform Calculations on Filtered Data)
Advanced Filter (Using Complex Criteria)
Ex Advanced Filter (Using Complex Criteria)
Excel Files for Practice (Please Download)
10 EXCEL CHARTS (ITS TIME FOR VISUAL PRESENTATION)
1. Excel Charts Introduction
2 How to Create a Chart
3 Link a Chart Title
4 How to Show Axis Title
5 How to Show Data Label
6 Column Chart
7 Bar Chart
8 Line Chart 1
9 Line Chart 2
10 Area Chart
11 Pie Chart
12 Pie of Pie or Bar of Pie
13 Line Chart with Log Scale
14 Bubble Chart
15 Selecting Chart Elements
16 Use of Format Dialog box
17 Modifying Chart & Plot Area
18 Modifying Data Series
19 How to handle Missing Data
20 Modifying 3-D Charts
21 Creating Chart Templates
22 Creating Picture Charts
23 Creating a Combination of upto 5 Different Charts
24 Show data with the chart in Data Table
25 Play with the Design & Layout of the Chart
Excel Files for Practice (Please Download)
11 DATA CONSOLIDATION (MULTIPLE WORKBOOKS WORKSHEETS)
Consolidate Data using Excel Inbuilt Function
Ex Consolidate data using Excel Inbuilt Function
Excel Files for Practice (Please Download)
12 DATA VALIDATION
Applying Data Validation
Ex Applying Data validation
Dependent Dropdown List
Ex Dependent Dropdown List
Using Data Validation with Vlookup & Match
Other Data Validation Examples
Excel Files for Practice (Please Download)
13 PROTECTION OF WORKSHEET WORKBOOK
Worksheet Level Protection
Ex Worksheet Level Protection
Cell Level Protection
Ex Cell Level Protection
Hiding Formulas from Formula Bar
Ex Hiding Formulas from Formula Bar
Protecting Workbook Structure
Ex Protecting Workbook Structure
Workbook Level Protection
Ex Workbook Level Protection
Excel Files for Practice (Please Download)
14 PIVOT TABLE & TECHNIQUES
Understanding pivot Table
Using Pivot Table in Real Scenario
Ex Using Pivot Table in Real Scenario
Grouping in Pivot Table
Ex Grouping in Pivot Table
Using Slicers (A Visually attractive Filter)
Ex Using Slicers (A Visually attractive Filter)
Excel Files for Practice (Please Download)
15 WHAT-IF ANALYSIS & SOLVER ADD-IN
Goal Seek (A Reverse Approach)
Ex Goal Seek (A Reverse Approach)
One-Way Data Table
Two-Way Data Table
Scenario Manager
Solver Add-In
Excel Files for Practice (Please Download)
16 AUTOMATION IN EXCEL (MACROS)
Record your first Macro
Record Another Macro
Assigning Macros to a Shape, Button, Picture
Editing or Deleting a Macro
Security Settings of a Macro
Excel Files for Practice (Please Download)
17. New Video Tutorials
*How to create a Map Chart in Excel
*How to use the Forecast sheet in Excel
*Excel Files for Practice (Please Download)
18. New Chapter - Conditional Formatting
*Highlight cells rules
*Top Bottom Rules
*Data Bars
*Color Scales
*Icon Sets
*Function based Conditional Formatting
*Exercise files for practice (please download)
19. Bonus Videos (In Hindi)
*Why my excel file size is huge and how to reduce Excel file size
*Problem of unwanted names when we create a copy of the sheet in Excel
*New chart types in Excel 2019/Office 365 || Map Chart || Funnel Chart
*How do you change the number format in Excel?
Types of Errors in Excel and How to resolve them
Excel Files for Practice (Please Download)
Let's discuss your specific needs and schedule a session at your convenience.
Best regards,
Md Khalid
see more
Recommendations
Recommendations come from relatives, friends and acquaintances of the teacher
1
I know him personally as he taught me. He is so good at teaching that I easily learned the complex formulas.
View more recommendations
see more
Rates
Price
- $7
Pack prices
- 5h: $36
- 10h: $73
online
- $7/h
Similar Microsoft Excel tutors in Kolkata
Erica
Fairfield & online
- $60/h
Neha
Sydney & online
- $65/h
Ahsan
Woodville North & online
- $80/h
- 1st lesson free
Tina
& online
- $55/h
- 1st lesson free
Andrea
Sydney & online
- $200/h
Amanda Yukari
Manunda & online
- $35/h
- 1st lesson free
Jabran
Hornsby & online
- $30/h
Humberto
Ravensdale & online
- $40/h
- 1st lesson free
Madhawa
Parklea & online
- $100/h
Tran
Sydney & online
- $35/h
- 1st lesson free
Sami
Sydney & online
- $35/h
Vaibhav
Adelaide & online
- $26/h
- 1st lesson free
Muhammad
Austral & online
- $10/h
- 1st lesson free
M Fouze
Tarneit & online
- $75/h
Johnson
Sydney & online
- $22/h
- 1st lesson free
Mal
Brisbane & online
- $35/h
- 1st lesson free
Dr Vijay Reena
Kensington & online
- $79/h
Upeksha
Holden Hill & online
- $30/h
Aashir
Austral & online
- $10/h
- 1st lesson free
Vishwajeet
Blacktown & online
- $45/h
- 1st lesson free
-
More Microsoft Excel teachers
