Excel Hacking
4.4 (590 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
8,352 students enrolled

Excel Hacking

30+Excel Hacks For Accelerated Learning & Comprehensive Guide To All Aspects Excel Related To Become A Specialist ASAP
4.4 (590 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
8,351 students enrolled
Last updated 11/2015
Current price: $135.99 Original price: $194.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • 8 articles
  • 13 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Gain Practical Knowledge Of Excel From The Very Basics, All The Way To Complex Formulas, Pivot Tables & Elaborate Keyboard Shortcuts
  • Take An Approach Focused On Practicality And Modify The Spreadsheets Made Available To You As You Go Through The Course
  • Master 20+ Excel Hacks Which Will Increase Your Working Speed Tremendously
  • Make Use Of Custom-Built Templates For Both Your Business & Personal Life
  • Learn The Top Excel Functionalities For Manipulating Data Without Formulas
  • Easily Digest The Comprehensive Formula-Based Part Of This Course And Learn Everything From the Sum Formula All The Way To Advanced combinations Such As Match + Index
  • Discover An Entire Section On How To Manipulate Text Strings With Formulas
  • Discover A 'Secret Ingredient' Which Will Revolutionise Your Data-Driven Charts From Excel To PowerPoint
  • Dig Deep Into Table Creation And Conditional Formatting
  • Must Have: Microsoft Excel Installed On Your Computer
  • Nice To Have: The Latest Version Of Excel (2013 is Preferable)
  • Nice To Have: Several Screens To Facilitate Better Action Taking (i.e. Extra Desktop Monitor or 2 Devices)
  • A Positive Attitude, Willingness To Take Action And Improve Your Excel Skills

  • 13,000+ Students have enrolled in my 13 Courses!
  • The 4.8 Rating from student reviews shows the value packed in this course!
  • Practicality: This course has 7 Downloadable Spreadsheets  so that you can follow along with every Section!

"I wish I was good at Excel, but it's too technical for me"

"Excel confuses me with all those formulas"

"I picked up an Excel book to start learning, hopefully I'll get a better grasp of it soon"

I hear excuses and bad approaches when it comes to learning Excel all the time. Here's the truth - Excel is extremely complex and is not an easy thing to master. However, I truly believe that you can hack your way through learning it - that is, know exactly what the most important aspects in Excel are and master them one by one. That's why I organised this course into so-called "Hacks", so that you can focus on the most important information first and foremost.

Have you ever been confused by the sheer complexity of Excel? Ever struggled with an annoying problem that you couldn't solve fast enough? Or maybe you're just looking to start learning to use Excel and master it quickly...

A lot of the Excel Trainings out there throw a bunch of formulas at you and teach you how to use them. However, they neglect to tell you their practical applications and what the most important shortcuts are.

A few years ago I was an Excel rookie. I thought I knew how to use it (what's so hard right?), but found out about my limitations as soon as I started a job in a Financial Controlling role. Everything that I have learned in Excel came as a result of the challenges that I faced on the job and my relentless drive to discover solutions that were more and more efficient.

The truth is I didn't have one of the most efficient learning curves because nobody told me what the most efficient path to mastering Excel was.

What do experts do on a daily basis? What are the key formula combinations for particular situations? What sort of tips & tricks do they use to be faster & more efficient when using Excel?

Those questions led to this course. I bundled all of my knowledge in a way that prioritises the most important Excel Hacks. This will ensure that you will get to your best Excel level in the fastest possible time. Doesn't that sound better than sitting through boring Excel Training Seminars for 8 hours during a whole day?

Here's what this course covers:

  1. The Excel Essentials - discover the quickest ways to navigate and manipulate data in Excel so that you can master the basics straight away
  2. 20+ Quick & Killer Hacks - These are individual lectures focused on particular Excel hacks which boost your productivity & use of Excel
  3. Bulls-Eye Formula Blueprint - master Excel Formulas by shifting the focus away from HOW they work to WHAT their usability is in practical scenarios

And much, much more. Just have a look at the Learning Outcomes.

The Excel Mastery Guarantee

I'm extremely confident that if you take action and follow these steps, you will revolutionise your Excel skills at a very fast pace. However, if for any reason you're not satisfied with this course, then I will personally jump on a 30 Minute Skype Call with you and help you get to the next level.

Nobody can give you a Magic Pill for learning Excel - it takes time & practice. However, if you're aware of the most important shortcuts from the beginning, that will end up saving you countless hours of your precious time. Take this course now and join me in this exciting journey!

Who this course is for:
  • Students Who Want To Prepare For Internships/Entry-Level Roles Which Require Excel
  • Managers / Experienced Professionals Who Want To Take Their Knowledge To The Next Level
  • Financial Managers & Consultants That Want To Explore The More Complex Functionalities Of The Software
  • Entrepreneurs Who Need To Create Spreadsheets For A Tighter Grip Over Their Financials
  • Anybody That Wants To Improve Their Use Of Microsoft Excel
Course content
Expand all 93 lectures 05:34:14
+ Introduction To this Course
3 lectures 08:10

Setting the expectations for this Excel course - showing you what you will learn and what you can expect from the course. Good luck!

Preview 02:35
Important: Let's Get To Know Each Other!

This piece of advice stems from my Excel experience acquired over the years. If you follow what I laid out in this lecture, it will make it much easier for you to master Excel fast.

Preview 03:26
+ Functionality & Formatting Basics
13 lectures 32:46

Excel Functionality Basics - In this lecture you will see the structure of this first content based section and know exactly what you can expect.

Preview 02:06

A downloadable resources for your first Excel spreadsheet. Use this when navigating through this section.

Download This First: Spreadsheet For This Section

How to take advantage of one important Excel functionality - Auto Fill. We're starting slow and increasing the level of difficulty as we go along.

Getting Started & Auto-Fill

Excel formatting is particularly important, especially when dealing with complex spreadsheets. Although this isn't the case here, it's important to understand how alignment based formatting works.

Getting Smart With Alignment-Based Formatting

Borders in Excel will help you a lot when it comes to organising your data. Find out how to add them in this quick lecture!

Customising The Format With Borders

Your Excel spreadsheet can sometimes become too large or you might have redundant data. In this lecture you will learn to play with multiple rows and columns at the same time in order to "clean up" your Excel spreadsheets.

How To Effectively Manipulate Rows And Columns

Quick Excel Hack - in this short lecture you will learn to insert more than one row at a time.

Quick Hack #1: Insert Several Rows More Effectively

Excel formatting can be applied to a cell-level as well. In this video I will show you the most important features to consider when formatting cells.

Beginners' Guide: Cell-Level Formatting

One particularly important Excel and Office tool is the Format Painter. Here's how you use it. Once you watch this video you will understand just how much time this will save you.

The Fundamental Excel Tool You Must Be Aware Of

This Excel Quick Hack - or the double-click trick, as I like to call it - was unknown to me for quite some time. However, it now saves me a ton of time and makes me more productive in Excel.

Quick Hack #2: The Double Click Trick
Use Hide & Group To Your Advantage
Quick Hack #3: Effortlessly Select The Whole Sheet
Do This Before Moving On!
+ Manipulating Data In Excel - The Hacks You Need To Know
16 lectures 48:48
Download This First: Spreadsheets For This Section
The Tool To Effortlessly Replicate Formulas & Values
Quick Hack #4: Auto-Fill... With A Twist!
The Easy Solution To Transposing Your Tables
Excel Hack #1: The Essential Functionality I Heavily Used To Build Spreadsheets
Quick Hack #5: Searching With Wildcard
PDF: 12 'Must-Know' Excel Shortcuts
13 pages
How To Make Sense Of Data-Packed Tables
Sorting Efficiently In Excel
Ultimate Guide: Filtering
How To Get Rid Of Duplicates In Your Data
Using Subtotals To Your Advantage
Quick Hack #7: How To Copy Visible Cells Only
Excel Hack #2: Introducing Flash-Fill
+ Introduction To Formulas In Excel
12 lectures 38:09
Introduction To This Chapter
Download This First: Spreadsheet For This Section
Formula Syntax Explained
PDF: Formula Cheat Sheet #1
10 pages
3 Essential Formulas To Master
Quick Hack #8: Verify Formulas Fast
2 Ways To Identify Maximum & Minimum Values
How To Use The IF Function The Right Way
3 Operators To Expand Your Condition-Based Formulas
No-Nonsense Guide To Solving Nested IFs
Excel Hack #3: Organised Formula Writing For Enhanced Visibility & Productivity
+ Manipulate Text Using Formulas
10 lectures 28:29
Download This First: Spreadsheet For This Section
PDF: Formula Cheat Sheet #2
7 pages
How To Stick Text Strings Together
Quick Hack #9: Combine Strings Without A Formula
3 Ways To Extract Bits Of Text
Ultimate Guide: Extracting Text By Identifying Specific Strings
Quick Hack #10: Ensure Text Accuracy
The Built-In Functionality To Customise Text Strings
+ Advanced Excel Formulas For Heavy Users
15 lectures 53:55
Download This First: Spreadsheet For This Section
Time Saver: How To Define Names In Excel
Beginners Guide: Using VLookup
Quick Hack #11: Vlookups For 100% Accuracy
How To Identify Row & Column Indicators With Unique Values
Quick Hack #12: The VLookup & Match Combo
When To Use Nested VLookups
Excel Hack #4: Extract Values From A Database With Row & Column Indicators
The Tidiest Way To Deal With Errors
Excel Hack #5: Looking Up Values With 2+ Unique Criteria
The Fastest Way To Sum Up Different Sheets
The Easy Way To Transpose Tables With Formulas
Quick Hack #13: Excel Goal-Seeker
Important: This Will Only Take You 2 Minutes
+ Excel Tables & Conditional Formatting
14 lectures 38:50
Download This First: Spreadsheet For This Section
Beginners' Guide: Excel Table Creation
Table Design Basics
Quick Hack #14: Adding Total Rows To Tables
Quick Hack #15: 3 Awesome Table Functionalities
Conditional Formatting Essentials
How To Manage Conditional Formatting
Conditional Formatting With Formulas
Excel Hack #6: 3 Features To Take Conditional Formatting To The Next LEvel
Excel Chart Creation Tutorial
Quick Hack #16: How Do I Know What Type Of Chart To Choose?
Customising Excel Charts
Excel Hack #7: How To Make Snap Judgements On Large Sets Of Data
+ The Secret Ingredient For Stunning Excel-Driven PowerPoint Charts
10 lectures 43:05
The Secret Ingredient Revealed
Download This First: Spreadsheet For This Section
How To Install The Software On Your Computer
The Most Effective Way To Create And Link Charts To PowerPoint
The Blueprint To Customising The Secret Charts
15+ Ways To Customise & Format Your Secret Charts
8 Secret Charts Exposed!
Case Study: Have Your Manager Get You The Secret Ingredient
10 Secret Charts Preview
12 pages
Download - 10 Secret Charts PowerPoint Template