Master Excel Formulas Tips & Tricks

Learn to utilize Excels Powerful Formulas to effortlessly Manage Information and become a Superstar in your organization
4.4 (63 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.
4,206 students enrolled
$19
$45
58% off
Take This Course
  • Lectures 39
  • Length 4.5 hours
  • 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 10/2015 English

Course Description

Master Excel Formulas, Tips & Tricks.

Learn to use Excel's Amazingly Powerful Formulas and the Tips and Tricks I've picked up over the past 20 years using Excel.

It doesn't take that much effort to go from someone barely proficient in utilizing Excel to become the Superstar at your organization. Being the Excel Guru has afforded me a lot of opportunities where I may not otherwise had the chance to participate.

We'll look at formulas, tips & tricks that I use almost every day while working.

I don't want this training to end there.

I'd like as much participation on your part as possible, letting me know exactly what problems you are having a tough time solving.

This way I can learn what issues you are having and cater the training to meet YOUR needs!

So what you are waiting for? Sign up right now and let's get started.

So you inside!

What are the requirements?

  • No Prerequisites necessary, just the desire to increase your skills using Microsoft Excel

What am I going to get from this course?

  • Utilize advanced formulas and Tricks in Excel to work more efficiently.
  • Become an Excel Guru and the "go-to" person at your job.
  • Feel much more confident about job security

What is the target audience?

  • Beginners with limited knowledge of Excel looking to sharpen their skills and getting a better grasp at more advanced topics.
  • Advanced users looking for a different perspective and a good reference

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

What is this Course all about?
Preview
04:25
One More Thing Before We Get Started
Preview
00:54
01:17

A quick walk-through showing you how to download the reference material.

Section 1: Excel Tips & Tricks
04:26

An Excellent trick to use when you need to fill in blank spaces with a table a data in Microsoft Excel

12:03

Learn how to manage data with the excellent tool - Data Validation

03:17

Learn Easiest Way to REMOVE DUPLICATES in Excel

13:31
Learn Multiple Ways to Spot Trends with Conditional Formatting
07:18

Learn how to insert and manipulate clipart to use in reports and presentations.

03:09

Use TRANSPOSE to Instantly Change the Row & Column Layout

11:10

Learn multiple ways to parse data, split text from one column into multiple columns with Microsoft Excel's Text to Columns Tool

06:59

Learn how to use multiple formulas to create complex & flexible conditional formatting

06:40

Learn to use & format Comments in Excel

12:20

Multiple ways to use Filters in Microsoft Excel using real world examples.

Section 2: Financial Formulas
10:32

Calculate a Loan Payment using the PMT Formula

05:18

Calculate the maximum loan you can afford using a constant rate and payment. 

03:38

Calculate the Total Remaining Payments of a Loan using NPER

Calculate the Future Value of an Annuity Investment using the FV Formula
05:57
04:22

Calculate the Interest Rate of a Loan using the  RATE Formula

08:26

Create your own Amortization Schedule in Excel using the PMT, IPMT and PPMT formulas

Section 3: Math & Trig Formulas
05:29

Use the Microsoft Excel formula RANDBETWEEN to create random selections. Great for Audit Sampling and Business.

07:35

SUMIF & COUNTIF - How to Summarize by Specific Criteria

10:09

SUBTOTAL vs SUM - Use Sum and Subtotals with Filters to Quickly Analyze Data

08:37

Learn the how to master Sumif and Sumifs in Microsoft Excel

09:24
ROUND - ROUNDUP - ROUNDDOWN - Simple tricks to make your reporting much cleaner
08:00

Learn to round numbers using multiples for greater flexibility.

Section 4: Text Formulas
09:19

Learn how to use the Excel Formula Concatenate to merge data from individual cells into a single cell for analysis and reporting purposes.

06:27

Learn How to Use Nested LEFT, RIGHT & MID using CONCATENATE

04:36

Remove all leading and trailing spaces from text using the Excel Formula TRIM

Section 5: Logical Formulas
04:49

Examples or how to use the AND & OR Formulas in Microsoft Excel

06:27

Learn Multiple ways to use the amazingly useful IF THEN Statement in Microsoft Excel

07:28

Using the IF Formulas (Part II) - Nesting Multiple IF formulas for greater flexibility

11:46

Learn to Nest multiple different formulas in the IF formula for maximum flexibility.

09:13

Learn how Hide or Format Errors in Excel using ISERROR / ISNA

Section 6: Lookup & Reference Formulas
11:16

Learn how to use one of my absolute favorite formulas in Excel - The Vlookup.

08:36

Learn how to use VLOOKUP when there are multiple items in the data.

08:25

Learn to use the HLOOKUP formula.

13:18

Learn how to manage recurring data with Named Ranges

Section 7: Date & Time Formulas
05:50

Deconstruct and Recompile a Date into the Correct Date Format

Section 8: Where do I go from here?
Where do I go from here?
00:56

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Scott Falls, Excel Trainer/Teacher

Hi, My name is Scott Falls and I've been working as in accounting/finance going on twenty years.

For my entire professional career I've used Excel.

Since the 90's I've been the Excel "go-to" guy in every company I've worked. Senior management has always relied on me to complete complex tasks involving massive amounts of data. They also sent me to numerous live Excel training courses over the years, from the basics to advanced classes.

The problem I always had with this type of training was that I never felt like I learned what I needed to learn. I'd go with a list of questions about how to actually solve real problems from work and the majority of the class centered on very generic training. Not too many real world examples.

So after recently sending some staff to a class with an outside training company we realized that we weren't getting the benefit we had hoped for, the staff came back with some knowledge but not that real world experience that I needed them to have. Since I was always the "Go To" guy for Excel questions the senior management team approached me about putting together an in house training program. So I spend a lot of time creating the most useful training programs I could devise.

What makes this training the absolute BEST training that you can buy? Besides using real world examples, I've found the absolute best way for me to train someone is to have them sit right next to me while I show them how I perform the work that needs to get done.

So I devised a training program that uses real world examples solved as if you're sitting right next to me.

I have found that this is the absolute best way for you to see how real world work is done!

So when asked to become an instructor on Udemy I jumped at the chance.

I love teaching and sharing my knowledge, I think it's awesome seeing someone go from an absolute beginner to a very confident master.

Check out my courses to learn more and if you don't see something that you like drop me an email.

Ready to start learning?
Take This Course