Module 1 - Advanced MS Excel and Excel Back-End Operations:
Introduction to Advanced MS Excel:-
- Circular References error, Rectify Circular Reference, Formula Auditing, Structured Reference
- Solve The Real World Excel Problems with Functions:
- Mathematical Functions:
- If Formulas:
- More If Formulas:
- Date & Time Function:
- Statistical Function & Other Functions:
- Lookup & Reference Functions:
- Array With Multiple Formulas:
- Text Functions & Data Validation:
- Pivot Table and Pivot Charts with Slicer:
- Advanced Chart Technique:
- Advanced Dashboard:
- Report Development:
People Who Are Looking To Learn MIS & Adv. Excel. This Is The Best Opportunity For Everyone, Get MIS & Adv. Excel Online Training With Certification. Boost your career with Advance Excel Training...
Who can attend:
- Working Professionals
- Freshers
- College/Students
Benefits:
- ISO Certified Institute with 100% Placement Assistance.
- 100% Practical Session provided by 15+ yrs. working Industry Experts.
- MS Teams, Zoom, Skype Software-based Classes for better comprehension.
- Real-time training session and workshop to practice their learning.
- Recording Videos provided after completion of the Session.
- Working Sheets & Handouts.