All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

The Microsoft Excel Data Analysis Toolkit Bundle [Video]

The Microsoft Excel Data Analysis Toolkit Bundle: Conquer Data Analysis in Excel with four comprehensive Excel courses in one [Video]

By Simon Sez IT

~~$49.99~~ $9.99

Video Jul 2021 24 hours 59 minutes 1st Edition

~~$49.99~~ $9.99

~~$49.99~~ $9.99

What do you get with a video?

Download this video in MP4 format

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

View table of contents Download Code

Key benefits

Learn how to merge data from various sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP
Learn how to create amazing looking dashboards using PivotTables
Learn how to use Goal Seek, Scenario Manager, and Solver to fill data gaps in Excel

Description

In this four-course bundle, we look at a number of advanced Excel techniques all aimed at helping you make sense of the numbers in your business. In Excel for business analysts, you will learn to clean raw data and look at a number of tools and functions that can be used to conduct analysis. Finally, we move onto some more advanced techniques designed to aid forecasting and use existing data to predict future trends. In Advanced Excel 2019, you will gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information. Advanced PivotTables starts with a PivotTable refresher and then goes on to discuss advanced sorting, slicers, timelines, calculated fields, pivot charts, and conditional formatting. In Advanced Formulas, learn the Excel formulas and tools that enable you to perform complex tasks and analyses. Filtering a dataset, sorting using formulas, creating multi-dependent drop-down lists, 2-way look-ups, text extraction, dynamic chart titles, and XLOOKUP are a few of the exciting concepts covered in the course. By the end of the course, you will become an expert in data analysis with Excel. You can find all the resources for the course at https://github.com/PacktPublishing/The-Microsoft-Excel-Data-Analysis-Toolkit-Bundle

What you will learn

How to standardize and clean data ready for analysis in Excel How to format a PivotTable, including adjusting styles Create multi-dependent dynamic drop-down lists in Excel Learn all about histograms and regression in Excel Conduct a linear forecast and forecast smoothing in Excel Automate repetitive tasks in Excel using macros

What do you get with a video?

Download this video in MP4 format

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

Product Details

Publication date : Jul 29, 2021

Length 24 hours 59 minutes

Edition : 1st Edition

Language : English

ISBN-13 : 9781803239262

Category :

Concepts :

Tools :

Excel (Intermediate)

Table of Contents

42 Chapters

1. Excel for Business Analysts: Introduction

2. Excel for Business Analysts: the Basics

A Recap of Basic Formulas

Absolute Versus Relative Referencing

3. Excel for Business Analysts: Merging and Looking Up Data

Merging Data from Different Sources

Looking Up Information with VLOOKUP (Exact)

Looking Up Information with VLOOKUP (Approx.)

How to Use VLOOKUP with Data that Expands

Combining VLOOKUP and MATCH

Using INDEX, MATCH, and XLOOKUP

Data Validation Lists with Lookups

4. Excel for Business Analysts: Making Better Decisions with IF

How to Use the IF Function

More Examples of the IF Function

Working with Nested Ifs

The IFS Function

Error Handling with IFERROR and IFNA

Using MAX and MIN Instead of the IF Function

Using SUMIFS and COUNTIFS

5. Excel for Business Analysts: Preparing Data for Analysis

Splitting Data Using Text Functions

Using the Flash Fill Command

Concatenating Data

Standardizing Data

Formatting Data as a Table

6. Excel for Business Analysts: PivotTables

An Introduction to PivotTables

Creating a PivotTable

Summarizing Data

Calculations in PivotTables

Using Slicers to Filter information

7. Excel for Business Analysts: Visualizing Data with Charts

Creating a Pivot Chart

Formatting a Pivot Chart

Using Sparklines

A Basic Interactive Dashboard

8. Excel for Business Analysts: Forecasting

Forecast Sheets

The Forecast Function

9. Excel for Business Analysts: Additional Useful Functions in Excel

Conditional Formatting

The INDIRECT Function

The OFFSET Function

Using Histograms

10. Excel for Business Analysts: WhatIf Analysis

Scenario Manager

11. Excel for Business Analysts: Conclusion

12. Advanced Excel 2019: Introduction

Introduction to the Advanced Excel 2019

Advanced Excel 2019 Learning Structure

13. Advanced Excel 2019: Functions

Functions - Part 1

Functions - Part 2

14. Advanced Excel 2019: Date and Time Functions

How Date and Time Works

Basic Date and Time Functions

Complex Date and Time Functions

15. Advanced Excel 2019: Text Functions

Using Text Functions - Part 1

Using Text Functions - Part 2

16. Advanced Excel 2019: Logical Functions

Logical Functions

17. Advanced Excel 2019: Lookup Functions

Lookup Functions - Part 1

Lookup Functions - Part 2

18. Advanced Excel 2019: Financial Functions

Financial Functions and Terminology

Personal Financial Functions

Principal and Interest Payments

19. Advanced Excel 2019: Statistical Functions

Statistical Functions for Description - Part 1

Statistical Functions for Description - Part 2

Statistical Functions for Forecasting - Part 1

Statistical Functions for Forecasting - Part 2

One Click Forecasting

Statistical Functions for Inference

20. Advanced Excel 2019: Connecting to External Data

Connecting to Other Workbooks

Connecting to Access Databases

Connecting Web Data Sources

Get and Transform

21. Advanced Excel 2019: Tables

Introduction to Tables

Working with Tables

Table References

22. Advanced Excel 2019: Pivot Tables

Introduction to Pivot Tables

Working with Pivot Tables

Filters and Slicers

Pivot and Charts

23. Advanced Excel 2019: Data Analysis

What If Analysis

Scenario Manager

24. Advanced Excel 2019: Graphs and Charts

25. Advanced Excel 2019: Web App

Web App - Part 1

Web App - Part 2

26. Advanced Excel 2019: Conclusion

27. Advanced PivotTables: Introduction

Introduction to Advanced PivotTables

PivotTables Recap

28. Advanced PivotTables: Importing Data

Importing Data from a Text File

Importing Data from Access

29. Advanced PivotTables: Preparing Data for Analysis

30. Advanced PivotTables: Creating and Manipulating PivotTables

Creating and Manipulating a PivotTable

Combining Data from Multiple Worksheets

Grouping and Ungrouping

Formatting Error Values and Empty Cells

31. Advanced PivotTables: Formatting PivotTables

PivotTable Styles

Custom Number Formatting

32. Advanced PivotTables: Value Field Settings

Summarizing Values

33. Advanced PivotTables: Sorting and Filtering

Advanced Sorting

Advanced Filtering

34. Advanced PivotTables: Interacting with PivotTables

Inserting and formatting Slicers

Inserting and formatting Timelines

Connecting Slicers to Multiple PivotTables

Using Slicers in Protected Workbooks

35. Advanced PivotTables: Calculations

Creating a Calculated Field

Creating a Calculated Item

Solve Order and List Formulas

36. Advanced PivotTables: Pivot Charts

Creating a Pivot Chart

Formatting a Pivot Chart - Part 1

Formatting a Pivot Chart - Part 2

Creating a Map Chart using Pivot Data

Dynamic Chart Titles

Include a Sparkline with your PivotTable

37. Advanced PivotTables: Conditional Formatting

Highlighting Cell Rules

Graphical Conditional Formats

Conditional Formatting and Slicers

38. Advanced PivotTables: Dashboards

Creating an Interactive Dashboard - Part 1

Creating an Interactive Dashboard - Part 2

Updating Pivot Charts and PivotTables

39. Advanced PivotTables: Conclusion

40. Advanced Formulas in Excel: Introduction

41. Advanced Formulas

Filter a Dataset Using a Formula

Sort a Dataset Using a Formula and Defined Variables

Multiple Dependent Dynamic Drop-Down Lists

Perform a 2-way Lookup

Make Decisions with Complex Logical Calculations

Extracting Parts of a Text String

Creating a Dynamic Chart Title

Finding the Last Occurrence of a Value in a List

Looking Up Information with XLOOKUP

Find the st Match to a Value

42. Advanced Formulas in Excel: Conclusion

Recommendations for you

Building LLM Powered Applications

Building LLM Powered Applications

May 2024 342 pages

eBook

$9.99 ~~$39.99~~

Machine Learning with PyTorch and Scikit-Learn

Machine Learning with PyTorch and Scikit-Learn

Feb 2022 774 pages

eBook

$9.99 ~~$43.99~~

Transformers for Natural Language Processing and Computer Vision

Transformers for Natural Language Processing and Computer Vision

Feb 2024 728 pages

eBook

$9.99 ~~$43.99~~

The Definitive Guide to Power Query (M)

The Definitive Guide to Power Query (M)

Mar 2024 758 pages

eBook

$29.99 ~~$43.99~~

Building Smart Chatbots with LangChain

Building Smart Chatbots with LangChain

Jun 2024 4h 15m

Video

$9.99 ~~$298.99~~

The Machine Learning Solutions Architect Handbook

The Machine Learning Solutions Architect Handbook

Apr 2024 602 pages

eBook

$9.99 ~~$32.99~~

Microsoft Azure AI Fundamentals AI-900 Exam Guide

Microsoft Azure AI Fundamentals AI-900 Exam Guide

May 2024 288 pages

eBook

$9.99 ~~$35.99~~

Generative AI with LangChain

Generative AI with LangChain

Dec 2023 360 pages

eBook

$9.99 ~~$39.99~~

Mastering NLP from Foundations to LLMs

Mastering NLP from Foundations to LLMs

Apr 2024 340 pages

eBook

$9.99 ~~$42.99~~

Machine Learning for Algorithmic Trading

Machine Learning for Algorithmic Trading

Jul 2020 822 pages

eBook

$9.99 ~~$46.99~~

Customer reviews

Top Reviews

Rating distribution

5

(1 Ratings)

5 star 100%

4 star 0%

3 star 0%

2 star 0%

1 star 0%

Filter

Top Reviews

N/A Jan 20, 2022

5

Super Service! Fast delivery.

Feefo Verified review

People who bought this also bought

Machine Learning with PyTorch and Scikit-Learn

Machine Learning with PyTorch and Scikit-Learn

Feb 2022 774 pages

eBook

$9.99 ~~$43.99~~

Machine Learning for Time-Series with Python

Machine Learning for Time-Series with Python

Oct 2021 370 pages

eBook

$9.99 ~~$43.99~~

Modern Time Series Forecasting with Python

Modern Time Series Forecasting with Python

Nov 2022 552 pages

eBook

$9.99 ~~$42.99~~

Deep Learning with TensorFlow and Keras – 3rd edition

Deep Learning with TensorFlow and Keras – 3rd edition

Oct 2022 698 pages

eBook

$9.99 ~~$39.99~~

Hands-On Data Preprocessing in Python

Hands-On Data Preprocessing in Python

Jan 2022 602 pages

eBook

$9.99 ~~$43.99~~

The Microsoft Excel Data Analysis Toolkit Bundle

The Microsoft Excel Data Analysis Toolkit Bundle

Jul 2021 24h 59m

Video

$9.99 ~~$49.99~~

About the author

Simon Sez IT

Simon Sez IT - Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity—no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

See other products by Simon Sez IT

FAQs

How can I download a video package for offline viewing?

Login to your account at Packtpub.com.
Click on "My Account" and then click on the "My Videos" tab to access your videos.
Click on the "Download Now" link to start your video download.

How can I extract my video file?

All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.

How can I get help and support around my video package?

If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail customercare@packt.com with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.

Video
Format watched (HTML, MP4, streaming)
Chapter or section that issue relates to (if relevant)
System being played on
Browser used (if relevant)
Details of support

Why can’t I download my video package?

In the even that you are having issues downloading your video package then please follow these instructions:

Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.