Microsoft Excel 103 - Advanced Excel

Become the Ultimate Excel Guru by Mastering Advanced Excel Functions, Macros, Protecting Worksheets and More
4.7 (26 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.
97 students enrolled
$19
$40
52% 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
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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

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

Curriculum

Section 1: Microsoft Excel 103 Course Introduction
Introduction to Topics in this Course
Preview
02:46
Course Exercise Files - Download this Excel File First!
Article
Section 2: Working with Excel's Conditional Functions
Working with Excel Name Ranges
Preview
05:10
Using Excel's IF() Function
Preview
06:09
Nesting Functions
07:43
Using Excel's COUNTIF() Function
03:55
Using Excel's SUMIF() Function
05:40
Using Excel's IFERROR() Function
06:05
Section 3: Working with Excel's Lookup Functions
Using Excel's VLOOKUP() Function
07:39
Using Excel's HLOOKUP() Function
04:22
Using Excel's INDEX() and MATCH() Functions
13:20
Section 4: Working with Excel's Text Based Functions
Using Excel's LEFT(), RIGHT() and MID() Functions
06:18
Using Excel's LEN() Function
06:15
Using Excel's SEARCH() Function
12:19
Using Excel's CONCATENATE() Function
03:10
Section 5: Auditing an Excel Worksheet
Tracing Precendents in Excel Formulas
04:01
Tracing Dependents in Excel Formulas
02:52
Working with the Watch Window
04:19
Showing Formulas
02:46
Section 6: Protecting Excel Worksheets and Workbooks
Protecting Specific Cells in a Worksheet
08:05
Protecting the Structure of a Workbook
04:13
Adding a Workbook Password
03:15
Section 7: Mastering Excel's "What If" Tools
Working with Excel's Goal Seek Tool
07:41
Working with Excel's Solver Tool
09:32
Building Effective Data Tables in Excel
06:17
Creating Scenarios in Excel
07:51
Section 8: Automating Repetitive Tasks in Excel with Macros
Understanding Excel Macros
03:50
Activating the Developer Tab in Excel
01:42
Creating a Macro with the Macro Recorder
07:39
Editing a Macro with VBA
05:16
Creating Buttons to Run Macros
03:11
Section 9: Congratulations!
Congratulations on Completing the Microsoft Excel 103 - Advanced Coruse
00:58
BONUS - Special Offer! Discount on any of my courses!
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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

Qualifications:

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

      • "ONE OF THE BEST COURSES THAT I'VE HAD... (IN 12+ YEARS)."

      • "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