In a (good) live class, teachers talk about why you would want to do something, real-world applications, and hidden power-tips. Good teachers also review to tell you what the important points to remember are. So why are these things almost always missing in video learning? We don't just show. We teach!
Our videos are designed for you to follow along in real life.
When you take a class, the teacher explains concepts, shows you how, reviews the important points, and asks you to try it yourself, right? That's how our videos work. They even pause themselves while you give your new skills a whirl.
We teach more than just button pushing; Also learn skills, theories, and ideas!
Have you ever watched a video tutorial online? They just showed you something and left you to figure out the practical application, right? Not us! We want you to really learn.
Practice assignments to help with retention
When you learn something new, you have to practice, right? Sometimes new students are at a loss for what they should do to build retention. That's why we have practice assignments, to advise you what to try by yourself. It's like homework that you'll like! Plus, you don't have to turn it in.
In this course, students will learn how to use advanced functions together such as INDEX and MATCH, as well as the OFFSET function. We cover the concept of using Array Formulas and Functions and discuss the pros and cons of using such functions. Youâll learn how to build your own dynamic ranges, as opposed to relying on the simple, out of the box Table formatting. Youâll learn how to build a Waterfall Chart, which is not a chart native to Excel. You will wrap up learning about advanced Pivot Table features and see an introduction to VBA programming to augment your macros.
This course is designed for the advanced Excel user who is looking for more than the run of the mill functions and features available in Excel.
- Excel Power User Intro
- Module 1 Intro
- Data Mining Techniques
- VLOOKUP Function
- Index and Match Function
- Using Arrays in Formulas
- Advanced Conditional Formatting
- Dynamic Ranges
- Module 2 Intro
- Dynamic Chart Sources
- Spin Controls
- PivotTable Calculations
- PivotTable Templates
- Import from Web
- Enhance Macros with VBA
Got questions? Contact us below or call 877-881-2235
Why Choose 360training.com?
- Fast and easy courses completion
- Get an education faster than at traditional colleges!
- 100% online - No classroom attendance required.
- Unlimited 24x7 online customer support
- Over 500,000+ certified nationwide.