-
Book Overview & Buying
-
Table Of Contents
The Microsoft Excel Data Analysis Toolkit Bundle
By :
The Microsoft Excel Data Analysis Toolkit Bundle
By:
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)
Excel for Business Analysts: Introduction
Excel for Business Analysts: the Basics
Excel for Business Analysts: Merging and Looking Up Data
Excel for Business Analysts: Making Better Decisions with IF
Excel for Business Analysts: Preparing Data for Analysis
Excel for Business Analysts: PivotTables
Excel for Business Analysts: Visualizing Data with Charts
Excel for Business Analysts: Forecasting
Excel for Business Analysts: Additional Useful Functions in Excel
Excel for Business Analysts: WhatIf Analysis
Excel for Business Analysts: Conclusion
Advanced Excel 2019: Introduction
Advanced Excel 2019: Functions
Advanced Excel 2019: Date and Time Functions
Advanced Excel 2019: Text Functions
Advanced Excel 2019: Logical Functions
Advanced Excel 2019: Lookup Functions
Advanced Excel 2019: Financial Functions
Advanced Excel 2019: Statistical Functions
Advanced Excel 2019: Connecting to External Data
Advanced Excel 2019: Tables
Advanced Excel 2019: Pivot Tables
Advanced Excel 2019: Data Analysis
Advanced Excel 2019: Graphs and Charts
Advanced Excel 2019: Web App
Advanced Excel 2019: Conclusion
Advanced PivotTables: Introduction
Advanced PivotTables: Importing Data
Advanced PivotTables: Preparing Data for Analysis
Advanced PivotTables: Creating and Manipulating PivotTables
Advanced PivotTables: Formatting PivotTables
Advanced PivotTables: Value Field Settings
Advanced PivotTables: Sorting and Filtering
Advanced PivotTables: Interacting with PivotTables
Advanced PivotTables: Calculations
Advanced PivotTables: Pivot Charts
Advanced PivotTables: Conditional Formatting
Advanced PivotTables: Dashboards
Advanced PivotTables: Conclusion
Advanced Formulas in Excel: Introduction
Advanced Formulas
Advanced Formulas in Excel: Conclusion