XLS-DA-BM.AB1

Microsoft Excel Data Analysis and Business Modeling

Learn the core concepts of MS data analysis and business modeling to develop the right skills for transforming worksheet data into actionable insights.

  • Practice in 60 Laboratorios prácticos — nothing to install
  • 97 Lecciones interactivas y 207 topics mapped to the official exam objectives
  • 368 Preguntas del examen de práctica

Intermediate A tu propio ritmo · 1 año de acceso 4.7/5 (313 Revisar)

60 LiveLabs prácticos

Practice real IT tasks in guided environments.

  • Entornos reales
  • Calificación automática
  • Sin instalación
97Lecciones interactivas
207Topics
60Laboratorio en vivo
368Preguntas del examen de práctica
111Tarjetas didácticas
111Glosario de términos

01 / Habilidades que obtendrás

What you will be able to do

Try Free → No se requiere tarjeta de crédito
In today’s data-driven world, every business (big or small) thrives on its ability to transform data into action items. This Excel Business Modeling and Data Analysis course teaches you how to use MS Excel for analyzing data and building financial models that help businesses make informed decisions. Other than learning basic excel formulas, functions, data manipulation and chart creation, you’ll also learn how to use data analysis tools like PivotTables, data tables, scenario analysis (what-if situations), and data consolidation. Use of analytical techniques for building financial models like budgets and forecasts is also covered in the Excel data analysis training course. To make it a fun learning experience for you, we have also included interactive activities like hand-on labs, flashcards, and quizzes along with the course content.
  • Translating Excel basics to relatable analytics
  • Using Power Query for cleaning and connecting data
  • Create custom functions with LAMBDA (without VBA)
  • Utilizing new charts and data types for visualizing data like a pro 
  • Utilizing data manipulation techniques like advanced XLOOKUP function 
  • Using 3D Maps for highlighting geographical trends
  • Confidently building powerful business data models

Target Career Roles

  • Periodista de datos
  • Gerente de ventas minoristas
  • Gerente de proyecto
  • Analista de Negocios
  • Analista financiero
  • Empleado de información
  • Ayudante Administrativo

02 / Lecciones y laboratorios

See exactly what you will learn and practice

Descargar esquema (PDF)

Plan de estudios

97 Lecciones interactivas · 207 topics
01 Introduction 2 topics
  • What you should know before reading this course?
  • How to use this course?
02 Basic worksheet modeling 2 topics · 1 Laboratorio en vivo
  • Answers to this lesson's questions
  • Problems

1 Laboratorio en vivo in this lesson — see the labs panel →

03 Range names 4 topics
  • How can I create named ranges?
  • Answers to this lesson’s questions
  • Remarks
  • Problems
04 Lookup functions 3 topics · 1 Laboratorio en vivo
  • Syntax of the lookup functions
  • Answers to this lesson’s questions
  • Problems

1 Laboratorio en vivo in this lesson — see the labs panel →

05 The INDEX function 3 topics · 1 Laboratorio en vivo
  • Syntax of the INDEX function
  • Answers to this lesson’s questions
  • Problems

1 Laboratorio en vivo in this lesson — see the labs panel →

Laboratorios prácticos Our edge

60 Laboratorio en vivos
  • Performing Mathematical Calculations using Formulas
  • Accumulating Data Using the VLOOKUP Function
  • Extracting Data Using the INDEX Function
  • Finding the Required Data Using the MATCH Function
  • Creating Email Addresses Using the Excel Text Functions
  • Calculating the Number of Workdays Using a Date Function
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.

03 / Preguntas frecuentes

Preguntas antes de empezar

Contáctanos ↗
What advanced techniques will I learn with the Microsoft Excel Data Analysis and Business Modeling course?
Besides working on the latest excel features, you’ll also learn to use advanced tools like XLOOKUP and LAMBDA functions.
How will I benefit from this course?
Most businesses (big or small) need meaningful data insights for making informed decisions, which is why there is a growing need of skilled Data Analysts across all industry verticals. With uCetify’s Microsoft Excel Data Analysis and Business Modeling course you can develop the right skill set needed for this job profile.
Where can I find technical support for this Learning Excel: Data Analysis course?
At uCertify, we provide 24/7 tech support to the users for all of our courses.
Is this course suitable for beginner’s wanting to upskill?
Definitely Yes. All those wanting to upskill themselves and learn advanced excel tools for data manipulation and analysis will benefit greatly from this course.
What opportunities can I pursue after completing this Excel data analysis course?
Completing this course will open doors to some exciting job opportunities like data analyst, financial analyst, management consultant, business, market research analyst, supply chain analyst, human resource analyst, and data journalist.

Keep going

You might also like

DATA-WRGLG-PYTHON.AJ1 Data Wrangling with Python View course →
REG-PYTHON.AJ1 Regression Analysis with Python View course →
DATA-VIS-XLS.AD1 Data Analysis and Visualization with Excel View course →

Get Ready to Become a Data Analysis Pro

Learn how to utilize the power of MS excel to analyze data and drive your career towards success.

  • 1 año de acceso completo
  • 60 LiveLab incluido
  • Certificado de finalización
Comprar ahora — $279.99 Try Free

No se requiere tarjeta de crédito

Utilizamos cookies para mejorar la experiencia del sitio y el análisis. Aprende más