Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying The Microsoft Excel Data Analysis Toolkit Bundle
  • Table Of Contents Toc
The Microsoft Excel Data Analysis Toolkit Bundle

The Microsoft Excel Data Analysis Toolkit Bundle

By : Simon Sez IT
close
close
The Microsoft Excel Data Analysis Toolkit Bundle

The Microsoft Excel Data Analysis Toolkit Bundle

By: Simon Sez IT

Overview of this book

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
Table of Contents (42 chapters)
close
close
1
Excel for Business Analysts: Introduction
8
Excel for Business Analysts: Forecasting
9
Excel for Business Analysts: Additional Useful Functions in Excel
10
Excel for Business Analysts: WhatIf Analysis
11
Excel for Business Analysts: Conclusion
13
Advanced Excel 2019: Functions
15
Advanced Excel 2019: Text Functions
16
Advanced Excel 2019: Logical Functions
17
Advanced Excel 2019: Lookup Functions
23
Advanced Excel 2019: Data Analysis
25
Advanced Excel 2019: Web App
26
Advanced Excel 2019: Conclusion
27
Advanced PivotTables: Introduction
29
Advanced PivotTables: Preparing Data for Analysis
31
Advanced PivotTables: Formatting PivotTables
32
Advanced PivotTables: Value Field Settings
33
Advanced PivotTables: Sorting and Filtering
39
Advanced PivotTables: Conclusion
40
Advanced Formulas in Excel: Introduction
42
Advanced Formulas in Excel: Conclusion
You're currently viewing a free sample. Access the full title and Packt library for free now with a free trial.
Chapter: 7
Excel for Business Analysts: Visualizing Data with Charts
Icon This video is locked
Icon
Icon
0:00
2.0x
1.5x
1.25x
1.0x
0.5x
caption settings
caption off
Icon Icon
ShowHide Transcripts Icon
CONTINUE WATCHING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
The Microsoft Excel Data Analysis Toolkit Bundle
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon