CCI Online Learning

Excel Power Tools: Advanced Data Modeling and Automation

with CA Vishal Zawar

Course Fees 499

inclusive of GST

Faculty: CA Vishal Zawar

Date: 30th June 2024

Time: 10 am to 2:30 pm (including break of 30 minutes)

Language: Hinglish

Recording Validity: 2 months & Unlimited views

E-certificate after course completion

Share on :

Course Contents

Excel Power Tools: Advanced Data Modeling and Automation –

1) Working with Excel PowerPivot Tools (1 Hour) –

  • What is Power Pivot: Advantages over standard Excel functions.
  • Creating data models: Importing data and establishing relationships.
  • DAX basics: Introduction to Data Analysis Expressions.
  • Advanced DAX formulas: Calculations, measures, and KPIs.
  • Building dashboards: Combining Power Pivot with PivotTables and PivotCharts.

2) Power Query [Get & Transform] (1 hour) -

  • Introduction to data transformation: Why it’s essential
  • Connecting to data sources: Files, databases, web data, and more.
  • Data cleaning: Removing duplicates, filtering rows, and transforming columns.
  • Advanced transformations like merging queries etc.
  • Automating data refresh: Keeping data up-to-date effortlessly.

3) Form Controls and ActiveX Controls ( 1 hour) –

  • Introduction to form controls: Enhancing user interaction.
  • Adding buttons, checkboxes, and combo boxes: Basic form controls.
  • ActiveX controls: Advanced customization.
  • Linking controls to data: Making controls dynamic.

4) Macros and VBA [Visual Basic for Applications] (1 hour) -

  • Introduction to automation: What are macros?
  • Recording and running macros: Step-by-step guide.
  • Editing macros: Understanding the VBA editor.
  • Automating repetitive tasks.

Features of the course –

  • Hands-on Learning: Each tool is accompanied by practical exercises and real-world examples.
  • Interactive Sessions: Engage with interactive content, live demos, and Q&A sessions.
  • Certification: Earn a certificate upon course completion to showcase your new skills
  • Career Advancement: Enhance your resume and job prospects with advanced Excel skills.
  • Comprehensive Materials: Access to detailed notes, video tutorials, and additional resources.

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