Skip to main content
by learnformula
search
For Business
Team license & compliance management
For Higher Education
Academic partnerships
For Government Agencies
Government training solutions
For Instructors & Course Creators
Teach on our marketplace
Become a Sponsor
Reach 9M+ professionals
Log inStart 7-Day Free TrialStart Free TrialStart Free Trial
search
Courses/Office Productivity/Microsoft

Microsoft Copilot for Excel

Transform your data analysis workflow with Copilot and Python integration for advanced Excel modeling.

Created byGrant Gamble
IntermediateUpdated Oct 16, 2026
Microsoft Copilot for Excel

What You'll Learn

check_circleExplain what Copilot in Excel can see and prepare your workbooks so it gives accurate, relevant answers
check_circleChoose between Chat, Plan and Edit modes and write specific prompts that get the right result first time
check_circleCreate, check and fix formulas with Copilot, from single cells to dynamic arrays such as FILTER, SORT and VSTACK
check_circleTurn business rules into readable, reusable formulas using LET, LAMBDA, BYROW and MAP
check_circleBuild self-updating reports with GROUPBY and PIVOTBY, and decide when a PivotTable is still the better choice

About This Course

This course contains the use of artificial intelligence. AI tools are used in the production of this course, including AI-assisted speech delivery based on the instructor’s own voice. All content, demonstrations, workbooks, and prompts have been personally designed, reviewed, and verified by the instructor to ensure accuracy and practical value.

Copilot in Excel can now read your workbook, write formulas, build reports and even create complete solutions from a single prompt. This course shows you how to use it properly: how to get reliable answers, how to check what it gives you and how to stay in control of your file.

Across 7 sections and 36 lessons, with around 7 hours of video, every lesson comes with a practice workbook so you can follow along and try each prompt yourself. You will work with realistic business data, not toy examples.

What you will cover:

  • Getting started: what Copilot can see, licensing and platforms, and choosing a model.
  • Working with Copilot: Chat, Plan and Edit modes, writing specific prompts and iterating on results.
  • Formulas: everyday edits, dynamic arrays such as FILTER, SORT and VSTACK, and reusable logic with LET, LAMBDA and BYROW.
  • Reporting and analysis: GROUPBY and PIVOTBY reports, charts and PivotTables.

Why this course is different:

  • It is honest about where Copilot gets things wrong, and teaches practical checks so you can trust its output to the right degree.
  • It explains why a prompt works, so you can write your own rather than copying templates.
  • It shows when not to use Copilot, because sometimes a shortcut or a simple formula is quicker.
  • No Python or advanced formula experience is needed. Copilot does the heavy lifting; you learn to direct and review it.

By the end of the course you will be able to hand routine and complex Excel work to Copilot with confidence, knowing how to check the results and reverse any change. Enrol now and start getting more from Excel today.

Who this course is for:

  • Excel users who want Copilot to save them time on everyday formulas, formatting and analysis.
  • Finance, operations, HR and sales professionals who build reports, trackers and models in Excel.
  • Analysts who want to use dynamic arrays, LAMBDA and Python in Excel without learning all the syntax first.
  • Team leads and IT staff rolling out Copilot who need to understand licensing, safe editing and governance.
  • Anyone who has tried Copilot in Excel, found the answers disappointing and wants dependable results.

Your Instructor

Grant Gamble
Grant Gamble

CEO of AI Awareness Limited | 25+ years in IT training | Helping non-technical professionals go from AI-curious to AI-confident

menu_book1 courses

Grant Gamble has spent over 25 years in IT and technology training, working with businesses across the UK on practical AI adoption. He is CEO of AI Awareness Limited and founder of G Com Solutions Limited, and specialises in helping non-technical professionals move from AI-curious to AI-confident through hands-on, domain-specific training and certification. Grant's view is that AI is not a single tool but a set of capabilities spread across every department, often underused or ungoverned. The organisations making real progress are not the ones running generic awareness programmes; they are the ones mapping specific AI capabilities to specific workflows and giving their people the time and permission to use them. His courses take exactly that approach. His teaching covers practical AI literacy for non-technical professionals, AI skills and workforce readiness, and the governance and responsible use of AI at work. Expect a hands-on style: real business examples, clear explanations of why each technique works, and skills you can apply to your own work straight away.

Credit Information

What Students Are Saying

0.0
Student's Choice
0 reviews

Frequently Asked Questions

We are a registered provider with 327+ associations and regulatory bodies worldwide. We operate across 29 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

You May Also Like

Office Productivity: Microsoft

Microsoft Teams 365 for Beginners

star5.0(2)
2.5 CPD hrs
Accounting & Tax: Soft Skills for Accountants

Taking Charge of Your Accounting Career in a Changing World

star5.0(7)
1 CPD hr
Career Development: Career Skills

The Era of Transformation: Redesigning Your Career

star5.0(1)
1.5 CPD hrs