Purchase any Event and get
20% Off
CODE: TWENTY20
T&C applicable, please referFAQ
Validity : 02nd Nov'24 to 12th Nov'24
Excel: Useful Formulas
- Flash Fill replaces complex Text-To-Columns and Concatenate functions
- Use two types of IF Functions (Logical and Error)
- Understand the syntax of the V- H- and X-Lookup formulas
- Transpose Data that may be organized incorrectly
- Remove Duplicates while staying in charge of the process with Conditional Formatting
- Name Box – Advanced level
- Absolute Ref vs Named Range in Formulas
- How to Audit Formulas
Overview of the webinar
In this practical webinar, you will learn and understand the syntax of a handful of the most useful and common formulas in Excel. These will include: VLookup, HLookup, XLookup, Flash Fill, Remove Duplicates, IF functions and more!
Who should attend?
- Anyone who is mostly self-taught in Excel, from beginner to advanced, you will learn amazing tips in this webinar.
Why should you attend?
Attend this webinar and learn time saving formulas that will improve your efficiency on projects.
This class demonstrates the most common formulas so attendees will understand formula syntax to build and fix their own calculations as needed.
Faculty - Ms.Andy Lanning
Andy Lanning has worked extensively with Microsoft Office products since the early 1990s.
She has traveled the United States presenting at conferences and corporate classes to help attendees unlock the full potential of the most common office software programs faced daily in our lives: Microsoft.
Andy considers herself a computer “nerd” and has been training individuals and groups since 1995. She continues to teach computer VoTech classes at Boise State University in Idaho and is the owner of a computer consulting business.
She is a Certified Microsoft Office Specialist and trains most Microsoft programs. With 30+ years’ experience in the computer industry, Andy focuses every class on using software to solve common workflow issues.
Be prepared to learn more than you bargained for in her class. Andy always teaches the 5 Super Secrets to computers and believes firmly in efficiency training.
“My goal is to lower frustration and raise productivity. And maybe have some laughs along the way!”
Software specialty areas include:
- Microsoft 365: Word, Excel, Outlook, PowerPoint, Publisher, Teams
- Excel topics: Charts and Data Visualization, Formulas, Hidden Tools of the Trade, Data Analysis tools, Pivot Tables and Power Queries
- Office Processes: mail merges, forms, databases, data analysis, including
- Power BI training
- How to set up accessible PDF and Word docs to comply with the US Federal
- ADA Law (American’s with Disabilities Act)
- Video Conferences: Zoom, Teams, and standalone VTC systems
- Internet and E-mail
- Computer Basics