¡OFERTA de fin de mes! 🤩 ¡Descuentos del 25% en certificados y diplomas ya!Termina en  : : :

¡No te lo pierdas!
Free Online Courses from the Jordan Goldmeier
Jordan Goldmeier
Data visualisation & analytics expert
98,903
de estudiantes
8
Cursos
290
Beneficiados
Information Technology (IT)
Imparte cursos en Alison desde May, 2021
Jordan Goldmeier is a data visualisation expert, author, and lecturer with an international reputation in analytics. He spent years in the data training trenches as the former chief operations officer at Excel.TV. He's the author of 'Advanced Excel Essentials' and 'Excel Dashboards' among other books.

His knowledge of analytics and visualisation enables learners to discuss, challenge, and comprehend data science using a common language and set of expectations.

His achievement as an Excel MVP Award holder permits him to offer assistance and support to Microsoft product teams. He also works as a volunteer emergency medical technician (EMT). NATO Training Mission, the Pentagon, Principal Financial, H&M, Wake Forest University, Stony Brook University...
Curso destacado de este creador de cursos
The Basics of Decision Formulas
2,298Estudiantes ya inscritos
No me interesa
Cursos en línea gratuitos por Jordan Goldmeier
The Basics of Decision Formulas
1.5-3 horas 2,298 estudiantes
By Jordan Goldmeier
Aprenderás Cómo

By the end of this course, you will be able to:

  • Identify the need for thinking differently to get the most out of Excel
  • Discuss the procedure for using the camera tool in Excel
  • Summarize the various development principles
  • Identify the multiple tips for formula editing in Excel
  • Describe the working principle behind the Excel Calculation Engine
  • Recognize the ways of writing better formulas in Excel
  • Explain the various LOOKUP functions used in Excel
  • Outline the methods of using array formulas in Excel
course logo
CERTIFICATE
Nivel avanzado
Data Analysis
The Basics of Decision Formulas
1.5-3 horas
2298 inscrito
A Quick Guide to Excel Tables and Functions
1.5-3 horas 5,788 estudiantes
By Jordan Goldmeier
Aprenderás Cómo

By the end of this course, you will be able to:

  • Identify the main rules and the advantages of using Excel tables
  • Describe the Excel function that allows making decisions easier
  • Distinguish between the sorting and decision functions
  • Outline the concept of data aggregation
  • Explain the process of creating filters on Excel tables
  • Compare the pros and cons of Excel Form and ActiveX controls
  • Summarize the shortcomings of classic Excel development
  • Discuss the notion of formula-driven development
course logo
CERTIFICATE
Nivel avanzado
Data Analysis
A Quick Guide to Excel Tables and Functions
1.5-3 horas
5788 inscrito
Interactive Dashboards and Data Visualization in Excel
1.5-3 horas 6,151 estudiantes
By Jordan Goldmeier
Aprenderás Cómo

By the end of this course, you will be able to:

  • Explain the concept of dashboards
  • Identify the functions of interactive dashboards in MS Excel
  • Discuss the dynamics of information–transformation–presentation in the context of interactivity
  • Explain how to set up, format and maintain an interactive legend dashboard
  • Describe how to set up, format and maintain an interactive chart dashboard
  • Outline the procedure for setting up, formatting and maintaining an interactive dashboard
  • Describe the importance of visual perception in the process of presenting information
  • Outline the concept of the Gestalt laws of grouping
  • Identify the various tips for using special and bullet charts
  • Recognise the need for using data visualisation
  • Explain the advantages of infographics in MS Excel
course logo
CERTIFICATE
Nivel avanzado
Data Analysis
Interactive Dashboards and Data Visualization in Excel
1.5-3 horas
6151 inscrito
Foundations of Microsoft Excel Dashboards, Data Analysis and Visualization
6-10 horas 20,478 estudiantes
By Jordan Goldmeier
Aprenderás Cómo

By the end of this course, you will be able to:

  • Identify the various tips for formula editing in MS Excel
  • Describe the working principle behind the MS Excel calculation engine
  • Describe how to write better formulas in Microsoft Excel
  • Identify the main rules and the advantages of using MS Excel tables
  • Distinguish between the sorting and decision functions
  • Analyse the pros and cons of MS Excel Form and ActiveX controls
  • Discuss the notion of formula-driven development
  • Explain the concept of dashboards
  • Discuss the dynamics of information–transformation–presentation in the context of interactivity
  • Describe the importance of visual perception in the process of presenting information
  • Identify the various tips for using special and bullet charts
  • Explain the advantages of infographics in MS Excel
course logo
CERTIFICATE
Nivel avanzado
Data Analysis
Foundations of Microsoft Excel Dashboards, Data Analysis and Visualization
6-10 horas
20478 inscrito
Understanding the Essentials of Excel Data Visualization
1.5-3 horas 3,626 estudiantes
By Jordan Goldmeier
Aprenderás Cómo

By the end of this course, you will be able to:

  • Define the concept of data visualization
  • Discuss the differences between Data graphics and infographics
  • Explain the principles of data visualization
  • State the guidelines for tables and charts
  • Describe the procedure of adding a developer tab and a camera tool
  • Outline the pros and cons of sparklines and heatmaps
  • Summarize the different types of KPI charts
  • Identify the process of creating infographics in Excel
  • Indicate the process of creating a Checkbox and a Tornado Drilldown Dashboard
course logo
CERTIFICATE
Nivel avanzado
Data Analysis
Understanding the Essentials of Excel Data Visualization
1.5-3 horas
3626 inscrito
Basics of Power Query
1.5-3 horas 5,900 estudiantes
By Jordan Goldmeier
Aprenderás Cómo

By the end of this course, you will be able to:

  • Discuss the history of the Microsoft Excel Power Query tool
  • Explain the process of manipulating data with Power Query in Excel
  • Summarize the steps for wrangling data to solve various problems
  • Define the concept of M code
  • Indicate the process of locating the M code
  • Outline the Power Query features and items
  • List the stages involved in merging several datasets from various systems
  • Describe how to change the sample file
  • Summarize the process of combining data from other folders
course logo
CERTIFICATE
Nivel avanzado
Basics of Power Query
1.5-3 horas
5900 inscrito
Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables
1.5-3 horas 45,391 estudiantes
By Jordan Goldmeier
Aprenderás Cómo

By the end of this course, you will be able to:

  • List the most frequently used lookup and decision formulas
  • Outline the methods for creating and applying formulas in a spreadsheet to locate specific data
  • Identify the correct formula for calculating a specific value, counting cells, or adding the provided data
  • Explain the syntax of several new Excel functions
  • Discuss the concept of named ranges
  • Outline the tools that can be used to customize the named ranges
  • Recognize the range operators that appear in the formula syntax
  • Describe the operations that may be performed within an Excel table
  • Discuss the mechanics of a pivot table and its capabilities
  • Summarize the steps for counting, averaging, and running totals with pivot tables
  • Explain how to use filters, slicers, timelines, and pivot charts to display dynamic views of data
  • Describe the process of creating a pivot chart
course logo
CERTIFICATE
Nivel avanzado
Data Analysis
Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables
1.5-3 horas
45391 inscrito
Introduction to Analysis with Power BI Desktop
3-4 horas 9,219 estudiantes
By Jordan Goldmeier
Aprenderás Cómo

By the end of this course, you will be able to:

  • Analyze the Power BI workflow
  • Describe different Power BI visualizations
  • Outline the stages involved in building an interactive dashboard
  • Identify and create various types of charts in Power BI
  • Define the concept of M code and indicate the process of locating it
  • Outline the Power Query features and items
  • List the stages involved in merging several datasets from various systems
  • Recognize how to change the sample file and combine data from other folders
  • Explain the DAX language concept
  • Describe the benefits and drawbacks of implied measures
  • Discuss the capabilities of time-intelligence functions
  • Classify the parameters used in Power BI and illustrate their functions
course logo
CERTIFICATE
Nivel avanzado
Data Analysis
Introduction to Analysis with Power BI Desktop
3-4 horas
9219 inscrito
Mostrando 1 - 8 of 8
Reseñas y comentarios de los estudiantes sobre
548
290
Great instructor, Concepts were very clear to understand. Good course to add to your knowledge.
¿Te resultó útil esta reseña?
Denunciar
Great course! Complete practical knowledge. Loved this course!! An important and amazing course for any Data Analyst.
¿Te resultó útil esta reseña?
Denunciar
Recibe actualizaciones exclusivas de cursos
Entérate antes que nadie cuando haya un nuevo curso disponible de Jordan Goldmeier. Mantente al día con tus objetivos de aprendizaje y encuentra nuevas oportunidades para crecer profesionalmente.
Ver similares Creadores de cursos
Explorar todas las categorías de cursos de Alison
Crea cursos en Alison, gana dinero y empodera a millones
¿Te inspira Jordan Goldmeier? Tú también puedes convertirte en creador de cursos. Comparte tu experiencia con millones de estudiantes y ayúdalos a crecer cada día.
Conviértete en creador de cursos