Wishlisted Wishlist

Please confirm that you want to add Master Excel Formulas Tips & Tricks to your Wishlist.

Add to Wishlist

Master Excel Formulas Tips & Tricks

Learn to utilize Excel's Powerful Formulas to effortlessly Manage Information and become the Office Superstar
4.4 (85 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.
5,428 students enrolled
Created by Scott Falls
Last updated 1/2017
  • 4.5 hours on-demand video
  • 34 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
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
View Curriculum
  • No Prerequisites necessary, just the desire to increase your skills using Microsoft Excel

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!

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 40 Lectures Collapse All 40 Lectures 04:44:18
What is this Course all about?
3 Lectures 06:36
What is this Course all about?

One More Thing Before We Get Started

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

Downloadable Reference Files
Excel Tips & Tricks
11 Lectures 01:21:49

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

Excellent Trick - Fill in the Blanks

One new thing I wanted to share

One More Thing

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


Learn Easiest Way to REMOVE DUPLICATES in Excel

Learn Easiest Way to REMOVE DUPLICATES

Learn Multiple Ways to Spot Trends with Conditional Formatting
Learn Multiple Ways to Spot Trends Using CONDITIONAL FORMATTING

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

Inserting and Formatting Clipart in Excel

Use TRANSPOSE to Instantly Change the Row & Column Layout

Instantly change the Row & Column Layout with TRANSPOSE

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

TEXT TO COLUMNS - Split/Parse Data from one Column to Multiple Columns

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

Using Multiple Formulas with CONDITIONAL FORMATTING

Learn to use & format Comments in Excel

Various Ways to Use & Format COMMENTS

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

FILTER - Multiple ways to use filters in Microsoft Excel
Financial Formulas
6 Lectures 38:13

Calculate a Loan Payment using the PMT Formula

Calculate a Loan Payment using the PMT Formula

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

Calculate the Loan Balance using PV

Calculate the Total Remaining Payments of a Loan using NPER

Calculate the Total Remaining Payments of a Loan using NPER

Calculate the Future Value of an Annuity Investment using the FV Formula

Calculate the Interest Rate of a Loan using the  RATE Formula

Calculate the Interest Rate of a Loan using the RATE Formula

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

Create your own Amortization Schedule in Excel
Math & Trig Formulas
6 Lectures 49:14

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

RANDBETWEEN - Random Selections

SUMIF & COUNTIF - How to Summarize by Specific Criteria

SUMIF & COUNTIF - How to Summarize by Specific Criteria

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

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

Learn the how to master Sumif and Sumifs in Microsoft Excel


ROUND - ROUNDUP - ROUNDDOWN - Simple tricks to make your reporting much cleaner

Learn to round numbers using multiples for greater flexibility.

Text Formulas
3 Lectures 20:22

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

Merge Text with CONCATENATE

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


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

Use the TRIM Formula
Logical Formulas
5 Lectures 39:43

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

AND & OR Formulas Explained

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

IF FORMULA (Part I) - Learn Multiple Ways to Use the Excel IF Formula

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

IF Formulas (Part II) - Nesting Multiple IF formulas

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

IF Formula (Part III) Nesting different formulas within the IF Formula

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

Working with Errors in Excel - ISERROR / ISNA
Lookup & Reference Formulas
4 Lectures 41:35

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


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


Learn to use the HLOOKUP formula.

Lookup (Part III) - The HLOOKUP

Learn how to manage recurring data with Named Ranges

Named Ranges & Lookups
Date & Time Formulas
1 Lecture 05:50

Deconstruct and Recompile a Date into the Correct Date Format

DATE - Use Text To Columns and Date to Fix Formatting Issues with Dates
Where do I go from here?
1 Lecture 00:56
Where do I go from here?
About the Instructor
4.4 Average rating
134 Reviews
6,074 Students
3 Courses
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.

Report Abuse