EXCEL & PowerPoint Using AI

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