PC Skill

PCskill

Excel Mastery Course.

November 18, 2021
50h
117

rating:

4.67(3 Ratings)

Enrolment validity: Lifetime

Course Benefits

materials include

course content

Ratings & Reviews

course description

👉  हमारे सभी रोजगारपरक कोर्स पर पायें 50% की छूट कोर्स खरीदते समय कूपन वाले बॉक्‍स में टाइप करें Nov21 और पायें 50% की जबदस्‍त छूट 🔥

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 Powerquery 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

146 Lessons50h

MS Excel Advanced Course

1- Microsoft Excel Introduction00:10:55
2 – How to Work in Excel And Use Basic Formulas00:11:09
3- Use Clipboard Like Pro Full Explain00:11:57
4 – Organize Row Column And Worksheet00:08:47
5 – Data Entry Like Pro00:05:44
6 – Create Your Own Custom List00:06:31
07 – How Make Password your Excel File00:05:54
08 – How To Create a Backup Excel File00:06:01
09 – How to Use Sum Formula00:06:14
10 – How to Use Skip Blanks00:03:24
11 – Subtract, Multiple, Divide And Percentage00:07:58
12 – Use of Number Format in Excel00:11:15
13 – Use Conditional Formatting00:13:38
14 – How to Sort & Filter Data00:08:37
15 – Using Find and Replace and Using GoTo00:07:19
16 – How to Use Status Bar00:07:26
17 – Freeze Panes Option00:04:42
18 – Split Window00:07:27
19 – Fill Option00:10:50
20 – Flesh Fill00:08:10
21 – Pivot Table00:11:40
22 – All Table Option00:11:22
23 – Pictures Option00:11:37
24 – Use Shape00:12:24
25 – Use 3D Modal00:06:04
26 – Smart Art00:08:29
27 – Advanced Charts & Graph00:06:29
28 – People Graph00:03:19
29 – Create Hyperlinks00:07:46
30 – Header and Footer00:07:30
31 – Write, Insert, or Change an Equation00:04:27
32 – Using the Draw Tab00:03:24
33 – How to Use Themes00:04:46
34 – Complete Page Setup00:15:03
35 – Scale to Fit Setup00:04:45
36 – IF Formula00:05:20
37 – IF Formula With Multiple Conditions00:06:37
38 – Change Case and Round Figure Formula00:05:07
39 – VLOOKUP Formula00:06:48
40 – VLOOKUP Formula Examples00:16:30
41- HLOOKUP Formula00:05:50
42 – And Formula00:04:12
43 – Convert Number into Word Formula00:04:37
44 – Use Macros with Example00:08:13
45 – Subtotal Formula00:05:15
46 – Link Data in Excel Spreadsheets Formula00:02:58
47 – Data Consolidate Formula00:02:39
48 – Calculate Age With Date, Date If Formula00:05:39
49 – E-Date and Eo-Month Formula00:03:40
50 – Calculating Percent Formula00:03:14
51 – Superscript and Subscript Formula00:02:09
52 – Group Ungroup Subtotal Formula00:03:49
53 – Goal Seek Formula00:02:38
54 – PMT Formula00:03:03
55 – Goal With PMT Formula00:01:24
56 – Concat Formula00:06:24
57 – INDIRECT Formula00:03:26
58 – Match Formula00:04:34
59 – Count, Counta, Countblank Formula00:02:38
60 – EXACT Formula00:02:41
61 – Sumif Formula00:03:08
62 – Sumifs Formula00:07:25
63 – Round, RoundUp, RoundDown, MRound Formula00:06:58
64 – Array Formula00:05:28
65 – LEFT, RIGHT, MID, LEN & FIND Formula00:06:11
66 – Split Name Using LEFT, RIGHT, MID, LEN Formula00:04:06
67 – Mod Formula00:04:03
68 – Quotient Formula00:03:14
69 – Replace Formula00:03:43
70 – SUBSTITUTE Formula00:04:45
71- Excel Formula Error Types00:06:33
72 – SUMPRODUCT Formula00:04:38
73 – Text Formula00:03:29
74 – Double VLOOKUP Formula00:05:51
75 – Simple Interest Formula00:02:48
76 – Compound Interest Formula00:05:17
77 – Ceiling And Floor Formula00:03:53
78 – Index Formula00:02:13
79 – INDEX + MATCH Formula00:04:00
80 – Forecast Formula00:03:26
81 – Value Formula00:03:59
82 – Most Important Keyboard Shortcut00:10:42
83 – Employees Payroll and Salary Slip00:13:00
84 – Daily Stock Register00:08:39
85 – Dynamic Unit Converter00:06:00
86 – Dynamic Dropdown List00:08:52
87 – School Marksheet With Grade00:07:39
88 – Make Checklist & To Do List00:05:11
89 – Make Attendance Sheet00:07: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.7

Total 3 Ratings

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

Course is Good but Application platforms very slowl its feel Kamchalau

5

.

Hours
Minutes
Seconds

जल्दी कीजिये ऑफर कुछ ही घंटो के लिए है

हर कोर्स पर एक्‍सट्रा 🔥 50% डिकांडट पाने के लिये कूपन कोड में टाइप करें – Nov21

हर कोर्स पर एक्‍सट्रा 🔥 50% डिकांडट पाने के लिये कूपन कोड में टाइप करें - nov21