Excel: Useful Formulas
Andy Lanning has worked extensively with Microsoft Office products since the early-1990s. She has traveled the United States presenting at conference and classes to help attendees unlock the full potential of the most common office software programs faced daily in our lives Microsoft.
Andy is a computer “nerd” and has been training individuals and groups since 1995. She has taught computer VoTech classes at both Boise State University 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 training.
Software specialty areas include:
- Microsoft Office: Word, Excel, Outlook, PowerPoint, Publisher
- Excel topics: Charts, Formulas, Hidden Tools of the Trade, Data Analysis tools
- Office Processes: mail merges, forms, databases, data analysis
- Video Teleconference (How to use for meetings and remote training)
- Internet and E-mail
- Computer Basics
Excel Formulas and Functions are different from each other in 1way: by who designs them. Formulas are created by you, the end-user, whereas Functions are pre-designed by Microsoft Excel programmers. This class is designed to remove the mystery from the language, or syntax, of the formula process. You will view multiple functions and their 2 separate help boxes. You will also see how to reverse-engineer existing formulas in order to make sense of them.
You will also see how to build in “controls” to double check your formulas in case of a mistake or miscalculation. Take this course and benefit from Andy Lanning’s 20+ years of experience. You will always learn more than you bargained for because this course has a multitude of tips-and-tricks that are woven into the presentation as she shows you how to master Formulas and Functions!
Calculations are a part of every business, and Excel Formulas and Functions are the mainstay and primary focus of the Excel program.
- Name Box – Advanced level
- Absolute Ref vs Named Range in Formulas
- Remove Duplicates
- Conditional Formatting
- Transpose Data
- Formula Auditing
- If Statements (aka Logical functions)
- VLookup, HLookup
- Text To Columns and Reverse w/ Concatonate
- If time allows: Protect a Worksheet or Workbook from RUIN!
Course Level - Intermediate-Advanced
Who Should Attend
There is no limit. If Excel is used, then this class appropriate
Why Should You Attend
The ultimate goal is to empower the attendees by demonstrating the most common formulas so they understand formula syntax to build their own calculations as needed.
Leery of those cryptic Excel Functions and syntax? Or frustrated when a working calculation suddenly stops working? Maybe feeling like you’ll never really “get” it? Attend this webinar and you’ll learn time-saving formulas the will improve your efficiency on projects.