Here are the tips💡 to get the most out of the course
🧑💻 Consistency is Key: Dedicate regular time to study and practice.
📣 Engage with the Course: Participate in discussions and ask questions. You will find the course forum↗ on the top right corner of this learning page.
💪🏻Apply What You Learn: Practice with real datasets to reinforce concepts. Download the dataset and practice what is covered in the video before moving to the next lesson.
.png){kind=small}
.png){kind=small}
Class Sessions
1- Introduction to PivotTables
2- Navigating the areas of a PivotTables
3- Analyze Data with multiple fields
4- Demo: Working with multiple fields
5- Change PivotTable Default Name
6- Summary Aggregations
7- Show values as % of Grand Total
8- Show values as % of Row Total
9- Show values as % of Column Total
10- Show values as % of Parent Row Total
11- Showing running totals
12- Time Intelligence calculations
13- Show ranking
14- Introduction to calculated fields
15- Calculated Fields 2
16- Calculated Fields 3
17- PivotTables Styles
18- Customize PivotTable Styles
19- PivotTables Layouts
20- PivotTables Layout options
21- PivotTables Fields Pane
22- Sorting PivotTables
23- Filtering PivotTables
24- Filtering PivotTables with Slicers
25- Connecting slicers to multiple PivotTables
26- Filter Table with Timelines
27- Grouping Data with PivotTable
28- Working with PivotCharts
29- Working with modern charts
30- Applying conditional formatting
31- Working with Sparklines - Line
32- Working with Sparklines - Bar
33- Working with Sparklines - Win/ Loss
34- Show report filter pages
35- Show PivotTable values detail
36- Using GETPIVOTDATA function
37- Course Conclusion
38- Guided Project 1
39- Guided Project 2
40- Capstone Project
41- Course Overview
42- Welcome to the course
43- Datasets walkthrough
18 Weeks Business Intelligence and Data Analytics
.png)
Learn advanced Excel, Power BI, SQL and AI. Become a Business Intelligence Analyst or Data Analyst.