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
    • Excel Formula Syntax
    • Writing Efficient Formulas with Fixed & Relative References
    • Common Excel Error Types
    • Formula Auditing Trace Precedents & Dependents
    • 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 Operatars 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
    7Lessons · 45 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
    • 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