Microsoft Excel Advanced: the Data Analysis Tools You Need (Udemy.com)

Advanced Excel skills for data analysis including What-If Scenarios, PivotTables, HLOOKUPs, VLOOKUPs and basic Macros

Created by: ZandaX Training

Produced in 2019

icon
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 General Introduction module so you are able to 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 Hyperl

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100

icon
Course Description

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 dont 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 dont need to sit through them all: once youre at a comfortable level, youll be able to use this as your reference library, where you can select what you want to view.
Well say it again: dont 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 dont think youll find better value, so why not enrol with us now?
Who this course is for:
You may have a good understanding of Microsoft Excel and want to improve your skills in analyzing and interpreting your dataOr 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

icon
Instructor Details

ZandaX Training

I'm Steve Warren, and I head up the team at ZandaX, where we provide English language online courses for personal development and Microsoft software. But it's my team here that make things work as well as they do. We share a passion for getting results, and our reason for working is simple: to help people to improve their skills - and their lives too ...
The development team here have many years of training industry experience, both in classroom and virtual environments, so they know what you need in a course to be able to get the most from it.
Our Microsoft instructors don't just know the software: they've used it commercially and taught it in a classroom environment. You won't be in better hands.
Our business and soft skills presenters have been chosen for their clarity and professionalism in getting the message across. You'll be engaged as well as educated.
Our ethos is to provide courses that are comprehensive but compact, where you can get all you need in a manageable time. We feel that too many online courses today aren't focused. They often say so much that it's hard to find the important stuff. Who wants to sit through 20 hours of chat that takes forever to get to the point, when what you need can be covered in a targeted, structured course?
Remember Mark Twain, who said "I didn't have time to write a short letter, so I wrote a long one

icon
More courses by ZandaX Training

Microsoft Word Advanced

$11.99

Microsoft Access Advanced

$11.99

icon
More data analysis courses

Microsoft Power BI - Up & Running With Power BI Desktop

$11.99

Python Data Analysis & Visualization Bootcamp

$11.99

Complete Introduction to Microsoft Power BI [2021 Edition]

$11.99

Data Analysis with Pandas and Python

$11.99

Python for Time Series Data Analysis

$11.99

[Intermediate] Spatial Data Analysis with R, QGIS & More

$11.99

icon
Reviews

4.2

20 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Yassine Kechida on 12/6/2020

Very clear and useful. Just wish we had the same excel file for hands on experience

By Susheela on 11/21/2020

good

By Aaron Hebert on 11/6/2020

A quick and easy course to go through if you're learning the basics of DA with Excel or just need a quick refresher!! Thanks!!!

By Thembinkosi Khumalo on 7/27/2020

I am enjoying the cause and looking forward to studying more courses through Udemy

By Christian Chung on 7/20/2020

It is divided greatly into bite sized sections, but it would also be helpful to have a sample data base to follow along and practice for concrete reinforcement.

By Doree Trapp on 6/9/2020

Yes it was a good match. A lot of things that I will need to reference back on when I start using more of the Excel Functions.

By Kevin Caron on 5/18/2020

Too elementary, I don't consider myself an Excel expert and yet I already knew 95% of what has been taught so far. Also, I don't find the ''overview'' videos very useful. Otherwise, the explanations were very clear!

By Ronald Parqui I. on 2/24/2020

Great, met my expectations

By Michelle Van Rooyen on 2/21/2020

There are no opportunities to practice or take quizes throughout the course. More application and practice is required to retain information. The guy speaking has this really annoying sucking sound whenever he starts a new sentence, otherwise the course is good for what you are paying.

By Bryan Deprat Urea on 2/15/2020

Good course, I'm learning useful things I didn't know.

By Deoran Wessels on 2/12/2020

Very good. The result vector for the lookup funtion wasnt absolutely referenced so if a list is autofilled on the sheet, the result vector will shift. :)

By Lloyd Mandidewa on 2/7/2020

Very relevant. Great work