Short-Term Certificate Course: Business Analytics with Spreadsheet Modeling & AI
📍 Venue: Online – Zoom
📅 Date: 9th – 13th December 2024 (5 Days)
⏰ Time: 7:00 PM – 8:30 PM IST
🎟 Registration & Participation: FREE
📄 Certificate & Recording Fee: ₹195 / $3 USD
Why Join?
This course is designed for students, professionals, and data enthusiasts eager to develop practical skills in business analytics. Gain hands-on experience with essential Excel tools, AI-driven functions, and visualization techniques to make data-driven decisions confidently. By the end of this course, you’ll be able to create impactful dashboards and analytical models for business insights.
Who Will Benefit?
- Students / Faculty Members in business, data science, and related fields
- Professionals in finance, marketing, and operations
- Data enthusiasts looking to upskill in AI and spreadsheet modeling
Course Outline
Day 1: Spreadsheet Modeling for Business
- Introduction to Spreadsheet
- Ribbons and Toolbar in Excel
- Working with Worksheets
Day 2: Entering Formulas in Excel Using AI
- Basic Functions and Formulas
- Date-Time Functions
- Logical Formulas
Day 3: Advanced Formulas and AI Functions
- Regression Analysis
- Lookup Functions
- Data Validation
- Spreadsheet Security
Day 4: Pivot Tables and Charts
- Using Pivot Tables
- Chart Types and Usage
- Conditional Formatting
Day 5: Case Study Using AI
- Creating KPIs
- Slicers for Dashboards
- Sales Dashboard
👨🏻💻 Resource Person:
Ms. Remya R S
Technical Trainer [Data Science, AI & ML]
A2Z EduScaleUp India Pvt. Ltd