Advanced Microsoft Excel – Part 1

Current Status

Not Enrolled

Price

INR 499/- for 6 months

Get Started

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