Excel Hacking

30+Excel Hacks For Accelerated Learning & Comprehensive Guide To All Aspects Excel Related To Become A Specialist ASAP
4.6 (180 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
6,794 students enrolled
Take This Course
  • Lectures 93
  • Length 5.5 hours
  • Skill Level All Levels
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English Closed captions available

Course 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!

What are the 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

What am I going to get from this course?

  • 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

Who is the target audience?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Introduction To this Course

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

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.

Section 2: Functionality & Formatting Basics

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


A downloadable resources for your first Excel spreadsheet. Use this when navigating through 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.


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.


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!


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.


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


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.


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.


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.

Use Hide & Group To Your Advantage
Quick Hack #3: Effortlessly Select The Whole Sheet
Do This Before Moving On!
Section 3: Manipulating Data In Excel - The Hacks You Need To Know
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
Quick Hack #6: Fast Navigation With A Few Keys
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
Section 4: Introduction To Formulas In Excel
Introduction To This Chapter
Download This First: Spreadsheet For This Section
Formula Syntax Explained
PDF: Formula Cheat Sheet #1
10 pages
A Complete Guide To Absolute & Relative Referencing
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
Section 5: Manipulate Text Using Formulas
Download This First: Spreadsheet For This Section
PDF: Formula Cheat Sheet #2
7 pages
Formulas To Ensure Proper Formatting
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
Section 6: Advanced Excel Formulas For Heavy Users
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
Section 7: Excel Tables & Conditional Formatting
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
Section 8: The Secret Ingredient For Stunning Excel-Driven PowerPoint Charts
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Dragos Stefanescu, Founder at TeacHack.com |15 Udemy Courses & 15,000+ Students

About Me

I'm an Internet Entrepreneur with a background in both the Management Consulting & Telecommunications industries. The skills that I have acquired during those stints and in previous years in general have unleashed my passion to teach.

I have a wide array of skills that I share with you via my courses

(1) Social Media

One of my true passions, I have invested a lot of time building a presence online. Highlights include:

  • Creating a connection base of 100+ people in a large Management Consulting firm within weeks of starting the job.
  • Met with a handful of Managing Directors & Senior Managers after approaching them on Social Media
  • Trained Partners on how to effectively make use of LinkedIn & Twitter to network and generate leads
  • Conducted Workshops with Project Teams and Small Enterprises on the use of Twitter and LinkedIn
  • (2) Resume/CV & Interviewing

With 30+ Job applications, I have gained a deep understanding of the recruiting process

  • I have never failed to get an interview (phone or face-to-face) after submitting my Resume
  • Participated in over 20 Job Interviews & Assessment Centres
  • Worked for a leading Management Consulting firm in a highly competitive market
  • (3) Productivity
  • Heavy user of Microsoft Excel & PowerPoint. I completely rebuilt the spreadsheets inherited from one of my teams, reducing the monthly updating time by over half the time (a few business days)
  • Co-produced reports that were ultimately held by members of the Board of Directors in one of the Multinationals I worked in (using Excel & PowerPoint)
  • General productivity freak, I love technology and always look for ways to make it work for me

How I got here…

Until recently I never really envisioned myself starting my own business. In fact, it was quite the opposite - my dream was to work for a large Multinational/ Consulting company and enjoy the riches of the Corporate life…

I soon found myself in what I thought would be my "dream job" only to do work that wasn't at all fulfilling, spending hours every day commuting and paying enormous rent (almost half of my salary) in one of the largest cities in the world. I felt stuck, limited and didn't think much of my future prospects.

I look back now and find it funny how at our lowest points we make life-changing decisions. Since a few members of our Mastermind Group had launched online businesses, I decided I would give it a try. I made up my mind that whatever happened, I absolutely HAD to launch an online product before my birthday.

Within two months, I launched my first Udemy course.

One month later I decided to quit my job (to the utter amazement of my colleagues, managers, friends & family - they probably thought I was crazy) and never looked back since.

My Goal

What I aim for is simple: I want to get you real results in the fastest possible time. Whether it's improving your presence on Social Media, getting your dream job, improving your productivity or self-development, I want you to walk away from my courses with a sense of achievement.

The courses I create are structured in a step-by-step manner so that you can implement them straight away. They do require your effort & commitment, but if you do that I'm extremely confident you can get to the next level.

Ultimately, receiving a message from a satisfied student detailing how I've helped him or her is immensely gratifying, more so than any number of sales.

Get in touch!

If you're one of my students and you want to ask me a question, or you're just reading this now and think we might have something in common then post a discussion item on one of my courses - I'll be more than happy to answer & get to know you better!

Instructor Biography

Richard Korbut, Udemy Producer - Filming, Editing & Creative Direction

Richard Korbut owns a professional film & media company with a mission to transform the field of education through interactive learning based on engagement, step-by-step instruction and actionable material.

We work with passionate individuals seeking to add value to the world by:

  1. Creative Direction - Transforming boring content into captivating education
  2. Filming - Documenting the content in an engaging way
  3. Production - Top quality post-production to add pizazz to each course
  4. Marketing - Ensuring that the word is spread to the public & changes the lives of each and every student

We also serve clients ranging from filming & producing weddings & festivals to directing multi-location exotic documentaries.

Ready to start learning?
Take This Course