IntroMediate Excel Techniques

Go back to Courses

IntroMediate Excel Techniques

On-Demand

Author: Ken Puls

Average Rating: (0) Reviews

This “intro-mediate” Excel course is designed to quickly review the basics, giving you a solid review of techniques that you should know to be efficient, but may have missed in your own education.

Course

IntroMediate Excel Techniques

$249 Renews at $29 per year
(All prices in USD)

Buy now

This Course contains:

4 hours of training content

8 Content Modules

Downloadable files and Handouts

Certificate of completion

Check our Group Discounts here!

DURATION:

4 hours

TOOLS:

Excel

SKILLS:

Excel Formulas

Data Modeling

What you'll learn?

Excel Essentials

Formula And Function Review

Structuring Data in Excel with Tables

VLOOKUP Deep Dive

Conditional Formatting

Introduction to PivotTables

Course Overview

Course Description

Excel is by far one of the most prolific and most versatile programs installed on desktops today. It’s everywhere, and touches most business positions in some way. Yet the reality is that by far the vast majority of Excel users are self-taught. We struggle through the program, learning what we need in order to accomplish our tasks and then… stop learning? The truth is that once we’ve worked out a method to finish our work, we usually call it a day.

Did you know that there are almost always three ways to do everything in Excel? Are you using the most efficient method possible to get things done? This “intro-mediate” Excel course is designed to quickly review the basics, giving you a solid review of techniques that you should know to be efficient, but may have missed in your own education. Once the basics are covered, we’ll also jump into more advanced tools and techniques that you’ll be able to take back to your daily work.

A Note on Access

Your registration in the seminar comes with a free 3-month trial subscription to this video course. After the free trial period, you can choose to continue your access for $29 USD/year.

Who this course is for?

This course is intended for people who are self-taught and feel comfortable in Excel.
Attendees should be comfortable with basic formula usage.

Course Formats

On-Demand

This is an on-demand course, delivered via pre-recorded video modules that you can consume at your own pace. It includes all required sample files, practice sets, and Q&A tests to validate your knowledge.

Course Content

Platform Introduction

2 Lessons

Course Examples

Who’s Ken

Excel Essentials

4 Lessons

Basic Navigation

Navigational Keyboard Shortcuts

Entering and Clearing Data

Useful Keyboard Shortcuts

Formula & Function Review

7 Lessons

Introduction to Formulas

Unlocking Excel’s Formula Power

Anatomy of a Function

Mathematical and Statistical Functions

Logical Functions

Text Parsing Functions

Working with Dates

Structuring Data in Excel

3 Lessons

Structuring Data in Excel

Excel Tables

Benefits of Excel Tables

VLOOKUP Deep Dive

7 Lessons

What is VLOOKUP

VLOOKUP Approximate Match

VLOOKUP Exact Match

Understanding VLOOKUP Matches

Common VLOOKUP Issues

Text vs Number Conversions

Guarding Against NA Results

Conditional Formatting

1 Lesson

Conditional Formatting

Introduction to PivotTables

5 Lessons

Introduction to PivotTables

Creating PivotTables

Understanding PivotTable Mechanics

Formatting PivotTables

PivotTable Design Options

Help Resources

5 Lessons

Free Help Forums

M is for (Data) Monkey

Power Query Academy

Free Newsletters

User Groups

How subscription works?

This course is built on an annual subscription format. Your registration comes with 12 months of access to the course materials, so you can refer back to the videos and example files whenever you like. Your subscription also gives you access to our private Discussion Forum, where you can ask questions related to the course materials, as well as how to apply those teachings to your own work. This forum is an invaluable resource that also allows students to practice their own learnings by helping others with those questions.

On your annual renewal date, your subscription will be automatically renewed with the credit card information on file, unless you cancel your subscription beforehand. You will be emailed a renewal reminder about one month before the renewal date. Please see the FAQs below for information about subscription renewals and cancellations.

About the author

Ken Puls

Microsoft MVP, FCPA, FCMA

Ken Puls is one of the founding partners of Skillwave.Training, and the President and Chief Training Officer of Excelguru Consulting Inc. in Canada. He is a Chartered Professional Accountant, blogger, author, and trainer with over 20 years of business and IT experience. His passion lies in exploring tools to turn data into information, and teaching others how to use them. Ken is a Microsoft MVP and a leading expert in Excel, Power Query, and Power BI.

FAQ

How do I access the course materials? Are they downloadable?

The videos are streamed on-demand and may be watched as often as you like. However, they are not downloadable. The example files and handouts for each lesson are downloadable.

Where are the course videos hosted?

All the videos for the course are hosted on Vimeo. Please note that some networks block access to Vimeo, in which case the videos will not be watchable. You may want to double-check that your network allows access to Vimeo before registering in the Academy, to ensure that you will be able to see the videos.

How do I receive my Certificate of Completion?

After all the modules and lessons have been completed, you will be able to download the Certificate of Completion from the My Courses area of your Account Dashboard.

Reviews

IntroMediate Excel Techniques

(0 Review)

Reviews

There are no reviews yet.

Only verified customers who have purchased this product may leave a review.

Recommended Courses

Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.