The Microsoft Excel Data Analysis Toolkit Bundle
- All prices mentioned above are in United States dollar.
- This product is available at Udemy.
- At udemy.com you can purchase The Microsoft Excel Data Analysis Toolkit Bundle for only $17.00
- The lowest price of The Microsoft Excel Data Analysis Toolkit Bundle was obtained on November 18, 2024 9:13 pm.
Original price was: $89.99.$17.00Current price is: $17.00.
Best deal at: 
udemy.com
Buy for best price
udemy.com
Set Lowest Price Alert
×
Notify me, when price drops
Set Alert for Product: The Microsoft Excel Data Analysis Toolkit Bundle - $17.00
Price history
×
| Price history for The Microsoft Excel Data Analysis Toolkit Bundle | |
|---|---|
|
Latest updates:
|
|
The Microsoft Excel Data Analysis Toolkit Bundle
Original price was: $89.99.$17.00Current price is: $17.00.
Description
| Price history for The Microsoft Excel Data Analysis Toolkit Bundle | |
|---|---|
|
Latest updates:
|
|
Didn't find the right price? Set price alert below
Set Alert for Product: The Microsoft Excel Data Analysis Toolkit Bundle - $17.00
The Microsoft Excel Data Analysis Toolkit Bundle
★★★★★
$17.00 in stock
Udemy.com
as of November 18, 2024 9:13 pm
Conquer data analysis in Excel with five comprehensive Excel courses in one
Created by:
Simon Sez IT
890,000+ Students, 260+ Courses, Learners in 180+ Countries
890,000+ Students, 260+ Courses, Learners in 180+ Countries
Rating:4.6 (793reviews)
4414students enrolled
What Will I 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 in Excel
- Conducting a Linear Forecast and Forecast Smoothing in Excel
- All about Histograms and Regression in Excel
- How to use Goal Seek, Scenario Manager, and Solver to fill data gaps in Excel
- Averages, percentiles, and LINEST functions
- Sparklines and data bars
- Importing data from other data sources
- Advanced data analysis techniques
- Financial & Statistical Functions
- How to create amazing looking dashboards using Pivot Tables
- How to format a PivotTable, including adjusting styles
- Advanced Sorting and Filtering in PivotTables
- How to use 3D Maps from a PivotTable
- How to update your data in a PivotTable and Pivot Chart
- Create multi-dependent dynamic drop-down lists in Excel
- Perform a 2-way lookup in Excel
- Automate repetitive tasks in Excel using Macros
- How to edit Macros in the VBA Editor
- How to write your own macro from scratch
Requirements
- Microsoft Excel for Windows. The course was created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.
- Intermediate knowledge of Microsoft Excel.
Target audience
- 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.
Price History
| Price history for The Microsoft Excel Data Analysis Toolkit Bundle | |
|---|---|
|
Latest updates:
|
|
There are no reviews yet.