Microsoft Excel Advanced: the Data Analysis Tools You Need

Microsoft Excel Advanced: the Data Analysis Tools You Need, available at $49.99, has an average rating of 4.45, with 47 lectures, based on 554 reviews, and has 7424 subscribers.

You will learn about Our EXCEL ADVANCED course will give you a solid understanding of the advanced data analysis tools and concepts in Excel The course has its own workbook with exercises – downloadable within the first “Introduction” module – so you can practice and reinforce what you have learned You'll acquire a highly impressive array of data analysis skills, including What-If Scenarios, PivotTables, PivotCharts, HLOOKUPs, VLOOKUPs and basic Macros What-If Analysis – Exploring Scenarios – Goal Seek and Data Tables – Using Solver 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 HLOOKUP and VLOOKUP Functions – Using the VLOOKUP Function – Using the LOOKUP Function Introduction to Macros in Excel – Recording and Playing Macros – Copying and Deleting Macros – Visual Basic and Macros This course is ideal for individuals who are You may have a good understanding of Microsoft Excel and want to improve your skills in analyzing and interpreting your data or Or you could be an existing user who wants a "refresher" to clarify a few hazy areas, or even unlearn some bad habits! or Above all, we want you to get the most from your training, so make sure you enjoy your time doing the course, and revisit it as often as you want It is particularly useful for You may have a good understanding of Microsoft Excel and want to improve your skills in analyzing and interpreting your data or Or you could be an existing user who wants a "refresher" to clarify a few hazy areas, or even unlearn some bad habits! or Above all, we want you to get the most from your training, so make sure you enjoy your time doing the course, and revisit it as often as you want.

Enroll now: Microsoft Excel Advanced: the Data Analysis Tools You Need

Summary

Title: Microsoft Excel Advanced: the Data Analysis Tools You Need

Price: $49.99

Average Rating: 4.45

Number of Lectures: 47

Number of Published Lectures: 47

Number of Curriculum Items: 47

Number of Published Curriculum Objects: 47

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

• Our EXCEL ADVANCED course will give you a solid understanding of the advanced data analysis tools and concepts in Excel
• The course has its own workbook with exercises – downloadable within the first “Introduction” module – so you can practice and reinforce what you have learned
• You'll acquire a highly impressive array of data analysis skills, including What-If Scenarios, PivotTables, PivotCharts, HLOOKUPs, VLOOKUPs and basic Macros
• What-If Analysis – Exploring Scenarios – Goal Seek and Data Tables – Using Solver
• 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
• HLOOKUP and VLOOKUP Functions – Using the VLOOKUP Function – Using the LOOKUP Function
• Introduction to Macros in Excel – Recording and Playing Macros – Copying and Deleting Macros – Visual Basic and Macros

Who Should Attend

• You may have a good understanding of Microsoft Excel and want to improve your skills in analyzing and interpreting your data
• Or you could be an existing user who wants a "refresher" to clarify a few hazy areas, or even unlearn some bad habits!
• Above all, we want you to get the most from your training, so make sure you enjoy your time doing the course, and revisit it as often as you want

Target Audiences

• You may have a good understanding of Microsoft Excel and want to improve your skills in analyzing and interpreting your data
• Or you could be an existing user who wants a "refresher" to clarify a few hazy areas, or even unlearn some bad habits!
• Above all, we want you to get the most from your training, so make sure you enjoy your time doing the course, and revisit it as often as you want