Excel with Top Microsoft Excel Hacks (Udemy.com)
Learn these Hidden Excel Gems to Become an Excel Master
Created by: Kyle Pew
Last updated October 2016
What you will learn
- 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
Quality Score
Overall Score : 94 / 100
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.
Instructor Details
- 4.7 Rating
2,371 Reviews
Kyle Pew
Welcome! I'm Kyle Pew, a Microsoft Certified Trainer (MCT), Microsoft Office Master Instructor, and Udemy Instructor Partner, with over 20 years of experience training over 2 million students in Microsoft Office and beyond. I’m passionate about helping students of all backgrounds and skill levels succeed in using tools like Excel, Word, PowerPoint, Access, and more, as well as diving into advanced topics like VBA and SharePoint.
With a background in media arts and animation from the San Francisco Art Institute and industry experience as a game designer at Electronic Arts, I bring a unique perspective to my training. My clients have included major corporations like Chevron, Facebook, Walmart, and many more, delivering training to both large-scale audiences and individuals, adapting each lesson to address real-world applications. My courses are built around the principle that the best way to learn is by tackling real-life challenges—allowing you to build confidence and problem-solving skills.
Join me on Udemy and let’s take your skills to the next level. When I’m not teaching, I’m enjoying time with my six children or cheering on my favorite hockey team, the San Jose Sharks.
More courses by Kyle Pew
Microsoft Excel - Excel from Beginner to Advanced 2026
4.7 (543,696 Reviews)
Provider: Udemy
Time: 22.3h
$139.99
Master Microsoft Excel Macros and Excel VBA (2025)
4.6 (33,954 Reviews)
Provider: Udemy
Time: 5.4h
$15.99
Master Microsoft Word Beginner to Advanced (2019)
4.7 (32,671 Reviews)
Provider: Udemy
Time: 7h
$18.99
Microsoft PowerPoint From Beginner to Advanced (2019)
4.6 (24,824 Reviews)
Provider: Udemy
Time: 6.8h
$14.99
Microsoft Excel Data Analysis and Dashboard Reporting (2018)
4.6 (13,525 Reviews)
Provider: Udemy
Time: 3.6h
$15.99
Reviews
By Miranda Nichols on 3/20/2022
This course is extremely helpful in the information it provides and the exercise files you do to follow along. As an avid Excel user, I found these tips to be very easy to transfer to my everyday work and get more automated with just some simple steps. I highly recommend this course to those who are not super savvy yet with Excel but who would like to be.
By JKrajnak on 12/18/2020
It was a short journey through the hacks for this course, as most of these hacks do not specifically work with the MAC OS X version of Excel which is what I have for my Macbook Pro. But for anyone with a Windows Machine, these topics are very interesting to work through, and should give anyone a better/more efficient way of working with Excel.
By James Krueger on 11/17/2020
Great course! I had no idea that there were all of these neat features available. They make anyone more productive when using Excel. I think Flash Fill and Camera are two of my favorites. Well worth the cost of the course. I will recommend this to all my friends. It will make me appear rather smart.
By Chuck Garmon on 6/18/2020
Extremely interesting and informative. I did know about some of the hacks before hand through other courses. What I noticed is the number of situations that I can actually use these hacks that I did not recognize before even when I knew about the hack. I continue to be impressed how detailed you are in your instructions and yet keep it exciting. Keep up the great work! I also appreciate that you will expand upon the course later in the future with Chuck
By Don Ellis on 5/4/2020
I had recently finished your Excel: Beginning to Advanced course so I decided I would jump right into your Excel: Hacks course. I enjoyed the quick concise lessons and definitely picked up some tips. I do recommend your courses to anyone looking to improve and master Excel.
By Mike on 6/12/2019
I enjoyed taking this class and learning cool and helpful tricks/tools. My favorite of the whole course is hack #22 creating a dynamic range using named range and offset command. When you combine this with the spinner control (hack #23) you can change the appearance of a chart with a click. Awesome!
By Bob Prentice on 11/25/2018
This is amazing!!! There are tons of really helpful short cuts and easier ways of doing things that can be applied immediately to everyday work. And it is just a work in progress as Kyle is apparently updating it every month. I loved it and will be referring back to it as needed from now on. Thanks Kyle!!
By Konrad Jakubiec on 1/21/2018
Course contains a wide variety of hacks, some of them are really easy and some quite hard. Thing that matter is non-applicable character of course. This means that if you learned "A" from lesson 3 and then you are on lesson 6 where you can use this "A" feature while learning "C" - "A" is not used.
By Over Analyzer on 11/29/2017
Time well spent learning automation hacks in Excel. Constantly being added to also, fast paced and yet is easy to understand. Important to work alongside Kyle. Highly recommend, have bought several of Kyle's courses as he is an excellent instructor. ======================================================== Only slight "cons" here : (1) link for lesson 25 "Importing from the Web" is not valid, I used the one from archive.org https://web.archive.org/web/20160430104744/http://www.geohive.com/earth/population_now.aspx (2) Custom views not working as it should but when copied to a separate page, it works.
By Elizabeth Thomas on 4/21/2016
Excellent course! The instructor is very clear in explanations. I like that it is broken into short lessons in which one skill is highlighted. The instructor gets straight to the topic rather than wasting time with long intros and other talking, which ultimately means you can get through a lot more material!
Kyle is the Man, as always i leave the expericance impressed. I've completed three courses from Kyle and I'm always satisfied with them!









