Excel Mastery Course
rating:
Enrolment validity: Lifetime
Login
Course Benefits
materials include
course content
Ratings & Reviews
course description
अगले 48 घंटे सभी Online कोर्स पर 70% डिस्काउंट !!!!
कोर्स खरीदते समय टाइप करें COUPON CODE – PC Skill
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 Benefits
- Excel Beginners to Advance 150+ Videos
- Learn all formulas and Options of excel
- Excel MIS Course 27 Videos
- Create Dashboard, Reports and Charts
- Excel Powerquery Course 27 Videos
- Import and Transform Data
materials include
- Video Tutorials
- Practice Files
- Course Completion Certificate
- 25 Lessons
- Lifetime Access
course content
MS Excel Advanced Course
1- Microsoft Excel Introduction00:10:56
2 – How to Work in Excel And Use Basic Formulas00:11:10
3- Use Clipboard Like Pro Full Explain00:11:57
4 – Organize Row Column And Worksheet00:8:48
5 – Data Entry Like Pro00:5:45
6 – Create Your Own Custom List00:6:31
07 – How Make Password your Excel File00:5:55
08 – How To Create a Backup Excel File00:6:01
09 – How to Use Sum Formula00:6:14
10 – How to Use Skip Blanks00:3:24
11 – Subtract, Multiple, Divide And Percentage00:7:57
12 – Use of Number Format in Excel00:11:14
13 – Use Conditional Formatting00:13:38
14 – How to Sort & Filter Data00:8:37
15 – Using Find and Replace and Using GoTo00:7:20
16 – How to Use Status Bar00:7:27
17 – Freeze Panes Option00:4:42
18 – Split Window00:4:41
19 – Fill Option00:10:51
20 – Flesh Fill00:8:09
21 – Pivot Table00:11:40
22 – All Table Option00:11:23
23 – Pictures Option00:11:36
24 – Use Shape00:12:24
25 – Use 3D Modal00:6:04
26 – Smart Art00:8:28
27 – Advanced Charts & Graph00:6:29
28 – People Graph00:3:19
29 – Create Hyperlinks00:7:45
30 – Header and Footer00:7:30
31 – Write, Insert, or Change an Equation00:4:27
32 – Using the Draw Tab00:3:45
33 – How to Use Themes00:4:46
34 – Complete Page Setup00:15:03
35 – Scale to Fit Setup00:4:45
36 – IF Formula00:5:20
37 – IF Formula With Multiple Conditions00:6:37
38 – Change Case and Round Figure Formula00:5:07
39 – VLOOKUP Formula00:6:49
40 – VLOOKUP Formula Examples00:16:30
41- HLOOKUP Formula00:5:49
42 – And Formula00:4:12
43 – Convert Number into Word Formula4:37
44 – Use Macros with Example00:8:13
45 – Subtotal Formula00:5:14
46 – Link Data in Excel Spreadsheets Formula00:2:58
47 – Data Consolidate Formula00:2:39
48 – Calculate Age With Date, Date If Formula00:5:39
49 – E-Date and Eo-Month Formula00:3:40
50 – Calculating Percent Formula00:3:13
51 – Superscript and Subscript Formula00:2:08
52 – Group Ungroup Subtotal Formula00:3:49
53 – Goal Seek Formula00:2:38
54 – PMT Formula00:3:03
55 – Goal With PMT Formula00:1:24
56 – Concat Formula00:6:24
57 – INDIRECT Formula00:3:26
58 – Match Formula00:4:34
59 – Count, Counta, Countblank Formula00:2:38
60 – EXACT Formula00:2:42
61 – Sumif Formula00:3:08
62 – Sumifs Formula00:7:25
63 – Round, RoundUp, RoundDown, MRound Formula00:6:58
64 – Array Formula00:5:28
65 – LEFT, RIGHT, MID, LEN & FIND Formula00:6:10
66 – Split Name Using LEFT, RIGHT, MID, LEN Formula00:4:06
67 – Mod Formula00:4:03
68 – Quotient Formula00:3:14
69 – Replace Formula00:3:43
70 – SUBSTITUTE Formula00:4:45
71- Excel Formula Error Types00:6:33
72 – SUMPRODUCT Formula00:4:38
73 – Text Formula00:3:28
74 – Double VLOOKUP Formula00:5:50
75 – Simple Interest Formula00:2:47
76 – Compound Interest Formula00:5:17
77 – Ceiling And Floor Formula00:3:52
78 – Index Formula00:2:13
79 – INDEX + MATCH Formula00:4:00
80 – Forecast Formula00:3:26
81 – Value Formula00:3:59
82 – Most Important Keyboard Shortcut00:10:42
83 – Employees Payroll and Salary Slip00:13:00
84 – Daily Stock Register00:8:38
85 – Dynamic Unit Converter00:6:00
86 – Dynamic Dropdown List00:8:52
87 – School Marksheet With Grade00:7:39
88 – Make Checklist & To Do List00:5:11
89 – Make Attendance Sheet00:7:19
90 – Student Database With Mail Merge00:32:56
Excel Power Query Beginner to Advance (27 Videos)
1 – Power Query – Introduction and Installation00:6:42
2 – Power Query – Create Connections with Excel Table00:7:19
3 – Power Query – Create Connections with Text file and Access Database00:9:23
4 – Power Query – Reconnect Data in Power Query00:7:14
5 – Power Query – Create Pivot table on Text file data00:7:31
6 – Power Query – Merge Multiple sheets using M Language00:10:39
7 – Power Query – Create Pivot table on Multiple Sheets00:4:26
8 – Power Query – Close and Load to Explain – Home tab – Query Group00:7:31
9 – Power Query – Home Tab – Manage Column and Rows Group00:11:05
10 – Power Query – Home Tab – Split Column into rows and columns00:7:31
11 – Power Query – Home Tab – Group by using Basic and Advance Option00:5:56
12 – Power Query – Home Tab – Data type & Replace Values00:6:05
13 – Power Query – Transform data Dynamically00:8:51
14 – Power Query – Combine 1000+Tables with 1 Function00:7:11
15 – Power Query – Alternate options of Vlookup inside Power query00:07:54
16 – Power Query – Multiple columns lookup00:13:43
17 – Power Query – Remove Weekends and Holidays00:10:27
18 – Power Query – Calculate Age with simple Method00:04:48
19 – Power Query – Calculate Task Timings00:05:00
20 – Power Query – Add Column Date Options in Detail00:09:21
21 – Power Query – Time and Duration Options in Details00:07:42
22 – Power Query – Transform Raw Data – Real Job Query00:11:00
23 – Power Query – Few clicks to get Trim, Propercase and Merge Data00:08:13
24 – Power Query – Merge Workbooks and Create Pivot00:12:03
25 – PowerQuery – Merge Workbooks with File Name as Column00:21:40
26 – PowerQuery – Raw Data to Pivot00:13:07
27 – Power Query – Merge Vs Append00:10:23
Excel MIS Beginner to Advance (28 Videos)
1- Pivot Table Introduction00:17:59
2 – Pivot Table and Pivot Chart00:11:06
3 – Design Tab of Pivot Chart00:12:34
4- Slicer in Pivot Table & Slicer Settings00:15:59
5 -Time Line in Pivot Table00:11:03
6 – Get Pivot Data in Excel00:23:28
7 – Pareto Chart in Excel00:5:56
8 – INFOGRAPHIC CHART IN EXCEL00:13:54
9 – Trend Chart using SumIFS Formula00:20:51
10 – Map Chart using XY Scatter Chart00:23:59
11- Key Performance Indicator in Excel00:13:51
12 – Chart with Hyperlink00:12:33
13 – Chart with Conditional Formatting00:35:24
14 – Create Bar Charts with Pictures MIS Series00:10:01
15 – Speedometer Chart in Excel00:16:43
16 – See Saw Comparison Chart00:17:20
17 – MIS – Hyperlink with Column and Pie-Chart00:14:06
18 – MIS – Male, Female Comparison Chart00:13:05
19 – Excel MIS – Create Dynamic Month Dashboard using Offset Formula00:27:57
20 – Excel MIS – Create Dashboard on Day Wise Report00:12:31
21 – Excel MIS – Sales Ranking Dashboard00:21:40
22 – Excel MIS – Create Weekly Sales Dashboard using Listbox00:18:29
23- MIS IN EXCEL – Daily Task Reminder Dashboard00:22:16
24 – MIS IN EXCEL – Create Year wise report using Vlookup, Match, Index00:14:58
25- MIS IN EXCEL- Create Dasboard Using VLOOKUP, INDEX, COUNTIF00:19:38
26 – MIS – Amazing Dashboard00:14:32
27 – MIS – Time Dashboard Project00:23:27
28 – MIS – Gantt Chart with Conditional Formatting00:10:46
Draft Lesson9:04
Trial Paper and Final Exam for Certificate
Trial Paper For Final Exam00:00:00
Final Exam for Certificate
Student Ratings & Reviews
4.5
Total 10 Ratings
Pankaj Thakur
1 month ago
5 out of 5 (Review by phone)
KHILENDRA DAS MANIKPURI
1 month ago
In this all course I can learn a lot of knowledge in your course ... This is very simple and very useful vedio..your vedio is increasing my excel knowlege it is fullfill my need .... Thanku so much Abhimanyu sir and very thanks to Satish sir ... You both are very good teacher know one can teach like this you ..Thanku so much...🙏🏻🙏🏻
Tulshidas Morye
3 months ago
Good course
I request to arrange advance excel course
🙏 आदरणीय सर !
आप बहुत अच्छा जानकारी देकर पढाते हो ।
आप ने तो इसके लिए बहुत मेहनत ली है ।
इसके लिए आपको आदरयुक्त मनसे प्रणाम ।🙏
आप बहुत अच्छी सेवा दे रहे हो।
ईश्वर आप के इस ग्यानदान के सेवा के लिए आप को बहुत शक्ती दे यही शुभकामनाएँ ।
- धनाजी माने , इस्लामपूर (सांगली)
महाराष्ट्र
Narendra Singh
4 months ago
thankyou for building confidence by learning this course.
harshavardhan Chauhan
5 months ago
sir note kaise milega
MUKESH KUMAR SINGH
6 months ago
Course is Good but Application platforms very slowl its feel Kamchalau
Ankush Verma
7 months ago
5
Abhash Dubey
8 months ago
.