CCI Online Learning

3rd Live Batch for Basic and Advanced MS Excel

with CA Vishal Zawar

Course Fees 999

inclusive of GST

Faculty: CA Vishal Zawar

Date: 11th March to 15th March 2024

Time: 7.30 pm to 9.30 pm

Language: Hinglish

Recordings Validity: 2 Months with Unlimited Views

Register Now
Share on :

Content

  1. Launching excel, Excel quick access toolbar, Excel structure, Saving excel file, Excel shortcuts
  2. Text formulas, Date formulas, Statistical functions, working with cell references, relative and absolute cell references
  3. Wildcards, Sort and Filter, Data Validation, Conditional Formatting
  4. Find and Replace tricks, Substitute function, Copy and Paste special, VLOOKUP, IF
  5. Autosum, Autofill, Excel Tables, Goal seek
  6. Changes in Excel worksheet - Moving, Copying, deleting, renaming
  7. Pivot tables and slicers, Sensitivity analysis
  8. Creating and working with excel charts
  9. Printing an excel worksheet, Excel protection, Use checkboxes
  10. SUMIFS, COUNTIFS, LEN - advanced functions for data analysis
  11. Power query
  12. Macro Recording

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.

Experienced Faculty

CA Vishal Zawar CA Vishal Zawar , is a qualified Chartered Accountant and holds 5+ years of experience of teaching Financing Management, Financial Modeling, Financial statement analysis. He has worked as Financial Analyst with Medical solutions India private limited. He has excellent command over MS Excel and he has been conducting sessions on Advanced Excel. His practical approach towards teaching Finance makes students understand concepts deeply and make them market ready.


Register Now


Other recommended course