Learn How To Write Formulas And Identify And Use Functions In Excel (3 Hours w/certificate)

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.

Select Date & Time

US/Pacific

09 February 2023 Thursday, 12:30 PM PST

All Spots for this Live Webinar has been booked now.

Writing Formulas Is Easy Once

YOU UNDERSTAND THE BASICS

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 webinar! 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

Workshop Premium Instructor

Billy "Mr. Aloha" Wigley

Microsoft Certified Trainer (MCT)

As a Microsoft Certified Trainer, Billy "Mr. Aloha" Wigley is a Microsoft Office Expert in Excel. He has traveled throughout the USA, and other countries to teach Excel skills to thousands of students. In just five years, he personally trained more than 65,000 professionals in over 100 cities. He currently has more than 42,000 active online students. With over 25 years of leadership experience, and from having resided in various cities worldwide, Mr. Aloha is well-known around the world. With his strong USA and Colombian heritage, Mr. Aloha takes pride in his multi-cultural background and being able to reach both English and Spanish speakers around the globe.
Think of Mr. Aloha as your Excel coach!
Teaching these skills is all he does, and he is committed to helping students like you to achieve beyond what you believe you are capable of. He maintains regular office hours to serve his students worldwide.

Workshop Premium Instructor

Billy "Mr. Aloha" Wigley

Microsoft Certified Trainer (MCT)

As a Microsoft Certified Trainer, Billy "Mr. Aloha" Wigley is a Microsoft Office Expert in Excel. He has traveled throughout the USA, and other countries to teach Excel skills to thousands of students. In just five years, he personally trained more than 65,000 professionals in over 100 cities. He currently has more than 42,000 active online students. With over 25 years of leadership experience, and from having resided in various cities worldwide, Mr. Aloha is well-known around the world. With his strong USA and Colombian heritage, Mr. Aloha takes pride in his multi-cultural background and being able to reach both English and Spanish speakers around the globe.
Think of Mr. Aloha as your Excel coach!
Teaching these skills is all he does, and he is committed to helping students like you to achieve beyond what you believe you are capable of. He maintains regular office hours to serve his students worldwide.

Live Workshop Pricing

  • Formula Basics
  • $127 USD

    Pricing for Formulas Workshop

    Buy Now
  • Workshop is taught by a Microsoft Certified Trainer (MCT).
  • Completion Certificate with MCID
  • 3 Hour Info Packed Fun Session That Will Boost Your Excel Confidence!
  • 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.
  • Access to a Private Community where you can interact with others.
  •