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

  • WED
    29 MAR
  • 12:30 PM
29 March 2023 Wednesday, 12:30 PM PDT

Webinar Session has ended 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 formula Shortcuts, function Tips, and Power Tricks

Step right up and unravel the "Mystery Map of Excel" without having to embark on a long treasure hunt! This vivacious workshop is more like a magic show, revealing secret doors, hidden tunnels, and handy levers to navigate Excel with a wizard's ease. Be ready to swing your wand (or should we say, your cursor) like a professional sorcerer, right after this thrilling ride. So, buckle up and join our exciting expedition where learning Excel is not just education, it's a fun-filled adventure!

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
  • Meet the "Formula Builder" 
  • Learn how to find the right function
  • SUM 
  • AVERAGE 
  • MAX 
  • MIN
  • The Text-to-Columns Tool
  • PROPER 
  • LOWER 
  • UPPPER.
  • Dynamic Function
  •   Static Function
  • NETWORKDAYS  
  • DAYS.
  • The mysterious IF function made easy.  
  • Multi-level formulas!  
  • Nested Functions - functions inside of functions.
  • An introduction to Dynamic Arrays
  • What is a Spill?
  • The Spilled range operator #
  • The famous VLOOKUP 
  • The NEW and improved version of the VLOOKUP - the XLOOKUP
  • Learn how to use the powerful Quick Analysis Tool
  • Put Ctrl+Q to use.
  • Multi-level SUBTOTALS

Workshop Premium Instructor

Billy "Mr. Aloha" Wigley

Author/Microsoft Certified Trainer (MCT)

Meet Billy "Mr. Aloha" Wigley: not just a Microsoft Certified Trainer, but a maestro of Excel!
His expertise has fueled a globe-spanning educational odyssey, crisscrossing the United States and beyond to ignite the Excel capabilities of thousands. Within an impressive five-year span, he personally elevated the skills of over 65,000 professionals across 100+ vibrant cities. At present, Billy's digital classroom brims with the energy of 55,000 active online students, all soaking up his vast Excel knowledge. A testament to his teaching prowess, indeed! With a rich tapestry of 25 years of leadership experience, Billy's influence resonates globally. His strong USA and Colombian heritage infuses his teaching approach with a unique multicultural flair, enabling him to connect with both English and Spanish speakers around the world. Picture Billy as your personal Excel champion, your guide on this journey of numerical mastery. Teaching Excel isn't just his job - it's his calling, his passion. He's committed to propelling students like you beyond perceived limits, unlocking potential you never knew you had. And no matter where you are in the world, Billy's there for you, maintaining regular office hours to ensure every student gets the support they need.  
So, ready to dive into the world of Excel with Mr. Aloha at the helm? Your journey towards Excel mastery starts now!

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

Most popular

Formula Basics

$5997 USD

  • Pricing for Formulas Workshop

    • 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 60 day 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.
Buy Now