2. Excel Advanced Part 2
Data Management & Pivot Tables
When managing large construction or engineering datasets, Excel’s data management and Pivot Table tools are essential. This course teaches you how to clean, validate, and organize data efficiently before transforming it into powerful reports and visual insights. You’ll create Pivot Tables and Pivot Charts that automatically update, enabling quick comparisons and summaries across multiple projects or departments.
By learning to control and visualize your data effectively, you’ll turn raw information into actionable intelligence—saving hours of manual work while improving reporting accuracy and decision-making.
-
Collecting Data using Data Validation
-
Add data validation, including using pick lists
-
Remove duplicate data; highlight invalid data
-
Advanced Filtering of Data
-
Summarizing data with Pivot Tables
-
5 steps in creating your first Pivot Table from a data set
-
Using a Pivot Source sheet to efficiently create multiple reports
-
Creating and printing multiple custom reports
-
Visualizing data with Pivot Charts
-
Applying slicers to data and charts
Course duration:4 hours.