-
₹400
-
Duration: 16 Hours
-
Delivery mode: Online
-
Group size: Individual
-
Instruction language:
English,
Hindi,
Urdu
-
Certificate provided:
No
Following are the Excel Key Concepts Required in Real World Scenarios, covered in my curriculum,
a) Basic & Intermediate Excel Functions
o (SUM, AVERAGE, COUNT, MIN, MAX, IF, AND, OR, LEFT, RIGHT, MID
LEN, TRIM, UPPER, LOWER, LOOKUP, HLOOKUP, XLOOKUP, INDEX & MATCH,
Nested IF, IFS, SUMIF, SUMIFS, COUNTIF, COUNTIFS, FILTER, SORT, UNIQUE)
b) Basic & Advanced Pivot Tables & Pivot Charts & Dashboards
c) Data Analysis Tools
o What-if Analysis: Goal Seek, Scenario Manager, Data Tables
d) Power Query Impact, Data Cleaning & Transformation, etc
e) Using AI & its Impact
f) Real-World Projects