Advanced Microsoft Excel – Part 1 Search for: Current Status Not Enrolled Price $INR 499/- for 6 months Get Started Buy Now Course Content 1 Formula Syntax 2 Writing Efficient Formulas 3 Formula Auditing 4 Function Shortcuts Formula 5 Creating Drop Down Menus With Data Validation 6 Conditional Statements And Logical Operators 7 Creating Rows And Columns 8 Data With Vlookup 9 Fixing Error With Iferror 10 Approximate Match Lookups 11 Combing Index And Match 12 Basic Formula Function 13 Calculate With Sumproduct 14 Basic Dashboard With Sumifs And Counifs 15 Data With Copy, Countifs And Sumproductifs