Excel Pivot and PowerPivot
1-Day Workshop
Learn how to create a task list with multiple people in a single cell and convert it into a list of people with tasks — all without programming! Discover how to implement automatic project planning with a Gantt chart. Simply input the start date and the number of days, and let Excel do the rest. The current date will automatically be highlighted. This seminar provides practical insights into how you can use these functions to work more efficiently and plan complex projects in an organized manner.
Workshop Content
Introduction to Pivot Tables:
- Preparing and organizing data
- Working with dynamic formatted tables from Excel 2010 onward
- Understanding the differences between lists and formatted tables
- Basic techniques for using pivot tables (building, structuring, and displaying results)
- Expanding pivot tables with calculated fields, filters/slicers, and grouping
- Analyzing pivot data as charts or passing results within Excel
- Understanding the limitations of pivot tables
Introduction to PowerPivot:
- Installing PowerPivot
- The structure and interface of PowerPivot
- Using PowerPivot as a replacement for VLOOKUP, linking worksheets
- Merging data from different sources (Excel tables, text files, databases) within PowerPivot
- Linking data from various sources through relationships
- Accessing databases using PowerPivot
- Adding additional data sources to existing PowerPivots
- Selecting and filtering data for analysis in PowerPivot; hiding irrelevant data and information
- Creating multidimensional PowerPivot reports and charts
Learning Basic Calculation and Analysis Functions:
- Creating links, analyses, and calculations
- A look at some of the 133 additional DAX functions such as CALCULATE, SUM, IF, AND/OR, DATE, ALL, RELATED, ...
- Visualizing results
- Creating dynamic and versatile charts
- Visualizing multiple charts in one analysis
- Visualizing key figures with KPIs (Key Performance Indicators)
- Creating dashboards for graphical data analysis
Who Should Attend This Workshop?
This workshop is aimed at employees in the commercial sector, management, and controlling, as well as users in administrative departments, staff functions, trainers, freelancers, and small business owners. In short, anyone looking to deepen and perfect their MS Excel skills.