In this practical webinar, you will learn a handful of the most useful and often used formulas in Excel. These will include: VLookup, HLookup, Text to Columns, Concatenate, and remove Duplicates, and more!
WHY SHOULD YOU ATTEND?
Leery of those cryptic Excel Functions and syntax? The ultimate goal is to empower the attendees by demonstrating the most common formulas so they understand formula syntax to build and fix their own calculations as needed.
Attend this webinar and you’ll learn time-saving formulas that will improve your efficiency on projects.
AREA COVERED
- Text To Columns and then Reverse w/ Concatenate
- Use two types of IF Functions (Logical and Error)
- Understand the syntax of the VLookup and HLookup 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
WHO WILL BENEFIT?
- Anyone who is mostly self-taught in Excel, from beginner to advanced, will learn amazing tips in this webinar
Leery of those cryptic Excel Functions and syntax? The ultimate goal is to empower the attendees by demonstrating the most common formulas so they understand formula syntax to build and fix their own calculations as needed.
Attend this webinar and you’ll learn time-saving formulas that will improve your efficiency on projects.
- Text To Columns and then Reverse w/ Concatenate
- Use two types of IF Functions (Logical and Error)
- Understand the syntax of the VLookup and HLookup 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
- Anyone who is mostly self-taught in Excel, from beginner to advanced, will learn amazing tips in this webinar
Speaker Profile

Andy Lanning, owner, trainer, and Chief Nerd of Computer Software Training, LLC. Andy has 25+ years of experience teaching computer software in the corporate and university environments. She teaches basic to advanced levels in most Microsoft Office programs. She is adjunct faculty at Boise State University, since 1994 to present, where she specializes in computer training for the Center for Professional Development. She also travels to teach at company conferences across the U.S. Andy’s background includes corporate training, private training, and freelance data analysis. She has recorded several online training courses for Udemy.com, GoSkills.com, and in her career has delivered …
Upcoming Webinars

Dealing With Difficult People In Life & Work

How to Write Effective Audit Observations: The Principles f…

How to Document Employee Discussions and Why it is Important

OSHA Requirements for Supervisors, Project Leaders & HR - W…

FDA Compliance And Laboratory Computer System Validation

4-Hour Virtual Seminar on Transformational Leadership - The…

3-Hour Virtual Boot Camp on Easier Excel Automation with VB…


2025 Handbook Overhaul: Navigating Critical Updates! Federa…

Negotiating Skills For Professional Results - Winning Strat…

Excel Spreadsheets; Develop and Validate for 21 CFR Part 11…

Building Thriving Teams: Proactive Strategies for Managers …

Designing Employee Experiences to Build a Culture of Compli…

President Trumps Executive Orders And What They Mean to Emp…

Empowering Conflict Resolution: Letting Go to Gain Control

The Anti-Kickback Statute: 2025 - Year in Review

Navigating Alcohol and Drug Addiction Protections Under the…

50+ new Excel features so far this decade

FDA Technology Modernization Action Plan (TMAP) and Impact …

Form W-9 Compliance: TIN Verification, B Notices, and Avoid…

Workplace Investigations 101: How to Conduct your Investiga…

From Challenges to Compliance: Understanding Dietary Supple…


FDA Regulation of Artificial Intelligence/ Machine Learning

Utilizing HR Metrics to Illustrate & Improve Human Resource…

Outlook - Master your Mailbox - Inbox Hero Inbox Zero


Policy Pops: Navigating DEI in the 2025 Workplace: Strategi…

The Importance of the first 5 seconds when presenting

Do's and Don'ts of Documenting Employee Behaviour, Performa…

Why EBITDA Doesn't Spell Cash Flow and What Does

Understanding the incredible uses and fallbacks of ChatGPT

Mastering Performance Management: Strategies for Continuous…

The Monte Carlo Simulations in Excel for Risky Investments


Impact Assessments For Supplier Change Notices

Navigating FDA Regulations – A guide for medical device and…

California Meal and Rest Breaks: What You Don't Know Can Co…

Unlock Employee Loyalty: Stay Interviews Will Keep Them Eng…


Onboarding is NOT Orientation - How to Improve the New Empl…


Gossip-Free: Leadership Techniques to Quell Office Chatter

Female to Female Hostility @Workplace: All you Need to Know


6-Hour Virtual Seminar on Learning the Highlights of Excel …

The Five Cs Of Commercial Credit: The Basic Elements Of Cre…


2025 Top Employment Regulations That Will Impact Employers!

Building GMP Excellence: A Guide to Implementing Compliant …