Microsoft Excel 103 - Advanced Excel
5.0 (56 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.
217 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 103 - Advanced Excel to your Wishlist.

Add to Wishlist

Microsoft Excel 103 - Advanced Excel

Become the Ultimate Excel Guru by Mastering Advanced Excel Functions, Macros, Protecting Worksheets and More
5.0 (56 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.
217 students enrolled
Created by Kyle Pew
Last updated 8/2016
Current price: $20 Original price: $40 Discount: 50% off
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • 2 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • 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
View Curriculum
  • 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.

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!

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.
Curriculum For This Course
33 Lectures
Microsoft Excel 103 Course Introduction
2 Lectures 03:02

Course Exercise Files - Download this Excel File First!
Working with Excel's Conditional Functions
6 Lectures 34:42

Nesting Functions

Using Excel's COUNTIF() Function

Using Excel's SUMIF() Function

Using Excel's IFERROR() Function
Working with Excel's Lookup Functions
3 Lectures 25:21
Using Excel's VLOOKUP() Function

Using Excel's HLOOKUP() Function

Using Excel's INDEX() and MATCH() Functions
Working with Excel's Text Based Functions
4 Lectures 28:02
Using Excel's LEFT(), RIGHT() and MID() Functions

Using Excel's LEN() Function

Using Excel's SEARCH() Function

Using Excel's CONCATENATE() Function
Auditing an Excel Worksheet
4 Lectures 13:58
Tracing Precendents in Excel Formulas

Tracing Dependents in Excel Formulas

Working with the Watch Window

Showing Formulas
Protecting Excel Worksheets and Workbooks
3 Lectures 15:33
Protecting Specific Cells in a Worksheet

Protecting the Structure of a Workbook

Adding a Workbook Password
Mastering Excel's "What If" Tools
4 Lectures 31:21
Working with Excel's Goal Seek Tool

Working with Excel's Solver Tool

Building Effective Data Tables in Excel

Creating Scenarios in Excel
Automating Repetitive Tasks in Excel with Macros
5 Lectures 21:38
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
2 Lectures 02:02
Congratulations on Completing the Microsoft Excel 103 - Advanced Coruse

BONUS - Special Offer! Discount on any of my courses!
About the Instructor
Kyle Pew
4.6 Average rating
13,985 Reviews
70,607 Students
16 Courses
Microsoft Certified Trainer - 65,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!