Office Series 2024 - Better Data Analysis with PowerPivot - 7 November 2024 (On Demand)
1.25 CPD Hours
Description
Unlock the full potential of Excel with PowerPivot! Import millions of rows, create complex data models, and perform advanced analysis—all within a familiar environment. Master PowerPivot and transform your data into actionable insights
If you are a fan of PivotTables you will love PowerPivot!
PowerPivot enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance.
Join us in this webinar and learn what PowerPivot is, how to activate and how to conduct powerful business intelligence (BI) in an environment that is familiar.
Please Note: PowerPivot is built in to Excel since Office 2013. We will be demonstrating using Microsoft Excel 365 but the content will be relevant to users of earlier versions.
ORIGINAL BROADCAST DATE
7 November 2024
LEARNING OUTCOMES
At the end of this webinar you will be familiar with:
- What is PowerPivot?
- Activating the PowerPivot
- The PowerPivot tab
- The PowerPivot managed window
- Adding data to the data model from various sources
- Add data by using copy and paste
- Create relationships between tables
- Create a PivotTable from PowerPivot data
- Add slicers to PivotTables
SUITED TO
This webinar is designed for Financial Controllers, Business Analysts, Business professionals, Administration support, Business owners and anyone who requires to do data analysis and data modeling in Excel.
Attendees must be familiar with Excel and PivotTables.
PRESENTER
Michael Blignaut, Senior IT Trainer, Lumify Work New Zealand.
Michael is an enthusiastic and certified Microsoft IT Trainer. He is able to offer a wide range of Microsoft end-user, soft skills, business skills and project management training. He has extensive experience delivering training in a variety of formats including classroom, video conference/webinar and in one-to-one sessions.