PC Skill

PCskill

Excel Mastery Course

May 16, 2022
50h
332

rating:

4.50(10 Ratings)

Enrolment validity: Lifetime

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

147 Lessons50h

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)

Excel MIS Beginner to Advance (28 Videos)

Trial Paper and Final Exam for Certificate

Student Ratings & Reviews

4.5

Total 10 Ratings

5
1 rating
4
1 rating
3
0 rating
2
0 rating
1
1 rating

Were is the practice data

5 out of 5 (Review by phone)

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...🙏🏻🙏🏻

Good course
I request to arrange advance excel course

🙏 आदरणीय सर !
आप बहुत अच्छा जानकारी देकर पढाते हो ।
आप ने तो इसके लिए बहुत मेहनत ली है ।
इसके लिए आपको आदरयुक्त मनसे प्रणाम ।🙏
आप बहुत अच्छी सेवा दे रहे हो।
ईश्वर आप के इस ग्यानदान के सेवा के लिए आप को बहुत शक्ती दे यही शुभकामनाएँ ।
- धनाजी माने , इस्लामपूर (सांगली)
महाराष्ट्र

thankyou for building confidence by learning this course.

sir note kaise milega

Course is Good but Application platforms very slowl its feel Kamchalau

5

.

Hours
Minutes
Seconds

😊 समर कैम्‍प ऑफर कोर्स खरीदते समय टाइप करें COUPON CODE - pC skill

अगले 48 घंटे पायें 70% का डिस्‍कांउट

🔥 अगले 48 घंटे सभी Online कोर्स पर 70% डिस्काउंट !!!!

कोर्स खरीदते समय टाइप करें COUPON CODE – PC SKILL

Call - 7217294034