OBJECTIVE

This course offers a comprehensive introduction to data analysis and visualization using Excel and Looker Studio. Students will learn to manipulate data in Excel, leverage AI-powered features, and create impactful dashboards and reports in Looker Studio with modern visualization techniques.

COURSE OUTLINE

Module 1

• Introduction to Data Analysis & Visualization
• Introduction to Excel
• Working with formulas and functions
• Data sorting and filtering
• Auditing
• Charts and tables
• Working with data
• What if analysis
• Ai-Powered Features in Excel
• Exporting importing and reviewing a worksheet
• VBA Macro

Module 2

• Modern Looker Studio with AI Analytics
• Looker Studio Fundamentals
• AI-Powered Insights with Gemini
• Advanced Visualization and Dashboard Design
• Integration and Collaboration
• Real-World Applications and Case Studies