Excel with Top Microsoft Excel Hacks

Learn these Hidden Excel Gems to Become an Excel Master
4.7 (1,203 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.
8,552 students enrolled
25% off
Take This Course
  • Lectures 36
  • Length 2 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 3/2016 English Closed captions available

Course Description

Unleash the Full Power of Microsoft Excel

Wow! How did you do that? This is something you're going to hear over and over again from your boss and co-workers as you apply the features you'll master as you participate in this course.

Microsoft Excel users use only a small percentage of what the application is really capable of. But, hidden within Excel are loads of lesser known Excel Productivity Hacks that will make your Excel experience more efficient and fun. I've been teaching Microsoft Excel since the '97 version of the Microsoft Office Suite. Join me in this course and I will share with you some of the tips and tricks that I have picked up along the way as I have helped others become Excel Guru's.

I have kept each video lecture short and to the point, about 2-3 minutes each. I created this course back in Feb. 2016. Over the next several months I have updated the course with more quick tips on working with Excel. Keep an eye on the course as I will continue to add more Excel hacks throughout the lifetime of the course. The course is recorded using Excel 2016, but Excel 2007, 2010,  2013 or 2016 will work in order to follow along.

Towards the beginning of the video lectures is an exercise file that you can download and use to practice the concepts taught during each video lecture. Also, jump into the course discussion board and participate by asking questions or commenting on how awesome this course is. I will also be participating in the discussion board offering more Excel resources and answering any questions you may have.

Enroll now and start learning the secrets of Microsoft Excel and begin to WOW your boss and co-workers today.

What are the requirements?

  • In order to follow along with the video lectures you will need a copy of Excel 2007, 2010, 2013 or 2016 loaded on your computer.

What am I going to get from this course?

  • Learn Excel Shortcuts to Save Time and Become More Productive Managing Your Excel Workbooks
  • Uncover Lesser Known Excel Shortcuts and Tools Cutting back on Wasted Time Doing Tasks the Long Way
  • Customize Your Microsoft Excel Experience Adding to Your Overall Productiviy
  • Wow Your Boss and CoWorkers with Lesser Known Excel Features

Who is the target audience?

  • This Microsoft Excel Hacks course was created for anyone looking to learn how to become more productive working with Microsoft Excel

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: Course Introduction
A Quick Introduction and Welcome
Download this Exercise File
Section 2: Microsoft Excel Hacks 101
Hack 01 - Linking Text Boxes to Worksheet Cells
Hack 02 - Effectively Deleting Empty Rows in a Data Set
Hack 03 - Quickly Fill Blank Cells with a Value
Hack 04 - The Secret Excel Camera Tool
Hack 05 - Quickly Navigating Between Excel Worksheets
Hack 06 - Quickly Navigating Between Excel Workbooks
Hack 07 - Jump Quickly to Formulas
Hack 08 - Adding an Average Line to Chart
Hack 09 - Opening the Excel Clipboard
Hack 10 - Creating Custom AutoFill Lists
Section 3: New Excel Hacks March 2016
Hack 11 - Status Bar Calculations
Hack 12 - Data Entry Shortcuts
Hack 13 - Grouping Worksheets
Section 4: New Excel Hacks April 2016
Hack #14 - Email as PDF
Hack #15 - Excel Calculator
Hack #16 - Add to AutoCorrect
Section 5: New Excel Hacks May 2016
Hack #17 - Hidden Excel Function - DATEDIF()
Hack #18 - Excel Function SUMPRODUCT()
Hack #19 - Excel Array Formulas
Hack #20 - Excel SUMPRODUCT() with Criteria
Section 6: New Excel Hacks June 2016
Hack #21 - Creating an Excel Table of Contents with VBA (UPDATED)
Hack #22 - Creating a Dynamic Range with Excel's OFFSET() Function
Hack #23 - Working with Excel Spin Controls
Section 7: New Excel Hacks July 2016
Hack #24 - Import Data from a Website
Hack #25 - Paste Special - Transpose Data
Hack #26 - Evaluate Formulas with F9
Section 8: New Excel Hacks August 2016
Hack #27 - Custom Views in Excel
Hack #28 - Excel's xlSTART Folder
Hack #29 - Automate with the Excel Macro Recorder
Section 9: New Excel Hacks October 2016
Hack #30 - Convert Text To Number
Hack #31 - Flash Fill (New Excel 2013 Feature)
Hack #32 - Quick Analysis (New Excel 2013 Feature)
Section 10: Congratulations

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