LIVE HANDS-ON WORKSHOP

Learn How To Write Formulas And Identify And Use Functions In Excel

26 JANUARY 2022 WEDNESDAY, 08:00 PM PST

If you are stuck and need help with your Excel work, this workshop is for you!

Days

18

Hours

04

Minutes

54

Seconds

31

Writing Formulas Is Easy Once

YOU UNDERSTAND THE BASICS

If you are stuck and need help with your Excel work, this workshop is for you! In this hands-on Excel Formula Basics workshop, you’ll learn how to think in formulas and how to write formulas in Excel. By the end of this workshop, you’ll be able to work with Excel’s most commonly used functions and you’ll have the confidence to create your own formulas.

Learn Excel Power Shortcuts, Tips, and Tricks

It takes years of using the program before you learn all of these “Secrets of Excel." That's why I have developed this workshop full of Shortcuts, Tips, and Tricks that will flatten your learning curve. You will be using Excel like a professional within seconds of participating in this workshop! Click on any of the topics to expand its contents.

  • The Order of Operations
  • Please Excuse My Dear Aunt Sally
  • Relative Reference
  • Absolute Reference
  • F4 is Your Friend
  • SUM
  • AVERAGE
  • MAX
  • MIN
  • The Text-to-Columns Tool.
  • PROPER
  • LOWER
  • UPPPER.
  • Use the AutoSum for next level 3D Referencing!
  • What is a Function?
  • XLOOKUP
  • The mysterious IF function made easy.
  • Multi-level formulas!
  • Nested Functions - functions inside of functions.
  • Dynamic Function.
  • Static Function.
  • NETWORKDAYS
  • DAYS.
  • Learn how to use the powerful Quick Analysis Tool.
  • Put Ctrl+Q to use.
  • Multi-level SUBTOTALS

BILLY WIGLEY

Your Premium Instructor is a Microsoft Certified Trainer with over 31,636 students enrolled in his courses on Udemy and more than 9,719 positive reviews. He always says: "Don't Get Mad...Get Skills!"

LIVE

MICROSOFT CERTIFIED TRAINER

Microsoft Certified Trainers (MCTs) are the premier technical and instructional experts in Microsoft technologies.

Trusted by These Companies

Formulas And Functions Live Workshop Pricing

  • Formula Basics
  • $54 USD

    Pricing for Formulas Workshop on 1/26/22

    Buy Now
  • Workshop is taught by a Microsoft Certified Trainer (MCT).
  • You can hear the instruction, ask questions, all in real-time!
  • You get UNLIMITED access to the workshop recording and the Excel workbook.
  • Learn To Write Formulas That Make You Genius Like!
  • Custom Built Excel Workbook For Hands On Workshop.
  •