Linkedin - Excel PivotTables For Begi...

Info Hash289432B65748ABE7ED600D5E2CFDD138B8BADC59

Course details

PivotTables don't have to be scary! This powerful Excel feature cuts the time you spend on formulas in half. In this concise course, Excel trainer Dave Ludwig demystifies PivotTables and shows you how to get started using them to analyze your data. Dave begins by explaining two PivotTable basic building blocks: value fields and row fields. Then he shows you how to adjust a PivotTable by adding fields, filters, and formatting. Dave shows you how to use special filter buttons which are known as slicers, and he also demonstrates how to use timelines. Plus, he goes over the basics of refreshing and updating a PivotTable. Finally, he’ll show you how to use AI in Excel to generate PivotTables automatically for you

1. Introduction/1. Excel PivotTables made simple- Analyze data with ease.mp43.67 MiB
1. Introduction/2. Using the exercise files and Excel versions.mp42.24 MiB
2. Basic PivotTable Concepts/1. What is a PivotTable.mp45.34 MiB
2. Basic PivotTable Concepts/2. Prepare your data.mp411.04 MiB
2. Basic PivotTable Concepts/3. A word about fields.mp48.38 MiB
3. Building Your First PivotTable/1. Start building a PivotTable.mp43.78 MiB
3. Building Your First PivotTable/2. Create the value field first.mp49.81 MiB
3. Building Your First PivotTable/3. Create row fields.mp412.82 MiB
3. Building Your First PivotTable/4. Create column fields.mp411.52 MiB
3. Building Your First PivotTable/5. Create filters.mp414.07 MiB
3. Building Your First PivotTable/6. Updating a PivotTable.mp46.28 MiB
3. Building Your First PivotTable/7. Create a PivotTable with AI.mp413.61 MiB
4. Conclusion/1. Where to learn more about PivotTables.mp42.51 MiB

Linkedin - Excel PivotTables For Beginners

Continue browsing

Description

Files (13)