Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Life Purpose Meditation Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel

Excel with Top Microsoft Excel Hacks

Learn these Hidden Excel Gems to Become an Excel Master
Rating: 4.6 out of 54.6 (2,160 ratings)
23,275 students
Created by Kyle Pew
Last updated 10/2016
English
English
30-Day Money-Back Guarantee

What you'll 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

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.

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.

Who this course is for:

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

Course content

10 sections • 35 lectures • 1h 47m total length

  • Preview01:46
  • Download this Exercise File
    00:26

  • Preview02:32
  • Preview02:45
  • Preview02:54
  • Preview04:08
  • Hack 05 - Quickly Navigating Between Excel Worksheets
    01:07
  • Hack 06 - Quickly Navigating Between Excel Workbooks
    01:13
  • Hack 07 - Jump Quickly to Formulas
    02:34
  • Hack 08 - Adding an Average Line to Chart
    03:59
  • Hack 09 - Opening the Excel Clipboard
    03:24
  • Hack 10 - Creating Custom AutoFill Lists
    04:59

  • Hack 11 - Status Bar Calculations
    01:59
  • Hack 12 - Data Entry Shortcuts
    02:46
  • Hack 13 - Grouping Worksheets
    03:05

  • Hack #14 - Email as PDF
    01:52
  • Hack #15 - Excel Calculator
    01:31
  • Hack #16 - Add to AutoCorrect
    03:59

  • Hack #17 - Hidden Excel Function - DATEDIF()
    02:16
  • Hack #18 - Excel Function SUMPRODUCT()
    03:45
  • Hack #19 - Excel Array Formulas
    03:49
  • Hack #20 - Excel SUMPRODUCT() with Criteria
    01:01

  • Hack #21 - Creating an Excel Table of Contents with VBA (UPDATED)
    08:47
  • Hack #22 - Creating a Dynamic Range with Excel's OFFSET() Function
    07:30
  • Hack #23 - Working with Excel Spin Controls
    03:16

  • Hack #24 - Import Data from a Website
    03:31
  • Hack #25 - Paste Special - Transpose Data
    02:02
  • Hack #26 - Evaluate Formulas with F9
    03:43

  • Hack #27 - Custom Views in Excel
    02:38
  • Hack #28 - Excel's xlSTART Folder
    02:55
  • Hack #29 - Automate with the Excel Macro Recorder
    04:52

  • Hack #30 - Convert Text To Number
    03:03
  • Hack #31 - Flash Fill (New Excel 2013 Feature)
    03:14
  • Hack #32 - Quick Analysis (New Excel 2013 Feature)
    02:41

  • Congratulations
    01:02

Instructor

Kyle Pew
Microsoft Certified Trainer
Kyle Pew
  • 4.6 Instructor Rating
  • 254,628 Reviews
  • 822,201 Students
  • 19 Courses

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;

Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013Excel, Word, PowerPoint, Outlook, Access and Visio

SharePoint End-User 2007, 2010, 2013

VBA (Excel and Access)

Adobe SuitePhotoshop, Illustrator, InDesign

Maya (Modeling and Animation)

Unity3d (Game Design)

HTML, CSS and JavaScript

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!

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.