Udemy

Advanced Microsoft Excel - Take your skills to a new level!

Enroll Now
  • 220 Students
  • Updated 6/2020
  • Certificate Available
4.8
(56 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
3 Hour(s) 14 Minute(s)
Language
English
Taught by
Corey @ Wisdify
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.8
(56 Ratings)

Course Overview

Advanced Microsoft Excel - Take your skills to a new level!

In this fun and engaging course, you'll learn Excel's most powerful functions, automate work with macros, and more!

Take your Excel skills to a whole new level! Our Advanced Excel course will give you the Excel skills to become an Excel master. You'll learn Excel's most powerful functions including INDEX/MATCH, learn advanced PivotTable tools, automate your work using VBA Macros, and more!


WHAT MAKES OUR EXCEL COURSE UNIQUE?

  • Earn points as you complete the course and unlock your spirit animal

  • Engaging instructor that won't put you to sleep

  • G-rated humor and lighthearted lessons

  • ZERO FLUFF!

  • Real world application that you can start applying today


WHAT YOU'LL BE LEARNING

This course will help you take your Excel skills to an advanced level. This course is beneficial to ANYONE who uses Excel. Here's what you'll master in the next 4 hours:

  • Powerful formulas such as INDEX/MATCH, MIN/MAX, and more

  • Advanced PivotTable functions to better analyze your data

  • Utilize named ranges to efficiently work with advanced formulas

  • Protecting your data using Data Validation and other techniques

  • Enhancing IF statements by incorporating AND/OR formulas

  • Keyboard shortcuts beyond the simple Ctrl+S or Ctrl+C


By the end of this course, you'll be a total boss at Excel! Then you can take those skills to a whole new level by taking our Microsoft Excel VBA (Macros) course which builds off of the Macros portion of this course.

__________

NOTE: If you would like to receive CPE credit for this course, you must complete the final exam on our website. All lectures are compatible with Excel 2010, Excel 2013 or Excel 2016.

Course Content

  • 8 section(s)
  • 40 lecture(s)
  • Section 1 Introduction
  • Section 2 Formatting & Keyboard Shortcuts
  • Section 3 Working with Ranges
  • Section 4 INDEX/MATCH
  • Section 5 Other Advanced Formulas
  • Section 6 Advanced PivotTables & PivotCharts
  • Section 7 Intro to Macros & Protecting your Data
  • Section 8 Conclusion

What You’ll Learn

  • Learn Excel in a fun, interactive, and entertaining manner (no sleeping in this course)
  • Master Excel's most powerful formulas like INDEX/MATCH
  • Automate redundant tasks through Macros and VBA
  • Save time by utilizing Named Ranges
  • Take your PivotTable skills to a whole new level by learning advanced features
  • Master keyboard shortcuts and become the Usain Bolt of Excel


Reviews

  • P
    Paras Verma
    4.5

    AMZING EXPLANATION WITH GOOD EXAMPLES ESPECIALLY THAT PRATICE WORKBOOK THANK YOU SO MUCH

  • D
    Dave Decker
    5.0

    good refresher

  • V
    Vaishnavi Parkar
    5.0

    The videos' are simple to understand as the concepts are clearly explained.

  • D
    Denis Mwiti Mbaka
    5.0

    Very organized and informative

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