Skip to Content
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
Add to Cart
Responsible King Enterprise
Last Update 26/09/2025
Completion Time 4 hours 16 minutes
Members 1
  • Excel Formulas 101
    11Lessons · 1 hr 38 mins
    • Introduction Excel Formulas 101
      Free Preview
    • Excel Formula Syntax
    • Writing Efficient Formulas with Fixed & Relative References
    • Common Excel Error Types
    • Formula Auditing Trace Precedents & Dependents
    • Formula Auditing Evaluate Formula & Error Checking PC Only
    • Navigating Excel Worksheets with Ctrl Shortcuts
    • Saving Time with Function Shortcuts
    • Accessing Tools with Alt Key Tips
    • PRO TIP Creating Drop Down Menus with Data Validation
    • Congrats, You're a Developer!
  • Conditional Statements & Logical Operators
    7Lessons · 30 mins
    • Conditional Statements & Logical Operators Introduction
    • Anatomy of the IF Statement
    • Nesting Multiple IF Statements
    • Adding Conditional ANDOR Operators
    • Using NOT & Conditionals
    • Fixing Errors with IFERROR
    • Common IS Statements
  • Common Excel Statistical Functions
    10Lessons · 1 hr 7 mins
    • Common Excel Statistical Functions Introduction
    • Basic Excel Statistical Functions
    • Extracting Values with SMALLLARGE & RANKPERCENTRANK
    • Randomization with RAND & RANDBETWEEN
    • Row Level Calculation with SUMPRODUCT
    • DEMO Calculating Shipping Costs with SUMPRODUCT
    • Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS
    • Building a Basic Dashboard with COUNTIFS & SUMIFS
    • DEMO Counting Duplicates with COUNTIF & SUMPRODUCT
    • PRO TIP Data Profiling with COUNT & SUMPRODUCT
  • Lookup & Reference Functions
    13Lessons · 1 hr 1 min
    • Lookup & Reference Functions Introduction
    • Working with Named Ranges
    • Counting Rows & Columns with ROWROWS & COLUMNCOLUMNS
    • Introduction to VLOOKUPHLOOKUP
    • Joining Data with VLOOKUP
    • Fixing Errors with IFERROR & VLOOKUP
    • VLOOKUP Reference Array Options
    • Approximate Match Lookups
    • Navigating Cell Ranges with INDEX
    • Matching Text & Values with MATCH
    • Combining INDEX & MATCH to Dynamically Search Ranges
    • Combining MATCH & VLOOKUP for More Flexible Lookups
    • TROUBLESHOOTING VLOOKUP with Duplicate Keys