Office workflows

Microsoft Copilot for Data Analysis and Visualization

Use Copilot in Excel to generate Power Query code, clean and reshape data, analyze anomalies and create charts or dashboards.

Available

Take a closer look.

See the full outline, latest price and registration details.

View course
Format
Self-paced
Time
Ten displayed module estimates total about 6h52 (6m, 24m, 1h, 1h, 1h, 29m, 24m,…
Tools
Microsoft Copilot, Microsoft Excel, Microsoft PowerPoint
Level
Intermediate
Language
English

What you’ll learn

  • Ten modules cover Power Query M-code generation and configuration
  • Cleaning/standardizing, pivoting, parsing, derivations and anomaly checks
  • Descriptive statistics, correlations, trends and hypothesis testing
  • Excel visualizations
  • Interactive Power BI dashboards and real-time refresh/sharing
  • Copilot in Excel
  • PowerPoint/Word summaries and storyboards
  • And data-backed project reporting.
  • Named tools include Copilot, Excel, Power BI, Power Query and PowerPoint.

What does the learning look like?

  • Nine assignments are listed.
  • Module assessments include data preparation/Excel automation, business data insights, dashboard/report building and spreadsheet workflow tasks
  • Lesson pages also name a hands-on complete analysis-report exercise.
  • Hands-on lessons
Example to try

Connect a repeated task

  1. 01Start with

    A message, form or new file

  2. 02Make a first pass

    A useful record in the next app

  3. 03Make it yours

    Review the result before saving or sending

Use a fictional example to practise the workflow.

Cost, access and setup

What you’ll need

  • The page recommends basic Excel and Power BI understanding
  • No Copilot experience is required.
  • It targets data analysts, BI professionals, project managers and people working with large datasets.
  • Requires access to relevant Microsoft analytics products

How you’ll learn

  • Ten displayed module estimates total about 6h52 (6m, 24m, 1h, 1h, 1h, 29m, 24m, 29m, 1h, 1h)
  • These are the module estimates only.
  • Self-paced Coursera course, based on a Packt publication/course by Anton Voroniuk and licensed/distributed by Packt.

Certificate

  • Shareable Coursera course certificate listed
  • Not a Microsoft Power BI certification or evidence of external recognition.

Help along the way

  • Nine assignments and one named hands-on report exercise are listed

Instructor

  • Packt is the licensing/distribution publisher.
  • Curriculum source is attributed to Anton Voroniuk
  • The Coursera listing panel says Packt - Course Instructors without a named instructor profile.

Course cost

Check the course page for current pricing.

Keep exploring