Certification Course on AI Tools Mastery for Finance Professionals
All Combo Subjects
Advanced Financial Management Capital Budgeting
CCI Learning
4th Live Batch for Basic and Advanced MS Excel
with CA Vishal Zawar
Course Price: ₹999
inclusive of all taxes- Faculty: CA Vishal Zawar
- Date: 8th April to 13th April 2024
- Time: 8:00 pm to 9.30 pm
- Language: Hinglish
- Validity: 2 Months with Unlimited Views
Course Content
- Launching Excel, Understanding Excel Interface, Customizing Excel Quick access toolbar
- Excel Shortcut keys, Absolute and Relative Cell referencing, Working with statistical and mathematical functions, Text Functions, Date functions (e.g. Sum(), Min(), Max(), Large(), Concatenate(), Textjoin(), Autosum, Edate(), Left(), Right() etc
- Conditional Formatting, Working with different types of Excel charts, Sort and Custom sort, Filter, Freeze panes, Using Checkboxes
- Data validation, Importing and Exporting data in Excel, Excel PivotTables, Excel Tables, Autofill/Flashfill
- Working with Excel’s PowerPivot Tools (USP of the course)
- Various Conditional functions like IF, IFS, SUMIF, COUNTIF, AVERAGEIF etc
- Working with various Lookup functions like VLOOKUP, HLOOKUP, INDEX, MATCH etc
- Tracing Precedents and Dependents in Excel Formulas, Wildcards, Find and Replace trick.
- Protecting Excel worksheets and Excel workbook, Working with PMT, IPMT, PPMT functions to make Loan schedule and Investment analysis.
- Mastering “What-If” tools like Goal Seek, Solver, data tables, Scenario manager
- Understanding Excel Macros and Power Query for automating tasks
Additional Benefits
- Home assignments will be given for practice
- Lifetime support through WhatsApp after completion of course
- Excel Updates will be shared through whatsapp after completion of course.
Course Highlights
Comprehensive PDF notes
Detailed reference materials for your learning journey
Interactive Q&A sessions
Each live class for enhanced learning
E - Certificate
Validate your learning and showcase your expertise
2 Months & Unlimited views
Review the course material at your own pace
About Faculty
CA Vishal Zawar
Vishal Zawar, a qualified Chartered Accountant holding more than 6 years of experience into teaching Finance specialised courses like Financial Modeling, Financial statement analysis, Financial Management.
Also worked as trainer for various institutes for Advance MS Excel and stock market courses. Also has served as Financial Analyst and Financial Controller for private limited companies.
Need Assistance?
Our counselors are available to help you with any questions
Other recommended course
CCI Learning provides pre-recorded video coaching classes by renowned faculties. The videos can be viewed anytime ,anywhere. Add on Pen drive option is also available.
CAclubindia
