Excel Mastery Course

About Course

This Course Includes ▶️ 140+ Video Tutorials of Excel Beginners to advance, MIS in Excel as well as Excel Power Query after learning this course you will be master in excel. You will learn a complete practical work of Back office, Banking and corporate sector. This course is for ⌛ Lifetime Access Including ? Course Test and ? Course Completion Certificate with ▶️ Practical Videos of ⌚ 50+ Hours.

अगर आप एक्सेल में MASTER बनाना चाहते हो तो मै आपको ये कोर्स पैकेज सजेस्ट करूँगा एक्सेल मास्टरी कोर्स

Including 3 Excel Courses

Excel Beginners to Advance 90+ Videos
Excel MIS Course – 28 Videos
Excel Power Query Course – 27 Videos

Course Content

MS Excel Advanced Course

1- Microsoft Excel Introduction

10:56
2 – How to Work in Excel And Use Basic Formulas

11:10
3- Use Clipboard Like Pro Full Explain

11:57
4 – Organize Row Column And Worksheet

08:48
5 – Data Entry Like Pro

05:45
6 – Create Your Own Custom List

06:31
07 – How Make Password your Excel File

05:55
08 – How To Create a Backup Excel File

06:01
09 – How to Use Sum Formula

06:14
10 – How to Use Skip Blanks

04:37
11 – Subtract, Multiple, Divide And Percentage

07:57
12 – Use of Number Format in Excel

11:14
13 – Use Conditional Formatting

13:38
14 – How to Sort & Filter Data

08:37
15 – Using Find and Replace and Using GoTo

07:20
16 – How to Use Status Bar

07:27
17 – Freeze Panes Option

04:42
18 – Split Window

04:41
19 – Fill Option

10:51
20 – Flesh Fill

08:09
21 – Pivot Table

11:40
22 – All Table Option

11:23
23 – Pictures Option

11:36
24 – Use Shape

12:24
25 – Use 3D Modal

06:04
26 – Smart Art

08:28
27 – Advanced Charts & Graph

06:29
28 – People Graph

03:19
29 – Create Hyperlinks

07:45
30 – Header and Footer

07:30
31 – Write, Insert, or Change an Equation

04:27
32 – Using the Draw Tab

03:45
33 – How to Use Themes

04:46
34 – Complete Page Setup

15:03
35 – Scale to Fit Setup

04:45
36 – IF Formula

05:20
37 – IF Formula With Multiple Conditions

06:37
38 – Change Case and Round Figure Formula

04:37
39 – VLOOKUP Formula

06:49
40 – VLOOKUP Formula Examples

16:30
41- HLOOKUP Formula

05:49
42 – And Formula

04:12
43 – Convert Number into Word Formula

04:37
44 – Use Macros with Example

04:37
45 – Subtotal Formula

04:37
46 – Link Data in Excel Spreadsheets Formula

04:37
47 – Data Consolidate Formula

04:37
48 – Calculate Age With Date, Date If Formula

04:37
49 – E-Date and Eo-Month Formula

04:37
50 – Calculating Percent Formula

04:37
51 – Superscript and Subscript Formula

04:37
52 – Group Ungroup Subtotal Formula

04:37
53 – Goal Seek Formula

04:37
54 – PMT Formula

03:03
55 – Goal With PMT Formula

04:37
56 – Concat Formula

04:37
57 – INDIRECT Formula

04:37
58 – Match Formula

04:37
59 – Count, Counta, Countblank Formula

02:38
60 – EXACT Formula

04:37
61 – Sumif Formula

04:37
62 – Sumifs Formula

07:25
63 – Round, RoundUp, RoundDown, MRound Formula

06:58
64 – Array Formula

05:28
65 – LEFT, RIGHT, MID, LEN & FIND Formula

06:10
66 – Split Name Using LEFT, RIGHT, MID, LEN Formula

04:06
67 – Mod Formula

04:03
68 – Quotient Formula

03:14
69 – Replace Formula

03:43
70 – SUBSTITUTE Formula

04:45
71- Excel Formula Error Types

06:33
72 – SUMPRODUCT Formula

04:38
73 – Text Formula

03:28
74 – Double VLOOKUP Formula

05:50
75 – Simple Interest Formula

02:47
76 – Compound Interest Formula

05:17
77 – Ceiling And Floor Formula

03:52
78 – Index Formula

02:13
79 – INDEX + MATCH Formula

04:00
80 – Forecast Formula

03:26
81 – Value Formula

03:59
82 – Most Important Keyboard Shortcut

10:42
83 – Employees Payroll and Salary Slip

04:37
84 – Daily Stock Register

08:38
85 – Dynamic Unit Converter

06:00
86 – Dynamic Dropdown List

08:52
87 – School Marksheet With Grade

07:39
88 – Make Checklist & To Do List

05:11
89 – Make Attendance Sheet

07:19
90 – Student Database With Mail Merge

32:56

Excel Power Query Beginner to Advance (27 Videos)

1 – Power Query – Introduction and Installation

06:42
2 – Power Query – Create Connections with Excel Table

07:19
3 – Power Query – Create Connections with Text file and Access Database

09:23
4 – Power Query – Reconnect Data in Power Query

07:14
5 – Power Query – Create Pivot table on Text file data

07:31
6 – Power Query – Merge Multiple sheets using M Language

10:39
7 – Power Query – Create Pivot table on Multiple Sheets

04:26
8 – Power Query – Close and Load to Explain – Home tab – Query Group

07:31
9 – Power Query – Home Tab – Manage Column and Rows Group

11:05
10 – Power Query – Home Tab – Split Column into rows and columns

07:31
11 – Power Query – Home Tab – Group by using Basic and Advance Option

05:56
12 – Power Query – Home Tab – Data type & Replace Values

06:05
13 – Power Query – Transform data Dynamically

08:51
14 – Power Query – Combine 1000+Tables with 1 Function

07:11
15 – Power Query – Alternate options of Vlookup inside Power query

07:54
16 – Power Query – Multiple columns lookup

13:43
17 – Power Query – Remove Weekends and Holidays

04:37
18 – Power Query – Calculate Age with simple Method

04:48
19 – Power Query – Calculate Task Timings

05:00
20 – Power Query – Add Column Date Options in Detail

09:21
21 – Power Query – Time and Duration Options in Details

07:42
22 – Power Query – Transform Raw Data – Real Job Query

11:00
23 – Power Query – Few clicks to get Trim, Propercase and Merge Data

08:13
24 – Power Query – Merge Workbooks and Create Pivot

12:03
25 – PowerQuery – Merge Workbooks with File Name as Column

21:40
26 – PowerQuery – Raw Data to Pivot

13:07
27 – Power Query – Merge Vs Append

10:23

Excel MIS Beginner to Advance (28 Videos)

1- Pivot Table Introduction

04:37
2 – Pivot Table and Pivot Chart

11:06
3 – Design Tab of Pivot Chart

12:34
4- Slicer in Pivot Table & Slicer Settings

15:59
5 -Time Line in Pivot Table

11:03
6 – Get Pivot Data in Excel

23:28
7 – Pareto Chart in Excel

05:56
8 – INFOGRAPHIC CHART IN EXCEL

13:54
9 – Trend Chart using SumIFS Formula

20:51
10 – Map Chart using XY Scatter Chart

23:59
11- Key Performance Indicator in Excel

13:51
12 – Chart with Hyperlink

12:33
13 – Chart with Conditional Formatting

35:24
14 – Create Bar Charts with Pictures MIS Series

10:01
15 – Speedometer Chart in Excel

16:43
16 – See Saw Comparison Chart

17:20
17 – MIS – Hyperlink with Column and Pie-Chart

14:06
18 – MIS – Male, Female Comparison Chart

13:05
19 – Excel MIS – Create Dynamic Month Dashboard using Offset Formula

27:57
20 – Excel MIS – Create Dashboard on Day Wise Report

12:31
21 – Excel MIS – Sales Ranking Dashboard

21:40
22 – Excel MIS – Create Weekly Sales Dashboard using Listbox

18:29
23- MIS IN EXCEL – Daily Task Reminder Dashboard

22:16
24 – MIS IN EXCEL – Create Year wise report using Vlookup, Match, Index

14:58
25- MIS IN EXCEL- Create Dasboard Using VLOOKUP, INDEX, COUNTIF

19:38
26 – MIS – Amazing Dashboard

14:32
27 – MIS – Time Dashboard Project

23:27
28 – MIS – Gantt Chart with Conditional Formatting

09:04
Draft Lesson

09:04

PCskill

About Course

What Will You Learn?

Course Content

MS Excel Advanced Course

1- Microsoft Excel Introduction

2 – How to Work in Excel And Use Basic Formulas

3- Use Clipboard Like Pro Full Explain

4 – Organize Row Column And Worksheet

5 – Data Entry Like Pro

6 – Create Your Own Custom List

07 – How Make Password your Excel File

08 – How To Create a Backup Excel File

09 – How to Use Sum Formula

10 – How to Use Skip Blanks

11 – Subtract, Multiple, Divide And Percentage

12 – Use of Number Format in Excel

13 – Use Conditional Formatting

14 – How to Sort & Filter Data

15 – Using Find and Replace and Using GoTo

16 – How to Use Status Bar

17 – Freeze Panes Option

18 – Split Window

19 – Fill Option

20 – Flesh Fill

21 – Pivot Table

22 – All Table Option

23 – Pictures Option

24 – Use Shape

25 – Use 3D Modal

26 – Smart Art

27 – Advanced Charts & Graph

28 – People Graph

29 – Create Hyperlinks

30 – Header and Footer

31 – Write, Insert, or Change an Equation

32 – Using the Draw Tab

33 – How to Use Themes

34 – Complete Page Setup

35 – Scale to Fit Setup

36 – IF Formula

37 – IF Formula With Multiple Conditions

38 – Change Case and Round Figure Formula

39 – VLOOKUP Formula

40 – VLOOKUP Formula Examples

41- HLOOKUP Formula

42 – And Formula

43 – Convert Number into Word Formula

44 – Use Macros with Example

45 – Subtotal Formula

46 – Link Data in Excel Spreadsheets Formula

47 – Data Consolidate Formula

48 – Calculate Age With Date, Date If Formula

49 – E-Date and Eo-Month Formula

50 – Calculating Percent Formula

51 – Superscript and Subscript Formula

52 – Group Ungroup Subtotal Formula

53 – Goal Seek Formula

54 – PMT Formula

55 – Goal With PMT Formula

56 – Concat Formula

57 – INDIRECT Formula

58 – Match Formula

59 – Count, Counta, Countblank Formula

60 – EXACT Formula

61 – Sumif Formula

62 – Sumifs Formula

63 – Round, RoundUp, RoundDown, MRound Formula

64 – Array Formula

65 – LEFT, RIGHT, MID, LEN & FIND Formula

66 – Split Name Using LEFT, RIGHT, MID, LEN Formula

67 – Mod Formula

68 – Quotient Formula

69 – Replace Formula

70 – SUBSTITUTE Formula

71- Excel Formula Error Types

72 – SUMPRODUCT Formula

73 – Text Formula

74 – Double VLOOKUP Formula

75 – Simple Interest Formula