PC Skill


MS Excel Advanced Course

August 20, 2021
10h 10m


4.67(15 Ratings)

Enrolment validity: Lifetime

Course Benefits

materials include

course content

Ratings & Reviews

course description

माइक्रोसॉफ्ट एक्‍सल को MS Excel नाम से भी जाना जाता है यह Microsoft Office Suite के साथ आने वाला Spread Sheet Program है Ms Excel में Data को Tabular Format में Open, Create, Edit, Format, Calculate किया जाता है इस कोर्स  में हम जानने वाले हैं कि Ms Excel क्‍या है और इसे कैसे उपयोग करते हैं केसे आप Ms Excel में विभिन्‍न फार्मूला लगाकर Report तैयार कर सकते हैं इसके साथ ही हम जानेंगे Ms Excel Use करने में किन Keyboard Shortcut Key का इस्‍तेमाल किया जाता है शुरू से लेकर आखिर तक यह कोर्स आपको एक जबरदस्त अनुभव प्रदान करेगा इस कोर्स को करने के बाद आपका एक्सेल के साथ एक जबरदस्त रिश्ता जुड़ जाएगा

अगर आपको Microsoft Excel चलाना आता है तो आप ऑफिस के कई घण्‍टों का काम मिनटों में कर सकते हैं Microsoft excel के अन्‍दर ढेर सारे Formulae दिये गये होते हैं जिसे किसी भी Spreadsheet पर Apply करने पर बडी जटिल Calculation भी मिनटों में Automatic तरीके से की जा सकती है इन Formulas को आप अगर एक बार Sheet में Save कर लेते हैं तो हर महीने Repeat होने वाले कामों को आप चुटकियों में तैयार कर सकते हैं Microsoft excel में बडी आसानी से Salary chart, Office employee, Database management, Billing Software, stock management Software तैयार किये जा सकते हैं

Course Benefits

  • Create Your Own Custom List
  • How Make Password your Excel File
  • How To Create a Backup Excel File
  • Use Sum Formula
  • Use Skip Blanks
  • Subtract
  • Multiple
  • Divide
  • Percentage
  • Use of Number Format in Excel
  • Use Conditional Formatting
  • Sort & Filter Data
  • Find and Replace and Using GoTo
  • Use Status Bar
  • Freeze Panes Option
  • Split Window
  • Fill Option
  • Flesh Fill
  • Pivot Table
  • Pictures Option
  • Use Shape
  • Use 3D Modal
  • Smart Art
  • Advanced Charts & Graph
  • People Graph
  • Create Hyperlinks
  • Header and Footer
  • Write Equation
  • Complete Page Setup
  • Scale to Fit Setup
  • IF Formula
  • Change Case Formula
  • Round Figure Formula
  • VLOOKUP Formula
  • HLOOKUP Formula
  • And Formula
  • Convert Number into Word Formula
  • Use Macros
  • Subtotal Formula
  • Data Consolidate Formula
  • Date If Formula
  • E-Date Formula
  • Eo-Month Formula
  • Percent Formula
  • Superscript Formula
  • Subscript Formula
  • Group Ungroup
  • Subtotal Formula
  • Goal Seek Formula
  • PMT Formula
  • Goal With PMT Formula
  • Concat Formula
  • INDIRECT Formula
  • Match Formula
  • Count Formula
  • Counta Formula
  • Countblank Formula
  • EXACT Formula
  • Sumif Formula
  • Sumifs Formula
  • Round Formula
  • RoundUp Formula
  • RoundDown Formula
  • MRound Formula
  • Array Formula
  • LEFT Formula
  • RIGHT Formula
  • MID Formula
  • LEN Formula
  • FIND Formula
  • Mod Formula
  • Quotient Formula
  • Replace Formula
  • SUBSTITUTE Formula
  • Formula Error Types
  • SUMPRODUCT Formula
  • Text Formula
  • Double VLOOKUP Formula
  • Simple Interest Formula
  • Compound Interest Formula
  • Ceiling Formula
  • Floor Formula
  • Index Formula
  • INDEX + MATCH Formula
  • Forecast Formula
  • Value Formula
  • Mail Merge
  • Dynamic Dropdown List
  • Dynamic Unit Converter
  • Daily Stock Register
  • Employees Payroll and Salary Slip

materials include

  • 90 पावरफुल ट्यूटोरियल्स
  • 90+ प्रैक्टिस फाइल
  • कोर्स सर्टिफिकेट

course content

91 Lessons10h 10m

Chapter 01 – Microsoft Excel Basic Knowledge

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

Chapter 02 – Password Protection & Backup

Chapter 03 – Basic Formula & Data Entry

Chapter 04 – Excel Home Tab Tutorial

Chapter 05 – Excel INSERT Tab Tutorial

Chapter 06 – Excel Draw Tab Tutorial

Chapter 07 – Excel Page Layout Tab Tutorial

Chapter 08 – Excel Advanced Formulas Part 1

Chapter 09 – Excel Advanced Formulas Part 2

Chapter 10 – Excel Advanced Formulas Part 3

Chapter 11 – Excel Advanced Formulas Part 4

Chapter 12 – Practical

Trial Paper and Final Exam for Certificate

Student Ratings & Reviews


Total 15 Ratings

1 rating
2 ratings
0 rating
1 rating
0 rating


Nice ???? sir आपके कोर्स के बारे मै जितना कहे उतना ही कम है कम फीस मै brand course

Very nice course ,presentation is excellent, some video on converting raw data to refined data is required.

Alhumdulillah i have completed course and also cleared Exams and i am certified with 90%

Great Course sirji

Thanks for your efforts

Nice course very good

Very nice course learned easily and very effective teaching skills and videos .thanks for giving such a excellent training.

Very nice session

Today I have enrolled in Excel course. I will try to complete each course and hopefully I will increase my command on excel.

????????????Super sir all excel video tutorial absolutely outstanding ????????????

Today I have completed this excel course and i learnt a lot of new things with practical. Thanks Sir for providing useful resources

Thank you so much i learned very well

Very nice course

Very good sir