Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from Hands-On Machine Learning with Microsoft Excel 2019 Build complete data analysis flows, from data collection to visualization

Product type Paperback

Published in Apr 2019

Publisher Packt

ISBN-13 9781789345377

Length 254 pages

Edition 1st Edition

Tools

Excel

Concepts

Data Analysis

Author (1):

Julio Cesar Rodriguez Martino

View More author details

Table of Contents (17) Chapters

Preface

1. Section 1: Machine Learning Basics FREE CHAPTER

2. Implementing Machine Learning Algorithms

3. Hands-On Examples of Machine Learning Models

4. Section 2: Data Collection and Preparation

5. Importing Data into Excel from Different Data Sources

6. Data Cleansing and Preliminary Data Analysis

7. Correlations and the Importance of Variables

8. Section 3: Analytics and Machine Learning Models

9. Data Mining Models in Excel Hands-On Examples

10. Implementing Time Series

11. Section 4: Data Visualization and Advanced Machine Learning

12. Visualizing Data in Diagrams, Histograms, and Maps

13. Artificial Neural Networks

14. Azure and Excel - Machine Learning in the Cloud

15. The Future of Machine Learning

16. Assessment

Questions

What is the main difference between classical computer programming and machine learning?
How are models classified, considering the type of target variable?
What are the different types of models, depending on how they learn?
What are the main steps when creating and using a machine learning model?
The output of the regression performed in Excel contains information about the residuals. What are they and how are they related to the MAE and MSE?
Explain underfitting and overfitting.
How can categorical features be used to feed machine learning models?

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

Cesar Rodriguez Martino

Julio Cesar Rodriguez Martino is a machine learning (ML) and artificial intelligence (AI) platform architect, focusing on applying the latest techniques and models in these fields to optimize, automate, and improve the work of tax and accounting consultants. The main tool used in this practice is the MS Office platform, which Azure services complement perfectly by adding intelligence to the different tasks. Julio's background is in experimental physics, where he learned and applied advanced statistical and data analysis methods. He also teaches university courses and provides in-company training on machine learning and analytics, and has a lot of experience leading data science teams.

See other products by Cesar Rodriguez Martino