Discounted courses from just $13.99 USD and save an extra 20% with code RELAMPAGO20SEP | Ends today at 11:59 PM!
LIGHTNING20SEP

Excel 2019: Power Pivot

Learn how to extract, transform and load (ETL) your data from different sources into Excel. Power Pivot or Query is today one of the advanced features offered by Excel. The offer ends in a few hours!

By Nohelia Bastidas | Master in Administration | Bachelor in Business Administration

👥 12.116
(165)
$13.99 USD $67.00 USD

15 day refund guarantee

This course includes:

▪️ 4h 25m duration on demand

▪️ 19 lessons

▪️ 26 downloadable resources

▪️ Available on mobile devices

▪️ Access forever

▪️ Language:

  • Spanish

▪️ Unlimited consultations

✦ Bonus: Set of Downloadable Guides and Practical Exercises

⚑ Certificate of completion

What you will learn

🟧 You will learn how to build and connect a data model.

🟧 You will create complete and dynamic reports using pivot tables.

🟧 You will be able to design a Dashboard based on dynamic tables

🟧 You will learn how to create key performance indicators in your data models.

🟧 You will learn the functions of
Excel Power Pivot.

🟧 You will be able to import data and combine it with Power Query.

Course content
U1: Power Pivot for Excel
  • What is Power Pivot?
  • How to add the Power Pivot add-in
  • Main icons in Power Pivot
U2: Main functions in Power Pivot for Excel
  • Add tables to the data model.
  • Create relationships between tables.
  • Create data model in Excel
U3: Importing data to Power Pivot in Excel
  • Get data from a .CSV or .TXT file.
  • Sort and filter data with Power Pivot in Excel
  • Unraveling the Secrets of Power Pivot
U4: Create a Power Pivot Dashboard or Control Panel
  • Create pivot tables from the Power Pivot model
  • Create pivot charts from the Power Pivot model
  • Create Data Segmenters
  • Power Pivot Dashboard
U5: DAX Measures and Formulas
  • Measures: AutoSum, Average, Max, Min, with Power Pivot in Excel
  • Introduction to DAX formulas
  • Decoding the DAX Language Measures and Formulas for Data Analysis in Power Pivot
U6: Calculate KPIs in Power Pivot for Excel
  • What are KPIs?
  • Create KPIs
  • Measuring Success by Calculating and Creating KPIs for Effective Business Analysis
Course evaluation
  • This course contains a final exam
G-Tools: For Students
  • Exclusive access to cutting-edge student tools: improve your employability, participate in exclusive events, take advantage of our intelligent virtual assistant, and more.
⚑ Certificate of completion
  • Your personalized digital certificate, a unique badge of your achievements, with international validity, course duration and QR code for instant verification.
__
Downloadable resources:

📎 Set of practical guides and exercises

▸ Data Analysis Guide with Power Pivot.
▸ Master Dashboard Guide with Excel.
▸ Guide to Pivot Tables in Excel


📎 Set of practical exercises:

▸ File, how to add the Power Pivot add-in
▸ File, main icons in Power Pivot for Excel
▸ File, add tables to the data model
▸ File, create relationships between tables
▸ File, create data model in Excel

Description

Do you want to learn how to manage data, extract, summarize and report information to enhance decision making and stand out in your environment?

Mastering tools that make your daily tasks easier will make a difference in your professional career. With Power Pivot you can link different databases, automate information updates and design a Data Model that generates high-level reports.

Power Pivot or Query will make any type of data analysis you need to perform easier.

In this course we will teach you everything you need to efficiently connect and model data, incredibly enhancing your Excel reports!

Companies from all industries invest in the development of their teams with this course from G-Talent and Nohelia Bastidas

Customer Reviews

Based on 165 reviews
75%
(124)
25%
(41)
0%
(0)
0%
(0)
0%
(0)
M
Martín Miranda
Habilidades en Excel al siguiente nivel

Recomiendo este curso a cualquier persona que quiera llevar sus habilidades en Excel al siguiente nivel y dominar Power Pivot para tomar mejores decisiones basadas en datos

S
Sebastián Espinoza
Me encanto este curso

El contenido del curso es práctico y está actualizado con las últimas funcionalidades de Power Pivot. Los ejercicios y casos de estudio me han permitido poner en práctica lo aprendido y resolver problemas reales

I
Ignacio Montes
Excelente

El curso me ha permitido dominar Power Pivot para realizar análisis de datos complejos. He aprendido a crear modelos de datos eficientes, a relacionar diferentes conjuntos de datos y a generar informes dinámicos e interactivos

Ver más reseñas

Nohelia Bastidas

Master in Administration | Bachelor in Business Administration

About Nohelia Bastidas

Master in Administration | Bachelor in Business Administration

Financial sector expert with over 20 years of experience in finance and business development. Throughout her career, Nohelia has demonstrated a deep understanding of cash flow management and optimization, making her a leading professional in her field. Her focus on improving administrative and technical functions has led her to develop innovative Business Intelligence solutions that automate and present financial information intelligently.

Since 2001, Nohelia has worked in various engineering and consulting firms, always with the aim of optimizing processes and providing strategic value. Her passion for the management and presentation of financial information has been the driving force behind the creation of tools that facilitate strategic decision-making based on relevant and automated data.

Why choose to learn with Nohelia Bastidas?

▪️ Proven experience: Over 20 years in the financial sector, developing a deep understanding of cash flow management and optimization.
▪️ Innovative solutions: Co-creator of Business Intelligence tools that automate the presentation of financial information to facilitate strategic decisions.
▪️ Practical approach: Nohelia shares her real, practical experience in improving administrative and technical functions, providing learning applicable to your career.
▪️ Guaranteed results: Your course is designed to transform your financial management, teaching you to master cash flow and improve the efficiency of your business.

Take advantage of the opportunity to learn with Nohelia Bastidas and transform your financial management! Enroll now in her Cash Flow course and master the tools you need to take your business to the next level.

Discover the added value: G-Tools and much more

In addition to high-quality content, this course gives you access to G-Tools, a suite of tools and resources designed to enhance your learning and your career.

Employability support resources, live events and take advantage of Aixa.IA's artificial intelligence to resolve your questions at any time.

View all

Explore other courses from Nohelia Bastidas

Discover other courses and learn something new today. Learn from the best!

Best Selling Courses in Personal Development

What to expect from G-Talent courses?

  • Study at your own pace

    Get video courses, taught by top instructors, to study at your own pace

  • Learn from the best

    Provides high quality courses developed by carefully selected experts

  • Quality guaranteed

    Not sure? All our courses offer a 15-day success guarantee

  • Permanent accompaniment

    Learn at your own pace, with lifelong updates, access and support.

  • Personalized certificate

    Get a world-class certificate, with international validity and a unique encrypted QR code

  • G-Tools: For Students

    Find all the tools you need for your employability in one place.