Wszystko co chcesz wiedzieć o tabelach przestawnych
Boost productivity & analyze data! Learn how to shorten work hours and leverage powerful analytics tools. Discover efficiency secrets now.
Course Content
Wszystko co chcesz wiedzieć o tabelach przestawnych is an intermediate-level Udemy course taught by Norbert Waszak. It runs 6h 2m, is taught in Polish, and includes a certificate of completion. Learners rate it 4.7 out of 5 from 116 reviews, with 640 students enrolled. It is a paid course, first published March 2020.
Data Preparation & Data Structures: Learn the essential steps for preparing your data for analysis. Understand different data structures and explore various data sources, including how TP utilizes data.
Pivot Table Design: Master the art of creating powerful pivot tables. We'll cover best practices for designing effective pivot tables to extract meaningful insights.
- Understanding the Difference: Table vs. Range - Clarify the distinction between using a table and a range as your data source.
- Working with Dates in Excel - Get a solid grasp of how to handle and manipulate dates within your pivot tables.
Data Analysis with Pivot Tables: Unlock the power of pivot tables for in-depth data analysis.
- Transforming Functions: Discover how to modify functions within your pivot tables to tailor your analysis.
- Calculating Percentages: Easily display data as percentages to highlight key trends.
- Quantity vs. Quality: Analyze the relationship between quantity and quality within your datasets.
- Pivot Table Formatting: Learn to format your pivot tables for clear and impactful presentation.
- Drilling Down for Details: Explore how to quickly access detailed information within your pivot tables.
- Report Filter Pages: Understand and utilize report filter pages for dynamic data exploration.
- Time Series Analysis: Master date grouping techniques for analyzing data over time.
- Grouping by Week: Group data by week for weekly trend analysis.
- Grouping Numerical Values: Group numerical data for aggregated insights.
- Identifying Top Performers Over Time: Determine who has the highest average performance over a specified period.
- Year-over-Year Comparison (% Difference): Calculate and interpret year-over-year growth or decline percentages.
- Calculated Fields: Create custom calculated fields to derive new metrics from your existing data.
- Using the "Get Data" Function: Leverage the "Get Data" function for advanced data manipulation.
- Multiple Filters in One Field: Apply multiple filters to a single field for refined data filtering.
Pivot Charts: Visualize your data effectively with pivot charts.
- Why Use Pivot Charts? Understand the benefits of using pivot charts compared to standard charts.
- Dual-Axis Charts: Learn when and how to use charts with two axes for complex data representation.
- Line Charts: Create compelling line charts to illustrate trends and patterns.
- Visualizing Trends (Spikes & Dips): Identify significant spikes and dips in your data through visual representation.
Power Pivot: Elevate your data analysis with Power Pivot.
- The Importance of Relationships: Understand the foundational role of relationships in Power Pivot.
- Data Sources Across Multiple Sheets: Connect data from multiple sheets within a single Excel workbook.
- Data Sources from Various Files: Import data from diverse files, including different formats and sources.
- Measures in Power Pivot: Create powerful measures to perform complex calculations.
Want AI in your product? Hire the team behind TutorialSearch.io
LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.