Microsoft Excel Advanced: the Data Analysis Tools You Need
5.0 /5- Offered byUDEMY
Microsoft Excel Advanced: the Data Analysis Tools You Need at UDEMY Overview
Duration | 3 hours |
Total fee | ₹1,280 |
Mode of learning | Online |
Credential | Certificate |
Microsoft Excel Advanced: the Data Analysis Tools You Need at UDEMY Highlights
- Earn a Certificate of completion from Udemy
- Get a 30 days money back guarantee on the course
- Get full lifetime access of the course material
- Learn from 2 downloadable resources
Microsoft Excel Advanced: the Data Analysis Tools You Need at UDEMY Course details
- Grouping & Outlining and Subtotals - Outlining and Grouping Data - Using the Subtotals Tool
- PivotTables - Getting Started with PivotTables - Displaying Data in a PivotTable - Formatting a PivotTable - Using the Classic PivotTable Layout - Slicers
- Charting Pivoted Data - Getting Started with PivotCharts - Using the PivotChart Tools Tabs - Formatting a PivotChart
- Advanced Excel Tasks - Excel and Hyperlinks - Using Custom AutoFill Lists - Sharing Workbooks
- The course has its own workbook with exercises -downloadable within the first 'Introduction-module -so students can practice and reinforce what they have learned
- They will acquire a highly impressive array of data analysis skills, including What-If Scenarios, PivotTables, PivotCharts, HLOOKUPs, VLOOKUPs and basic Macros
Microsoft Excel Advanced: the Data Analysis Tools You Need at UDEMY Curriculum
Introduction
Overview
What-If Analysis
Introduction
Exploring Scenarios - Overview
Exploring Scenarios
Goal Seek and Data Tables - Overview
Goal Seek
Data Tables
Using Solver
Pivot Tables
Introduction
Getting Started with PivotTables - Overview
Getting Started with PivotTables
Displaying Data in a PivotTable - Overview
Displaying Data in a PivotTable
Formatting a PivotTable - Overview
Formatting a PivotTable
Slicers - Overview
Charting Pivoted Data
Introduction
Getting Started with PivotCharts - Overview
Getting Started with PivotCharts
PivotChart Tools and Formatting - Overview
PivotChart Tools and Formatting
Advanced Excel Sheets
Introduction
Excel and Hyperlinks - Overview
Excel and Hyperlinks
Using Custom AutoFill Lists - Overview
Using Custom AutoFill Lists
Sharing Workbooks - Overview
Sharing Workbooks
Tracking Changes
HLOOKUP and VLOOKUP Functions
Introduction
Using the VLOOKUP Function - Overview
Using the VLOOKUP Function
Using the LOOKUP Function - Overview
Using the LOOKUP Function
Microsoft Excel Advanced: the Data Analysis Tools You Need at UDEMY Entry Requirements
- Prerequisites : Working knowledge and understanding of the subjects covered in the Introduction and Intermediate courses
- Not mentioned
Other courses offered by UDEMY
Microsoft Excel Advanced: the Data Analysis Tools You Need at UDEMY Students Ratings & Reviews
2 Ratings- 4-52
Student Forum
Anything you would want to ask experts?