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