Udemy

Master Microsoft Excel - Excel from Beginner to Advanced

Enroll Now
  • 3,823 Students
  • Updated 4/2021
4.4
(922 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
15 Hour(s) 39 Minute(s)
Language
English
Taught by
Kirt Kershaw
Rating
4.4
(922 Ratings)

Course Overview

Master Microsoft Excel - Excel from Beginner to Advanced

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

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. MAC users, since the videos are recorded with the Windows version of Microsoft Excel, the interface will be a bit different.

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...

Course Content

  • 10 section(s)
  • 158 lecture(s)
  • Section 1 Excel Introduction - First Look
  • Section 2 Excel Level 1 - Beginner
  • Section 3 Basics
  • Section 4 Functions & Formulas
  • Section 5 Editing Worksheets
  • Section 6 Formatting
  • Section 7 Print
  • Section 8 Modifying Worksheet Appearance
  • Section 9 Excel Level 2 - Intermediate
  • Section 10 Advanced Formulas & Functions

What You’ll 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!


Reviews

  • R
    Rajat kumar
    4.0

    very good

  • F
    Felix Halm
    5.0

    Great Course!

  • R
    Rinchen Doma Bhutia
    3.0

    This course is good for beginners with no prior excel knowledge. If you wanna become a master, one course alone wont suffice.

  • A
    Ana Denisse Medina Ramírez
    5.0

    Explains complicated things in a simple way, makes it look easy! Kirt makes this course fun and entertaining, I was very comfortable with his way of teaching.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed