5th Live Batch for Basic and Advanced MS Excel

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