Excel & Copilot – Beyond the Basics

Elevate Your Productivity – Excel & Copilot in Action

This session is designed for users of Copilot and Excel that are familiar with basic navigation and tool use. We will look at more complex features and implementations of Copilot.

• Data Cleaning
• Creating and Troubleshooting Complex Formulas
• Analysis and Forecasting with Python in Excel
• Visualising Data with PivotTables, PivotCharts and Python Charts

We will follow through one 5-year Sales Data set example from start to finish.

This content is detailed practical, with some theory of capabilities.

Learning Outcomes:

Attendees can expect to learn:

• The capabilities of Copilot in handling large datasets, following the BI process from raw data to enrichment and analysis followed by presentation. This will end with workable metrics for decision making
• Copilots Data cleaning tool and other approaches to cleaning.
• Writing complex formulas with Copilot / troubleshooting
• Using Python to create a forecast of future data.
• Presenting this in clear charts and tables

Suited to:

Accountants, and those in the finance sector who want to learn how to combine Excel with Copilot

This On Demand recording Includes: 

• Recording of the Live Webinar, which can be viewed multiple times, for as long as required 
• Presenters contact details for follow up questions 
• CPD Quiz
• CPD Certificate 
• CPD Report – Logged automatically 
• PowerPoint Presentation
• Verbatim Transcript, with Searchability
• Supporting Documentation