Blog
Library

Master Microsoft Excel - Excel from Beginner to Advanced

Features Includes:
  • Self-paced with Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App

Course Preview Video

  • Categories

    Productive Expertise & Efficiency

  • Duration

    15:28:32

  • 1338 Students Enrolled

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

As your instructor I will use my 18+ 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. 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, INDEX and much more

Basic knowledge
  • This course was created with Excel 2016. However, Excel 2007, 2010, 2013, 2016, 2019 and 365 will work with most, or all features
  • You will need Microsoft Excel installed on your computer to follow along and complete the exercise files

What will you learn
  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding on the Basics of Microsoft Excel
  • Writing Formulas and performing Calculations
  • Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more
  • 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
  • Taught by Certified Microsoft Office Excel 2016 Specialist and Expert with over 18 years of Excel training
Course Curriculum
Number of Lectures: 157 Total Duration: 15:28:32
Reviews
Deena Timko – June 24, 2020

This is a great training, I really learned a lot of new techniques I would like to start implementing. If I had to add anything, it would be to be able to practice what I learn as I learn it. Like see it, now do it. I do have the notes provided and will try to use those to practice, hopefully exercises are provided as well. The instructor is clear and easy to follow! I highly recommend taking this course!

SARATHKUMAR K – May 21, 2020

useful. good teaching

Wayne Harding – May 16, 2020

Excellent pace, short segments, with a little humor to make it go faster.

Mary Saul – April 30, 2020

Good amount of detail while keeping the training moving forward. Easy to understand and follow.

Laura Lowell – April 23, 2020

Very informative and I learned many things I was able to use right away. At times I felt the information went by too fast but I could have just been listening for too long....Thank you very much!

Ross Spens – April 18, 2020

Gary Freiberger – April 15, 2020

So Far, very impressed. Clear voice & clear explainations of functions. I actually learned a few kool tips so for Look forward to getting my hands dirty tomorrow:)

Paige Chmiel – April 02, 2020

Marline Reid – March 19, 2020

Velvet Morris – March 10, 2020

Very informational and easy to learn

Mitchell Rogalski – March 02, 2020

Giacomo Cavina – February 26, 2020

Interesting Excel course, expecially for beginner users. You can learn also many short-cuts and advanced skills

Idoko Job John – February 07, 2020

Ronald Church – December 17, 2019

This course if very helpful. It's explained so I can understant it.

Sofi Ibrahim – August 27, 2019

Excellent course! Wish the Author could develop another course for VBA!

Alaa Alhashemi – December 31, 2018