Excel Hacking
4.5 (280 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.
7,476 students enrolled

Excel Hacking

30+Excel Hacks For Accelerated Learning & Comprehensive Guide To All Aspects Excel Related To Become A Specialist ASAP
4.5 (280 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.
7,476 students enrolled
Last updated 11/2015
English
English
Current price: $107.24 Original price: $194.99 Discount: 45% 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 3,500+ 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
Requirements
  • 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
Description

  • 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!
02:09

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
00:02

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
04:33

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
03:44

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
01:54

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
02:21

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
01:14

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
04:20

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
02:55

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