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.
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.
Formula Basics
- The Order of Operations
- Please Excuse My Dear Aunt Sally
Cell Referencing
- Relative Reference
- Absolute Reference
- F4 is Your Friend
AUTOSUM Magic
- SUM
- AVERAGE
- MAX
- MIN
Working With Text
- The Text-to-Columns Tool.
- PROPER
- LOWER
- UPPPER.
AutoSum Function
- Use the AutoSum for next level 3D Referencing!
How To Use Functions
- What is a Function?
- XLOOKUP
Logical Functions
- The mysterious IF function made easy.
- Multi-level formulas!
- Nested Functions - functions inside of functions.
Dates and Times
- Dynamic Function.
- Static Function.
- NETWORKDAYS
- DAYS.
Quick Analysis
- Learn how to use the powerful Quick Analysis Tool.
- Put Ctrl+Q to use.
BONUS
- 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
-
$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.