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
Les mer
Produktdetaljer
ISBN
9781803239262
Publisert
2023
Utgave
1. utgave
Utgiver
Packt Publishing
Språk
Product language
Engelsk
Format
Product format
Digital bok
Forfatter