Excel
Microsoft Copilot
📊Data Analytics
Excel - Data to Dashboard using AI
Learn Excel fundamentals and analyze data with AI
📘 5 modules
🕐 12 hours
🎯 Beginner
Course Overview
This hands-on course helps beginners build a strong foundation in Microsoft Excel for data analysis and reporting. Participants will learn essential Excel features, formulas, PivotTables, dashboards, and data visualization techniques. The course concludes with an introduction to Microsoft Copilot Chat for analyzing Excel data, generating insights, and improving productivity using AI.
What You'll Learn
- ✓ Navigate Excel confidently and work with structured datasets
- ✓ Use essential formulas to perform calculations and analysis
- ✓ Analyze data using PivotTables, filters, and conditional formatting
- ✓ Create interactive dashboards and business reports
- ✓ Use Microsoft Copilot Chat to analyze and summarize Excel data
Prerequisites
- 👉 Basic knowledge of Microsoft Excel
- 👉 Familiarity with spreadsheets and tables
- 👉 Interest in data analysis
- 👉 Basic understanding of business reporting
- 👉 Access to a Generative AI tool
Curriculum
Excel Foundations ▾
- ▸ Introduction to Microsoft Excel
- ▸ Understanding the Excel Interface
- ▸ Ribbon, Worksheets and Workbooks
- ▸ Keyboard Shortcuts
- ▸ Working with Rows, Columns and Cells
- ▸ Data Types (Text, Numbers and Dates)
- ▸ Creating and Formatting Tables
- ▸ Sorting and Filtering Data
- ▸ Using Flash Fill for Data Cleaning
Formula Thinking and Logic Building ▾
- ▸ Understanding Cell References
- ▸ Relative vs Absolute References
- ▸ SUM
- ▸ AVERAGE
- ▸ COUNT
- ▸ IF Function
- ▸ VLOOKUP
- ▸ XLOOKUP
- ▸ Formula Auditing and Error Checking
Data Analysis Techniques ▾
- ▸ Creating PivotTables
- ▸ Summarizing Large Datasets
- ▸ Using Slicers
- ▸ Conditional Formatting
- ▸ Data Validation
- ▸ Basic Data Exploration
Dashboard Development ▾
- ▸ Choosing the Right Chart
- ▸ Bar, Line, Pie and Combo Charts
- ▸ Creating KPI Cards
- ▸ Building Interactive Dashboards
- ▸ Dashboard Design Best Practices
- ▸ Formatting and Layout
AI with Microsoft Copilot Chat ▾
- ▸ Introduction to Microsoft Copilot Chat
- ▸ Preparing Excel Data for AI Analysis
- ▸ Uploading and Analyzing Excel Files
- ▸ Summarizing Large Datasets
- ▸ Identifying Trends and Patterns
- ▸ Generating Business Insights
- ▸ Creating Executive Summaries
- ▸ Writing Effective Prompts for Data Analysis
System Requirements
Hardware
- • Minimum 4 GB RAM
- • Dual-Core Processor
- • Stable Internet Connection
Software
- • Microsoft Excel 365 or Excel 2021
- • ChatGPT, Copilot, Claude, or Gemini
- • Modern Web Browser
- • Sample Excel Datasets
Course Details
6 sessions
· 12 hours
₹6,000
Have questions about this training?
Your Trainer
Vaidehi Nair
Corporate Trainer
15+ of experience · Corporate Trainer | Python Developer | Power BI Consultant | AI Solutions
View Trainer Profile →You Might Also Like
Request a Batch
Course
Get in Touch