Purchase any WEBINAR and get
10% Off
CODE: SAVE10
T&C applicable, please referFAQ
Validity : 22nd Aug'25 to 01st Sep'25
Microsoft Excel: Slice, Dice & Summarise: Getting started with Pivot tables
- Understand what PivotTables are and why they’re useful
- Create a basic PivotTable from raw data
- Navigate the PivotTable Field List and layout options
- Summarize data using different aggregation methods (Sum, Count, Average)
- Apply filters and slicers for dynamic data exploration
- Format PivotTables for clarity and presentation
Overview of the webinar
PivotTables are one of Excel’s most powerful tools for data analysis. This webinar introduces the core concepts and practical steps to start using PivotTables effectively, even if you’re new to data manipulation.
It will cover details on what pivot tables are and why you would use them, and how to create a basic one from scratch. It will also cover the different functions the pivot table can use as well as ways to filter the data and change basic formatting.
Who should attend?
- Finance
- Marketing
- Sales
- Operations
- Logistics
- HR
- Recruitment
- Financial Analysts
- Human Resource Personnel
- IT Professionals
- Education and Research
- Social Media Specialists
- Staff at all Levels
- Bookkeepers
- Business Owners
- Chief Executives
Basically, anyone who works with data in Excel can benefit!
Why should you attend?
Pivot tables can summarise large datasets quickly, help you gain insights into your data to support business strategies and more. They do not require any knowledge of programming or functions to produce well structured overview information in seconds.
Faculty - Ms.Lara Mellor
Lara Mellor has worked as a Microsoft Trainer since 1997. She is a subject matter expert in most of the Microsoft Applications. She has a mathematical background so specialises in packages that are logical and analytical such as Excel, Power BI and Project. She also is very excited by the fast paced developments with Microsoft’s AI tool Copilot. She is based in the North East of England and has delivered training courses, run webinars and provided one to one support (both online and face to face) to a large range of UK based companies but also internationally. Lara has also done a range of Excel analysis and development work for clients providing them with a finished working solution.