Home └Microsoft Excel: Advanced Excel and Formulas
Microsoft Excel: Advanced Excel and Formulas

Microsoft Excel: Advanced Excel and Formulas

Master Microsoft Excel with our Advanced Excel and Formulas course. Learn powerful functions, data analysis tools, pivot tables, conditional formatting, and advanced formulas to boost productivity and make smarter data-driven decisions. Ideal for professionals seeking to enhance their Excel skills for business, finance, and analytics.

₹ 999.00
999.0 INR ₹ 999.00
₹ 999.00
Buy Now
Add to Cart
Responsible Contemporary Learning
Last Update 16/06/2025
Completion Time 3 hours 44 minutes
Members 1
  • Excel Formulas 101
    10Lessons · 1 hr 28 mins
    • Introduction Excel Formulas 101
      Free Preview New
    • Excel Formula Syntax
      New
    • Writing Efficient Formulas with Fixed & Relative References
      New
    • Common Excel Error Types
      New
    • Formula Auditing Trace Precedents & Dependents
      New
    • Navigating Excel Worksheets with Ctrl Shortcuts
      New
    • Saving Time with Function Shortcuts
      New
    • Accessing Tools with Alt Key Tips
      New
    • PRO TIP Creating Drop Down Menus with Data Validation
      New
    • Congrats, You're a Developer!
      New
  • Conditional Statements & Logical Operators
    7Lessons · 30 mins
    • Conditional Statements & Logical Operatars Introduction
      New
    • Anatomy of the IF Statement
      New
    • Nesting Multiple IF Statements
      New
    • Adding Conditional ANDOR Operators
      New
    • Using NOT & Conditionals
      New
    • Fixing Errors with IFERROR
      New
    • Common IS Statements
      New
  • Common Excel Statistical Functions
    7Lessons · 45 mins
    • Common Excel Statistical Functions Introduction
      New
    • Basic Excel Statistical Functions
      New
    • Extracting Values with SMALLLARGE & RANKPERCENTRANK
      New
    • Randomization with RAND & RANDBETWEEN
      New
    • Row Level Calculation with SUMPRODUCT
      New
    • DEMO Calculating Shipping Costs with SUMPRODUCT
      New
    • PRO TIP Data Profiling with COUNT & SUMPRODUCT
      New
  • Lookup & Reference Functions
    13Lessons · 1 hr 1 min
    • Lookup & Reference Functions Introduction
      New
    • Working with Named Ranges
      New
    • Counting Rows & Columns with ROWROWS & COLUMNCOLUMNS
      New
    • Introduction to VLOOKUPHLOOKUP
      New
    • Joining Data with VLOOKUP
      New
    • Fixing Errors with IFERROR & VLOOKUP
      New
    • VLOOKUP Reference Array Options
      New
    • Approximate Match Lookups
      New
    • Navigating Cell Ranges with INDEX
      New
    • Matching Text & Values with MATCH
      New
    • Combining INDEX & MATCH to Dynamically Search Ranges
      New
    • Combining MATCH & VLOOKUP for More Flexible Lookups
      New
    • TROUBLESHOOTING VLOOKUP with Duplicate Keys
      New