Excel Hacking

30+Excel Hacks For Accelerated Learning & Comprehensive Guide To All Aspects Excel Related To Become A Specialist ASAP
4.3 (165 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,668 students enrolled
$195
Take This Course
  • Lectures 93
  • Contents Video: 5 hours
    Other: 42 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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

About This Course

Published 7/2015 English

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

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

Curriculum

Section 1: Introduction To this Course
02:35

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

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

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

Article

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

04:33

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.

03:44

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.

01:54

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!

02:21

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.

01:14

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

04:20

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.

02:55

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.

03:11

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
03:40
Quick Hack #3: Effortlessly Select The Whole Sheet
00:55
Do This Before Moving On!
01:51
Section 3: Manipulating Data In Excel - The Hacks You Need To Know
Introduction
Preview
02:20
Download This First: Spreadsheets For This Section
Article
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
Quick Hack #6: Fast Navigation With A Few Keys
Preview
01:41
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
Section 4: Introduction To Formulas In Excel
Introduction To This Chapter
02:38
Download This First: Spreadsheet For This Section
Article
Formula Syntax Explained
02:52
PDF: Formula Cheat Sheet #1
10 pages
A Complete Guide To Absolute & Relative Referencing
Preview
05:29
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
Section 5: Manipulate Text Using Formulas
Introduction
02:13
Download This First: Spreadsheet For This Section
Article
PDF: Formula Cheat Sheet #2
7 pages
Formulas To Ensure Proper Formatting
Preview
03:02
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
Section 6: Advanced Excel Formulas For Heavy Users
Introduction
02:02
Download This First: Spreadsheet For This Section
Article
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
Section 7: Excel Tables & Conditional Formatting
Introduction
01:48
Download This First: Spreadsheet For This Section
Article
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
Section 8: The Secret Ingredient For Stunning Excel-Driven PowerPoint Charts
The Secret Ingredient Revealed
03:37
Download This First: Spreadsheet For This Section
Article
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

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