20 participants can join this course.

20 Reviews

Duration

20 hours

Lectures

8

Projects

2

Transform Your Spreadsheets with AI-Powered Insights

AI Powered MS Excel Training for Data Analysis 1

COMPLETED

Training Start Date 05 Jan 2026      End Date    10 Feb 2026

Course Overview

This exclusive 20-hour training program, brought to you by ADN EduServices, is the first of its kind—designed to equip participants with the skills to harness Artificial Intelligence (AI) within Microsoft Excel. From mastering essential Excel functions to exploring cutting-edge AI integrations, this course redefines how you analyze data, automate tasks, and extract insights. Tailored for both aspiring professionals and seasoned users, this unique course will transform your Excel capabilities and set you apart in a rapidly evolving digital world.

Class Schedule

Friday and Saturday

Class Time

8:30 PM to 10:30 PM

Course Fee

৳ 3000
৳ 2000 Off ৳ 5000
Registration Closed

Further communication.

[email protected]

+8809610961961

Course Curriculum

  • Excel Basics Refresher
  • Data Manipulation and Cleaning
  • Data Analysis and Visualization Fundamentals
  • AI Tools and Integrations with Excel
  • Leveraging Built-in AI in Excel: Smart Data Input and Transformation
  • Advanced Functions with AI Capabilities
  • : Introduction to AI Concepts for Excel Users: What Why
  • Key AI Concepts for Data Analysis
  • Introduction to Power Query for Data Preparation
  • AI-Powered Insights: Visualizing AI Outputs and Insights
  • Automation and Advanced AI Integration : Automating Tasks with VBA and AI
  • Power Automate for Excel and AI Workflows
  • Future Trends and Next Steps

    • Instructor Profile

    Course Content

    Excel Basics Refresher

    Workbooks, Worksheets, and Rangesee Data Entry and Formattingee Basic Formulas and Functionsee Tables and Named Ranges

    Data Manipulation and Cleaning

    Text Functions: LEFT, RIGHT, MID, LEN, FIND, REPLACE, CONCATENATE (or ), and TEXTJOINee Date Time Functions: TODAY, NOW, DAY, MONTH, YEAR, DATEDIFee Data Validationee Remove duplicates and Go To Specialee Flash Fi: Leveraging Excels inteigent pattern recognition for rapid data transformation

    Data Analysis and Visualization Fundamentals

    Sorting and Filteringee PivotTables and Pivot Chartsee Basic Chartingee What-If Analysis (Goal Seek, Data Tables, Scenario Manager)

    AI Tools and Integrations with Excel

    Overview of Microsoft 365 AI Featuresee Power Query and Power BI Integration (Conceptual)ee Introduction to Python/R for Excel (Conceptual)ee Cloud-based AI Services (Conceptual)

    Leveraging Built-in AI in Excel: Smart Data Input and Transformation

    Flash Fi in Depthee Text to Columns by Exampleee Data Types (Stocks, Geography, etc.)ee Ideas (Analyze Data)

    Advanced Functions with AI Capabilities

    XLOOKUP and XMATCH (Review)ee TEXTSPLIT and TEXTBEFORE/TEXTAFTERee LET Functionee Dynamic Arrays (UNIQUE, SORT, FILTER, SEQUENCE, RANDARRAY

    : Introduction to AI Concepts for Excel Users: What Why

    Defining AI, Machine Learning (ML), and Deep Learning (DL)ee Common AI Use Cases in Businessee The Value Proposition of AI in Excelee Ethical Considerations of AI

    Key AI Concepts for Data Analysis

    Supervised vs. Unsupervised Learningee Regression vs. Classificationee Feature Engineering (Conceptual)ee Model Training and Evaluation (Conceptual)

    Introduction to Power Query for Data Preparation

    Importing Data from Various Sourcesee Transforming Data with Power Query Editoree Unpivoting Dataee Creating Custom Columns

    AI-Powered Insights: Visualizing AI Outputs and Insights

    Advanced Charting for Predictive Dataee Sparklines and Conditional Formatting for AI Resultsee Dashboarding AI Insights in Excelee Connecting Excel to Power BI for Enhanced Visualization

    Automation and Advanced AI Integration : Automating Tasks with VBA and AI

    Introduction to VBA (Visual Basic for Applications)ee VBA for Data Preparation Automationee External Programs/Scripts from VBA (Conceptual)ee Creating Custom Functions (UDFs) with VBA

    Power Automate for Excel and AI Workflows

    Introduction to Power Automate (Flow)ee Triggering Flows from Excelee Integrating Excel with AI Builder (Conceptual)ee Automating Data Entry and Reporting with AI

    Future Trends and Next Steps

    Emerging AI Features in Microsoft 365ee Introduction to Python for Excel (Conceptual)ee Resources for Continued Learning

    Pre-Requisites

    * Basic understanding of Microsoft Excel (formulas, formatting, navigation)

    * Ability to work with structured data (tables, sorting, filtering)

    * Interest in AI, automation, and data analysis

    * Familiarity with Microsoft 365 tools (Power Query, Power BI) is a plus

    * Access to Microsoft Excel (Microsoft 365 version recommended)

    Learning Outcomes

    By the end of this course, participants will be able to confidently apply AI-powered features within Microsoft Excel to automate tasks, analyze data more efficiently, and generate actionable insights. Learners will gain a strong foundation in Excel functions, data cleaning, and visualization—while also exploring how AI tools like Power Query, dynamic arrays, and Microsoft 365’s intelligent features can revolutionize their workflow. This course will equip participants with future-ready skills to enhance productivity, make smarter decisions, and stand out in data-driven roles.

    Benefits

    This training helps you save time by automating tasks and makes data analysis faster and more accurate using AI-powered Excel features. You’ll boost your productivity and decision-making skills while gaining future-ready expertise that will help you stand out in data-driven roles and advance your career.

    Popular Courses

    A To Z IELTS

    Starting
    26 Feb, 2026

    A To Z IELTS
    ONGOING
    0.0

    ৳ 0

    No Instructor Assigned

    Online Course

    Lessons

    Enroll
    IELTS PREPARATION COURSE

    Starting
    27 Feb, 2026

    IELTS PREPARATION COURSE
    ONGOING
    0.0

    ৳ 0

    No Instructor Assigned

    Online Course

    30 Lessons

    Enroll
    Foundation Course

    Starting
    28 Feb, 2026

    Foundation Course
    ONGOING
    0.0

    ৳ 0

    No Instructor Assigned

    Online Course

    Lessons

    Enroll