Be an excel formulas expert in just 4 hours

(Hindi – English)

Saturday and Sunday – 12 Pm to 2 PM

Formula Basic

  1. Relative and Absolute Reference
  2. R1C1 and A1 Notation
  3. How to Refer other sheets in formulas.
  4. Range Address / Name Range.
  5. Define Name / Apply Range.
  6. Create name ranges in just one click.

String Manipulation

Left, Right, Mid, Substitute, Replace
Find, Search, Exact, Code, Char, Text
Concatenate, Mid, Lower, Upper, Replace
Clean, Rept.

Date and Time

How dates and times works?
Date, Year, Month, Day, Date
Hours, Minute, Second, Time
Edate, EOMOnth, NetWorkday
Workday,Timevalue, DateValue

Logical Function

Comparison Operator
AND, OR, NOT
IF Statement

Lookup and Reference

Vlookup, Hlookup, Indirect, Index, Match
Row, Column, Offset, choose, address, Lookup
Transpose.

Other formulas

Sumproduct, Sumif, Sumifs, Countif, Countifs
Averageif, Averageifs, Count, Counta, Round,
Mround, RoundUp, RoundDown, MMULT, Mod, Small
Large, Max, Min

Array Formulas

10 complex examples of array formulas
Creating Mega formulas
Using N and — in formulas
Using Wild Card in formulas

Formulas Auditing

How to calculation all formulas at once.
how to troubleshoot formula and fix it.
What is Circular reference and how to fix it.

Spend your weekend and be expert in all those formulas @ INR 500.

you will be able to solve these formula challenges after this training

How this works

  1. Register yourself by filling form below.
  2. Make online payment of INR 500/-
  3. Once payment is confirm, you will get a meeting invite
  4. We will use that link to share our screen and audio.
  5. you will get practice file after the meeting

Registration for formulas training