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 CompTIA Security+ AWS Certified Developer - Associate
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Neuroscience Emotional Intelligence
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 Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging 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 Shortcut

Excel Shortcuts, Hacks & Tricks: 100+ Powerful Excel Tips

Master Excel with 100+ Excel Tips & Hacks, from an Excel Best Seller Instructor. Excel Project Files included.
Highest Rated
Rating: 4.8 out of 54.8 (428 ratings)
2,890 students
Created by Andreas Exadaktylos
Last updated 11/2020
English
English
30-Day Money-Back Guarantee

What you'll learn

  • Maximize the power of Excel with 100+ ready-to-use tips Hacks on Excel Interface, Workbooks, Worksheets, Formatting Secrets, Organizing Data, Formulas, Dates, Numbers, Pivot Tables and Charts
  • Increase your Productivity and be more Efficient than you ever imagined
  • Accomplish and Master all of your Excel Tasks
  • Save precious minutes from the very first Tips
  • Fully understand the Excel Hacks using the Custom-Build Templates that I have in every Lecture
  • Improve your Excel Skills using the latest version of Excel 2016

Requirements

  • Microsoft Excel Installed On Your Computer (2013 or 2016 is Preferable)
  • A willingness to learn new Tips and reinvent your work in Excel

Description

COMPLETELY REDONE ON NOVEMBER 2020 WITH NEW VIDEOS!


If you’ve ever thought to yourself, “There has to be a better way to do this,” while using Excel, then know you're probably right.

With over 100 HD Lectures + Excel Templates, I’m going to teach you the best 100 time-saving tips and tricks in Excel to make Excel more efficient than you ever imagined.

I created this course to help Excel users avoid common spreadsheet stumbling blocks and reveal ways to maximize the power of Excel. I started with no knowledge of Excel and when I started to use it on a daily basis, I said to myself, “There has to be a better way to do this.”

In this course, I compile all my notes and my knowledge and I want to teach you how to improve your skills in short order.

Are you ready to fire up your skills and become a super-efficient Excel user?

First, you’re going learn my top favorite Excel Hacks that can save you a ton of time.

Then I’ll show you some tips that will help you to customize your Excel Interface.

You’re gonna learn several new tips to organize your data, to work with formulas or Dates, to hack your Charts and Pivot tables, to complete lightning your tasks in Workbooks and Worksheets, and a bunch of other cool stuff.

Do you want to enter data to multiple worksheets at a time? No problem. Do you also want to block a user from interacting outside a specific range? Piece of cake. Do you want to get rid of duplicate values in seconds? Easy! These and 97 more tips and hacks can add significant productivity and save money across your organization, too.

The course is entirely project based and requires no Excel experience. It has been recorded with the Excel 2016 and Excel 365 in full HD 1080p.

If you get stuck, don’t worry. I have fast and full support through the discussion board.

And if you don’t like the course, simply return it! There is a 30-day money back guarantee.

But first, you probably want to know who I am. What real world experience do I have? My name is Andreas and I have been a teacher for over 16 years. I have my own computer learning school and I have taught Excel to over 3,000 students. I use Excel daily and because of that, I had to find hacks and tips to increase my productivity and efficiency. So I made this collection of powerful tips. At the end of this course, you’ll accomplish and master all of your spreadsheet tasks at least half the time that you do now.

Thanks for your interest in the course, I’m really excited to share it with you.

Check out the free previews and I’ll see you in class.

Who this course is for:

  • Anybody, from a Novice to an Expert can benefit with this collection of powerful Excel Hacks and Tricks
  • Ideal for Managers, Entrepreneurs and Students

Course content

11 sections • 102 lectures • 4h 4m total length

  • Preview02:02
  • Course Resources & Important Notes for New Student
    02:38
  • Excel 2019 Useful keyboard Shortcuts and Tips
    09:32

  • Customizing the Quick Access Toolbar
    02:20
  • Customizing the Ribbon
    02:26
  • Using Keyboard to Access Ribbon
    01:20
  • The Best Techniques for Inserting, Deleting & Hiding Columns and Rows
    02:52
  • Undo, Redo and Repeat
    02:29
  • Summary
    01:17
  • Excel Interface Hacks
    4 questions

  • Preview07:48
  • Navigate between Workbooks Quickly
    02:18
  • Applying Document Themes in a Workbook
    01:25
  • Saving Excel as a Read-only Webpage File
    01:45
  • Zooming In and Out Quickly
    01:55
  • Summary
    00:51
  • Excel Workbooks Hacks
    3 questions

  • Navigate between Worksheets Quickly
    02:20
  • How to Create a Hyperlink to Other Worksheets
    02:44
  • Preview02:53
  • Copying and Moving Worksheets in Various Ways
    01:46
  • Entering Data to Multiple Worksheets at a Time
    02:13
  • How to Print a 2-page Worksheet on 1 page
    01:48
  • Preview01:27
  • How to Set the Number of Worksheets
    01:27
  • Learning Different Techniques for Navigating within a Given Worksheet
    02:22
  • How to Create and Save Custom Views of a Worksheet
    02:54
  • Summary
    02:44
  • Excel Worksheets Hacks
    3 questions

  • Solving the Problem with Leading Zero
    01:56
  • How to Add Text to a Number
    01:48
  • How to Enter a Line Break into One of Your Cell’s Data
    03:26
  • Using Wrap Text and Shrink Cell Tools to Have the Size of the Cells
    02:23
  • Preview02:50
  • Preview02:10
  • How to Hide the Status Bar
    02:04
  • Changing Values without Formulas
    02:11
  • How to Highlight Formula Cells using Conditional Formatting
    02:17
  • How to Color Rows using Conditional Formatting - Alternate Row Shading
    02:36
  • How to Format Numbers using Keystroke Shortcuts
    01:34
  • How to Modify or Create a Cell Style
    02:51
  • Duplicate Records and How to Get Rid of These
    01:37
  • Creating Bulleted List
    02:37
  • Format Painter Tips
    02:14
  • How to Insert a Watermark
    02:08
  • Making Your Comments Stand Out
    02:15
  • Creating a Custom List
    03:02
  • Summary
    04:12
  • Excel Formatting Hacks
    4 questions

  • The Paste Special Feature
    02:33
  • How to Display a Print Preview using Keyboard Shortcuts
    01:15
  • Preview02:18
  • How to Use FlashFill to Fill Values in a Range Rapidly
    01:50
  • How to Select Data using Various Keystroke Shortcuts
    02:14
  • How to Set a Specific Print Area
    01:17
  • Entering Data Quickly and Efficiently
    03:04
  • Copying and Moving Data with Various Ways
    01:46
  • Using Pick from Drop-down List and Enter Data Quickly
    01:23
  • Preview01:33
  • How to Freeze Titles and Split Screens
    02:34
  • How to Create a Data Entry Form
    02:22
  • Filling non-adjacent Cells with the Current Entry
    02:06
  • Highlighting Blank Cells and Sorting Columns with Them
    02:54
  • Summary
    03:41
  • Excel Productivity Hacks
    3 questions

  • Filling Random Values into Every Cell in a Selection
    01:46
  • How to Generate Random Decimal Numbers between 0 and 1
    01:10
  • Preview02:39
  • How to Add Comments Inside Formulas
    01:35
  • Preview02:00
  • Identifying and Fixing Error inside of an Excel Formula
    02:00
  • Finding Related Formulas Easy
    01:59
  • How to Enter the Current Date or Time
    01:21
  • Using the new-in-Excel-2016 Function PDURATION to Calculate Time
    01:37
  • How to Round Values with Various Ways
    02:42
  • Converting Formulas to Values Easily
    01:33
  • Using Named Ranges in Formulas
    03:26
  • Displaying All Worksheet Formulas in a Second
    01:27
  • Using TRIM Function to Get Rid of Unwanted Spaces
    02:01
  • How to Calculate a Person's Age
    01:52
  • How to Convert Values between Measurement Systems
    01:43
  • Locking and Hiding Formula Cells
    02:40
  • Summary
    04:31
  • Excel Formulas Hacks
    3 questions

  • Create Table & Formatting Data as Table with Table Styles
    02:19
  • Using the Structure Reference to Create a Formula
    01:55
  • How to Create Separate Worksheets from PivotTable using Filters Area
    01:20
  • Summary
    00:40
  • Excel Tables & Pivot Tables Hacks
    2 questions

  • How to Move or Resize a Chart using Special Keys
    02:27
  • Create Mini Charts using Sparklines
    03:09
  • Linking Chart Titles with Cell Content
    02:25
  • How to Make all the Charts Exactly the Same Size
    01:16
  • How to Deal with Missing Data for a Chart
    01:28
  • Creating a Chart with Keyboard Shortcuts
    01:41
  • Summary
    02:03
  • Excel Visualization Hacks
    3 questions

  • How to Analyze an Active Workbook using the Inquire Add-in
    02:41
  • How to Compare Two Lists of Items and Identify Differences between them
    02:55
  • Using Quick Analysis Tool to find Information about Your Data
    01:55
  • Using Status Bar to Get a Quick Summary of your Data
    01:38
  • Getting Data from a PDF File
    01:34
  • Presenting Information in a More Compact Way, using Group Tool
    01:36
  • Applying Goal Seek Tool to Find a Target
    02:14
  • Forecasting Scenarios with Scenario Manager
    03:21
  • Monitoring the Value in a Worksheet using Watch Window Tool
    01:58
  • Calculating Running Totals
    01:30
  • Summary
    02:49
  • Excel Analysis Hacks
    3 questions

Instructor

Andreas Exadaktylos
Best Selling Teacher | Msc Computer Scientist
Andreas Exadaktylos
  • 4.6 Instructor Rating
  • 5,666 Reviews
  • 25,308 Students
  • 7 Courses

Hi, I am Andreas and I'm a teacher. I really love learning and teaching whenever I can.

I have over 16 years of experience in teaching as an instructor, especially in Microsoft Excel. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school. 

I have a Master's Degree in Computer Science and a Degree in Electronic Engineering. 

I always wanted to create my own business. Being your own boss is an incredibly liberating experience but difficult as well. 

I have a passion for software products that make people's lives easier. I teach Python Programming,  Microsoft Excel and all Microsoft software products for over 17 years. I am a professional Forex Trader for over 5 years.

I love to create websites and optimize them with Search Engine Optimization techniques. I created my online e-shop, called Bite me not jewels, with my wife. 

I live in Rodos, a beautiful Greek island. When I am not working, I love being with my family and my two kids. Travel, forex trading, and reading books are my favorite hobbies. 

  • 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.