PivotTables Are Easy! 30 Examples for Highline College Professional Development Day 2014

Excel Basics 20: PivotTable Power: 14 Amazing PivotTable Reporting Tricks: Slicers to Show Values As

Highline Excel 2013 Class Video #35: Excel 2013 PivotTables: Basic To Advanced 58 Examples

Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model)

PivotTables & Slicers Made Easy! 4 Amazing Examples for WAAT Accounting Seminar August 26, 2016

Excel For Accountants: VLOOKUP & PivotTables Complete Lessons: Basic to Advanced: CWU Seminar

Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)

Slaying Excel Dragons Book #39: Data Analysis Pivot Tables & Pivot Charts, PivotTables & PivotCharts

Slaying Excel Dragons Book #40: Grouping Dates in PivotTables: Years, Months or Weeks, and more

Excel Magic Trick 1418: PivotTables Ranking For Unit & Total Profit for Products within Manufacturer

Excel Basics #20: Data Analysis Pivot Tables PivotTables

Highline Excel Class 20: Pivot Tables 20 Examples

You Tubers Love Excel#11: Pivot Table, SUMPRODUCT & SUMIFS

YouTubers Love Excel 12: Pivot Table AVERAGEIF SUMIF/COUNTIF

YouTubersLoveExcel#25: Dynamic Range for Pivot Table & Chart

Excel Name Trick #5: Names for Pivot Tables & more...

Excel Statistics 04: Frequency Pivot Table Chart Basics

YTLE#53: Excel Pivot Table and COUNTIF function

YTLE#59: Pivot Table for Age Account Receivable

Excel Statistics 16: Categorical Cross Tabulation with Pivot Table

Excel Statistics 19: Grouping Categories w Formula & Pivot Table

Excel Statistics 15: Category Frequency Distribution w Pivot Table & Pie Chart

YTLE#70 PivotTable & TRIM function & AVERAGES

Excel Statistics 24: Quantitative Freq. Dist. w Pivot Table

Excel Statistics 25: % Freq. Dist.& Histogram w Pivot Table

Excel Statistics 26: Cumulative Freq. Dist w Pivot Table (Running Total)

Excel Statistics 29: Quantitative Cross Tabulation W Pivot Table

YTLE#86: Pivot Table Filtering & Functions

YTLE#91: PivotTable: Average w MONTH criteria

Excel 2010 Magic Trick 812: PivotTable Show Report Filter Pages For School District Reports

YTLE#106: Alternatives To Pivot Tables - Excel

YTL Excel #124: Pivot Table Bowling Average

Excel Magic Trick #114: GetPivotData ISERROR and IF function

Excel Magic Trick #172: Running Total Formula or Pivot Table

Excel Magic Trick #168: Cross Tabulation For a Survey

Excel Magic Trick 216 Pivot Table 4 Variable Cross Tabulation

Excel Magic Trick #219: Pivot Table Macro w Dynamic Range #2

Excel Magic Trick #218: Pivot Table Macro w Dynamic Range #1

Excel Magic Trick 250 Pivot Table Unique List in Unique List

Excel Magic Trick 257 Convert Dates as Text to Dates As No.

Excel Magic Trick 401: Quarterly Comparative Report - Pivot Table (PivotTable)

Excel Magic Trick 402: Monthly Comparative Report - Pivot Table

Excel Magic Trick 403: March End Quarterly Comparative Report - Pivot Table

Excel Magic Trick 482: 2 Pivot Tables with Different Date Groupings On Same Sheet

Excel Magic Trick 498: 6 PivotTable Calculation Tricks (Pivot Table)

Excel Magic Trick 542: PivotTable Count How Many Times A Word Occurs In Word Document

Excel Magic Trick 556: Change PivotTable Source Data (Pivot Table)

Excel Magic Trick 710: average with 3 Criteria Using PivotTable Pivot Table

Mr Excel & excelisfun Trick 83: PowerPivot or Helper Column & PivotTable & Custom Number Format

Excel Magic Trick 805: Unique List When Adjacent Cell Contains 1 of 4 Words SEARCH Function & More

Excel 2010 Magic Trick 812: PivotTable Show Report Filter Pages For School District Reports

Excel 2010 Statistics #15: Frequency Distributions, Histograms, Column Charts (11 Examples)

Excel 2010 Statistics #17 Ogive Chart Formula PivotTable Data Analysis Toolpak Add-in & Pareto Chart

Excel 2010 Statistics #21: Cross Tabulation With PivotTable Frequencies and % Column & % Row

Excel 2010 Statistics #41: Joint Probability Table with PivotTable

Learn Excel PowerPivot From Chandoo and Rob

Excel Magic Trick 1034: Convert Summarized Table To Proper Data Set With PivotTable Trick

Excel Magic Trick 1033: Re-do Duel 134: Join Product and Sub-Product Text Using PivotTable

Excel Magic Trick 1112: Clean Transactional Data, Then Create PivotTable Monthly Cost Report

Excel Magic Trick 1115: PivotTable to Count How Many of Each Item There Are In a Column

Excel Magic Trick 1131: Aging Accounts Receivable Reports On Multiple Sheets With PivotTable

Excel 2013 PowerPivot Basics #11: Group By Date: Excel PivotTable vs. PowerPivot PivotTable

Excel 2013 PowerPivot Basics #12: Show Report Filter Pages Not Available In PowerPivot Pivot Table

Excel Magic Trick 1151: Get Two Tables Into Pivot Table Field List using Excel 2013

Excel Magic Trick 1158: Get Millions of Rows of Data into PivotTable without PowerPivot, Excel 2013

Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable

Excel Magic Trick 1203: 2 Slicers Control 4 PivotTables: Sum, Running Total, Change and % Change

Excel Magic Trick 1218: PivotTable & Slicer To Show Historical Adj Stock Price by Year & Month

Excel Magic Trick 1219: Paste Special Linked Picture so PivotTable is not Hidden When Filter Applied

Excel Magic Trick 1223: Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data

Excel 2013 PivotTables from A to Z for the Northwest Accounting Educators 2015 Conference

Excel Magic Trick 1255: Formula to Convert Text Dates With Missing Year & Extra Spaces To Real Dates

Excel Magic Trick 1256: Grouped Dates in PivotTable With Becomes UnGrouped When I Refresh!!!

Excel Magic Trick 1267: PivotTable Automatic Date Grouping: New in Excel 2016

Excel Magic Trick 1268: Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List

Excel Magic Trick 1269: Excel 2016: Without Power Pivot: DAX Measures, Relationships & Data Model

Excel Magic Trick 1273: Web Query To Get Super Bowl Data, PivotTable Count Teams with Most Wins

Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model

Highline Excel 2016 Class 17: How to Build Excel Dashboard PivotTable, Chart, Conditional Formatting

Highline Excel 2016 Class 20: Power Query Import Multiple Excel Files & PivotTable Show Values As

Highline Excel 2016 Class 22: How To Build Data Model & DAX Formulas in Power Pivot

Excel Magic Trick 1298: Group By Date in Power Pivot Data Model, New in Excel 2016

Excel Magic Trick 1299: Automatic Calendar Table in Data Model, New in Excel 2016

Excel Magic Trick 1319: Distinct/Unique Count with 1 Condition Using 2 PivotTables.

Excel Magic Trick 1318: Unique Visitors To Site Each Day? Data Model PivotTable or Array Formula?

Excel Magic Trick 1321: Time Between Starting College & Taking 1st Geology Class (6 Methods)

Excel Magic Trick 1322: Backwards One To Many Relationship Report: Excel, Power Query or SQL?

Excel Magic Trick 1323: DAX Formula to Pass Many-Side Filter to One Side Aggregate Calculation

Excel Magic Trick 1330: Append All Excel Tables in Current Workbook: Power Query (Get & Transform)

Excel Magic Trick 1331: Import Multiple Excel Files & Sheets into Excel: Power Query Get & Transform

Excel Magic Trick 1350: Formulas in PivotTables For Gross Profit & Percentage of Gross Profit

Excel Magic Trick 1380: Slicer Power Query Report To Show Incomplete Student Assignments

Excel Magic Trick 1393 PivotTable Show Values As: % Column Total, % Parent Total, % Parent Row Total

Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total

Excel Magic Trick 1394 Part 2: Formulas for % Parent Total using Wild Cards to Get First Text Item

Excel Magic Trick 1395: DAX Measures for Show Values As % of Grand Total, Column Total, Parent Total

Excel Magic Trick 1396: PivotTable Show Values As: Running Total and % of Running Total (2 Examples)

Excel Magic Trick 1397 Part 3: % Cumulative Frequency Formula & X Y Chart for Irregular Increments

Excel for Accountants: PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts…CWU Seminar

Excel Magic Trick 1409: Build PivotTable From 2 Tables without Power Pivot or VLOOKUP

Excel Magic Trick 1412: Power Query to Merge Two Tables Into One Table for PivotTable Report

Excel Magic Trick 1413: Set Default Layout in a PivotTable (New in Excel 2016, Office 365)

Excel Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufacturer

Excel Magic Trick 1424: Average, Moving Average at Different Granularity: DAX or Excel Formulas?

Excel Magic Trick 1436 Excel 2016: Combine 2 BIG Tables into 1 for PivotTable Report, No Power Pivot

Excel for Accountants: Power Query & PivotTables to Import & Clean Data and Build Reports

Excel Magic Trick 1450: Replace VLOOKUP When Making PivotTables with Excel 2016 Relationships

Excel Magic Trick 1451: Hack Data Model, Date Table & DAX Measures WITHOUT buying Power Pivot

Excel Magic Trick 1449: DAX Measure % Change MOM & YOY Formulas For Incomplete Years

Excel Magic Trick 1452: Max Monthly Customer Total for Year: Array Formula or PivotTable?

Excel Magic Trick 1456: PivotTable & Slicer to Create 8 Year Sales Report by Product & Month

Excel Basics 22: Set Default PivotTable Layout & Options in Excel 2016 Office 365 or Later

Excel Magic Trick 1469: Add Daily Rainfall 5 AM to 5 AM Next Day: Helper Column & PivotTable

MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to Excel

Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports? Unbelievable! EMT 1520

Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports With Totals!!!!! EMT 1528

MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions

EMT 1536: Power Query to Import Text Data for Accounting Schedule of Accounts

MSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS (50 Examples)

E-DAB 04: PivotTables & Slicers Create Dashboards & Summary Reports

E-DAB 05: Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards

E-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot?

E-DAB 08: Power Pivot: Big Data, Data Modeling, DAX & Dashboards

MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Query

MSPTDA 23: Two Fact Tables? DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table

MSPTDA 26: Budget vs Actual in Power Pivot & Power BI Desktop, DAX & Data Model

MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship

Excel Magic Trick 1559: PivotTable: Year Totals, YOY Change, % YOY Change from Daily Sales

Excel Magic Trick 1560: Half Year Running Totals in PivotTable

Summarize Survey Results with PivotTable in One Minute - Excel Magic Trick 1577

Excel PivotTable Keyboard? Keyboard for PivotTable –Excel Magic Trick 1578

DAX Measure & Data Model PivotTable - List Student Classes in Single Cell –- Excel Magic Trick 1607

Count Unique Days In Each Month: PivotTable, Array Formula, or Dynamic Array? EMT 1620

Bring Tables from Different Excel Sheets into Single Table for PivotTable Report (EMT1622)

Combine Excel Worksheet Data (Not Excel Tables) Into PivotTable using Power Query (EMT 1626)

Power Query M Code Custom Function to Convert 12 Cross Tabulated Data Sheets to PivotTable. EMT 1621

MSPTDA 36: How To Build Sample File Parameter For A Custom Function to Transform 12 Cross Tab Tables

PivotTables Are Easy: 6 Criteria Cross Tabulated Counting Report. Excel Magic Trick 1657.

Power Query & PivotTable Work Together! 6 Criteria Cross Tabulated Counting Report. EMT 1658.

Combine Two Excel Files Into PivotTable Report - Excel Magic Trick 1667

List Students Last Access Date & Time for Class Web Site with PivotTable. Excel Magic Trick 1688.

Joint Probability Tables. What Are They? How To Use? How To Create using PivotTable. EMT 1719

PivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720

4 New Create PivotTable Dialog Boxes: 4 Amazing Data Sources. Excel Magic Trick 1729.

PivotTable Formulas? Calculated Field, DAX Formula or Excel Table Formula for Gross Profit? EMT 1730

Excel AI with Analyze Data Tool. PivotTable, Pivot Chart & X-Y Scatter Charts Excel Magic Trick 1732

Create PivotTable in Excel Online. Excel Magic Trick 1733.

Excel Data Analysis Class 01: PivotTables, Power Query, Formulas and Charts

Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More!

Excel Data Analysis Class 04: BIG Data Analysis with Power Pivot & Power BI: Visuals & DAX Formulas

Power Query to Import Excel File From OneDrive SharePoint into PivotTable, Refresh New Data EMT 1756

3 Unbelievable Excel Reporting Tricks for Monthly Employee Sales By Department. EMT 1779

WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robustify" your formulas! Excel Magic Trick 1784

TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785

Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13

Power Query UnPivot to Convert Cross Tabulated Table into Proper Data Set. 365 MECS Class 14

Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845

Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848

Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849

Formula for Sales Rep by Month Report: The Amazing GROUPBY Function! Excel Magic Trick 1853

PIVOTBY & GROUPBY to Create Year by Month Sales Report. Grouping Trick! Excel Magic Trick 1859

Grouping in GROUPBY & PIVOTBY Functions!?!? Yes!!!! Frequency Distribution with GROUPBY EMT 1858

GROUPBY Function to Group Transactions with No Transaction Number. EMT 1855

1/2 Year Summary Report in a PivotTable? Cool Formula to Help PivotTable! Excel Magic Trick 1862

GROUPBY & PIVOTBY Functions to Create a 1/2 Year Summary Report! Excel Magic Trick 1863

PivotTable Automatically Pulls Number Formatting From Data Source: Finally!!! Excel Magic Trick 1879

GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? Insert Column & Chart Breaks?

MS 365 Excel Basics 09: PIVOTBY & GROUPBY Functions Beat PivotTable: 10 Mind-Blowing Examples!

MS 365 Excel Basics 10: Power Query, FlashFill, XLOOKUP, PivotTables Sort & Filter! 7 DA Examples.

Turn Off GETPIVOTDATA Function So I Can Refer To My PivotTable With A Cell Reference. Excel Short 77

GETPIVOTDATA Function: What it Does & When and How to Turn It Off. Excel Magic Trick 1883

Why Data Analysis Needs Proper Tables and Power Query’s UnPivot Feature. Excel Magic Trick 1886

Fix PivotTable When Dates Not Grouping: 3 Methods (Including Power Query). Excel Magic Trick 1890