Strategic Performance Management and Business Valuation
E Way Bill in GST (Without Recording)
Fundamentals of Business Mathematics and Business Statistics
Course Fees 499
inclusive of GSTFaculty: 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
Register NowCourse 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 , 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
CAclubindia
