Gráficos Dinámicos Avanzados y Visual Basic | Excel Empresarial desde Cero

Welcome to Digital Skills! In this third lesson of our Business Excel course, we'll take the definitive leap from being mere data operators to becoming true strategic analysts. In this session, you'll learn how to connect multiple reports simultaneously, interpret sales seasonality using dynamic line charts, and prepare your work environment for full automation with Visual Basic macros. 📌 What will you learn in this step-by-step tutorial? How to create a centralized Summary Sheet by inserting new pivot tables from clean databases. Using Time Scales in date format to segment information by months, semesters, or full years. Advanced Report Connections: The key to having a single slicer filter multiple pivot tables and charts at once (a fundamental criterion for building dashboards). Multidimensional visual analysis with Grouped Column Pivot Charts (Region vs. Categories). - Trend Reading and Analysis: How to interpret behaviors, identify seasonal peaks or troughs, and make demand projections in the sales area. Introduction to the Macro Environment: What they are, their use in daily work routines, and the differences between the Macro Recorder and coding. How to activate the hidden Programmer/Developer tab and take your first steps in the Visual Basic for Applications (VBA) editor. 📂 Download the class materials: [Here you can insert the Drive/Mega link with the sales database file for the session so your audience can practice along with you]. 🔔 Subscribe to Digital Skills and don't miss the next class, where we will run a complete macro and build an interactive management dashboard from start to finish. Video Content: 00:00 Introduction and brief review of the clean sales database 01:19 Review of the practical use of slicers and data filters 02:27 Today's objective: Segment connections, advanced charts, and macros 04:10 Creating a new pivot table in the "Summary Sheet" 06:36 Grouping dates by time and applying tabular formatting 08:08 Simultaneously inserting slicers and timelines 10:56 Design trick: Distributing buttons across multiple columns 14:07 Ensuring correct date formatting for the timeline 15:06 Practical demonstration of cross-filtering (Category vs. Region) 17:16 The core of Dashboards: What are Report Connections and how do they work? 20:19 Live Solution: Linking and Unlinking PivotTables to a Slicer 24:44 Live Support: Setting Up PivotTable Layouts and Usability 32:47 Step-by-Step Creation of a Clustered Column Pivot Chart 36:12 Real Market Analysis: Visual Comparison of 2025 and 2026 Sales 38:50 Extracting Business Hypotheses: Analyzing Peaks and Profitable Niches 42:35 Thinking Like Data Analysts vs. Management Reports 43:33 How to Invert PivotChart Axes from the Field List 48:42 Key Criteria for Chart and Slicer Interconnectivity 51:20 Inserting Line Charts for Technical Trend Analysis 55:25 Interpreting Monthly Seasonality and Volatile Peaks in Technology 59:00 Reading Trends in Trading Quarters (Up vs. Down) (low) 01:04:57 What is a Macro: Automating routines and repetitive processes 01:11:48 Types of macros: Automatic action recorder vs. Programming language 01:13:28 The current role of Artificial Intelligence in VBA code development 01:16:00 How to activate the hidden Programmer/Developer tab in Excel 01:18:00 Explanation of the Record Macro button and use of the list of executable macros 01:21:15 Introduction to the Microsoft Visual Basic Editor and creation of code modules 01:27:06 How to save and execute commands from VBA and closing the class #BusinessExcel #DynamicCharts #ExcelMacros #VisualBasicExcel #TrendAnalysis #ExcelDashboard #DigitalSkills #AdvancedExcel