User Name

REDAPPLE TALKS

Excel 151 Mastery Course

The “Excel 170+ Shortcut Key Course” is a comprehensive guide to mastering Excel using quick and efficient keyboard shortcuts. This course is perfect for anyone who wants to boost their productivity and save time while working in Excel.
Whether you’re a beginner or an experienced Excel user, this course will help you take your skills to the next level and become a more efficient and effective Excel user.

Overall, this course is an excellent resource for anyone who wants to improve their Excel skills and work more efficiently with shortcut keys.

Original price was: ₹50,000.00.Current price is: ₹45,000.00.

Category Tag

Description

About Course

🚀 Get Started…

This is a comprehensive course on MS Excel 2021 that covers over 150+ functions. The course is designed in Hindi language for ease of understanding and accessibility.

The course covers various functions such as Lookup Function, Loan Function, Financial Function, Sum Function and many more. These functions are essential for working with data in Excel and can help simplify complex tasks.

The Lookup Function allows you to search for specific data within a table or range. The Loan Function helps you calculate payments and interest rates for loans. The Financial Function is useful for financial analysis and calculations, while the Sum Function is a basic function that allows you to add up a range of cells.

Overall, this course is an excellent resource for anyone who wants to improve their Excel skills and work more efficiently with data.

 

Week 1

  • Introduction of Excel
  • Basic Fundaments of Function
  • Sum, Max, Maxa, Min & Mina Function
  • Row, Column, Rows & Columns Function
  • Count, Counta & Average Function
  • Lower, Upper & Proper Function
  • Date, Day, Month & Year Function
  • Time, Hour, Minute & Second Function
  • Power, Int & Abs Function
  • Len, Mod & Rept Function
  • Dollar, Edate, Eomonth & Countblank Function
  • Datevalue, Roman & Arabic Function

Week 2

  • Code, Char & Clean Function
  • Odd, Even, Isodd & Iseven Function
  • Fact, Gcd & Exact Function
  • Large & Small Function
  • Left, Right & Lcm Function
  • Round, Roundup & Rounddown Function
  • Sumproduct Function
  • Mround, Floor & Ceiling Function
  • SLN, DB, DDB, VDB & SYD Function
  • PMT, PPMT & IPMT Function

Week 3

  • Degress, Radians & Yearfrac Function
  • Today, Now, Trim & Sumsq Function
  • Filter Function
  • Minifs & Maxifs Function
  • Convert Function
  • SIN, COS, TAN, COT, SEC & CSC Function
  • NPER & RATE Function
  • Rand, Randbetween & Rand Array Function
  • SQRT, Median & Transpose Function
  • Formulatext, Find & Quotient Function

Week 4

  • Sumif, Countif & Averageif Function
  • Sumifs, Countifs & Averageifs Funtion
  • Substitute & Replace Function
  • Concat & Textjoin Function
  • Isnumber, Isblank, Iserror & Istext Function
  • Isformula, Isref, Isna & Iserr Function
  • Isnontext, Isodd, Iseven & Islogical Function
  • Ispmt Function
  • Value, Delta, N & T Function
  • Datedif Function

Week 5

  • Offset Function
  • IF, And, Or & Not Function
  • Dmin & Dmax Function
  • Dcount & Dcounta Function
  • Dsum & Dproduct Function
  • Daverage & Dget Function
  • Stdev & Stdevp Function
  • Stdev.s & Stdev.p Function
  • FV & PV Function

Reviews

There are no reviews yet.

Be the first to review “Excel 151 Mastery Course”

Your email address will not be published. Required fields are marked *