Course Overview
This 6-week beginner-friendly course is the perfect launchpad for your data career. You will master Microsoft Excel for real-world data analysis and learn to supercharge your workflow with Generative AI tools — no programming required.
What You Will Learn
- Excel fundamentals — formulas, functions, formatting
- Advanced Excel — VLOOKUP, INDEX-MATCH, pivot tables, charts
- Data cleaning and preparation techniques
- Statistical analysis in Excel
- Data visualization and storytelling with Excel
- Using ChatGPT and Copilot to write Excel formulas
- AI-assisted data summarization and report writing
- Introduction to Power Query for data transformation
Who Is This For?
- Absolute beginners starting their data journey
- Office professionals who use Excel regularly
- Students and recent graduates
Prerequisites
Basic computer skills. No prior Excel or data experience required.
Course Highlights
- ⏱ Duration: 6 Weeks (Self-paced)
- 📜 Data Analyst portfolio
Ready to Transform Your Career?
Our expert trainers are ready to guide you. Leave your details and we will get back to you shortly.
What's Included
Course Curriculum
Go beyond basic Excel and master the advanced formulas and features used by professional data analysts.
- VLOOKUP, HLOOKUP, INDEX-MATCH
- IF, IFS, IFERROR, nested logical functions
- SUMIFS, COUNTIFS, AVERAGEIFS
- Named ranges and dynamic arrays
- Data validation and conditional formatting
Build powerful pivot table reports and master the data cleaning workflow that analysts use daily.
- Pivot tables: grouping, filtering, calculated fields
- Power Query for automated data cleaning
- Removing duplicates and handling nulls
- Text functions: TRIM, LEFT, RIGHT, CONCATENATE
- Date functions for time-based analysis
Build executive-ready interactive dashboards entirely in Excel.
- Chart types and when to use each
- Sparklines and mini-charts
- Slicers and timelines for interactivity
- Dashboard layout and design principles
- Linking charts to dynamic data ranges
Write SQL queries to extract and analyze data from relational databases.
- SELECT, WHERE, ORDER BY, LIMIT
- JOINs: INNER, LEFT, RIGHT, FULL
- GROUP BY, HAVING, aggregate functions
- Subqueries and CTEs
- Connecting SQL output to Excel for dashboards
Use AI tools to accelerate your analysis, automate reporting, and generate insights 10x faster.
- ChatGPT / Copilot for formula generation
- AI-assisted data cleaning and outlier detection
- Generating Python scripts for Excel automation via AI
- AI-powered narrative and commentary generation
- Microsoft 365 Copilot in Excel features
Complete a full business data analysis project: from raw dataset to an executive-ready dashboard presentation.
- Dataset acquisition and cleaning
- Exploratory analysis and key findings
- Dashboard design and build
- AI-generated executive summary
- Presentation and stakeholder walkthrough
Skills You Will Gain
Career & Salary Outcomes
Average salaries after completing this training
What Our Students Say
Real feedback from real professionals who completed this program
“The Data Analyst Using Excel and Gen Ai course at Astrikcoders was exactly what I needed to upskill. The hands-on projects were incredible.”
“I was able to transition into a new role thanks to this Data Analyst Using Excel and Gen Ai program. The instructors are very knowledgeable.”
“Highly recommend the Data Analyst Using Excel and Gen Ai training. It covers everything from basics to advanced topics with real-world examples.”
Frequently Asked Questions
Everything you need to know before enrolling