Microsoft Excel 103 - Advanced Excel
4.9 (39 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.
141 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
4.9 (39 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.
141 students enrolled
Created by Kyle Pew
Last updated 8/2016
English
English
Current price: $10 Original price: $40 Discount: 75% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 2 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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
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.
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!


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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 33 Lectures Collapse All 33 Lectures 02:55:29
+
Microsoft Excel 103 Course Introduction
2 Lectures 03:02

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


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
+
Working with Excel's Lookup Functions
3 Lectures 25:21
Using Excel's VLOOKUP() Function
07:39

Using Excel's HLOOKUP() Function
04:22

Using Excel's INDEX() and MATCH() Functions
13:20
+
Working with Excel's Text Based Functions
4 Lectures 28:02
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
+
Auditing an Excel Worksheet
4 Lectures 13:58
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
+
Protecting Excel Worksheets and Workbooks
3 Lectures 15:33
Protecting Specific Cells in a Worksheet
08:05

Protecting the Structure of a Workbook
04:13

Adding a Workbook Password
03:15
+
Mastering Excel's "What If" Tools
4 Lectures 31:21
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
+
Automating Repetitive Tasks in Excel with Macros
5 Lectures 21:38
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
+
Congratulations!
2 Lectures 02:02
Congratulations on Completing the Microsoft Excel 103 - Advanced Coruse
00:58

BONUS - Special Offer! Discount on any of my courses!
01:04
About the Instructor
Kyle Pew
4.6 Average rating
6,450 Reviews
42,081 Students
15 Courses
Microsoft Certified Trainer - 40,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!