Master Excel Formulas, Tips & Tricks - Real-World Examples

Learn to utilize Excel's Powerful Formulas to effortlessly Manage Information and become the Office Superstar

Created byScott Falls

Last updated 11/2017

English

What you'll 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

Course content

9 sections • 40 lectures • 4h 44m total length

What is this Course all about?4:25
One More Thing Before We Get Started0:54
Downloadable Reference Files1:17
A quick walk-through showing you how to download the reference material.

Excellent Trick - Fill in the Blanks4:26
An Excellent trick to use when you need to fill in blank spaces with a table a data in Microsoft Excel
One More Thing0:56
One new thing I wanted to share
DATA VALIDATION12:03
Learn how to manage data with the excellent tool - Data Validation
Learn Easiest Way to REMOVE DUPLICATES3:17
Learn Easiest Way to REMOVE DUPLICATES in Excel
Learn Multiple Ways to Spot Trends Using CONDITIONAL FORMATTING13:31
Learn Multiple Ways to Spot Trends with Conditional Formatting
Inserting and Formatting Clipart in Excel7:18
Learn how to insert and manipulate clipart to use in reports and presentations.
Instantly change the Row & Column Layout with TRANSPOSE3:09
Use TRANSPOSE to Instantly Change the Row & Column Layout
TEXT TO COLUMNS - Split/Parse Data from one Column to Multiple Columns11:10
Learn multiple ways to parse data, split text from one column into multiple columns with Microsoft Excel's Text to Columns Tool
Using Multiple Formulas with CONDITIONAL FORMATTING6:59
Learn how to use multiple formulas to create complex & flexible conditional formatting
Various Ways to Use & Format COMMENTS6:40
Learn to use & format Comments in Excel
FILTER - Multiple ways to use filters in Microsoft Excel12:20
Multiple ways to use Filters in Microsoft Excel using real world examples.

Calculate a Loan Payment using the PMT Formula10:32
Calculate a Loan Payment using the PMT Formula
Calculate the Loan Balance using PV5:18
Calculate the maximum loan you can afford using a constant rate and payment.
Calculate the Total Remaining Payments of a Loan using NPER3:38
Calculate the Total Remaining Payments of a Loan using NPER
Calculate the Future Value of an Annuity Investment using the FV Formula5:57
Calculate the Interest Rate of a Loan using the RATE Formula4:22
Calculate the Interest Rate of a Loan using the RATE Formula
Create your own Amortization Schedule in Excel8:26
Create your own Amortization Schedule in Excel using the PMT, IPMT and PPMT formulas

RANDBETWEEN - Random Selections5:29
Use the Microsoft Excel formula RANDBETWEEN to create random selections. Great for Audit Sampling and Business.
SUMIF & COUNTIF - How to Summarize by Specific Criteria7:35
SUMIF & COUNTIF - How to Summarize by Specific Criteria
SUBTOTAL vs SUM - Use Sum and Subtotals with Filters to Quickly Analyze Data10:09
SUBTOTAL vs SUM - Use Sum and Subtotals with Filters to Quickly Analyze Data
SUMIF vs SUMIFS8:37
Learn the how to master Sumif and Sumifs in Microsoft Excel
ROUND - ROUNDUP - ROUNDDOWN - Simple tricks9:24
ROUND - ROUNDUP - ROUNDDOWN - Simple tricks to make your reporting much cleaner
CEILING, FLOOR & MROUND8:00
Learn to round numbers using multiples for greater flexibility.

AND & OR Formulas Explained4:49
Examples or how to use the AND & OR Formulas in Microsoft Excel
IF FORMULA (Part I) - Learn Multiple Ways to Use the Excel IF Formula6:27
Learn Multiple ways to use the amazingly useful IF THEN Statement in Microsoft Excel
IF Formulas (Part II) - Nesting Multiple IF formulas7:28
Using the IF Formulas (Part II) - Nesting Multiple IF formulas for greater flexibility
IF Formula (Part III) Nesting different formulas within the IF Formula11:46
Learn to Nest multiple different formulas in the IF formula for maximum flexibility.
Working with Errors in Excel - ISERROR / ISNA9:13
Learn how Hide or Format Errors in Excel using ISERROR / ISNA

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

See you inside!

Who this course is for:

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

Master Excel Formulas, Tips & Tricks - Real-World Examples

What you'll learn

Explore related topics

Course content

What is this Course all about?3 lectures • 7min

Excel Tips & Tricks11 lectures • 1hr 22min

Financial Formulas6 lectures • 38min

Math & Trig Formulas6 lectures • 49min

Text Formulas3 lectures • 20min

Logical Formulas5 lectures • 40min

Lookup & Reference Formulas4 lectures • 42min

Date & Time Formulas1 lecture • 6min

Where do I go from here?1 lecture • 1min

Requirements

Description

Who this course is for: