Microsoft Excel Professional: Become an Excel Power User

Rating 3.95 out of 5 (15 ratings in Udemy)

What you'll learn

Our EXCEL PROFESSIONAL course provides you with a formidable array of skills that will enable you to use Excel at an exceptionally high level
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 take what you know in Conditional Formatting, LOOKUPs, PivotTables to a whole new level, and be introduced to User Defined …

Rating 3.95 out of 5 (15 ratings in Udemy)

What you'll learn

Our EXCEL PROFESSIONAL course provides you with a formidable array of skills that will enable you to use Excel at an exceptionally high level
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 take what you know in Conditional Formatting, LOOKUPs, PivotTables to a whole new level, and be introduced to User Defined Functions (UDFs) using VBA
Advanced Conditional Formatting - Editing Standard Formatting Rules - Using Formulas in Conditional Formatting
Using Form Controls and Templates - Using Form Controls - Creating Templates
Advanced LOOKUP Functions - Using Index & Match Functions - Using Index & Match Together - Using Index & Match with Array Formula - Using the Indirect Functions
Advanced Functions in Excel - Using Error Functions - Using Logical Functions - Using Array Formulas - Using Rounding Functions
Advanced Pivot Table Tools - Importing Pivot Table Data - Calculated Fields in Pivot Tables - Showing Pivot Data as a Percentage - Creating Custom Styles
Introduction to User Defined Functions Using VBA - Creating a User Defined Function - Creating an Interactive Procedure - Create and Share a Function Add-in

Description

Are you ready to take your work from good to downright impressive?

This course will enable you to get more out of Excel than most people will think possible! (Though it's not a course for geeks or programmers.)

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 begin with Advanced Conditional Formatting, Form Controls and Templates, then learn about Advanced LOOKUP Functions. You move on to Advanced Functions, Array Formulas and Advanced Pivot Table Tools before being introduced to User Defined Functions (UDFs) and VBA.

When you have mastered all this and put it into action, you will be able to call yourself a true Excel Power User!

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?

Duration 2 Hours 58 Minutes

Paid

Self paced

Expert Level

English (US)

3384

Rating 3.95 out of 5 (15 ratings in Udemy)

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.