Course Content
Generating Formulas with Natural Language
- ChatGPT for Formula Creation
- Prompt Engineering to generate complex Excel formulas.
- Verifying and Refining Formulas
- Tools like Excel’s Formula Builder and ChatGPT to cross-check and optimize formulas.
- AI Tools for Data Extraction
- Extract data from PDFs, websites, and other sources
Advanced-Data and Financial Analysis and Insights
- Identifying Trends and Patterns in Datasets
- Excel Analytics, Copilot, and ChatGPT for data analysis.
- AI-Powered Reporting Tools
- Google Sheets Explore and Zoho Analytics for generating automated visualizations.
- Making Informed Decisions Using AI Excel Insights
Automating Repetitive Excel Tasks with AI
Data Consolidation with AI
Scenario Analysis and Sensitivity Testing
AI for PowerPoint Presentations
- AI-Powered Design and Layout
- Beautiful.AI, Microsoft Designer, and Canva for slide and presentation designs.
- Content Generation with AI
- ChatGPT and Canva Magic Write for creating and refining presentation content.
AI Tools for Presentation Personalization
- Tailoring Slides for Different Audiences
- Using Gamma and Canva for dynamic content generation.
- Presentation.ai and Gamma to generate presentations from word, ppt or prompts
Following tools will be used:
- ChatGPT, Gemini
- Excel Power Query
- Copilot
- FormulaBot
- Excel’s Formula Builder
- Google Sheets Explore
- Zoho Analytics
- Excel Forecast
- Beautiful AI
- Microsoft Designer
- Canva
- Canva Magic Write
- Presentation ai
- Gamma