Microsoft Excel Advanced: High Level Data Analysis Tools

Microsoft Excel Advanced: High Level Data Analysis Tools udemy course

NOW INCLUDES OUR PROFESSIONAL EXCEL COURSE: includes What-If, Pivot, HLOOKUPs, VLOOKUPs & Intros to Macros, VBA & UDFs

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.  And we show you how yo use What-If Scenarios, Pivot Tables, HLOOKUPs, VLOOKUPs at introductory and advanced levels.  There are even introductions to Macros, basic VBA & UDFs.

We have now included our Professional level Excel course to add even more value (the price is the same!)

With every ZandaX Microsoft course, you get a workbook and exercises (downloadable from the “Introduction” module at the start of each course). There are two types of exercises: first of all, exercises to match the lessons (called Lesson 1.1, Lesson 1.2, etc) where you can "follow along" with the instructor or the workbook, and also Skill Sharpeners, where you are given exercises that will reinforce your learning. These all correspond exactly to the manual.  So remember to download them, and the manual, from the "Introduction" module at the start of the course. People tell us that the Skill Sharpeners are a real bonus!

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 waffle! 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!

The Professional level course takes you higher, with advanced treatment of Conditional Formatting, LOOKUPs, Pivot Tables, as well as how to use advanced functions like Error Function, Logical Functions and Array Formulas.  Finally, we introduce you to the basics of VBA and User Defined Functions (UDFs) to give you a good working knowledge without getting too complex.

You will now be able to produce spreadsheets that not only display your data, but analyze 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 “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 set of talk-through videos. We don’t think you’ll find better value...