Posted inBlog discovery Education World
Here’s a step-by-step guide to mastering advanced Excel, complete with examples:
Advance excel Step 1: Mastering Formulas & Functions 1.1 Logical Functions IF: =IF(A2>50, "Pass", "Fail") IFERROR: =IFERROR(A2/B2, "Error") AND, OR: =IF(AND(A2>50, B2>50), "Good", "Bad") 1.2 Lookup Functions VLOOKUP: =VLOOKUP(101, A2:C10,…
