PC Skill

PCskill

4.88
(17 Ratings)

Excel Mastery Course

Categories: Excel course, Paid
Wishlist Share
Share Course
Page Link
Share On Social Media

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

Show More

What Will You Learn?

  • 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

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)

Excel MIS Beginner to Advance (28 Videos)

On Demand Videos

Trial Paper and Final Exam for Certificate

Student Ratings & Reviews

4.9
Total 17 Ratings
5
15 Ratings
4
2 Ratings
3
0 Rating
2
0 Rating
1
0 Rating
AC
3 months ago
Knowledgeable course.
AS
5 months ago
Best Course
RC
12 months ago
Very Good 👍👍
RR
1 year ago
Good
RY
2 years ago
nice course
AR
2 years ago
Course very helpful
K
2 years ago
sir bhut h best course h
RD
2 years ago
course content is so nice
PT
2 years ago
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...????????????????
TM
2 years ago
Good course
I request to arrange advance excel course
D
2 years ago
???? आदरणीय सर !
आप बहुत अच्छा जानकारी देकर पढाते हो ।
आप ने तो इसके लिए बहुत मेहनत ली है ।
इसके लिए आपको आदरयुक्त मनसे प्रणाम ।????
आप बहुत अच्छी सेवा दे रहे हो।
ईश्वर आप के इस ग्यानदान के सेवा के लिए आप को बहुत शक्ती दे यही शुभकामनाएँ ।
- धनाजी माने , इस्लामपूर (सांगली)
महाराष्ट्र
NS
2 years ago
thankyou for building confidence by learning this course.
sir note kaise milega
MK
2 years ago
Course is Good but Application platforms very slowl its feel Kamchalau
AV
3 years ago
5
AD
3 years ago
.