CCI Online Learning

5th Live Batch for Basic and Advanced MS Excel

with CA Vishal Zawar
Course discontinued. View Other Course

Course Fees 999

inclusive of GST

Faculty: CA Vishal Zawar

Date: 20th May to 24th May 2024 (5 days)

Time: 7.30 pm to 9.30 pm

Language: Hinglish

Recordings Validity: 2 Months with Unlimited Views

Register Now
Share on :

Contents -

  • 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.

Experienced Faculty

CA Vishal Zawar CA 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 a 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.

Register Now

Other recommended course