In this class, students will learn how to build and decipher Excel functions (fx) in simplified terms.
The class will include exercises on automating processes with common Excel functions including VLookup, HLookup, transpose, split text, combine data, remove duplicates and also design a drop-down list within cells. All of this contributes to employee productivity by eliminating data entry and redundancy errors.
The students will also learn how to utilize built-in Excel features in order to easily manage large spreadsheets. This includes using multiple windows, freezing rows/columns, splitting windows, auditing formulas, watch unique cells and designing macros to further automate redundant processes.
In-class exercises include:
- Working through a functional spreadsheet and adding formulas and Excel features to automate an entire spreadsheet
- Create a simple macro to automate a complex and repetitive formula and redundant formatting tasks
Enroll in Excel Intermediate, Level 2
Dates & Times
Thursday, February 27, 2025, 8:30 a.m.-4:30 p.m.
Location
Zoom
Fees
$299 per person, includes all materials
Benefits of Attending
You will discover how to translate formulas into plain English. Once you can read a formula, you can master all kinds of complex calculations in Excel and it finally all makes sense. Plus you will learn the many secret attributes provided in Excel, but unless someone told you about them, you would never have known. This class is full of those tips.
Who Should Attend
Supervisors, team leaders, team members with reporting responsibilities or anyone with the desire to master their Excel skills.
Presenter
Andy Lanning is a self-taught computer “nerd” and has been training individuals and groups since 1996. She has taught computer VoTech classes at both Boise State and CWI, and is the owner of a computer consulting business. In addition, she is a Certified Microsoft Office Specialist and trains most Microsoft programs. With 20+ years of experience in the computer industry, Andy focuses every class on using software to solve common workflow issues.