Udemyalles

Nivel 2 - Excel 100% Practico

Excel automation: Connect to external systems & data. Learn data transformation & workflow automation. Master Excel integration.

3h 52m
Certificate
Edwin Montero
Edwin MonteroIngeniero de Sistema Edwin Montero

Course Content

Nivel 2 - Excel 100% Practico is an all-levels Udemy course taught by Edwin Montero. It runs 3h 52m, is taught in Spanish, and includes a certificate of completion. It is a paid course, first published December 2021.

Unveiling Advanced Excel Techniques: Streamline Your Data Analysis & Reporting

This course provides a comprehensive overview of powerful Excel techniques designed to boost your productivity and transform raw data into actionable insights. Discover how to move beyond basic functions and unlock the full potential of Excel for data-driven decision-making.

  • Mastering VBA Macros for Efficiency: Learn to automate repetitive tasks by manipulating VBA code. Create macros that execute complex sequences from a single point, and write macros from scratch – no macro recorder required! This is the key to creating powerful Excel macros.

  • Data Transformation with the Flow Transformer: Address data gaps and improve the quality of your reports with the Flow Transformer. Learn the six-step process for transforming data from external systems and third-party sources. This is a core skill for data professionals.

  • Power Query (Get & Transform Data): Explore the game-changing Power Query tool – one of Excel's most valuable additions in recent years. Learn when and how to use Power Query to clean, shape, and combine data from various sources. Includes an introduction to M language.

  • Dynamic Data Visualization with Pivot Tables: Go beyond basic Pivot Tables. Discover advanced techniques for segmenting data, utilizing time scales, and building dynamic dashboards. Learn to create Pivot Tables based on Flow Transformers for enhanced reporting.

  • Strategic Data Presentation: Transform static data into compelling visuals. Explore techniques like:

    • Dynamic Time Windows: Visualize trends and track progress with interactive time windows.
    • Conditional Formatting: Use icons, progress bars, and data bars to highlight key performance indicators (KPIs).
    • Dashboard Collages: Create visually appealing reports by combining multiple charts and tables.
  • KPI & Indicator Management: Learn to define and track key performance indicators (KPIs) effectively. Understand when to use SUMIF, COUNTIF, and other functions for accurate reporting. Master the art of comparing actuals against targets with insightful icon-based visualizations.

  • Static Tables in Excel: Understand the purpose and benefits of static tables for managing and analyzing data.

  • The Excel Compass: A practical tool to help you identify the best technique for any data reporting challenge.

  • Building User-Friendly Menus: Create custom menus with UserForms to streamline your workflow and enhance report accessibility.

  • Handling External Data: Learn to integrate data from external systems like SAP seamlessly into your Excel reports.

  • Managing Multiple Data Sources: Effectively combine data from various sources to create comprehensive and insightful reports.

  • Managing Indigo Adult Data: Learn to build procedural menus to deliver high-confidence reports.

This course equips you with the skills to efficiently prepare data, create insightful reports, and make data-driven decisions – empowering you to become a true Excel expert. Stop wasting time on tedious data manipulation and start unlocking the power of your data!

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

5.0(17)
3h 2m
intermediate
5.0(9)
57m
all
5.0(64)
7h 26m
intermediate
5.0(1)
3h 2m
expert
5.0(5)
8h
intermediate