1st 90 minutes: Tools of the Trade and Every Day 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.
Why you should Attend
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.
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 to two or more Columns
- Combine Text from Two Columns to 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
- Financial consultants
- Human Resource
- Logistics & Supply Chain
- Medical Devices
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.