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 Youll 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

Youll 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

Are you looking to use Excel to analyze your data?

With this course you’ll enter the world of analyzing your data, using your spreadsheets to interpret, illuminate and present your data in a whole new way.

With every ZandaX Microsoft course, you get a workbook and exercises (downloadable from the short “General Introduction” module at the start of each course). These are a great addition because they enable you to practice the skills you learn.

Our Microsoft instructors are seasoned professionals – they don’t just know the software: they’ve used it commercially and taught it in a classroom environment for years. You won’t be in better hands!

And we don’t woffle!Do you want to sit through hours of over-explaining before you get the knowledge you need? We doubt it! So we make sure that everything is covered in easy-to-follow video lessons, and we get to the point so you make the best use of your time.

You learn about Grouping, Outlining and Subtotals, and how to use What-If Analysis, Pivot Tables and Pivot Charts.  Then we introduce you to HLOOKUPS and VLOOKUPS, and finish with an introduction to Macros which will make your spreadsheets FLY!

You will now be able to produce spreadsheets that not only display your data, but analyse and play tricks with it too

Each lecture is self-contained, so you don’t need to sit through them all: once you’re at a comfortable level, you’ll be able to use this as your reference library, where you can select what you want to view.

We’ll say it again: don’t forget the course workbooks and exercises – downloadable with the first “General Introduction” module in each course – which really enhance and deepen your learning. Remember that practice makes perfect!

So this course is genuinely much more than just a talk-through video. We don’t think you’ll find better value, so why not enrol with us now?

Course Curriculum

Chapter 1: Course Introduction

Lecture 1: Introduction and Overview

Chapter 2: Grouping & Outlining and Subtotals

Lecture 1: Introduction

Lecture 2: Outlining and Grouping Data – Overview

Lecture 3: Outlining and Grouping Data

Lecture 4: Using the Subtotals Tool – Overview

Lecture 5: Using the Subtotals Tool

Chapter 3: What-If Analysis

Lecture 1: Introduction

Lecture 2: Exploring Scenarios – Overview

Lecture 3: Exploring Scenarios

Lecture 4: Goal Seek and Data Tables – Overview

Lecture 5: Goal Seek

Lecture 6: Data Tables

Lecture 7: Using Solver – Overview

Lecture 8: Using Solver

Chapter 4: PivotTables

Lecture 1: Introduction

Lecture 2: Getting Started with PivotTables – Overview

Lecture 3: Getting Started with PivotTables

Lecture 4: Displaying Data in a PivotTable – Overview

Lecture 5: Displaying Data in a PivotTable

Lecture 6: Formatting a PivotTable – Overview

Lecture 7: Formatting a PivotTable

Lecture 8: Slicers – Overview

Lecture 9: Slicers

Chapter 5: Charting Pivoted Data

Lecture 1: Introduction

Lecture 2: Getting Started with PivotCharts – Overview

Lecture 3: Getting Started with PivotCharts

Lecture 4: PivotChart Tools and Formatting – Overview

Lecture 5: PivotChart Tools and Formatting

Chapter 6: Advanced Excel Tasks

Lecture 1: Introduction

Lecture 2: Excel and Hyperlinks – Overview

Lecture 3: Excel and Hyperlinks

Lecture 4: Using Custom AutoFill Lists – Overview

Lecture 5: Using Custom AutoFill Lists

Lecture 6: Sharing Workbooks – Overview

Lecture 7: Sharing Workbooks

Lecture 8: Tracking Changes

Chapter 7: Creating HLOOKUP and VLOOKUP Functions

Lecture 1: Introduction

Lecture 2: Using the VLOOKUP Function – Overview

Lecture 3: Using the VLOOKUP Function

Lecture 4: Using the LOOKUP Function – Overview

Lecture 5: Using the LOOKUP Function

Chapter 8: Introduction to Macros in Excel

Lecture 1: Introduction

Lecture 2: Recording and Playing Macros – Overview

Lecture 3: Recording and Playing Macros

Lecture 4: The VBA Editor – Overview

Lecture 5: The VBA Editor

Lecture 6: Visual Basic and Macros

Instructors

ZandaX Training
80,000 students cant be wrong!

Rating Distribution

1 stars: 4 votes

2 stars: 14 votes

3 stars: 90 votes

4 stars: 211 votes

5 stars: 235 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!