The Microsoft Excel Data Analysis Toolkit Bundle

The Microsoft Excel Data Analysis Toolkit Bundle

**This course bundle includes practice exercises**

Data Analysis is THE skill you need to thrive in the modern workforce.

Data Analysis is easier than you might think. You don’t need to be able to code or understand algorithms. What you need, is a deep understanding of the Microsoft Excel techniques needed to conduct comprehensive data analysis.

In this five-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 this special course, we’ve combined five of our full-length titles into one, huge-value bundle. Here’s what you get:

Excel for Business Analysts

What you’ll learn:

• How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP

• How to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysis

• How to split data using text functions SEARCH, LEFT, RIGHT, MID

• How to standardize and clean data ready for analysis

• About using the PivotTable function to perform data analysis

• How to use slicers to draw out information

• How to display your analysis using Pivot Charts

• All about forecasting and using the Forecast Sheets

• Conducting a Linear Forecast and Forecast Smoothing

• How to use Conditional Formatting to highlight areas of your data

• All about Histograms and Regression

• How to use Goal Seek, Scenario Manager, and Solver to fill data gaps

Advanced Excel 2019 Course

What You'll Learn:

• What's new/different in Excel 2016

• Advanced charting and graphing in Excel

• How to use detailed formatting tools

• Lookup and advanced lookup functions

• Financial functions including calculating interest and depreciation

• Statistical functions

• Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.

• How to create awesome visualizations using sparklines and data bars

• Mastery of PivotTables and Pivot Charts

• Scenario Manager, Goal Seek, and Solver

• Advanced charts such as Surface, Radar, Bubble, and Stock Charts

PivotTables for Beginners

What You'll Learn:

• How to clean and prepare your data

• Creating a basic PivotTable

• Using the PivotTable fields pane

• Adding fields and pivoting the fields

• Formatting numbers in PivotTable

• Different ways to summarize data

• Grouping PivotTable data

• Using multiple fields and dimension

• The methods of aggregation

• How to choose and lock the report layout

• Applying PivotTable styles

• Sorting data and using filters

• Create pivot charts based on PivotTable data

• Selecting the right chart for your data

• Apply conditional formatting

• Add slicers and timelines to your dashboards

• Adding new data to the original source dataset

• Updating PivotTables and charts

Advanced PivotTables

What You'll Learn:

• How to do a PivotTable (a quick refresher)

• How to combine data from multiple worksheets for a PivotTable

• Grouping, ungrouping, and dealing with errors

• How to format a PivotTable, including adjusting styles

• How to use the Value Field Settings

• Advanced Sorting and Filtering in PivotTables

• How to use Slicers, Timelines on multiple tables

• How to create a Calculated Field

• All about GETPIVOTDATA

• How to create a Pivot Chart and add sparklines and slicers

• How to use 3D Maps from a PivotTable

• How to update your data in a PivotTable and Pivot Chart

• All about Conditional Formatting in a PivotTable

• How to create amazing looking dashboards

Advanced Formulas in Excel

What You'll Learn:

• Filter a dataset using a formula

• Sort dataset using formulas and defined variables

• Create multi-dependent dynamic drop-down lists

• Perform a 2-way lookup

• Make decisions with complex logical calculations

• Extract parts of a text string

• Create a dynamic chart title

• Find the last occurrence of a value in a list

• Look up information with XLOOKUP

• Find the closest match to a value

This course includes:

1. 30+ hours of video tutorials

2. 230+ individual video lectures

3. Exercise files to practice what you learned

4. Certificate of completion

This course was recorded using Excel 2019 and Excel 365. It's also relevant to those using other, recent versions of Microsoft Excel including Excel 2013 and 2016.

Here’s what our students are saying…

"Well described and clearly demonstrated."

- Harlan

"My name is Kenvis and i have a knowledge in IT but never thought of specializing in Data Analytics before. This was so exciting and am now anxious to learn more."

- Kenvis

"I like the instructor very much. I had a slight problem with the MIN function but I reviewed the tutorial again until I realized where my error was, and fixed it!"

- Beverly

Conquer data analysis in Excel with five comprehensive Excel courses in one

Url: View Details

What you will learn

• How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP
• How to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysis
• How to split data using text functions SEARCH, LEFT, RIGHT, MID

Rating: 4.59884

Level: Intermediate Level

Duration: 32 hours

Instructor: Simon Sez IT