fbpx

AI-Powered Data Analysis in Excel

Boost Your Team’s Productivity with AI and Automation in Excel

  • Duration

    15 Hours

  • Schedule

    3 – 5 June 2025
    09.00 – 15.00 WIB

  • Habitare

    Jl. H. R. Rasuna Said No.Kav.20, Karet Kuningan, Kecamatan Setiabudi, Jakarta Selatan 12940

  • Investment

    Rp. 5.550.000

WORKSHOP STARTS IN

0Weeks0Days0Hours0Minutes0Seconds
REGISTER NOW

Overview

This 15-hour training program equips participants with the skills to leverage Excel’s built-in AI capabilities and related features to significantly enhance efficiency, automate tasks, and gain deeper insights from data. The course combines advanced Excel techniques (Power Query, PivotTables, Power Pivot) with a practical exploration of Excel’s AI-powered tools, including “Analyze Data,” formula suggestions, and potential integrations with external AI services (explained conceptually). Participants will learn how to streamline their workflows, automate data analysis, and unlock the full potential of their data using the power of AI within Excel.

Course Syllabus

  • Overview of Excel Power Query Editor
  • Importing Data From Various Sources (Excel, CSV, Text files)
  • Connecting to External Data Sources
  • Setting Up Automatic Data Refresh
  • Merging and Appending Data from Multiple Table
  • Understanding Data Types and Their Impact on Analysis
  • Handling Inconsistencies and Errors in Data
  • Working with Dates and Times Effectively
  • Conditional Column & Column Formatting
  • Understanding the Importance of Excel Table
  • Naming Data Ranges to Improve Efficiency
  • Using Table References to Make Writing Formulas Easier
  • Introduction to Pivot Tables
  • Creating and managing Pivot Table fields
  • Customizing Pivot Table layouts and data aggregation
  • Advanced Pivot Table Features: Calculated Fields & Grouping
  • Understanding the Importance of Power Pivot in Excel
  • Connecting Multiple Tables using Relationships
  • Using DAX (Data Analysis Expressions) for Advanced Calculations
  • Using Pivot Table with Power Pivot
  • One-click statistical data analysis in Excel
  • Using comparison calculation for calculating business metrics
  • Advanced comparison calculation for measuring KPI
  • What Is AI and How Does AI Learn?
  • Key AI Technologies: Machine Learning, Deep Learning, Generative AI (GenAI), and Large Language Models (LLMs)
  • Discriminative vs Generative AI and Their Business Applications
  • In-depth exploration of the “Analyze Data” feature
  • Understanding how AI support “Analyze Data” to works
  • Asking effective questions to get meaningful insights
  • Critically evaluating AI-generated suggestions
  • Customizing “Analyze Data” results
  • Leveraging LABS.GENERATIVEAI for Text Summarization and Data Insights
  • Utilizing GPT Models within Excel for Formula Assistance
  • Automating Chart Creation and Data Analysis with Copilot in Excel

Course Receivables

  • Lecturer’s Notes

    Including Course Books (PDF), HTML files, course transcripts (if any).

  • Highly-accelerated Learning

    Learn under the assistance of mentorship of our lead instructor and a band of qualified teaching assistants throughout each course.

  • Certification of Completion

    Show current employer hat you’ve completed the course with a signed certificate of completion.

  • Quality Learning Environment

    We pay meticulous attention to the logistical details of our workshops: quality audio and visual setups, comfortable sitting arrangements, and small group size.

  • Refreshments & Coffee Break

    In our commitment to delivering a premium experience, we collaborate with leading catering services in Jakarta. Our aim is to ensure that all participants are served delectable lunches and revitalizing coffee breaks.

REGISTER NOW

ABOUT THIS SERIES

Courses in this series cater to a diverse audience: from casual learners and working professionals to those venturing into data science and machine learning without a programming background.

We recognize that many students may not have prior expertise in statistics, mathematics, or algebra. Therefore, our courses are designed with a gentle learning curve, placing a strong emphasis on hands-on experience and individualized instruction. Our dedicated team of instructors and teaching assistants ensure personalized guidance every step of the way.

Teaching Methodology

Students work through tons of real-life examples using sample datasets donated by our mentors and corporate partners. We believe in a learn-by-building approach, and we employ instructors who are uncompromisingly passionate about your growth and education.

YOUR INSTRUCTOR

Muhammad Dzaky Jayalaksono
Business Intelligence Instructor at Algoritma Data Science School

Dzaky has a strong understanding and proficiency in platforms for business analytics, enabling valuable insights for data-driven decision-making. As a detail-oriented professional, He possesses the technical thinking skills to identify innovative solutions for business problems and is deeply committed to the company’s advancement. Orchestrating the end-to-end business intelligence process from defining the business problem to conducting thorough analysis, visualizing insights, and deploying impactful dashboards. Bring a comprehensive skill set to drive the entire lifecycle of business intelligence. He is motivated to continuously learn and grow, keep collaborating, and provide exceptional abilities to drive success.

REGISTER NOW

Get In Touch

PT. Algoritma Data Indonesia.
RDTX Square, 9th Floor. Setiabudi, DKI Jakarta 12930.
Office: 0816-692-471
Email: community@algorit.ma

Data Science School

For Corporates
For Individuals
Alumni
Testimonials

Company

About us
Contact us
Join Us
Blog
Press