Microsoft Excel 103 - Advanced Excel

Become the Ultimate Excel Guru by Mastering Advanced Excel Functions, Macros, Protecting Worksheets and More
5.0 (34 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
122 students enrolled
62% off
Take This Course
  • Lectures 33
  • Length 3 hours
  • Skill Level All Levels
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2016 English Closed captions available

Course Description

Unleash Your Microsoft Excel Skills to an Advanced Level

Course Material Works in Excel 2007, 2010, 2013 and 2016

Using my 10+ years of Microsoft Excel training I will guide you through some of the most advanced tools Excel has to offer, including;

  • Create dynamic formulas using Excel's IF(), SUMIF() and IFERROR() functions
  • Make searching for information in large Excel data sets a breeze by using Excel's powerful VLOOKUP() and HLOOKUP() functions
  • Learn to manipulate text values by using Excel's LEFT(), RIGHT(), and CONCANTENATE() functions
  • Master Excel's formula auditing tools to trace errors in your worksheets formulas
  • Learn how to protect specific cells in a worksheet locking important information
  • Put Excel on autopilot by learning how to automate your day to day task by using Macros

By engaging and completing this advanced Microsoft Excel course you will master tools that will blow the socks off of your boss and coworkers. You will learn how using these tolls will ultimately streamline you Excel experience boosting your productivity to the highest level.

Each section within this course also includes exercise files for you to download and practice with. These are the same files that are used in the video lectures.

So, what are you waiting for, enroll now and take the next step in mastering Excel and become an Advanced Excel Guru!

What are the requirements?

  • You will need Excel loaded on your computer in order to follow along and complete the exercise files provided in each section.
  • Videos have been recorded using Excel 2013, but Excel 2007, 2010 , 2013 or 2016 will work in order to follow along.

What am I going to get from this course?

  • Create Dynamic Excel Calculations with Excel's Logic Based Functions
  • Streamline the Process of Looking for Information in Large List by Mastering Excel's Lookup Functions
  • Ease Your Pains of Working with Text Values by Using Excel's Text Based Functions
  • Audit an Excel Worksheet by Taking Advantage of Excel's Formula Auditing Tools
  • Understand How Excel's "What If" Tools Can Assist You in Creating Projections and Data Tables
  • Streamline your Excel workflow by automating tasks with Excel Macros

Who is the target audience?

  • The Microsoft Excel course was designed for those that are looking to advance their Excel skills to an advanced level taking advantage of several of the more advanced Microsoft Excel features.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Microsoft Excel 103 Course Introduction
Introduction to Topics in this Course
Course Exercise Files - Download this Excel File First!
Section 2: Working with Excel's Conditional Functions
Working with Excel Name Ranges
Using Excel's IF() Function
Nesting Functions
Using Excel's COUNTIF() Function
Using Excel's SUMIF() Function
Using Excel's IFERROR() Function
Section 3: Working with Excel's Lookup Functions
Using Excel's VLOOKUP() Function
Using Excel's HLOOKUP() Function
Using Excel's INDEX() and MATCH() Functions
Section 4: Working with Excel's Text Based Functions
Using Excel's LEFT(), RIGHT() and MID() Functions
Using Excel's LEN() Function
Using Excel's SEARCH() Function
Using Excel's CONCATENATE() Function
Section 5: Auditing an Excel Worksheet
Tracing Precendents in Excel Formulas
Tracing Dependents in Excel Formulas
Working with the Watch Window
Showing Formulas
Section 6: Protecting Excel Worksheets and Workbooks
Protecting Specific Cells in a Worksheet
Protecting the Structure of a Workbook
Adding a Workbook Password
Section 7: Mastering Excel's "What If" Tools
Working with Excel's Goal Seek Tool
Working with Excel's Solver Tool
Building Effective Data Tables in Excel
Creating Scenarios in Excel
Section 8: Automating Repetitive Tasks in Excel with Macros
Understanding Excel Macros
Activating the Developer Tab in Excel
Creating a Macro with the Macro Recorder
Editing a Macro with VBA
Creating Buttons to Run Macros
Section 9: Congratulations!
Congratulations on Completing the Microsoft Excel 103 - Advanced Coruse
BONUS - Special Offer! Discount on any of my courses!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kyle Pew, Microsoft Certified Trainer - 35,000+ Udemy Students


Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including;

  1. Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013
    1. Excel, Word, PowerPoint, Outlook, Access and Visio
  2. SharePoint End-User 2007, 2010, 2013
  3. VBA (Excel and Access)
  4. Adobe Suite
    1. Photoshop, Illustrator, InDesign
  5. Maya (Modeling and Animation)
  6. Unity3d (Game Design)
  7. HTML, CSS and JavaScript
  8. Crystal Reports

Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.

Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.

Some of the clients Kyle has provided training for include:

  • Brocade
  • Chevron
  • Genentech
  • Facebook
  • Levi Strauss
  • PMI Mortgage Insurance
  • State Fund
  • Bank of the West
  • VISA
  • Walmart
  • and many more...

What Students have said about Kyle:

      • "Kyle was off the chart "GOOD""


      • "Awesome trainer because I'm computer "stupid" and he helped me understand it."

      • "Kyle Pew is very knowledgeable and presented information with exceptional skill."

In his 10+ years of training (corporate training, 1-on-1 consulting and college courses), Kyle has taught 1000's of courses and 10's of thousands of students all the while maintaining a high level of delivery and satisfaction from the student he has taught.

Teaching Philosophy:

Kyle believes that student’s best learn through the application of real-life business situations through exercises. Allowing students to guide the class with their specific situations allows for the quickest and easiest adaptation to new technology and skills.

In His Spare Time:

Kyle enjoys spending time with his family (6 children). When he’s not busy entertaining his kids, you will find him cheering on his favorite hockey team, the San Jose Sharks, this is their year!

Ready to start learning?
Take This Course