~Get Your Files Here !/01 - Getting Started/001 Course Structure & Outline.mp423.06MB
~Get Your Files Here !/01 - Getting Started/002 IMPORTANT Versions & Compatibility.mp426.25MB
~Get Your Files Here !/01 - Getting Started/004 Introducing the Course Project.mp43.06MB
~Get Your Files Here !/01 - Getting Started/006 Setting Expectations.mp44.47MB
~Get Your Files Here !/02 - Intro to “Power Excel/001 Understanding the “Power Excel” Workflow.mp49.25MB
~Get Your Files Here !/02 - Intro to “Power Excel/002 Power Query + Power Pivot Best Thing to Happen to Excel in 20 Years.mp459.49MB
~Get Your Files Here !/02 - Intro to “Power Excel/003 When to use Power Query & Power Pivot.mp41.57MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/001 Introduction.mp41.44MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/002 Getting to Know Power Query in Excel.mp48.07MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/003 Exploring Excel's Power Query Editor.mp423.77MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/004 Power Query Data Loading Options.mp43.29MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/006 Applying Basic Table Transformations with Power Query.mp460.67MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/007 Power Query Demo Text Tools.mp480.81MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/008 Power Query Demo Number & Value Tools.mp463.52MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/009 Power Query Demo Date & Time Tools.mp443.42MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/010 PRO TIP Creating a Rolling Calendar with Power Query.mp413.34MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/011 Power Query Demo Generating Index & Conditional Columns.mp448.98MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/012 Power Query Demo Grouping & Aggregating Records.mp425.62MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/013 Power Query Demo Pivoting & Unpivoting Data.mp451.55MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/014 Modifying Excel Workbook Queries.mp417.89MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/015 Merging Queries with Power Query.mp457.9MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/016 Appending Queries with Power Query.mp432.71MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/017 Power Query Demo Connecting to a Folder of Files.mp464.91MB
~Get Your Files Here !/03 - Connecting & Transforming Data with Power Query in Excel/018 Excel Power Query Best Practices.mp46.38MB
~Get Your Files Here !/04 - Building Table Relationships with Excel's Data Model/001 Introduction.mp41.52MB
~Get Your Files Here !/04 - Building Table Relationships with Excel's Data Model/002 Meet Excel's Data Model.mp419.7MB
~Get Your Files Here !/04 - Building Table Relationships with Excel's Data Model/003 The Data Model Data vs. Diagram View.mp410.73MB
~Get Your Files Here !/04 - Building Table Relationships with Excel's Data Model/004 Principles of Database Normalization.mp410.5MB
~Get Your Files Here !/04 - Building Table Relationships with Excel's Data Model/005 Understanding Data Tables vs. Lookup Tables.mp421.05MB
~Get Your Files Here !/04 - Building Table Relationships with Excel's Data Model/006 Benefits of Relationships vs. Merged Tables.mp45.29MB
~Get Your Files Here !/04 - Building Table Relationships with Excel's Data Model/007 Creating Table Relationships in Excel's Data Model.mp421.2MB
~Get Your Files Here !/04 - Building Table Relationships with Excel's Data Model/008 Modifying Data Model Table Relationships.mp47.2MB
~Get Your Files Here !/04 - Building Table Relationships with Excel's Data Model/009 Managing Active vs. Inactive Table Relationships.mp411.91MB
~Get Your Files Here !/04 - Building Table Relationships with Excel's Data Model/010 Understanding Relationship Cardinality.mp434.28MB
~Get Your Files Here !/04 - Building Table Relationships with Excel's Data Model/011 Connecting Multiple Data Tables in the Data Model.mp429.18MB
~Get Your Files Here !/04 - Building Table Relationships with Excel's Data Model/012 Understanding Filter Flow.mp412.33MB
~Get Your Files Here !/04 - Building Table Relationships with Excel's Data Model/013 Hiding Fields from Excel Client Tools.mp411.68MB
~Get Your Files Here !/04 - Building Table Relationships with Excel's Data Model/014 Defining Hierarchies in a Data Model.mp48.77MB
~Get Your Files Here !/04 - Building Table Relationships with Excel's Data Model/015 Excel Data Model Best Practices.mp43.07MB
~Get Your Files Here !/05 - Analyzing Data with Power Pivot & DAX/001 Introduction.mp42.28MB
~Get Your Files Here !/05 - Analyzing Data with Power Pivot & DAX/002 Creating a Power Pivot Table.mp417.69MB
~Get Your Files Here !/05 - Analyzing Data with Power Pivot & DAX/003 Power Pivots vs. “Normal” Pivots in Excel.mp418.13MB
~Get Your Files Here !/05 - Analyzing Data with Power Pivot & DAX/004 Introducing Data Analysis Expressions (DAX).mp42.8MB
~Get Your Files Here !/05 - Analyzing Data with Power Pivot & DAX/005 Understanding DAX Calculated Columns.mp471.21MB
~Get Your Files Here !/05 - Analyzing Data with Power Pivot & DAX/006 Understanding DAX Measures.mp44.99MB
~Get Your Files Here !/05 - Analyzing Data with Power Pivot & DAX/007 Creating Implicit DAX Measures.mp44.77MB
~Get Your Files Here !/05 - Analyzing Data with Power Pivot & DAX/008 Creating Explicit DAX Measures with AutoSum.mp437.71MB
~Get Your Files Here !/05 - Analyzing Data with Power Pivot & DAX/009 Creating Explicit DAX Measures with Power Pivot.mp435.01MB
~Get Your Files Here !/05 - Analyzing Data with Power Pivot & DAX/010 Understanding DAX Filter Context.mp437.93MB
~Get Your Files Here !/05 - Analyzing Data with Power Pivot & DAX/011 Step-by-Step DAX Measure Calculation.mp476.87MB
~Get Your Files Here !/05 - Analyzing Data with Power Pivot & DAX/012 RECAP Calculated Columns vs. DAX Measures.mp45.26MB
~Get Your Files Here !/05 - Analyzing Data with Power Pivot & DAX/013 Excel Power Pivot & DAX Best Practices.mp43.84MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/001 Introduction.mp41.44MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/002 Understanding DAX Formula Syntax & Operators.mp49.32MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/003 Common DAX Function Categories.mp49.04MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/004 DAX Demo Basic Math & Stats Functions.mp455.38MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/005 DAX Demo COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS.mp465.84MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/007 DAX Demo Logical Functions (IFANDOR).mp4120.19MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/008 DAX Demo SWITCH & SWITCH(TRUE).mp439.03MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/009 DAX Demo Common Text Functions.mp475.43MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/011 DAX Demo CALCULATE.mp475.37MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/012 DAX Demo Adding Filter Context with FILTER (Part 1).mp435.17MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/013 DAX Demo Adding Filter Context with FILTER (Part 2).mp474.05MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/014 DAX Demo Removing Filter Context with ALL.mp437.47MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/016 DAX Demo Joining Data with RELATED.mp412.35MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/017 DAX Demo Iterating with SUMX.mp452.51MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/018 DAX Demo Iterating with RANKX.mp440.71MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/020 DAX Demo Basic Date & Time Functions.mp444.99MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/021 DAX Demo Time Intelligence Formulas.mp4132.71MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/023 DAX Speed & Performance Considerations.mp47.14MB
~Get Your Files Here !/06 - Common DAX Formulas & Functions/024 DAX Best Practices.mp43.94MB
~Get Your Files Here !/07 - Wrapping Up/001 Introduction.mp42.82MB
~Get Your Files Here !/07 - Wrapping Up/002 Data Visualization Options in Excel.mp49.41MB
~Get Your Files Here !/07 - Wrapping Up/003 Sneak Peek Microsoft Power BI.mp434.22MB