Data Analysis and Machine Learning with Excel 2019

Data Analysis and Machine Learning with Excel 2019

TTML5610

Intermediate

3 Days

Course Overview

 

Huge progress has been made in teaching computers to perform difficult tasks, especially those that are repetitive and time-consuming for humans. Much of this data analysis and machine learning work is completed leveraging modern scripting and programming skills, such as R or Python programing, for example.  It’s easy for Excel users not fluent in these skills or languages to feel sidelined from this innovation wave. However, that isn’t the reality. The truth is that a large amount of the work needed to develop and use a machine learning model can be done purely in Excel.

 

Data Analysis and Machine Learning in Excel is a three-day, foundation-level, hands-on course that explores this fast-changing field and how experienced Excel users can leverage their skills to contribute. The course starts by giving a general introduction to machine learning, making every concept clear and understandable. Then, it shows every step of a machine learning project, from data collection, reading from different data sources, developing models, and visualizing the results using Excel features and offerings. In every lesson, there are several examples and hands-on exercises that will show the reader how to combine Excel functions, add-ins, and connections to databases and to cloud services to reach the desired goal: building a full data analysis flow. Different machine learning models are shown, tailored to the type of data to be analyzed.

Course Objectives

This “skills-centric” course is about 50% hands-on lab and 50% lecture, with extensive practical exercises designed to reinforce fundamental skills, concepts and best practices taught throughout the course.  Students will be led through a series of progressively advanced topics, where each topic consists of lecture, group discussion, comprehensive hands-on lab exercises, and lab review.

 

Working in a hands-on learning environment led by our expert practitioner, attendees will learn to:

  • Use Excel to preview and cleanse datasets
  • Understand correlations between variables and optimize the input to machine learning models
  • Use and evaluate different machine learning models from Excel
  • Understand the use of different visualizations
  • Learn the basic concepts and calculations to understand how artificial neural networks work
  • Learn how to connect Excel to the Microsoft Azure cloud
  • Get beyond proof of concepts and build fully functional data analysis flows

Course Prerequisites

This course is geared for attendees seeking next-level use cases using Automated Machine Learning, and artificial neural network, which simplifies the analysis task and represents the future of machine learning.

Attending students should have the following incoming skills

  • Basic to Intermediate IT Skills and Machine Learning with Microsoft Excel 2019 knowledge
  • Good foundational mathematics or logic skills
  • Basic Linux skills, including familiarity with command-line options such as ls, cd, cp, and su

Course Agenda

Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We’ll work with you to tune this course and level of coverage to target the skills you need most. Topics, agenda and labs are subject to change, and may adjust during live delivery based on audience needs and skill-level.

 

 

  1. Implementing Machine Learning Algorithms
  • Technical requirements
  • Understanding learning and models
  • Focusing on model features
  • Studying machine learning models in practice
  • Comparing underfitting and overfitting
  • Evaluating models

 

  1. Hands-On Examples of Machine Learning Models
  • Technical requirements
  • Understanding supervised learning with multiple linear regression
  • Understanding supervised learning with decision trees
  • Understanding unsupervised learning with clustering

 

  1. Importing Data into Excel from Different Data Sources
  • Technical requirements
  • Importing data from a text file
  • Importing data from another Excel workbook
  • Importing data from a web page
  • Importing data from Facebook
  • Importing data from a JSON file
  • Importing data from a database

 

  1. Data Cleansing and Preliminary Data Analysis
  • Technical requirements
  • Cleansing data
  • Visualizing data for preliminary analysis
  • Understanding unbalanced datasets

 

  1. Correlations and the Importance of Variables
  • Technical requirements
  • Building a scatter diagram
  • Calculating the covariance
  • Calculating the Pearson's coefficient of correlation
  • Studying the Spearman's correlation
  • Understanding least squares
  • Focusing on feature selection

 

  1. Data Mining Models in Excel Hands-On Examples
  • Technical requirements
  • Learning by example – Market Basket Analysis
  • Learning by example – Customer Cohort Analysis

 

  1. Implementing Time Series
  • Technical requirements
  • Modeling and visualizing time series
  • Forecasting time series automatically in Excel
  • Studying the stationarity of a time series

 

  1. Visualizing Data in Diagrams, Histograms, and Maps
  • Technical requirements
  • Showing basic comparisons and relationships between variables
  • Building data distributions using histograms
  • Representing geographical distribution of data in maps
  • Showing data that changes over time

 

  1. Artificial Neural Networks
  • Technical requirements
  • Introducing the perceptron – the simplest type of neural network
  • Building a deep network
  • Understanding the backpropagation algorithm

 

  1. Azure and Excel - Machine Learning in the Cloud
  • Technical requirements
  • Introducing the Azure Cloud
  • Using AMLS for free – a step-by-step guide
  • Loading your data into AMLS
  • Creating and running an experiment in AMLS

 

  1. The Future of Machine Learning
  • Automatic data analysis flows
  • Automated machine learning

Course Materials

Each student will receive a Student Guide with course notes, code samples, software tutorials, diagrams and related reference materials and links (as applicable). Our courses also include step by step hands-on lab instructions and and solutions, clearly illustrated for users to complete hands-on work in class, and to revisit to review or refresh skills at any time. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.

Raise the bar for advancing technology skills

Attend a Class!

Live scheduled classes are listed below or browse our full course catalog anytime

Special Offers

We regulary offer discounts for individuals, groups and corporate teams. Contact us

Custom Team Training

Check out custom training solutions planned around your unique needs and skills.

EveryCourse Extras

Exclusive materials, ongoing support and a free live course refresh with every class.

Attend a Course

Please see the current upcoming available open enrollment course dates posted below. Please feel free to Register Online below, or call 844-475-4559 toll free to connect with our Registrar for assistance. If you need additional date options, please contact us for scheduling.

Course Title Days Date Time Price
Data Analysis and Machine Learning with Excel 2019 3 Days Apr 7 to Apr 9 10:00 AM to 06:00 PM EST $2,195.00 Register
Data Analysis and Machine Learning with Excel 2019 3 Days Jun 9 to Jun 11 10:00 AM to 06:00 PM EST $2,195.00 Register
Data Analysis and Machine Learning with Excel 2019 3 Days Aug 11 to Aug 13 10:00 AM to 06:00 PM EST $2,195.00 Register
Data Analysis and Machine Learning with Excel 2019 3 Days Oct 13 to Oct 15 10:00 AM to 06:00 PM EST $2,195.00 Register
Data Analysis and Machine Learning with Excel 2019 3 Days Dec 8 to Dec 10 10:00 AM to 06:00 PM EST $2,195.00 Register

New Site, BIG Savings!
We're celebrating the launch of our lonnngggg awaited new site with with *50% off all 2021 Public Classes* booked by March 31!  Check out our Current Offers for Individuals, Teams and Organizations to Learn for Less!

See our latest Offers and Promotions

Learn. Explore. Advance!

Extend your training investment! Recorded sessions, free re-sits and after course support included with Every Course
Trivera MiniCamps
Gain the skills you need with less time in the classroom with our short course, live-online hands-on events
Trivera QuickSkills: Free Courses and Webinars
Training on us! Keep your skills current with free live events, courses & webinars
Trivera AfterCourse: Coaching and Support
Expert level after-training support to help organizations put new training skills into practice on the job

The voices of our customers speak volumes

Special Offers
Limited Offer for most courses.

SAVE 50%

Learn More