Master Microsoft Excel - Excel from Beginner to Advanced (Udemy.com)

Become an Excel Expert in this Microsoft Excel A-Z Course (Microsoft Excel 2010, 2013, 2016, 2019 and 365).

( 97 Reviews )

Created by: Kirt Kershaw

Produced in 2021

What you will learn

Build a solid understanding on the Basics of Microsoft Excel
Master Microsoft Excel from Beginner to Advanced
Writing Formulas and performing Calculations
Create charts with Trend Lines, and Dual Axis
Use Excel as a Database with Sort and Filter options
How to avoid the most common Database Design flaws
Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more...
Taught by Certified Microsoft Office Excel 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist and Expert with over 17 years of Excel training!

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 92 / 100

Course Description

Microsoft Excel All-In-One Training
This Microsoft Excel course includes all three Levels from Beginner to Advanced

Microsoft Excel Level 1 Beginner
Microsoft Excel Level 2 Intermediate
Microsoft Excel Level 3 Advanced

Material recorded with Excel 2016 but works in 2010, 2013, 2016, 2019 and 365.

As your instructor I will use my 17+ years of Excel training and certifications including: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016, Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP) to guide you step by step through Beginner, Intermediate and Advanced Levels of Excel.
At completion of this course you will master Excel skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks, as well have all the training you need to help pass both Microsoft's Excel Core and Excel Expert Exams and become certified, like me. Below are just a few of the topics that you will master:

Creating effective worksheets
Writing and editing formulas and calculations
Use sorting and filtering options
Build a database right the first time and avoid common design flaws
Creating informative and captivating Charts
Eliminate repetitive tasks instantly using Macros
Create many scenarios with varying groups of data
Manage large ranges of data in a List or Table
Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH and much more...

Who this course is for:

This Microsoft Excel course contains all three levels of learning for the: Beginner, Intermediate and Advanced users
Includes all the training you need to help you pass both the Excel 2016 Core (77-727) and Excel Expert (77-728) Exams and become certified!

Time: 15.5h

Instructor Details

Kirt Kershaw

4.6 Rating
97 Reviews

Kirt Kershaw is President of Dream Force LLC and provides certified and professional training videos on Microsoft Office applications including: Access, Excel, Outlook, PowerPoint, Word, Project and Windows since 2000. His certifications include: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016. Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP), Certified Microsoft Project XP (2002), 2010 and 2013 and CompTIA's A+.
Whew! With all my certifications and experience you're probably looking at the biography of the only Microsoft trainer on the web who has the most Microsoft teaching experience and holds the most Microsoft certifications. So, I do have a lot to share in my arsenal of Microsoft Office training.
What Makes My Training Unique?

If you've read my reviews, seen my certifications (above) and my training videos, you probably already know the answer to this; I focus on step-by-step basics to more advanced training including: unique tips, tricks, shortcuts and other Microsoft Office time saving features you won't find taught in ANY other course, by the ONLY multi-certified Microsoft Office trainer since Microsoft Office 2000; including all the training you need to help pass Microsoft Access, Excel, Outlook, Project, PowerPoint and Word Exams and become ce

Excel Basics (2017)

4.9 (15 Reviews)

Provider: YouTube
Time: 12h

Free

Microsoft Excel - Online Tutorial for Beginners (2010)

0.0 (0 Reviews)

Provider: Chandoo.org
Time: 1h 30m

Free

Excel Power Pivot and Power Query For Dummies

Excel Power Pivot and Power Query For Dummies (2016)

0.0 (0 Reviews)

Provider: Amazon

$14.53

More Courses

More courses by Kirt Kershaw

Master Microsoft Access - Access from Beginner to Advanced

Master Microsoft Access - Access from Beginner to Advanced (2021)
4.6 (169 Reviews)

- Provider: Udemy
- Time: 17h

$11.99

Master Microsoft Outlook - Outlook from Beginner to Advanced

Master Microsoft Outlook - Outlook from Beginner to Advanced (2021)
4.4 (147 Reviews)

- Provider: Udemy
- Time: 14.5h

$11.99

All courses by Kirt Kershaw

Reviews

4.6

97 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Jose Ramirez

Great course for someone who wants to learn Excel 2016. The last excel I worked with was the 2003 version and the changes are really mind boggling. However, the creator of this class explains the basics and shows you how to do it without getting bogged down by minutiea.

By Kari Kershaw

Clear and to the point, no wasting time with extra helpful information.

By Michael Diamond

I find Kirt quite knowledgeable. I've taken a number of courses from other instructors but I find Kirt brings a feeling of fun and excitement to Excel. I've had several Mr Spock moments in both this course and his Access course. I highly recommend this course who is really serious about becoming an Excel power user.
Michael

By Susie Greenspoon

I need to get reacquainted with Excel and these courses are just the way to do the job.

By John Zschoche

I have tried four or five different online courses for beginners in Excel You are the only one that doesn't assume That the people already know something about EXCEL

By Mackenzie Gray

This course helped me understand a vast amount of features that I didn't even know existed on Excel. It has also helped me get through using excel programming in college. I feel better prepared and increasingly confident to say I have special skills in understand the Excel technology.

By Mark Page

The course was well thought out and presented in an engaging manner. Kirt was both funny and informative. I would highly recommend this course to a beginning Excel user.

By Felipe Gama