How to Create Pivot Table in Excel | Step-by-step Tutorial

Learn how to create a Pivot Table in Microsoft Excel step by step in this beginner-friendly tutorial, so that you can quickly and easily analyze data. We start with how to prep your data and then walk through all the core functionality of pivot tables, including sorting, filtering, inserting charts, slicers, and more. Perfect for students, engineers, and anyone working with messy datasets in Excel. 00:00 Introduction & Overview of Raw Data 00:55 Pivot Table 02:54 Value Settings 04:35 Filters 05:25 Chart & Slicer 06:13 Refresh Table How to Use Custom Text Formatting in Excel | Quick Tutorial (2 min) https://youtu.be/I0GEStp6ZGw Import data from files to Excel: https://youtu.be/lZkcWJKLXXQ Remove, Sum & Find Related Values with Duplicates using UNIQUE(), COUNTIF(), SUMIF(), and MATCH(): https://youtu.be/bgEu1zmaxx0 Consolidate Multiple Tables into One in Excel Using CONSOLIDATE() (2 min): https://youtu.be/iOsg_rR5IDI Example 8.1 Spreadsheet Tools for Engineers Using Excel, 4th Edition, Byron S. Gottfried, (2019), McGraw Hill #excel #pivot_table #pivottables