Microsoft Excel Professional: Become an Excel Power User (Udemy.com)

From Advanced Conditional Formatting, through Array Formulas and Advanced Pivot Table Tools, to Basic UDFs and VBA

( 0 Reviews )

Created by: ZandaX Training

Produced in 2019

What you will 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 General Introduction module so you are able to 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 the Index Function - Using the Match Function - Using Index and Match Together - Using Index and Match with Array Formula - Using the Indirect Function
Advanced Functions in Excel - Using Error Functions - Using Logical Functions - Using Array Formulas

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 0 / 100

Course 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 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 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 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 solid understanding of, and experience with, Microsoft Excel, and want to become a real power userOr you may already have many of the skills, but want a "refresher" to tidy up and complete your understanding of themIMPORTANT NOTE: This is not a technical course, so if you are looking for high level programming content, this isn't for you

Time: 2.5h

Instructor Details

ZandaX Training

0.0 Rating
0 Reviews

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