MS Excel - Advanced Data Analysis
Annotation:
MS Office course designed for employees of the University of South Bohemia.
More information:
Advanced techniques for working with pivot tables for effective data analysis, reporting, and visualization without the need for programming.
Introduction to pivot tables
• Definition and purpose of a pivot table
• Difference between a regular table and a pivot table
• Preparing data for analysis (cleaning, structure, format)
Creating a pivot table
• Inserting a pivot table from a data list
• Selecting fields for rows, columns, values, and filters
• Basic settings and interface orientation
Editing and formatting
• Changing the calculation type (sum, count, average, max/min)
• Customizing field names and number formatting
• Grouping data by category, number range, or time unit
Filtering and sorting
• Using filters in a pivot table
• Working with slicers and the timeline
• Sorting data by value or alphabetically
Calculation fields and custom calculations
• Creating a custom calculation field
• Displaying values as a percentage of the total, difference from the previous value
• Comparing categories
Pivot charts
• Creating a chart from a pivot table
• Dynamic updates when data changes
• Selecting the appropriate chart type for a given analysis
Files:
Ke kurzu nejsou žádné přílohy
Contact:
Mgr. Vendula Mikolášková
