Overview
Leery of those cryptic Excel Functions and syntax? The ultimate goal 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. And in this seminar, we have time to move into more advanced
formula features.
Plus, have you ever wished someone would just
tell you what you didn't know about Excel? It is amazing what has been
around the program since the beginning, and we will reintroduce some of
those features in this seminar.
Why you should Attend
1st 90 minutes: Tools of the Trade and Everyday Excel Hacks: These are
the old-school tips and tricks that have been forgotten by so many Excel
users. They will change how you handle your spreadsheets and data
projects and make you more efficient and productive.
2nd 90
minutes: Formulas and Functions: learn the most common, and also some
advanced formulas and understand formula syntax to build and fix your
own calculations as needed. These will include: VLookup, HLookup, IF
Error, SumIF, Nested IF functions, Text to Columns, Concatenate, and the
power of the Name Box when creating formulas.
A PDF handout will
be provided for download as well as an Excel file for practice and
review, or click along with the teacher to simulate a workshop training
environment.
Areas Covered in the Session
- Split Screen vs New Window
- Watch Window
- Auto Calculate Feature
- Transpose Data
- Remove Duplicates, combined with Filters and Conditional Formatting
- Conditional Formatting used as a control or alert; also embed into formulas
- Split Text into two or more Columns
- Combine Text from Two Columns into One
- Protect a Worksheet or Workbook from RUIN!
- Logical Functions: IF Error, SumIF, and Nested IF functions
- Name Box - Advanced level
- Understand the syntax of the VLookup and HLookup formulas
- Absolute Ref vs Named Range in Formulas
- Formula Auditing
Who Will Benefit
- Accountants
- Accounts
- Audit
- Aviation
- Banking
- CFOs
- Controllers
- CPAs
- Education
- Energy
- FDA
- Finance
- Financial consultants
- Human Resource
- Insurance
- Investments
- IT
- Logistics & Supply Chain
- Marketing
- Medical Devices
- Pharmaceutical
- Retail
- Sales
- Telecom
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 hundreds of courses and webinars on a variety of Microsoft topics.