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!
A quick walk-through showing you how to download the reference material.
An Excellent trick to use when you need to fill in blank spaces with a table a data in Microsoft Excel
One new thing I wanted to share
Learn how to manage data with the excellent tool - Data Validation
Learn Easiest Way to REMOVE DUPLICATES in Excel
Learn how to insert and manipulate clipart to use in reports and presentations.
Use TRANSPOSE to Instantly Change the Row & Column Layout
Learn multiple ways to parse data, split text from one column into multiple columns with Microsoft Excel's Text to Columns Tool
Learn how to use multiple formulas to create complex & flexible conditional formatting
Learn to use & format Comments in Excel
Multiple ways to use Filters in Microsoft Excel using real world examples.
Calculate a Loan Payment using the PMT Formula
Calculate the maximum loan you can afford using a constant rate and payment.
Calculate the Total Remaining Payments of a Loan using NPER
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
Use the Microsoft Excel formula RANDBETWEEN to create random selections. Great for Audit Sampling and Business.
SUMIF & COUNTIF - How to Summarize by Specific Criteria
SUBTOTAL vs SUM - Use Sum and Subtotals with Filters to Quickly Analyze Data
Learn the how to master Sumif and Sumifs in Microsoft Excel
Learn to round numbers using multiples for greater flexibility.
Learn how to use the Excel Formula Concatenate to merge data from individual cells into a single cell for analysis and reporting purposes.
Learn How to Use Nested LEFT, RIGHT & MID using CONCATENATE
Remove all leading and trailing spaces from text using the Excel Formula TRIM
Examples or how to use the AND & OR Formulas in Microsoft Excel
Learn Multiple ways to use the amazingly useful IF THEN Statement in Microsoft Excel
Using the IF Formulas (Part II) - Nesting Multiple IF formulas for greater flexibility
Learn to Nest multiple different formulas in the IF formula for maximum flexibility.
Learn how Hide or Format Errors in Excel using ISERROR / ISNA
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.
Learn how to manage recurring data with Named Ranges
Deconstruct and Recompile a Date into the Correct Date Format
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.