₹800.00
Enrollment validity:
Lifetime
About This Course
Microsoft Excel – Beginner to Advance
Microsoft Excel is an essential tool in various professional and personal contexts due to its versatility and powerful features. Here is 5 days Advance Excel Course with Chat GPT and AI tools:
| Day 1 | Day 2 | Day 3 |
| All the Basic functions with short-cut | Advance Functions | Advance Functions |
| Font & Format | Conditional Formatting | Pivot Table |
| Alignment & Numbers | Charts & Sparklines | Data Table |
| Cells & Editing, Style | Font & Formats | Pivot Chart |
| Printing & Layout | Go-To Functions | Slicer functions |
| Sort, Filter & Search | Hyperlink | Page Layout |
| Insert & Delete | ||
| Special Paste Function | ||
| Cell References | ||
| cell/ Sheet Security & Protection | ||
| Day 4 | Day 5 | |
| Advance Functions | Excel Formulas | |
| Text to Columns | Arithmetical Formulas | |
| Formula Evaluation | Alignment Formulas | |
| Data Validation | Lookup & References Formulas | |
| Flash Fill | Conditional Formulas | |
| Remove Duplicacy | Multiple Formula in a single cell | |
| Grouping | Other Misc. Formulas | |
| Proofing (Error Check, Statistics) | Simplify Complicated data with Pivot & Formulas |
Learning Objectives
Learn ChatGPT & A.I. tools in MS Excel and upgrade yourself.
Master in MS Excel-advance Formulas like V-Lookup, X-Lookup,Pivot,Sumifs.
Learn Fx financial Formulas,Slicer,Charts and dashboard.
Become 10 times faster at work place.
Increase Productivity with the use of advance formulas & shortcuts.
Be in the top 1% employee of the company.
Get the 30-50% hike in salary & promotion
Target Audience
- 1) Chartered Accountants, CS , ICWA for preparation of financial reports
- 2) HR & Recruiters for payroll and data analysis
- 3) Sales & Marketing Department for analysis of revenue segment wise
- 4) Purchase Department
- 5) Cost Department
- 6) Accountants
- 7) Engineer and other department for their routine analysis
Curriculum
5 Lessons7h 30m
Microsoft Excel Beginner to Advance
Day 1
Login with Google