inflearn logo

Using AI in Excel and Automating Data Analysis Workflows

Going beyond explanations of basic Excel functions, this hands-on course teaches the full workflow of recurring tasks in real-world work—from data entry, organization, preprocessing, calculations, analysis, and visualization to report writing and automation. It covers responsive dashboards, data preprocessing, AI-assisted macro coding, the latest Excel functions and features, Copilot, and Python in Excel, expanding Excel use from traditional applications into the AI era.

1 learners are taking this course

Level Beginner

Course period 1 months

AI
AI
Business Productivity
Business Productivity
AI Agent
AI Agent
Big Data
Big Data
Excel
Excel
AI
AI
Business Productivity
Business Productivity
AI Agent
AI Agent
Big Data
Big Data
Excel
Excel

What you will gain after the course

  • 1. Understand the structure of Excel data and data entry principles, and systematically manage work-related data.

  • 2. You can analyze and visualize business data using functions, pivot tables, charts, and data preprocessing features.

  • 3. You can automate repetitive Excel tasks and improve work productivity using the latest Excel features and generative AI.

Background and Rationale


Beyond using Excel merely as a tool for calculations and document creation,

Practical skills for systematically managing, analyzing, and automating data are becoming increasingly important.


This course is designed to address these issues by

Fundamental principles of data and databases → Data entry and preprocessing → Dates, times, and number formats → Sorting and filtering → Operators and cell references →

Essential functions for practical work → PivotTables and data visualization → Dashboards → Data preprocessing → AI-powered macro automation →

Expand the learning stages to include the latest Excel features and AI applications.


Market Overview


Excel use is expanding beyond simple document creation and calculations to include data analysis, visualization, dashboards, workflow automation, and AI applications.

Especially in the Microsoft 365 environment,

SORT, FILTER, UNIQUE, XLOOKUP, VSTACK, GROUPBY, PIVOTBY, etc.

With the emergence of new features such as the latest functions, importing data from the web and PDFs, Copilot, and Python in Excel,

Traditional ways of using Excel are also changing. The course materials also cover the latest functions, Copilot functions, Python in Excel, and more.

It presents the potential uses.


Expected Benefits


Reduce the time spent on repetitive data entry and organization.

Understand the structure of Excel data and data entry principles, and reduce errors.

You can automate repetitive calculations and data lookups using functions and cell references.

Can quickly analyze large volumes of data using pivot tables and charts.


Practical application in the workplace


I want to organize and manage Excel data systematically.

I want to reduce tasks that involve repetitive data entry or copying and pasting.

I want to use complex functions and formulas more efficiently.

I want to quickly analyze large amounts of data and identify key insights.


Recommended for
these people

Who is this course right for?

  • 1. An office worker who uses Excel every day at work

  • 2. Professionals who can use Excel for basic tasks but struggle with analysis

  • 3. Working professionals who want to master everything from functions, pivot tables, and charts to dashboards

  • 4. Professionals who want to reduce repetitive Excel tasks

  • 5. Working professionals who want to use Excel and Copilot together in the AI era

Hello
This is CON100

706

Learners

56

Reviews

4.8

Rating

55

Courses

Hello! We’re CON100, your training partner dedicated to boosting your work efficiency by 100%.

We provide practice-oriented content that unifies fragmented tasks into a single workflow, helping you create flawless 'deliverables' from proposals to reports.

Begin your transformation into a highly effective professional who commands systems with CON100!

More

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

CON100's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

Limited time deal ends in 6 days

$92,400.00

30%

$102.30