4th Live Batch for Basic and Advanced MS Excel

Share this course:

Course Description

  • 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

Meet Your Instructor

CA Vishal Zawar

CA

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.

4th Live Batch for Basic and Advanced MS Excel
Start Date
08 April 2024
End Date
13 April 2024
Time
8 PM - 9.30 PM
Medium
Hinglish
₹999
Enroll Now
Course feature :
  • Validity: 2 Months with Unlimited Views

Have Questions About This Course?

Our course advisors are here to help you make the right decision for your career growth.