Call us at +1-661-336-9555

cart

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!


  • 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

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.


  • Anyone who is mostly self-taught in Excel, from beginner to advanced, will learn amazing tips in this webinar

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 hundreds of courses and webinars on a variety of Microsoft topics.

View all trainings by this speaker
 
On Demand

Transcript

PDF Transcript of the Training which are available once the webinar is completed.(Transcript for single user only)

$179

Downloadable Recorded Session

Get unlimited access to the link for six months.

$239

USB

Free shipment within 15 Working Days, from the date of webinar completion.*

$350

 

Dec. 23, 2024

Understanding and Analyzing Financial Statements

Carl Young

Upcoming Webinars

Image

By Carl Young
Understanding and Analyzing Financial Statements
Date: Dec. 23, 2024

Image

By Marcia Zidle
Onboarding is Not Orientation: How to Improve Your New Hires’ Experience & Their Retention
Date: Dec. 23, 2024

Image

By Bob Verchota
Managing Toxic & Other Employees Who have Attitude Issues
Date: Dec. 23, 2024

Image

By Jenny Douras
Getting a Handle on Outlook Email
Date: Dec. 23, 2024

Image

By Diane L. Dee
Do's and Don'ts of Documenting Employee Behaviour, Performance, and Discipline
Date: Dec. 23, 2024

Image

By Beverly Beuermann-King
Gossip-Free: Leadership Techniques to Quell Office Chatter
Date: Dec. 27, 2024

Image

By Anirban Ghosh
SAP Security and GRC
Date: Dec. 27, 2024

Image

By Mike Thomas
Outlook - Master your Mailbox - Inbox Hero Inbox Zero
Date: Dec. 27, 2024

Image

By Bruce Lee
Harassment, Bullying, Gossip, Confrontational and Disruptive Behavior: A Manager's Guide on How to Detox and Neutralize a Negative Workplace
Date: Dec. 27, 2024

Image

By Susan Fahey Desmond
HANDLING FMLA ABUSE
Date: Dec. 30, 2024

Image

By Garrett Wasny
Excel & ChatGPT Synergy Masterclass: Unleashing Financial Analysis Superpowers
Date: Dec. 30, 2024

Image

By Jackie Kiadii
Introduction to Microsoft Power BI Dashboards
Date: Jan. 6, 2025

Image

By Wendy Sellers
Drive Recruiting Success with the Using Recruiting Metrics for Positive Change
Date: Jan. 6, 2025

Image

By Diane L. Dee
2025 EEOC & Employers: Investigating Claims of Harassment & Discrimination
Date: Jan. 6, 2025

Image

By Alan M Golden
Impact Assessments For Supplier Change Notices
Date: Jan. 7, 2025

Image

By Melveen Stevenson
Mastering Job Descriptions: Legal and Practical Insights for HR Pros
Date: Jan. 7, 2025

Image

By Bob McKenzie
Effective Onboarding: How to Welcome, Engage, and Retain New Employees with Your In-Person and Virtual On-boarding
Date: Jan. 7, 2025

Image

By Margie Faulk
What is in Store for Employers When Updating Employee Handbooks in 2025? Learn What Changes Will Impact Employees!
Date: Jan. 7, 2025

Image

By Rebecca Farabaugh
Designing Employee Experiences to Build a Culture of Compliance
Date: Jan. 7, 2025

Image

By Marcia Zidle
Onboarding Best Practices for 2025: Proven Strategies to Power Up Your New Hires’ Experience & Retention.
Date: Jan. 8, 2025

Image

By Richard E Cascarino
Accounting For Non Accountants : Debit, Credits And Financial Statements
Date: Jan. 8, 2025

Image

By Dr. B. Lynn Ware
Creating a Successful Job Rotation Program
Date: Jan. 9, 2025

Image

By William Mack Copeland
The Anti-Kickback Statute: Enforcement and Recent Updates
Date: Jan. 9, 2025

Image

By Carolyn Troiano
FDA Compliance And Laboratory Computer System Validation
Date: Jan. 9, 2025

Image

By Michael Healey
How To Create Psychological Safety in your Organization
Date: Jan. 10, 2025

Image

By Pete Tosh
Aligning Your HR Strategy with Your Business Strategy
Date: Jan. 10, 2025

Image

By Mark Gorkin
Transforming Anger And Conflict Into Collaborative Problem Solving: The Stress Doc’s Four Faces Of Anger – Model And Method
Date: Jan. 10, 2025

Image

By Bruce Lee
How to Give Corrective Feedback: The CARE Model - Eliminating Negative Behaviour, By Focusing On Accountability
Date: Jan. 13, 2025

Image

By Diane L. Dee
I-9 Audits: Strengthening Your Immigration Compliance Strategies in 2025
Date: Jan. 14, 2025

Image

By William A. Levinson
Zero Acceptance Sampling to Reduce Inspection Costs
Date: Jan. 14, 2025

Image

By Yedid Chavez
Identifying, Managing, and Retaining High Potential Employees
Date: Jan. 14, 2025

Image

By Terry Winship
AI at Your Service: Enhancing Your Microsoft OfficeSkills with AI as your Personal Assistance.
Date: Jan. 14, 2025

Image

By Ernest Worthman
The Four Horsemen of AI
Date: Jan. 15, 2025

Image

By Susan Fahey Desmond
Writing Effective Job Descriptions
Date: Jan. 15, 2025

Image

By Dev Strischek
Why EBITDA Doesn't Spell Cash Flow and What Does
Date: Jan. 15, 2025

Image

By Rachelle D Souza
FDA Recommendations for Artificial Intelligence/Machine Learning (AI/ML)-Enabled Device Software Functions
Date: Jan. 16, 2025

Image

By Charles H. Paul
Project Management for Non-Project Managers - How to communicate project actions and progress - conducting effective project review meetings
Date: Jan. 16, 2025

Image

By Paul J. Cline
Dealing With Difficult People In Life & Work
Date: Jan. 16, 2025

Image

By Meredith Crabtree
Developing and Implementing Quality Culture in the Organization and Why it’s Important
Date: Jan. 16, 2025

Image

By David Nettleton
2-Hour Virtual Seminar on the 6 Most Common Problems in FDA Software Validation and Verification
Date: Jan. 17, 2025

Image

By Abdelrahman Abdou
Enhancing Pivot Tables with Images: Visualize Your Data Like a Pro
Date: Jan. 17, 2025

Image

By Jonnie Keith
How to Write Effective Audit Observations: The Principles for Bullet Proofing Your Audit Findings
Date: Jan. 17, 2025

Image

By Kenneth M. Jones
How to Write Contracts for Procurement Professionals
Date: Jan. 22, 2025

Image

By William J. Rothwell
Uplifting the Credibility of HR: How to Build the Credibility of the HR Department
Date: Jan. 24, 2025

Image

By Pete Tosh
Strategic Interviewing & Selection: Getting the Right Talent on Your Team
Date: Jan. 27, 2025

Image

By Meredith Crabtree
Performance of Root Cause Analysis, CAPA, and Effectiveness Checks
Date: Jan. 27, 2025

Image

By Charles H. Paul
FDA Audit Best Practices - Do's and Don'ts
Date: Jan. 28, 2025

Image

By Marcia Zidle
Unlock Employee Loyalty: Stay Interviews Will Keep Them Engaged Before They Start Looking Elsewhere!
Date: Jan. 29, 2025

Image

By Margie Faulk
How to Manage the Legal Landmine of the FMLA, ADA and Workers Compensation in the Workplace!
Date: Jan. 30, 2025

Image

By Cathy Horwitz
Excel Lookup Functions: VLOOKUP, HLOOKUP, and XLOOKUP Made Easy
Date: Jan. 31, 2025

Image

By Dr. Susan Strauss
The Business Case for LGBTQIA+ Inclusion in the Workplace: Navigating Policies, Procedures, Practices.
Recorded Session

Image

By David R. Dills
Successful Strategies for FDA Expedited Pathways for Your Drug and Device Products
Recorded Session

Image

By Justin Muscolino
Updated Metro 2®, e-OSCAR and the New Tougher FCRA/CFPB Compliance Requirements
Recorded Session

Image

By Abdelrahman Abdou
Pivot tables beginner to advanced + 20 advanced Pivot table techniques
Recorded Session

Image

By Dr. Susan Strauss
Workplace Investigations 101: How to Conduct your Investigation Like a Pro
Recorded Session

Image

By Ginette M. Collazo
Human Error Reduction Techniques for Floor Supervisors
Recorded Session

Image

By Meredith Crabtree
From Challenges to Compliance: Understanding Dietary Supplement Oversight by the FDA
Recorded Session

Image

By Michael Healey
Conquer Toxic People - Learn To Protect Yourself And Get Your Sanity Back
Recorded Session

Image

By Alan M Golden
Validation Sampling Plans
Recorded Session

Image

By Paul J. Cline
4-Hour Virtual Seminar on Transformational Leadership - The Ultimate Leadership Course
Recorded Session

Image

By Richard E Cascarino
ChatGPT for Accountants
Recorded Session

Image

By Ginette M. Collazo
Building GMP Excellence: A Guide to Implementing Compliant Training Programs
Recorded Session

Image

By Dev Strischek
Construction Lending And Real Credit Administration: Evaluating, Underwriting, And Monitoring Construction Loans
Recorded Session

Image

By Jonnie Keith
What It Takes to be the Auditor-In-Charge
Recorded Session

Image

By Don Phin
Onboarding is NOT Orientation - How to Improve the New Employee Experience
Recorded Session

Image

By Marcia Zidle
So, You’re Now the “Boss”: Essential Skills to Succeed as a New Supervisor, Manager, Team Leader
Recorded Session

Image

By Audrey Halpern
Do's and Don'ts of Giving Effective Feedback for Performance Improvement
Recorded Session

Image

By Pete Tosh
Managing Toxic & Other Employees Who Have Attitude Issues
Recorded Session

Image

By Mike Thomas
Excel - Pivot Tables - The Key To Modern Data Analysis and Reporting
Recorded Session

Image

By Carolyn Troiano
FDA Technology Modernization Action Plan (TMAP) and Impact on Regulated Computer Systems and Data Integrity
Recorded Session

Image

By Edwin Waldbusser
How to Prepare For and Host a FDA Inspection and Respond to 483's
Recorded Session

Image

By Rebecca Staton-Reinstein
Project Management for administrative professionals
Recorded Session

Image

By Pete Tosh
Utilizing HR Metrics to Illustrate & Improve Human Resource's Contribution
Recorded Session

Image

By Cathy Horwitz
Transform Data into Insights: A Beginners Guide to Excel PivotTables
Recorded Session

Image

By Kelly Thomas
Establishing Appropriate Quality Metrics and Key Performance Indicators (KPIs)
Recorded Session

Image

By Ernest Worthman
Understanding the Artificial Intelligence Landscape
Recorded Session

Image

By Dr. Susan Strauss
Female to Female Hostility @Workplace: All you Need to Know
Recorded Session

Image

By Justin Muscolino
FFIEC BSA/AML Examination Manual: What Compliance Officers Really Need to Know?
Recorded Session

Image

By Danielle DeLucy
Sunshine Act Reporting - Clarification for Clinical Research
Recorded Session

Image

By Dr. B. Lynn Ware
What's New in Onboarding
Recorded Session

Image

By Dr. Susan Strauss
Tattoos, hijabs, piercings, and pink hair: The challenges of a dress & appearance code in 2024
Recorded Session

Image

By Bob McKenzie
With Mandatory Paid Leave Gaining Ground Is It Time To Do Away With Your PTO and Go Back to a Sick/Vacation Time Off Program
Recorded Session

Image

By William Mack Copeland
Marketing to Medicare or Medicaid Beneficiaries - What You Can and Cannot Do
Recorded Session

Image

By Susan Fahey Desmond
Documenting Misconduct that Will Stand Up in Court
Recorded Session

Image

By Marcia Zidle
Stressed Out: How to Handle Conflict, Difficult People and Challenging Situations
Recorded Session

Image

By Melveen Stevenson
Essential Job Functions According to the American with Disabilities Act (ADA)
Recorded Session

Image

By Melveen Stevenson
California Meal and Rest Breaks: What You Don't Know Can Cost You
Recorded Session

Image

By Robert Geary
Treasury Risk Management, Funding, Liquidity, Interest Rate, FX
Recorded Session

Image

By Marcia Zidle
AI-Powered Onboarding: How to Personalize, Streamline the New Hire Experience for Maximum Impact!
Recorded Session

Image

By Dr. Susan Strauss
2-Hour Virtual Seminar on How to Conduct an Internal Harassment and Bullying Investigation to Determine Facts and Minimize Liability
Recorded Session

Image

By Edwin Waldbusser
Human Factors Usability Studies Following ISO 62366 and FDA Guidance
Recorded Session

Image

By Dev Strischek
Better Business Writing - How to Write Right
Recorded Session

Image

By Patrick Haggerty
Form 1099 Update 2024: Latest Forms, Rules and Reporting Regulations
Recorded Session

Image

By Cathy Horwitz
6-Hour Virtual Seminar on Learning the Highlights of Excel - A Complete Set of Useful Tools
Recorded Session

Image

By Mike Thomas
Excel - Lists and Tables - A Beginner's Guide to Managing List-Based Data
Recorded Session

Image

By Michael D Haberman
How to Document Employee Discussions and Why it is Important
Recorded Session

Image

By Danielle DeLucy
Batch Record Review and Product Release
Recorded Session

Image

By Margie Faulk
Employee Handbook Requirements for 2024. Includes Updated Federal, State and Local Regulations as well as Multi-State Regulations
Recorded Session

Image

By Dr. Susan Strauss
2-Hour Virtual Seminar on The Complexity and Interplay Among ADAAA, FMLA, and Worker's Comp (WC) - How do they Work Together, or Not?
Recorded Session

Image

By Michael Healey
How to Survive an Emotionally Toxic Workplace
Recorded Session

Unsubscribe

×

Subscribe Here

×