Instructor for this course
more

Excel is a versatile tool that can be used for a lot of advanced data analysis projects; if you know how to use the various supplemental add-ons and features. This in-depth course walks participants through the critical elements of performing advanced analysis in Excel. The focus is on allowing participants to follow along and actually perform the analysis as the instructor is doing it.

By the end of the course, participants will be equipped to perform complex analysis on a variety of types of data and draw inferences based on the data to make business decisions effectively.

***Please download and open all supporting materials before starting the course videos.***

Learning Objectives

 

  • Explore how to gather and clean a compiled dataset from disparate sources
  • Explore how to identify and flag outliers in data
  • Explore how to compute correlations between variables
  • Discover how to turn non-numerical qualitative data into numerical data that can be effectively analyzed with statistics
  • Discover how to perform basic regressions in Excel for use in finding hidden relationships between business decisions
  • Discover how to run t-tests and other statistics to make informed business decisions based on data

 

Last updated/reviewed: November 6, 2019

Included In Certifications

This course is included in the following Certification Programs:

15 CoursesCDAP (Certified Data Analyst Professional)

  1. The Fundamentals of Business Intelligence (BI): What it Does and Why it's so Essential
  2. How is Industry Using Big Data? – A Case Study Reading
  3. Business Intelligence - Data Collection and Cleaning
  4. Business Intelligence - Structuring Data for Analysis
  5. Business Intelligence - Fundamentals of Data Analysis
  6. Business Intelligence - Using Big Data Analytics
  7. Doing Data Analytics In Excel (Hands-on module)
  8. Regressions in Excel (Hands-on module)
  9. Financial Forecasting
  10. Advanced Analytics – Omitted Variables
  11. Advanced Analytics – Fixed Effects
  12. Case Study in Data Analytics
  13. Using Regressions for Forecasting
  14. Financial Forecasting in Excel (Hands-on module)
  15. Blockchain for Business

44 Reviews (274 ratings)Reviews

4
Member's Profile
I've been taking all the other courses in the Certified Data Analyst group and really glad to see that there is a hands on lesson, which was something I had requested earlier. Michael goes over all the steps involved in thorough detail to download data from FRED, synchronize the preriodicity of the data (D, W, M), then generate some univariate statistics to help interpret the data. My only critique is that he manually synchronized the data between daily / weekly / yearly when that could have been done automatically by changing the FRED download, but it's possible he did this as a learning point in case you are importing data from other sources. The hands on took 1.5 hours for me (and probably would for most since you need to pause and recreate what he's doing) so a bit more than the recommended 1 hr. Very good course overall and looking forward to more.
4
Member's Profile
Another great course! I enjoyed learning through the hands on excercise. Very clear explanations on the methodology. I still would like to have notes to get an understanding of the terminology, perhaps this is in the other courses. The exercises were very helpful to understand how to go about building a good data set for analysis.
4
Anonymous Author
Having a walkthrough module that you could do alongside the instructor helped to put the different items from past courses into perspective. It would have helped though if the walkthrough was better organized or slightly slower, I had to keep repeating segments to check my numbers.
5
Anonymous Author
I really liked how the instructor walked us through building a data set, especially how he worked through a few different challenges we may face. I also liked his explanation of V-lookups, as I am trying to get more familiar with this tool.
5
Anonymous Author
This was a great course. Building data sets in a great tool to have in the business world. Also learning how to clean up and use the different tools that excel has to offer was great to learn
4
Anonymous Author
Course covered how to complete basic statistical analyses of a dataset from free data provided by the federal reserve. Description of how to deal with variable frequency issues was helpful.
5
Anonymous Author
Doing data analytics in excels is a really useful skill in analyzing data. I would rate this course 5 stars course this course is easy to understand and easy to learn.
5
Member's Profile
The presentation was great and easy to follow. I was able to follow the instructor by opening a blank excel sheet and following how he using data analytics in excel.
4
Anonymous Author
Pausing the course to follow along using my own Excel example really helped me understand. Nothing like hands-on for mastering concepts!
3
Member's Profile
I wish there had been slide deck of the salient points. I tried to capture them all as I viewed the video, but did not catch them all.
2
Anonymous Author
I was hoping for a more practical excercise that analyzed an income statement with 1000 line items grouped in 50 different departments
4
Anonymous Author
This course was helpful in understanding and utilizing FRED tool bar and I was surprised with the data that was provided within
5
Anonymous Author
This course, with its helpful hands-on approach, helped in a concrete way ensure that mastery of the lesson was accomplished!
4
Anonymous Author
this was a fun course to watch!! I learned about v-lookups, as well as great tactics to get around missing data problems.
4
Anonymous Author
Overall this was helpful. I liked the hands on approach, although having a strong understanding of excel was helpful.
4
Anonymous Author
Course had a lot of good examples of how to build out data points. I especially liked the bit on a moving average.
4
Anonymous Author
This is a good introduction course but will require more work on the student's part to utilize the skills learned.
5
Anonymous Author
I appreciate that the instructor walked through the steps of how to find things and how to manipulate the data.
3
Anonymous Author
It was thorough, though a little basic, at times. I appreciated starting with the FRED add-in - very helpful!
5
Anonymous Author
Thanks Michael for a great course that was manageable and easy to understand. Appreciate it as always!
5
Anonymous Author
Excellent hand-on module. Always helpful to apply the concepts from lectures in a realistic scenario.
3
Anonymous Author
The interactive session was helpful in getting a better idea of how everything will actually work.
5
Anonymous Author
Michael was clear and concise in this hands on module, and I found it very easy to follow along.
3
Anonymous Author
Good basic course that guides you and provides opportunity to put into practice what is taught.
5
Anonymous Author
Useful that step by step and logic behind each step. Please continue to offer courses on data.
4
Member's Profile
The information is helpful. It would be great to get a cheat sheet for the formulas used.
5
Anonymous Author
Great course I look forward to the next lesson. every learning objective was covered
5
Member's Profile
Helpful insight to the best way to do data analytics. The workbook was very helpful.
5
Anonymous Author
Course was informative and easy to navigate. I would recommend it to a colleague.
5
Member's Profile
Very good examples and very well explained. Great for starting to work with data
4
Anonymous Author
this was a decent intro class, I would like to see more in depth slide material
5
Anonymous Author
I like the use of FRED data for the example case presented in this course.
5
Member's Profile
Good overview of Data Analytics and Prep. Explained methodically and well.
3
Anonymous Author
Explanations are Easy to understand and examples are useful to practice.
5
Anonymous Author
This class was helpful but at the same time was very boring and bland.
4
Member's Profile
Manipulating the data and walking through step by step is very helpful
4
Member's Profile
very good primer for basic regression analysis and the fundamentals
4
Anonymous Author
Very good course. I wish this one come with a set of slides as well
4
Anonymous Author
Good course. Nice summary of excel functions and data analytics.
5
Member's Profile
Great course, knew most of the excel stuff but a good refresher
4
Anonymous Author
learning how to manipulate data in excel was extremely helpful
5
Anonymous Author
Being able to walk through an example was very helpful.
4
Anonymous Author
I liked the hands on aspect of this course on Illumeo
5
Member's Profile
Everything about this course was absolutely fantastic.

Prerequisites

Course Complexity: Intermediate

Viewers should be familiar with basic financial and accounting concepts. In addition, viewers should be familiar with Big Data and Business Intelligence, or review my existing courses on the topic. Familiarity with and access to Excel will be helpful.

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
  9:32Introduction to Doing Data Analytics In Excel (Hands-on module)
  11:05Data Analytics in Excel Part 2
  16:24Data Analytics in Excel Part 2 (Continued)
  14:58Data Analytics in Excel Part 3
CONTINUOUS PLAY
  51:48Doing Data Analytics In Excel (Hands-on module)
SUPPORTING MATERIALS
  PDFDoing Data Analytics In Excel (Hands-on module) Glossary/Index
  XLSWorkbook: Doing Data Analytics In Excel (Hands-on module)
  XLSCompleted Workbook: Doing Data Analytics In Excel (Hands-on module)
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM