Setup Menus in Admin Panel

Course Curriculum

0.0 Data Analysis with Excel Pivot Tables - Course Details
0.0 Data Analysis with Excel Pivot Tables – Course Details 00:00:00
1.1 Course Materials & Outline
1.1 Course Materials & Outline 00:00:00
1.2 Downloading the Course Resources
1.2 Downloading the Course Resources 00:00:00
1.3 Resource Files and Datasets
1.3 Resource Files and Datasets 00:00:00
1.4 Getting to Know the IMDb Movie Database
1.4 Getting to Know the IMDb Movie Database 00:00:00
1.5 Setting Expectations
1.5 Setting Expectations 00:00:00
2.1 Why PivotTables
2.1 Why PivotTables 00:00:00
2.2 Structuring Your Source Data
2.2 Structuring Your Source Data 00:00:00
2.3 Inserting Your First PivotTable
2.3 Inserting Your First PivotTable 00:00:00
2.4 Navigating the Field List
2.4 Navigating the Field List 00:00:00
2.5 PivotTable Options Analyze & Design
2.5 PivotTable Options Analyze & Design 00:00:00
2.6 Selecting, Clearing, Moving & Copying Pivots
2.6 Selecting, Clearing, Moving & Copying Pivots 00:00:00
2.7 Refreshing & Updating Pivots
2.7 Refreshing & Updating Pivots 00:00:00
2.8 Pro Tip Dealing with Growing Source Data
2.8 Pro Tip Dealing with Growing Source Data 00:00:00
2.9 How PivotTables ACTUALLY Work
2.9 How PivotTables ACTUALLY Work 00:00:00
3.1 Number Formatting
3.1 Number Formatting 00:00:00
3.2 Pro Tip Automatically Formatting Empty Cells
3.2 Pro Tip Automatically Formatting Empty Cells 00:00:00
3.3 Table Layouts & Styles
3.3 Table Layouts & Styles 00:00:00
3.4 Pro Tip Using Tabular Tables to Create New Source Data
3.4 Pro Tip Using Tabular Tables to Create New Source Data 00:00:00
3.5 Customizing Headers & Labels
3.5 Customizing Headers & Labels 00:00:00
3.6 Conditional Formatting
3.6 Conditional Formatting 00:00:00
3.7 Pro Tip Data Bars with Invisible Text
3.7 Pro Tip Data Bars with Invisible Text 00:00:00
4.1 Sorting Options
4.1 Sorting Options 00:00:00
4.2 Pro Tip Why is my Alphabetical Sorting Wrong
4.2 Pro Tip Why is my Alphabetical Sorting Wrong 00:00:00
4.3 Label Filters & Manual Selections
4.3 Label Filters & Manual Selections 00:00:00
4.4 Pro Tip Using Label Filters with Wildcards
4.4 Pro Tip Using Label Filters with Wildcards 00:00:00
4.5 Value Filters
4.5 Value Filters 00:00:00
4.6 Pro Tip Enabling Multiple Filters
4.6 Pro Tip Enabling Multiple Filters 00:00:00
4.7 Pro Tip Enabling Multiple Filters
4.7 Pro Tip Enabling Multiple Filters 00:00:00
4.8 Pro Tip Automatic Date Grouping
4.8 Pro Tip Automatic Date Grouping 00:00:00
4.9 Using Slicers & Timelines to Filter Data
4.9 Using Slicers & Timelines to Filter Data 00:00:00
4.10 Breaking Out Report Filter Pages
4.10 Breaking Out Report Filter Pages 00:00:00
5.1 Breaking Out Report Filter Pages
5.1 Breaking Out Report Filter Pages 00:00:00
5.2 Pro Tip Avoiding the Count Of Trap
5.2 Pro Tip Avoiding the Count Of Trap 00:00:00
5.3 Show Values As Calculations
5.3 Show Values As Calculations 00:00:00
5.4 Show Values As % of ColumnRow
5.4 Show Values As % of ColumnRow 00:00:00
5.5 Show Values As % of Parent
5.5 Show Values As % of Parent 00:00:00
5.6 Show Values As Difference From
5.6 Show Values As Difference From 00:00:00
5.7 Show Values As Running Total
5.7 Show Values As Running Total 00:00:00
5.8 Show Values As Rank
5.8 Show Values As Rank 00:00:00
5.9 Show Values As Index
5.9 Show Values As Index 00:00:00
5.10 Inserting Calculated Fields
5.10 Inserting Calculated Fields 00:00:00
5.11 Calculations in Pivots vs. Raw Data
5.11 Calculations in Pivots vs. Raw Data 00:00:00
5.12 Pro Tip Calculating Using Counts
5.12 Pro Tip Calculating Using Counts 00:00:00
5.13 Pro Tip Calculating Using Counts (Part 2)
5.13 Pro Tip Calculating Using Counts (Part 2) 00:00:00
5.14 Inserting a Calculated Item (Not recommended!)
5.14 Inserting a Calculated Item (Not recommended!) 00:00:00
5.15 The Solve Order & List Formulas Tools
5.15 The Solve Order & List Formulas Tools 00:00:00
6.1 Intro to PivotCharts
6.1 Intro to PivotCharts 00:00:00
6.2 PivotChart Demo Column Chart
6.2 PivotChart Demo Column Chart 00:00:00
6.4 PivotChart Demo Clustered Bar Chart
6.4 PivotChart Demo Clustered Bar Chart 00:00:00
6.5 Pro Tip Prevent Charts from Resizing with Cells
6.5 Pro Tip Prevent Charts from Resizing with Cells 00:00:00
6.6 Pro Tip Prevent Charts from Resizing with Cells
6.6 Pro Tip Prevent Charts from Resizing with Cells 00:00:00
6.7 PivotChart Demo Stacked Area Chart
6.7 PivotChart Demo Stacked Area Chart 00:00:00
6.8 PivotChart Layouts & Styles
6.8 PivotChart Layouts & Styles 00:00:00
6.9 Moving PivotCharts to New Sheets
6.9 Moving PivotCharts to New Sheets 00:00:00
6.10 Applying Slicers & Timelines to Multiple Charts
6.10 Applying Slicers & Timelines to Multiple Charts 00:00:00
6.11 Building a Dynamic Dashboard
6.11 Building a Dynamic Dashboard 00:00:00
7.1 Setting Expectations
7.1 Setting Expectations 00:00:00
7.2 Setting Expectations
7.2 Setting Expectations 00:00:00
7.3 San Francisco Salaries
7.3 San Francisco Salaries 00:00:00
7.4 Shark Attack Records
7.4 Shark Attack Records 00:00:00
7.5 Stock Market Data
7.5 Stock Market Data 00:00:00
7.6 Baseball Team Stats
7.6 Baseball Team Stats 00:00:00
7.7 San Diego Burrito Ratings
7.7 San Diego Burrito Ratings 00:00:00
7.8 Daily Weather Conditions
7.8 Daily Weather Conditions 00:00:00
7.9 Spartan Race Facebook Posts
7.9 Spartan Race Facebook Posts 00:00:00
8.1 Resources & Next Steps
8.1 Resources & Next Steps 00:00:00
Data Analysis with Excel Pivot Tables Course Details
Data Analysis with Excel Pivot Tables Course Details 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

PRIVATE COURSE
  • PRIVATE
  • 1 week, 3 days
1 STUDENTS ENROLLED
Copyright @2019