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

 

Oct. 31, 2024

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

Melveen Stevenson

Upcoming Webinars

Image

By Melveen Stevenson
California Meal and Rest Breaks: What You Don't Know Can Cost You
Date: Oct. 31, 2024

Image

By Don Phin
Onboarding is NOT Orientation - How to Improve the New Employee Experience
Date: Oct. 31, 2024

Image

By Kenneth M. Jones
New York State Procurement Overview
Date: Nov. 1, 2024

Image

By Edwin Waldbusser
Human Factors Usability Studies Following ISO 62366 and FDA Guidance
Date: Nov. 1, 2024

Image

By Diane L. Dee
Blending Virtual & In-Person Onboarding to Welcome, Engage & Retain New Hires in 2025
Date: Nov. 4, 2024

Image

By Meredith Crabtree
Performance of Root Cause Analysis, CAPA, and Effectiveness Checks
Date: Nov. 4, 2024

Image

By Ginette M. Collazo
Building GMP Excellence: A Guide to Implementing Compliant Training Programs
Date: Nov. 4, 2024

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
Date: Nov. 4, 2024

Image

By Susan Fahey Desmond
Documenting Misconduct that Will Stand Up in Court
Date: Nov. 5, 2024

Image

By Payson Hall
A Modest PMBOK® Guide Proposal: Project Blame Management (Satire)
Date: Nov. 6, 2024

Image

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

Image

By William Mack Copeland
Marketing to Medicare or Medicaid Beneficiaries - What You Can and Cannot Do
Date: Nov. 6, 2024

Image

By Marcia Zidle
AI-Powered Onboarding: How to Personalize, Streamline the New Hire Experience for Maximum Impact!
Date: Nov. 6, 2024

Image

By Marcia Zidle
So, You’re Now the “Boss”: Essential Skills to Succeed as a New Supervisor, Manager, Team Leader
Date: Nov. 7, 2024

Image

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

Image

By Pete Tosh
Managing Toxic & Other Employees Who Have Attitude Issues
Date: Nov. 7, 2024

Image

By Carolyn Troiano
FDA Compliance And Laboratory Computer System Validation
Date: Nov. 7, 2024

Image

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

Image

By Audrey Halpern
Managing Complex Projects - Project Management
Date: Nov. 8, 2024

Image

By Meena Chettiar
Design Verification, Validation and Testing for Medical Devices
Date: Nov. 8, 2024

Image

By Jose Ignacio Mora
21 CFR Part 820 - Quality System Regulation - Applying Principles of Lean Documents and Lean Configuration
Date: Nov. 8, 2024

Image

By Richard E Cascarino
Tips and Techniques for Conducting an Effective Fraud Risk Assessment
Date: Nov. 8, 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: Nov. 8, 2024

Image

By Bob Verchota
Performance Management: Dealing With The Difficult Employee
Date: Nov. 12, 2024

Image

By Robert Geary
Treasury Risk Management, Funding, Liquidity, Interest Rate, FX
Date: Nov. 13, 2024

Image

By Gary Heppner
OSHA Requirements for Supervisors, Project Leaders & HR - What do they need to be Responsible for
Date: Nov. 13, 2024

Image

By Pete Tosh
Improving Employee Engagement & Retention Through Stay Interviews
Date: Nov. 14, 2024

Image

By Joseph Wolfe
HIPAA Bootcamp for Health Care Providers, Professionals, and Business Leaders.
Date: Nov. 14, 2024

Image

By Melveen Stevenson
Essential Job Functions According to the American with Disabilities Act (ADA)
Date: Nov. 14, 2024

Image

By Justin Muscolino
FFIEC BSA/AML Examination Manual: What Compliance Officers Really Need to Know?
Date: Nov. 14, 2024

Image

By Garrett Wasny
Introduction to Generative AI for Accountants
Date: Nov. 15, 2024

Image

By Justin Muscolino
Updated Metro 2®, e-OSCAR and the New Tougher FCRA/CFPB Compliance Requirements
Date: Nov. 15, 2024

Image

By Paul J. Cline
Dealing With Difficult People In Life & Work
Date: Nov. 15, 2024

Image

By Michael Healey
Conquer Toxic People - Learn To Protect Yourself And Get Your Sanity Back
Date: Nov. 15, 2024

Image

By Jonnie Keith
How to Write Effective Audit Observations: The Principles for Bullet Proofing Your Audit Findings
Date: Nov. 18, 2024

Image

By Mark Gorkin
Surviving and Thriving Organizational Change and Loss: The Science of Psychological Hardiness
Date: Nov. 18, 2024

Image

By Cathy Horwitz
3-Hour Virtual Seminar on Excel Deep Dive: Advanced Tips & Techniques
Date: Nov. 18, 2024

Image

By Alan M Golden
Impact Assessment and Risk Management for Change Control
Date: Nov. 18, 2024

Image

By William J. Rothwell
Effective Succession Planning
Date: Nov. 19, 2024

Image

By Don Phin
Marijuana: Compliance and Safety in the Workplace
Date: Nov. 19, 2024

Image

By Marcia Zidle
Stressed Out: How to Handle Conflict, Difficult People and Challenging Situations
Date: Nov. 19, 2024

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
Date: Nov. 19, 2024

Image

By Edwin Waldbusser
FDA Regulation of Artificial Intelligence/ Machine Learning
Date: Nov. 19, 2024

Image

By Bob McKenzie
Coming Soon - New Minimum Salary Levels for Exempt Employees, Are You Ready?
Date: Nov. 19, 2024

Image

By David Nettleton
Data Integrity: Compliance with 21 CFR Part 11, SaaS-Cloud, EU GDPR
Date: Nov. 20, 2024

Image

By Susan Fahey Desmond
Writing Effective Job Descriptions
Date: Nov. 21, 2024

Image

By Bruce Lee
How to Give Corrective Feedback: The CARE Model - Eliminating Negative Behaviour, By Focusing On Accountability
Date: Nov. 21, 2024

Image

By Meredith Crabtree
SOPs - How to Write Them to Satisfy those Inspectors
Date: Nov. 21, 2024

Image

By Dev Strischek
Why EBITDA Doesn't Spell Cash Flow and What Does
Date: Nov. 21, 2024

Image

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

Image

By Dr. John Ryan holds
Food Safety And Quality In Home Food Delivery
Recorded Session

Image

By Margie Faulk
New Domestic Violence, Sexual Assault and Stalking Leave Notice Regulations! What Should Employers do to Ensure Compliance?
Recorded Session

Image

By Janette Levey Frisch
Wage and Hour Issues - The Exempt Vs Non-Exempt
Recorded Session

Image

By Miles Hutchinson
Nonresident Alien Information Reporting Using Forms 1042-S And W-8
Recorded Session

Image

By Ronald Sereika
Analyzing Financial Statements
Recorded Session

Image

By Deborah Covin Wilson
Managing Medical Leave In California, What'S The Difference Between Fmla, Cfra And Pdl
Recorded Session

Image

By Donna K Olheiser
What Are Ach Payments, How Do They Work And What Does That Mean - Essentials Of Ach Payments
Recorded Session

Image

By Margie Faulk
Due Diligence Steps For Form 1099
Recorded Session

Image

By Paul J. Sanchez
Capital Ratio Computations For Depository Institutions
Recorded Session

Image

By Catherine M. Mattice
Employee Engagement: Keeping Your Workforce Motivated To Improve Results
Recorded Session

Image

By Toni G. Cesta
Compliance Measures For Case Management
Recorded Session

Image

By Thomas Nollner
How To Identify & Monitor Your High Risk Customers
Recorded Session

Image

By Neil Malek
Mastering Excel Pivot Tables: The Ace Analytical Tool Of Excel Instead
Recorded Session

Image

By Deborah Covin Wilson
Workplace Civility - Respectful Habits Lead To Increased Productivity, Decreased Liability
Recorded Session

Image

By Ray Graber
Credit Card Surcharging - Who Is Going To Do It And What Are The Stipulations For Compliance?
Recorded Session

Image

By Janette Levey Frisch
Interview Questions And Pre-Employment Screening What Every Employer Needs To Know - Title Vii, Ada/Adaaa, Pdl, Gina, I-9S And Affirmative Action
Recorded Session

Image

By David H. Ringstrom
Excel Proficiency: Pivot Table Basics
Recorded Session

Image

By Paul J. Sanchez
Use Of Analytical Procedures (Aps) For Accountants, Auditors, Financial Analysts And Others
Recorded Session

Image

By David H. Ringstrom
Excel Proficiency: Dashboard Time-Saving Tactics
Recorded Session

Image

By Catherine M. Mattice
Bullying Versus Harassment Versus Violence: Understanding The Similarities And Differences, And Risks For Employer Liability
Recorded Session

Image

By Danielle DeLucy
Preparing And Investigating Oos/Oot Results In A Regulated Environment
Recorded Session

Image

By Joy McElroy
Gaining And Re-Establishing Control Of Your Cleanroom
Recorded Session

Image

By Teddy Burriss
Writing an Effective Investigative Case Report
Recorded Session

Image

By Lisa Marsden
Application Of New Cms Quality Indicator Process In Healthcare And Food Service
Recorded Session

Image

By E. Pete Lewis
Uncovering Overlooked Tax Breaks : Planning Considerations in 2018
Recorded Session

Image

By Mike Thomas
Excel Power Query: The Powerful Get & Transform Tool for Importing and Manipulating Data
Recorded Session

Image

By Karla Brandau
Catapult Your Career with Microsoft Outlook Productivity Tools
Recorded Session

Image

By Deborah Covin Wilson
Managing Medical Leave In California: What’S The Difference Between Fmla, Cfra And Pdl
Recorded Session

Image

By Jeff Kasoff
Best practices for purchasing and supplier controls in the medical device industry
Recorded Session

Image

By Candace Curry Leuck
Finance for Non-Financial Managers: Accounting, Analysis and Budgeting
Recorded Session

Image

By Loren Gelber
FDA Regulations for Pharmaceutical Good Manufacturing Practice (GMP)
Recorded Session

Image

By Rebecca Staton-Reinstein
Leaders Who Win: 7 Strategies for CEO Success You Need Now
Recorded Session

Image

By Marcia Zidle
Workplace Conflict: How to Handle Disagreements, Difficult People, Tough Situations and Be Less Stressed
Recorded Session

Image

By Paul R Hales
Hipaa Social Media Violations - Widespread, Risky, Highly Visible - Learn The Two Simple Steps To Comply With Hipaa
Recorded Session

Image

By Ronald L. Adler
HR Metrics: 2018 Update
Recorded Session

Image

By David E Sanders
Child Support and Garnishments - All You Need To Know
Recorded Session

Image

By Paul J. Sanchez
Analytical Tools - Use of Financial Statement Analytical Procedures (APs) Designed to Focus on Bank Areas of Concern
Recorded Session

Image

By Robert Peoples
Technical Writing Best Practices
Recorded Session

Image

By Margie Faulk
Multi-state Regulation Coordination! Learn How Employers Can Ensure Compliance with Current, New and Proposed State Specific Laws!
Recorded Session

Image

By Candace Curry Leuck
Preparing the Statement of Cash Flows
Recorded Session

Image

By Teddy Burriss
Using Linkedin As A Business Tool
Recorded Session

Image

By Deborah Covin Wilson
Is it FMLA or the "Friday-Monday Leave Act"? How to Identify and Investigate Employees Who Are Gaming the System
Recorded Session

Image

By Janette Levey Frisch
Guidelines For Dealing With Psychiatric Issues At Work
Recorded Session

Image

By Paul J. Sanchez
Accounting for Income Taxes – A Timely Refresher and Update
Recorded Session

Image

By Lisa Marsden
Third Party Vendor Risk Assessment for Financial Firms - Rules, Regulations and Best Practices
Recorded Session

Image

By Laura Goodrich
Innovate and Create by Leveraging The Power of Generations
Recorded Session

Image

By Gregory Powell
The ABCs of Document Retention & Retrieval
Recorded Session

Image

By Donna K Olheiser
2018 NACHA Operating Rules: An Update on Changes Ahead
Recorded Session

Image

By Michael D Haberman
How to Conduct Workplace Investigations - Best Practices and Know How's
Recorded Session

Image

By Mike Thomas
Microsoft Excel: Creating an effective and balanced KPI Dashboard for HR Professionals
Recorded Session

Unsubscribe

×

Subscribe Here

×