~Get Your Files Here !/2 - Data Importing, Cleaning, and Structuring/4 -Advanced Cleaning Techniques.mp4 118.1 MB
~Get Your Files Here !/1 - Introduction to Marketing Analytics and Excel Reporting/5 -Data Validation, Drop-Down Lists, and Arithmetic operations.mp4 76.4 MB
~Get Your Files Here !/3 - Fundamental Excel Functions for Marketing Analytics/1 -Lookups and Reference Functions (VLOOKUP).mp4 72.0 MB
~Get Your Files Here !/5 - Data Visualization Techniques for Marketing Insights/1 -Creating Key Visuals for Marketing (Bar, Column, Line, and Pie Charts for Market.mp4 69.2 MB
~Get Your Files Here !/6 - Project 1 - Building Interactive Performance Marketing Dashboard/1 -Summarizing Data Using Pivot Tables.mp4 68.6 MB
~Get Your Files Here !/4 - Time-Based Analysis and Trend Analysis/3 -Calculating Moving Averages and Visualizing Trends Over Time.mp4 58.6 MB
~Get Your Files Here !/1 - Introduction to Marketing Analytics and Excel Reporting/4 -Formatting Data for Readability.mp4 58.4 MB
~Get Your Files Here !/2 - Data Importing, Cleaning, and Structuring/3 -Cleaning Data for Accuracy.mp4 58.3 MB
~Get Your Files Here !/4 - Time-Based Analysis and Trend Analysis/1 -Organizing Data by Dates and Setting Up Dynamic Filters.mp4 54.7 MB
~Get Your Files Here !/7 - Final Project – Interactive Sales and Revenue Dashboard/6 -Course Conclusion and Wrap-Up.mp4 53.9 MB
~Get Your Files Here !/3 - Fundamental Excel Functions for Marketing Analytics/3 -Logical and Conditional Functions (IF, AND, OR, and Nested IFs).mp4 53.9 MB
~Get Your Files Here !/3 - Fundamental Excel Functions for Marketing Analytics/6 -Introduction to Macros and Basic VBA Scripting for Automation.mp4 52.6 MB
~Get Your Files Here !/7 - Final Project – Interactive Sales and Revenue Dashboard/1 -Dashboard Layout Design.mp4 52.0 MB
~Get Your Files Here !/2 - Data Importing, Cleaning, and Structuring/1 -Importing Data from Various Sources (CSV, Excel, and External Sources).mp4 51.4 MB
~Get Your Files Here !/4 - Time-Based Analysis and Trend Analysis/2 -Advanced Date Functions (EOMONTH, EDATE, DATEDIF).mp4 51.3 MB
~Get Your Files Here !/7 - Final Project – Interactive Sales and Revenue Dashboard/2 -Creating Pivot Tables and Metrics.mp4 50.6 MB
~Get Your Files Here !/6 - Project 1 - Building Interactive Performance Marketing Dashboard/3 -Dashboard Layout and Design Best Practices.mp4 50.5 MB
~Get Your Files Here !/6 - Project 1 - Building Interactive Performance Marketing Dashboard/2 -Adding Pivot charts and Slicers.mp4 48.5 MB
~Get Your Files Here !/5 - Data Visualization Techniques for Marketing Insights/2 -Advanced Visualizations for Marketing Insights (Combo, Waterfall, Bullet, etc.).mp4 48.3 MB
~Get Your Files Here !/3 - Fundamental Excel Functions for Marketing Analytics/5 -Calculating Key Marketing Metrics (CTR, Conversion Rate, ROI, CPA, and CLV).mp4 48.0 MB
~Get Your Files Here !/4 - Table Data Mastery Adding, Deleting, Sorting, and More!/2 -Data Sorting & Filtering Find Your Needle in the Haystack.mp4 93.0 MB
~Get Your Files Here !/6 - Structured References Your Table's GPS for Formulas/5 -Dynamic Structured References Formulas That Flex with Your Data.mp4 86.3 MB
~Get Your Files Here !/4 - Table Data Mastery Adding, Deleting, Sorting, and More!/3 -Table Formulas Where Data Meets Dynamic Calculations.mp4 82.2 MB
~Get Your Files Here !/6 - Structured References Your Table's GPS for Formulas/2 -Structured References Build Your Formulas with Confidence.mp4 80.4 MB
~Get Your Files Here !/5 - Advanced Table Techniques Level Up Your Excel Game/1 -Template Triumph Streamline Your Excel Workflow.mp4 80.3 MB
~Get Your Files Here !/5 - Advanced Table Techniques Level Up Your Excel Game/3 -Table Connections Linking to External Data Sources.mp4 77.6 MB
~Get Your Files Here !/4 - Table Data Mastery Adding, Deleting, Sorting, and More!/4 -PivotTable Power Unleash Data Insights with a Click.mp4 76.9 MB
~Get Your Files Here !/2 - Excel Tables Unveiled Your First Steps to Data Mastery/1 -Excel Tables A Bird's-Eye View.mp4 69.6 MB
~Get Your Files Here !/3 - Table Formatting Polishing Your Data's Presentation/2 -Table Makeover Elevate Your Data's Style.mp4 68.3 MB
~Get Your Files Here !/6 - Structured References Your Table's GPS for Formulas/4 -Structured References Elevate Your Formulas, Simplify Your Life.mp4 67.6 MB
~Get Your Files Here !/2 - Excel Tables Unveiled Your First Steps to Data Mastery/2 -Why Tables are Awesome Unveiling the Perks.mp4 65.8 MB
~Get Your Files Here !/5 - Advanced Table Techniques Level Up Your Excel Game/2 -Conditional Formatting Spotlight Your Key Data.mp4 64.6 MB
~Get Your Files Here !/6 - Structured References Your Table's GPS for Formulas/3 -Structured References Unlock the Hidden Advantages for Your Formulas.mp4 64.2 MB
~Get Your Files Here !/3 - Table Formatting Polishing Your Data's Presentation/3 -Table Style Tweaks Personalize Your Data's Look.mp4 62.1 MB
~Get Your Files Here !/2 - Excel Tables Unveiled Your First Steps to Data Mastery/4 -Anatomy of an Excel Table Understanding the Building Blocks.mp4 58.3 MB
~Get Your Files Here !/6 - Structured References Your Table's GPS for Formulas/1 -Structured References Demystified A Beginner's Guide.mp4 57.0 MB
~Get Your Files Here !/4 - Table Data Mastery Adding, Deleting, Sorting, and More!/1 -Table Transformations Adding and Deleting Data with Ease.mp4 52.4 MB
~Get Your Files Here !/2 - Excel Tables Unveiled Your First Steps to Data Mastery/3 -Creating Tables in a Flash The CTRL+T Trick.mp4 43.8 MB
~Get Your Files Here !/7 - Excel Tables Your Journey to Data Mastery Concludes/1 -Aloha and Farewell Reflecting on Your Excel Table Journey.mp4 41.9 MB
~Get Your Files Here !/1 - Introduction Your Gateway to Data Mastery/1 -Excel Table Mastery From Beginner to Pro.mp4 34.0 MB
~Get Your Files Here !/04 - 3. Advanced Flow Configuration and Optimization/03 - Error handling and debugging flows.mp4 19.0 MB
~Get Your Files Here !/02 - 1. Power Automate Overview/03 - Getting help building flows with Copilot.mp4 18.4 MB
~Get Your Files Here !/03 - 2. Building and Managing Flows/01 - Automating Excel entry with Power Automate.mp4 17.4 MB
~Get Your Files Here !/04 - 3. Advanced Flow Configuration and Optimization/01 - Building an expense approval workflow in Power Automate.mp4 17.3 MB
~Get Your Files Here !/04 - 3. Advanced Flow Configuration and Optimization/05 - Solution Automating feedback responses with Power Automate.mp4 17.3 MB
~Get Your Files Here !/03 - 2. Building and Managing Flows/02 - Conditional logic and data handling in Power Automate.mp4 14.9 MB
~Get Your Files Here !/02 - 1. Power Automate Overview/01 - Building a Power Automate for Excel flow from a template.mp4 13.8 MB
~Get Your Files Here !/03 - 2. Building and Managing Flows/06 - Solution Automated file upload tracking with Excel.mp4 13.7 MB
~Get Your Files Here !/03 - 2. Building and Managing Flows/03 - Using Office Scripts with Power Automate for Excel.mp4 12.4 MB
~Get Your Files Here !/02 - 1. Power Automate Overview/02 - Reformatting the flow's outputs with Power Fx.mp4 11.4 MB
~Get Your Files Here !/02 - 1. Power Automate Overview/06 - Solution Set up a flow in Power Automate for Excel.mp4 10.4 MB
~Get Your Files Here !/04 - 3. Advanced Flow Configuration and Optimization/02 - Retrieving data from external sources.mp4 9.6 MB
~Get Your Files Here !/05 - Conclusion/01 - Power Automate and the citizen developer.mp4 9.4 MB
~Get Your Files Here !/03 - 2. Building and Managing Flows/04 - Operating on multiple Excel workbooks with Power Automate.mp4 8.2 MB
~Get Your Files Here !/02 - 1. Power Automate Overview/04 - Sharing your Power Automate flows.mp4 7.8 MB
~Get Your Files Here !/01 - Introduction/02 - What to know before starting this course.mp4 6.4 MB
~Get Your Files Here !/01 - Introduction/01 - Welcome to Power Automate for Excel.mp4 4.0 MB
~Get Your Files Here !/04 - 3. Advanced Flow Configuration and Optimization/04 - Challenge Setting up a customer review process.mp4 2.8 MB
~Get Your Files Here !/03 - 2. Building and Managing Flows/05 - Challenge Logging new file uploads in a workbook.mp4 2.5 MB
~Get Your Files Here !/02 - 1. Power Automate Overview/05 - Challenge Set up a flow in Power Automate for Excel.mp4 2.3 MB