PC Skill

PCskill

4.71
(77 Ratings)

MS Excel Advanced Course

Categories: Microsoft Office, Paid
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

माइक्रोसॉफ्ट एक्‍सल को 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 तैयार किये जा सकते हैं
Show More

What Will You Learn?

  • 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

Course Content

Chapter 01 – Microsoft Excel Basic Knowledge

  • 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:47
  • 5 – Data Entry Like Pro
    05:45
  • 6 – Create Your Own Custom List
    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

On Demand Videos

Trial Paper and Final Exam for Certificate

Student Ratings & Reviews

4.7
Total 77 Ratings
5
59 Ratings
4
16 Ratings
3
1 Rating
2
0 Rating
1
1 Rating
PK
4 days ago
Bahut badhiya
RC
2 weeks ago
I really enjoyed learning Advanced Excel, it is a very good course.
RP
4 months ago
Explained in very easy language and manner. Thank you
JS
10 months ago
Nice course sir...
CP
10 months ago
Good E-learning platform & teaching technique simple and Easy
DS
10 months ago
Very Excellent guru ji.

Sir ji मेरा कोर्स पूर्ण हो गया है मुझे सर्टिफिकेट कहा से मिलेगा..
PS
11 months ago
Excellent way of teaching, I have learned so many things????Keep doing good things for students ???? Thanks Sir
RS
12 months ago
excellent
PK
1 year ago
Bahut Achha course hai mujhe bahut pasand aya????????
NV
1 year ago
Excellent course sir ????
KR
1 year ago
course Is Good, But Backend Support Is Not Available
DP
1 year ago
Thanks you sir
KA
1 year ago
Thank you sir ????
SK
1 year ago
thanks
VK
1 year ago
ABHI SIR AAPKE SMAJANE KA TARIKA BHUT HI ACCHA LGA
MG
1 year ago
Nice course
AS
1 year ago
GOOD COURSE
WT
1 year ago
Course was very much interesting and easy to understand. But I am having some problem in downloading my certificate. Can you please look under this..
PG
1 year ago
Excellent Course....
JS
1 year ago
Its Ok Ok.