Enroll for the course now at just Rs. 500. Course Duration : 10 sessions, each lasting 1.5 hours
Classes Timing: Saturday or Sunday from 9am to 10.30 am' Students can choose their own class timing. Please enroll today and take advantage of the course. Topics
a. Pivot Table -Basic & Advance
b. Top 50+ Formulas- Lookup/Financial/Logical/Date
i. CELL REFERENCE- ABSOLUTE/RELATIVE/MIX CELL REFERENCE
ii. IF/AND/OR/IFERROR
iii. SUMIF/SUMIFS/COUNTIF/COUNTIFS/AVRAGEIF/AVERAGEIFS. iv. VLOOOKUP/INDEX-MATCH/LOOKUP. v. MID-RIGHT-LEFT/SEARCH/SUSTITUTE/LEN/CONCAT/TEXTJOIN
vi. MAX/MIN/LARGE/SMALL/MAXIF/MAXIFS/MINIFS
vii. DATEDIF/TEXT/MONTH/YEAR/DAY/DAYS/EOMOTH/EDATE/FINANCIAL YEAR/DATE
viii. ABS/RANK/ROUND/TRIM/CLEAN
ix. UPPER/LOWER/PROPER
c. Filtering- Basic & Advance-Text/Date/Number filter
d. Sorting Data with multiple columns
e. Data Validation Basic & Advance
f. Charts – Basic & Advance-Line Charts-Column/Bar Charts-Pie Charts-Combo Charts-Column & Line Chart together
g. Conditional Formatting -Basic & Advance-Conditional formatting with Formulas-Conditional formatting on basis of another column
h. Printouts-How to take printout with huge data-Benefit of Header and Footer
i. Keyboard Shortcuts/ Flash Fill/Text to column/Paste Special/Remove Duplicate/Move and copy Sheets/Freeze and Unfreeze/Find and Replace
j. Hyperlink/How to insert excel in PPT
k. Introduction of Power Query
Who need to enrolled.
1) Anyone who working with any age.
2) Who don’t know excel.
3) Who has laptop personal or office for practice.
4) Excel 2026 and above version needed.
5) Student should have ready to practice on daily basis. What is benefit. With lower price. Each lecture assignment
Each lecture recording. Only one-hour classes on Sunday. Teaching with real examples
Can join with mobile also. Can crack interview
Understand logic how to build formulas in excel. Easily & confidently work on Pivot Table
Practice on multiple datasets with real examples. And each lecture recording will be available for 3 months
