For full functionality of this site it is necessary to enable JavaScript. Here are the instructions how to enable JavaScript in your web browser.

Excel: Useful Formulas

Andy is a computer "nerd" and has been training individuals and groups since 1995. She has taught computer VoTech classes at both Boise State Univ. and the College of Western Idaho and is the owner of a computer consulting business. She is a Certified Microsoft Office Specialist and trains most Microsoft programs. With 20+ 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 train........

Read More

This Webinar qualifies for a recertification credit hour that may be counted toward SHRM-CP and SHRM-SCP recertification from SHRM.
This Lecture contains 1 Credit.


Calculations are a part of every business, and Excel Formulas and Functions are the mainstay and primary focus of the Excel program

Why should you attend?

Have you ever been confused by Excel's Functions and formula syntax? The goal of this webinar is to empower the attendee 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 the will improve your efficiency on projects.

Areas Covered in the Session:

  • Text To Columns and then Reverse w/ Concatonate
  • 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 can Benefit:

Anyone who is mostly self-taught in Excel, from beginner to advanced, you will learn amazing tips in this webinar.
Webinar Id: DBISP37

Duration: 60 mins

No reviews yet!!


Refund Policy

Webinars of Andy Lanning
Excel: Pivot Tables Crash Course
Presenter: Andy Lanning

View Anytime
Price: $167
Status: Archived

Excel - Creating High Impact Business Repor...
Presenter: Andy Lanning

View Anytime
Price: $231
Status: Archived

Webinars of Soft Skills
Leadership Development for Executive Assist...
Presenter: Rebecca Staton-Reinstein

View Anytime
Price: $301
Status: Archived

Zap! You're a manager: getting off on the r...
Presenter: Rebecca Staton-Reinstein

View Anytime
Price: $167
Status: Archived