Financial Accounting
Operations Management & Strategic Management
How to Handle Show Cause Notices in GST Recording
CCI Learning
Basic and Advanced MS Excel Batch Recorded Session
with CA Vishal Zawar
Course Price: ₹999
inclusive of all taxes- Faculty: CA Vishal Zawar
- Course Duration: 7.5 Hours
- Language: Hinglish
- Validity: 2 Months with Unlimited Views
What will be Covered in the Course?
- Launching excel, Excel quick access toolbar, Excel structure, Saving excel file, Excel shortcuts
- Text formulas, Date formulas, Statistical functions, working with cell references, relative and absolute cell references
- Wildcards, Sort and Filter, Data Validation, Conditional Formatting
- Find and Replace tricks, Substitute function, Copy and Paste special, VLOOKUP, IF
- Autosum, Autofill, Excel Tables, Goal seek
- Changes in Excel worksheet - Moving, Copying, deleting, renaming
- Pivot tables and slicers, Sensitivity analysis
- Creating and working with excel charts
- Printing an excel worksheet, Excel protection, Use checkboxes
- SUMIFS, COUNTIFS, LEN - advanced functions for data analysis
- Power query
- Macro Recording
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
