Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 4.5 hours on-demand video
  • 34 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel Formulas and Functions

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

Learn to utilize Excel's Powerful Formulas to effortlessly Manage Information and become the Office Superstar
Rating: 4.5 out of 54.5 (119 ratings)
5,673 students
Created by Scott Falls
Last updated 1/2017
English
English [Auto]
30-Day Money-Back Guarantee

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

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

Course content

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

  • Preview04:25
  • Preview00:54
  • Preview01:17

  • Excellent Trick - Fill in the Blanks
    04:26
  • One More Thing
    00:56
  • Preview12:03
  • Learn Easiest Way to REMOVE DUPLICATES
    03:17
  • Learn Multiple Ways to Spot Trends Using CONDITIONAL FORMATTING
    13:31
  • Inserting and Formatting Clipart in Excel
    07:18
  • Instantly change the Row & Column Layout with TRANSPOSE
    03:09
  • TEXT TO COLUMNS - Split/Parse Data from one Column to Multiple Columns
    11:10
  • Using Multiple Formulas with CONDITIONAL FORMATTING
    06:59
  • Various Ways to Use & Format COMMENTS
    06:40
  • FILTER - Multiple ways to use filters in Microsoft Excel
    12:20

  • Calculate a Loan Payment using the PMT Formula
    10:32
  • Calculate the Loan Balance using PV
    05:18
  • 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
    04:22
  • Create your own Amortization Schedule in Excel
    08:26

  • RANDBETWEEN - Random Selections
    05:29
  • SUMIF & COUNTIF - How to Summarize by Specific Criteria
    07:35
  • SUBTOTAL vs SUM - Use Sum and Subtotals with Filters to Quickly Analyze Data
    10:09
  • SUMIF vs SUMIFS
    08:37
  • ROUND - ROUNDUP - ROUNDDOWN - Simple tricks
    09:24
  • CEILING, FLOOR & MROUND
    08:00

  • Merge Text with CONCATENATE
    09:19
  • Nested LEFT, RIGHT & MID using CONCATENATE
    06:27
  • Use the TRIM Formula
    04:36

  • AND & OR Formulas Explained
    04:49
  • IF FORMULA (Part I) - Learn Multiple Ways to Use the Excel IF Formula
    06:27
  • IF Formulas (Part II) - Nesting Multiple IF formulas
    07:28
  • IF Formula (Part III) Nesting different formulas within the IF Formula
    11:46
  • Working with Errors in Excel - ISERROR / ISNA
    09:13

  • VLOOKUP (Part I)
    11:16
  • VLOOKUP (Part II)
    08:36
  • Lookup (Part III) - The HLOOKUP
    08:25
  • Named Ranges & Lookups
    13:18

  • DATE - Use Text To Columns and Date to Fix Formatting Issues with Dates
    05:50

  • Where do I go from here?
    00:56

Instructor

Scott Falls
Excel Trainer/Teacher
Scott Falls
  • 4.4 Instructor Rating
  • 904 Reviews
  • 22,094 Students
  • 7 Courses

Hi, My name is Scott Falls and I've been working 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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.