Microsoft Excel 102 - Intermediate Excel
4.5 (73 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.
229 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 102 - Intermediate Excel to your Wishlist.

Add to Wishlist

Microsoft Excel 102 - Intermediate Excel

Supercharge your Microsoft Excel Skills to the Next Level by Mastering Excel Lists, PivotTables, PowerPivot and More
4.5 (73 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.
229 students enrolled
Created by Kyle Pew
Last updated 8/2016
English
English
Current price: $10 Original price: $40 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 2 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Maintain large sets of Microsoft Excel data in a list or table
  • Create dynamic reports by mastering Excel PivotTables
  • Control user input prompting the user when an incorrect value is entered in a cell
  • Use Excel to its full potential using PowerPivot to create relationships between lists and report off the data
  • Use some of the lesser known Excel functions to create calculations based on Excel lists
  • and much more, boosting your Microsoft Excel skills to a whole new level
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

Go Beyond the Basics

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

Ready to take your Microsoft Office Excel skills to the next level? Then you've come to the right course. Enroll now and you will receive step by step mentoring on mastering Microsoft Excel at an intermediate level and beyond. You will learn how to work with some of the most powerful tools Excel has to offer.

Using my 10+ years of Microsoft Excel training I will guide you through these tools preparing you for the most advanced features used my Excel office workers.

  • Mastering Excel Lists (Sorting, Filtering, Subtotals, and more)
  • Creating Powerful Excel Functions in order to Summarize List Data
  • Become an Excel Report Creating Pro with Excel PivotTables
  • Harness the Power of an Excel Add-In, PowerPivot to Create even more robust PivotTables
  • Work with Data from other Sources through Import and Export Commands


At completion of this Excel Intermediate course you will have mastered the above mentioned tools and more, supercharging your Excel knowledge and skills to a whole new level of expertise.

Each section also includes a quiz to test the knowledge you will gain and 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 on your way to becoming an Excel Guru!

Who is the target audience?
  • This Microsoft Excel 102 course was designed for those that are look to advance their knowledge and skills of Excel beyond the basics and learn to master using large sets of Excel data and create dynamic reports.
Compare to Other Excel Courses
Curriculum For This Course
44 Lectures
03:16:11
+
Microsoft Excel 102 Course Introduction
2 Lectures 01:56

Course Exercise Files - Download these First!
00:03
+
Working with Excel Lists
9 Lectures 44:50

During this lecture you will be introduced to a few key concepts of building an effective and well formatted list in Microsoft Excel

Understanding List Structure
05:39

During this lecture you will how easy it is to sort a list by a single column, making the list more accessible and easy to find the data you are looking for

Preview 03:47

During this lecture you will take sorting a list to the next level by introducing the multi-level sort window. This window will allow you perform multiple column sorts on your Excel lists

Sorting a List Using Multi-Level Sorts
03:46

During this lecture you will learn one of the hidden features found in Excel, a custom list sort.

Using Custom Sorts in an Excel List
04:33

During this lecture you will be introduced to using filters to assist in finding specific records in a list.

  • Filters allow a user to specify criteria when searching
  • You can specify a single filter or multiple


Filter an Excel List Using the AutoFilter Tool
04:56

During this lecture you will learn how to use the built subtotal tool within Excel. With just a little input from you Excel will create the subtotals for you.

Creating Subtotals in a List
06:36

During this lecture you will learn how to format a simple list as a table.

  • Formatting as a table will open new features for your list
  • Alternate row colors automatically
  • Create a "Total Row" to perform calculations on your list
  • Accommodate more records by increasing the size of your list at any time
Format List as Table
07:30

During this lecture you will learn how to use conditional formatting to highlight duplicate records in your list

Using Conditional Formatting to Find Duplicates
03:53

During this lecture you will learn how to remove duplicate records from a list using the remove duplicates feature that was introduced in Excel 2010

Removing Duplicates
04:10

Test the knowledge you have learned about working with lists in Microsoft Excel

Working with Lists Quiz
4 questions
+
Excel List Functions
4 Lectures 18:39

During this lecture you will learn how to use the DSUM function within an Excel list.

  • The DSUM function allows you to sum a range of data based on criteria
  • You can sum a single range or multiple ranges
Excel Function: DSUM()
06:35

During this lecture you will learn how to use the DAVERAGE function within an Excel list.

  • The DAVERAGE function allows you to average a range of data based on criteria
  • You can average a single range or multiple ranges
Excel Function: DAVERAGE()
02:47

During this lecture you will learn how to use the DCOUNT function within an Excel list.

  • The DCOUNT function allows you to count a range of data based on criteria
  • You can count a single range or multiple ranges
  • The DCOUNT function will only count numeric data
Excel Function DCOUNT()
03:02

During this lecture you will learn how to use the SUBTOTAL function to create more dynamic calculations.

  • Use the SUBTOTAL function to create SUM, AVERAGE, COUNT, MIN, MAX and more calculations
  • SUBTOTAL calculations will update even when a list is filtered
Excel Function: SUBTOTAL()
06:15
+
Excel Data Validation
4 Lectures 19:51
Understanding the Need for Data Validation
05:13

Creating a Validation List
05:37

Adding a Custom Validation Error
04:37

Dynamic Formulas by Using Validation Techniques
04:24
+
Importing and Exporting Data
3 Lectures 14:01

Importing Data from Microsoft Access Database
04:14

Exporting Data to Text File
04:13
+
Excel PivotTables
9 Lectures 41:30
Understanding Excel PivotTables
03:44


Modifying Excel PivotTable Calculations
06:37

Grouping PivotTable Data
04:43

Formatting PivotTable Data
04:24

Drilling Down into PivotTable Data
03:31

Creating PivotCharts
04:40

Filtering PivotTable Data
03:47

Filtering with the Slicer Tool
03:44
+
Working with Excel's PowerPivot Tools
6 Lectures 28:41
Why PowerPivot?
04:50

During this lecture you will learn how to activate the installed PowerPivot AddIn within Microsoft Excel.

Activating the Excel PowerPivot AddIn
02:26

Creating Data Models with PowerPviot
06:37

Creating PivotTables based on Data Models
03:51

PowerPivot Calculated Fields
03:51

PowerPivot KPIs
07:06
+
Working with Large Sets of Excel Data
5 Lectures 25:06
Using the Freeze Panes Tool
03:39

Grouping Data (Columns and/or Rows)
04:17

Print Options for Large Data Sets
07:32

Linking Worksheets (3D Formulas)
04:08

Consolidating Data from Multiple Worksheets
05:30
+
Congratulations! You're an Intermediate Excel User
2 Lectures 01:45
Congratulations!
00:42

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