This course is delivered live online, remotely across Indonesia. 

To attend remotely from Indonesia, select "Remote East" or "Remote West" as your location when you book now.

Microsoft Copilot for Excel puts the power of AI right into your spreadsheets and this course shows you exactly how to use it. Learn how to clean and analyse data, generate formulas, build dashboards, and create visual reports using natural language commands.

In this hands-on training, you’ll explore practical ways to streamline your Excel tasks, uncover insights, and boost productivity using Microsoft 365 Copilot. No coding required! just smarter ways to work.

By the end of the course, you’ll be able to:

  • Navigate and use Copilot features in Excel
  • Query data using natural language
  • Clean and audit data using built-in AI tools
  • Generate and troubleshoot formulas
  • Build PivotTables and visualisations
  • Format spreadsheets for readability and impact
  • Perform advanced analytics with Python in Excel
  • Summarise and present data clearly and professionally

Course Details

Download Course PDF
Price
Rp 5.780K
Duration
1 day
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
Address
N/A

Upcoming Courses

Remote JKT

Remote JKT

We currently have no public courses scheduled. Please contact us to register your interest.

Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Copilot Training Courses

Course Icon Copilot for M365

Learn how to use Copilot across Word, Excel, Outlook and more. Get hands-on with AI-powered tools to boost productivity and streamline everyday tasks.

download course pdf
Price: Rp 5.058K
Course Icon Copilot for Outlook and Teams

Work smarter in Outlook and Teams. Learn how Copilot helps you manage emails, plan meetings and collaborate more efficiently.

download course pdf
Price: Rp 5.780K
Course Icon Copilot for PowerPoint

Turn ideas into polished presentations with AI. Learn how to draft slides, enhance visuals and create content using natural language.

download course pdf
Price: Rp 5.780K
Course Icon Copilot for Word

Write, edit and summarise documents faster with Copilot. Save time and improve quality using AI in Microsoft Word.

download course pdf
Price: Rp 5.780K

Copilot for Excel Indonesia Course Content

Expand All | Collapse All

Introduction to Copilot for Excel

Understand the course scope and objectives

Familiarise with Excel Copilot interface and usage

Quick demo of Excel Copilot

Learner introductions and experience sharing

Exploring and Understanding Data

Query and summarise data with natural language

Identify key insights quickly

Guided practice querying Copilot

Explore provided dataset and identify insights

Group discussion on insights discovered

Data Cleaning & Quality Auditing

Use Excel’s AI-powered Clean Data tool

Understand data quality and consistency issues

Clean Data demonstration

Hands-on activity with intentionally messy data

Simple Formulas & Functions

Generate basic Excel formulas with Copilot assistance

Understand and verify created formulas

Creating calculated columns and simple summaries

Hands-on creating formulas and verifying results

Complex Formulas & Troubleshooting

Build complex formulas using Copilot

Troubleshoot formulas with Copilot assistance

IF, VLOOKUP and INDEX-MATCH formulas

Troubleshooting broken formulas

Formatting & Conditional Formatting

Improve spreadsheet readability with formatting

Dynamically highlight data using conditional formatting

Copilot formatting commands (bold, currency formatting)

Conditional formatting examples (top values, thresholds)

Hands-on formatting practice

Advanced Analysis using Python in Excel

Understand Excel's integration with Python for advanced analytics

Perform complex analysis without coding

Sales forecasting and statistical analysis with Python through Copilot

Learners observe and discuss real examples (forecast, correlation analysis, advanced visualisation)

Visualising Data – Charts, Pivot Tables and Displays

Summarise data using PivotTables with Copilot

Understand pivot layouts and interpret data summaries

Visualise data insights with Excel charts using Copilot

Present data clearly and professionally

Pivot creation for sales by region/product

Creating and customising a chart with Copilot

Frequently Asked Questions

What is Microsoft Copilot and how does it use AI?

Microsoft Copilot is an AI-powered tool built into Microsoft 365 apps like Word, Excel, Outlook, PowerPoint, and Teams. It helps you complete tasks faster and more efficiently by generating content, summarising data, drafting emails, and assisting with workflows — all using natural language commands and the latest in AI technology.

What skills will I gain from attending these courses?

You’ll learn how to use Microsoft Copilot to write and edit documents, analyse data, manage emails and meetings, build presentations, and collaborate more effectively. You’ll also develop practical skills in crafting effective prompts, improving Copilot output, and using AI responsibly in a work environment.

Who can benefit from these courses?

These courses are ideal for Microsoft 365 users across any industry — whether you're an executive, admin assistant, analyst, marketer, or team leader. If you're looking to save time, automate tasks, and enhance the way you work with familiar Microsoft apps, these courses are for you.

Do I need any prior AI knowledge before taking this course?

No prior knowledge of AI is required. These courses are designed for everyday users of Microsoft 365. We’ll guide you through Copilot features step by step, and you’ll gain hands-on experience throughout the course.

Can I take these courses online?

Yes. Our Microsoft Copilot courses are available via live online sessions, in-person classes across major cities, and hybrid formats. You’ll receive the same expert-led training experience regardless of how you choose to attend.

Will there be practical exercises during the course?

Absolutely. All Copilot courses include interactive, hands-on exercises. You’ll use Microsoft 365 Copilot within real apps like Word, Excel, Outlook, or Teams to practise prompts, automate tasks, and apply what you’ve learned in a practical setting.

What is remote training?

Remote training is delivered live by our expert instructors via video conferencing. You’ll be able to ask questions, participate in discussions, share your screen for help, and complete activities in real time — just like in a traditional classroom.

What Microsoft Copilot courses are available from Nexacu?

We currently offer five Copilot-focused courses:

- Copilot for Microsoft 365
- Copilot for Word
- Copilot for Excel
- Copilot for PowerPoint
- Copilot for Outlook and Teams

Is there a certification upon completion of these courses?

Yes. You’ll receive a Nexacu Certificate of Completion to verify your skills with Microsoft Copilot. It’s perfect for sharing on LinkedIn or adding to your CV.

Course Details

Download Course PDF
Price
Rp 5.780K
Duration
1 day
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
Address
N/A

skills test nexacu

Skills Test

Try our short skills test and find out which course is right for you.

 skills test

 

Contact Us

Can’t find a suitable date or have questions about the course? Fill out the form below, and our team will get back to you promptly.

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Related Training Courses

Course Icon Copilot for M365

Learn how to use Copilot across Word, Excel, Outlook and more. Get hands-on with AI-powered tools to boost productivity and streamline everyday tasks.

download course pdf
Price: Rp 5.058K
Course Icon Copilot for Outlook and Teams

Work smarter in Outlook and Teams. Learn how Copilot helps you manage emails, plan meetings and collaborate more efficiently.

download course pdf
Price: Rp 5.780K
Course Icon Copilot for PowerPoint

Turn ideas into polished presentations with AI. Learn how to draft slides, enhance visuals and create content using natural language.

download course pdf
Price: Rp 5.780K
Course Icon Copilot for Word

Write, edit and summarise documents faster with Copilot. Save time and improve quality using AI in Microsoft Word.

download course pdf
Price: Rp 5.780K

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Trusted Globally by Leading Organisations

At Nexacu, we are proud to be the trusted training partner for hundreds of leading organisations across Australia, New Zealand, and around the world. From government agencies to multinational corporations, we help teams build practical skills and achieve real outcomes through expert-led training.

  • 400+ companies rely on Nexacu for workforce development
  • Trusted by government agencies at all levels
  • Delivering training across 9 countries and growing

Why Nexacu? 

step by step courseware

Step by Step Courseware

Custom workbook included with a step by step exercises

Facility Image 2
Facility Image 3
Facility Image 1

Interactive real time training

Interactive, Real-Time Training

Learn with expert instructors, wherever you are

Trusted by Business

Trusted by Business

Procured by Government

Procured by Goverment

Reviews Not Found

Valued by Individuals