Join millions using the Alison App – faster, easier, and made for learning on the move... 📲 Learn On The Go With
The Alison App
Free Online Courses from the Jordan Goldmeier
Jordan Goldmeier
Data visualisation & analytics expert
83,731
Learners
8
Courses
174
Benefited
IT
Teaching on Alison since Aug 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...
🏆 Top Course by this Course Creator
The Basics of Decision Formulas
2,100 Learners already enrolled
3
5
Not Interested
Free Online Courses by Jordan Goldmeier
The Basics of Decision Formulas
1.5-3 hrs 2,100 learners
By Jordan Goldmeier
You Will Learn How To

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
Advanced Level
Data Analysis
The Basics of Decision Formulas
1.5-3 hrs
2100 enrolled
A Quick Guide to Excel Tables and Functions
1.5-3 hrs 5,018 learners
By Jordan Goldmeier
You Will Learn How To

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
Advanced Level
Data Analysis
A Quick Guide to Excel Tables and Functions
1.5-3 hrs
5018 enrolled
Interactive Dashboards and Data Visualization in Excel
1.5-3 hrs 5,122 learners
By Jordan Goldmeier
You Will Learn How To

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
Advanced Level
Data Analysis
Interactive Dashboards and Data Visualization in Excel
1.5-3 hrs
5122 enrolled
Foundations of Microsoft Excel Dashboards, Data Analysis and Visualization
6-10 hrs 17,272 learners
By Jordan Goldmeier
You Will Learn How To

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
Advanced Level
Data Analysis
Foundations of Microsoft Excel Dashboards, Data Analysis and Visualization
6-10 hrs
17272 enrolled
Understanding the Essentials of Excel Data Visualization
1.5-3 hrs 3,290 learners
By Jordan Goldmeier
You Will Learn How To

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
Advanced Level
Data Analysis
Understanding the Essentials of Excel Data Visualization
1.5-3 hrs
3290 enrolled
Basics of Power Query
1.5-3 hrs 5,148 learners
By Jordan Goldmeier
You Will Learn How To

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
Advanced Level
Basics of Power Query
1.5-3 hrs
5148 enrolled
Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables
1.5-3 hrs 38,064 learners
By Jordan Goldmeier
You Will Learn How To

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
Advanced Level
Data Analysis
Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables
1.5-3 hrs
38064 enrolled
Introduction to Analysis with Power BI Desktop
3-4 hrs 7,702 learners
By Jordan Goldmeier
You Will Learn How To

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
Advanced Level
Data Analysis
Introduction to Analysis with Power BI Desktop
3-4 hrs
7702 enrolled
Showing 1 - 8 of 8
Learner Reviews & Feedback For
379
174
avatar
Aanu A.
Alison is the best online tutorial, the learning is flexible and easy to understand. 10stars for Alison
Was This Review Helpful?
Report
Loved this course, explanations are very clear and with examples! I learned a lot!
Was This Review Helpful?
Report
Get Exclusive Course Updates
Be the first to know when a new course is available from Jordan Goldmeier . Stay on track with your learning goals and find new opportunities to grow.
View Similar Course Creators
category image
Teaching & Academics
+6
Course creators avatar
ADU
Industry leaders in maritime learning
For two decades, American Digital University (ADU) has been publishing quality courses related to the maritime..Know More
211 Courses
556,913 Learners
category image
IT
+5
Course creators avatar
Channel 9
Computer science written by MS tutors
Channel 9 is a Microsoft community site created in 2004. Originally launched as the company's blog, it is run ..Know More
55 Courses
1,661,015 Learners
category image
IT
+3
Course creators avatar
Ermin Dedic
Data science content specialist
Ermin Dedic started his studies by studying psychology for six years. He received his bachelor's degree from t..Know More
7 Courses
91,965 Learners
category image
Language
+8
Course creators avatar
NPTEL
University lecturer curated courses
The National Programme on Technology Enhanced Learning is an online learning platform founded in 2003 by the c..Know More
590 Courses
5,111,309 Learners
category image
Business
+5
Course creators avatar
SimonSezIT
Business & technical software leaders
SimonSezIT has been providing quality online education for over a decade and has taught hundreds of thousands ..Know More
60 Courses
1,506,566 Learners
category image
Business
+3
Course creators avatar
The Excel Club
Accounting and Excel brainiac
Paula Guilfoyle is the brains and the driving force behind The Excel Club. A certified public accountant, she ..Know More
9 Courses
203,588 Learners
category image
Business
+6
Course creators avatar
Workforce Academy Partnership
Business solutions & skills masters
Workforce Academy Partnership works with global leaders in online video learning content solutions for project..Know More
137 Courses
2,880,271 Learners
Explore All Alison Course Categories
IT
1,241
Courses
Language
312
Courses
Health
983
Courses
Teaching & Academics
1,582
Courses
Personal Development
1,286
Courses
Business
1,690
Courses
Sales & Marketing
433
Courses
Engineering & Construction
797
Courses
Management
1,019
Courses

Frequently Asked Questions

Is Alison really free?
The good news is that it’s free to learn on Alison! There is no cost for you to study and complete any of the courses offered by Alison. Once you’ve completed a course, you’ll have the option to purchase a printed or digital Certificate. If you don’t purchase a Certificate or Diploma, you can download your free Learner Record. This is official confirmation of the courses you have completed with Alison and the results you have achieved. Your Learner Record can be found in your Profile/Dashboard.
Create Courses on Alison, Make Money, Empower Millions
Feeling inspired by Jordan Goldmeier? You can become a Course Creator too. Share your expertise with millions of learners and help them grow every day.
Become a Course Creator