The Microsoft Excel Data Analysis Toolkit Bundle
- Offered byUDEMY
The Microsoft Excel Data Analysis Toolkit Bundle at UDEMY Overview
Duration | 33 hours |
Total fee | ₹649 |
Mode of learning | Online |
Credential | Certificate |
The Microsoft Excel Data Analysis Toolkit Bundle at UDEMY Highlights
- Earn a certificate of completion
- 30-Day Money-Back Guarantee
- Get Full Lifetime Access
The Microsoft Excel Data Analysis Toolkit Bundle at UDEMY Course details
- Those wanting to automate Excel task or procedures.
- Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions
- Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge.
- 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 in Excel
- Conducting a Linear Forecast and Forecast Smoothing in Excel
- All about Histograms and Regression in Excel
- 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
The Microsoft Excel Data Analysis Toolkit Bundle at UDEMY Curriculum
Excel for Business Analysts
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'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
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
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
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?