Data Analysis Black Magic with Excel
4.7 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
16 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Analysis Black Magic with Excel to your Wishlist.

Add to Wishlist

Data Analysis Black Magic with Excel

A fast-paced course on how to do data analysis right, based on real-life cases, to learn useful Excel techniques
4.7 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
16 students enrolled
Created by Info Artist
Last updated 6/2017
English
Current price: $10 Original price: $35 Discount: 71% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 32 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • An engaging step-by-step guide to exploring and analyzing data in Excel
  • Learn the Structured Analysis Process to analyze the right way
  • Explore and analyze data with knowledge and confidence
  • Turn data into insights and tell stories with them
  • Build reusable reports instead of starting a new file from scratch
  • Unique content that you will not find anywhere else
  • English and Spanish versions of this course
View Curriculum
Requirements
  • You should be able to use Excel at a beginner level
Description

Solid data analysis skills are absolutely essential in today's corporate world.  Whether you are a beginner, intermediate or advanced Excel user, this course will take you to the next level.  In addition to best-practices, you will learn from hands-on examples and real-life cases.  Some of the techniques covered here are true gems and are not available anywhere else!  Lots of additional resources and guides are included with each lecture for your convenience!

This course does not aim to be a comprehensive Excel introduction.  Rather, it focuses on how to polish your data analysis skills and become much more efficient in the use of Excel.  That's why Excel users at any level of proficiency can take advantage of this course!

Our unique example-driven method for this course includes these elements:

  • Learn
  • Apply
  • Exercise
  • Solve
  • Explore

This ensures that you will learn quickly, apply your skills immediately, solidify your knowledge and expand it as much as you want!

Who is the target audience?
  • Excel users who have the skills but want to get more proficient in data exploration and analysis
  • Anyone who uses Excel regularly
  • Anyone who wants to use Excel VBA programming to solve common problems
Students Who Viewed This Course Also Viewed
Curriculum For This Course
16 Lectures
01:22:46
+
Introduction
3 Lectures 07:44

Brief introduction to the course, describing how it is organized.

Preview 01:13

This short video will help you set up your Visual Basic environment properly before we start to code.

Preview 01:08

This lecture will enable you to load data from an Access database quickly and easily.

Preview 05:23
+
Structured Analysis Process
6 Lectures 48:37

This lecture will introduce you to the structured analysis process, starting with univariate analysis.

Univariate analysis
08:17

This lecture is an introduction to multivariate analysis.

Delving into multivariate analysis
04:34

This lecture covers how to accelerate multivariate analysis with macros on pivot tables.

Saving time on pivot tables
11:17

This lecture covers an advanced real-life case of multivariate analysis.

More multivariate analysis
11:06

This lecture covers how to deal with outliers and missing data.

Preview 04:51

This lecture covers the topics of setting intervals, averages, confirmation bias, correlation, and analysis process documentation.

Preview 08:32
+
Data Analysis Toolset
7 Lectures 26:25

This short video describes the optimum report structure for data analysis.

Optimum report structure
01:57

This lecture shows how easy it is to create a PowerPoint presentation from Excel.

Create a PowerPoint presentation from Excel
05:18

This video shows some of the most useful timesaving techniques known in Excel.

Preview 05:24

This lecture shows how to recognize users with environment variables.

User detection with environment variables
07:34

This lecture describes how to use a documenter for Access databases, with the purpose of obtaining a summary of all forms, queries and tables contained in a database.

Preview 00:50

This lecture shows three examples of a basic Monte Carlo simulator.

Preview 03:27

This video describes how to use a file scheduler, in order to schedule a list of files to be opened at specific times.

Preview 01:55
About the Instructor
Info Artist
4.8 Average rating
9 Reviews
32 Students
2 Courses
Experts in advanced data analytics and business intelligence

Infoartist is a group of data analytics professionals with more than 12 years of experience developing global analysis tools for multinational companies across America and Europe, in the fields of telecommunications, consumer packaged goods, e-commerce, energy and food industry.  We have also covered and refined this material at two universities.  We have condensed the most valuable knowledge that we have acquired over the years and are ready to share it with you!