Master Excel Formulas Tips & Tricks
4.5 (91 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,546 students enrolled
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.5 (91 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,546 students enrolled
Created by Scott Falls
Last updated 1/2017
English
Current price: $10 Original price: $25 Discount: 60% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • No Prerequisites necessary, just the desire to increase your skills using Microsoft Excel
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!

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


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

Preview 01:17
+
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
04:26

One new thing I wanted to share

One More Thing
00:56

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

Preview 12:03

Learn Easiest Way to REMOVE DUPLICATES in Excel

Learn Easiest Way to REMOVE DUPLICATES
03:17

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

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

Inserting and Formatting Clipart in Excel
07:18

Use TRANSPOSE to Instantly Change the Row & Column Layout

Instantly change the Row & Column Layout with TRANSPOSE
03:09

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
11:10

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

Using Multiple Formulas with CONDITIONAL FORMATTING
06:59

Learn to use & format Comments in Excel

Various Ways to Use & Format COMMENTS
06:40

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

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

Calculate a Loan Payment using the PMT Formula

Calculate a Loan Payment using the PMT Formula
10:32

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

Calculate the Loan Balance using PV
05:18

Calculate the Total Remaining Payments of a Loan using NPER

Calculate the Total Remaining Payments of a Loan using NPER
03:38

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

Calculate the Interest Rate of a Loan using the  RATE Formula

Calculate the Interest Rate of a Loan using the RATE Formula
04:22

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

Create your own Amortization Schedule in Excel
08:26
+
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
05:29

SUMIF & COUNTIF - How to Summarize by Specific Criteria

SUMIF & COUNTIF - How to Summarize by Specific Criteria
07:35

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
10:09

Learn the how to master Sumif and Sumifs in Microsoft Excel

SUMIF vs SUMIFS
08:37

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

Learn to round numbers using multiples for greater flexibility.

CEILING, FLOOR & MROUND
08:00
+
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
09:19

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

Nested LEFT, RIGHT & MID using CONCATENATE
06:27

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

Use the TRIM Formula
04:36
+
Logical Formulas
5 Lectures 39:43

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

AND & OR Formulas Explained
04:49

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

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

IF Formulas (Part II) - Nesting Multiple IF formulas
07:28

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

IF Formula (Part III) Nesting different formulas within the IF Formula
11:46

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

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

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

VLOOKUP (Part I)
11:16

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

VLOOKUP (Part II)
08:36

Learn to use the HLOOKUP formula.

Lookup (Part III) - The HLOOKUP
08:25

Learn how to manage recurring data with Named Ranges

Named Ranges & Lookups
13:18
+
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
05:50
+
Where do I go from here?
1 Lecture 00:56
Where do I go from here?
00:56
About the Instructor
Scott Falls
4.5 Average rating
143 Reviews
6,209 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.