Learn to Build and Decipher Excel Functions (fx)
Learn skills to increase your productivity by eliminating data entry and redundancy errors.
In-class exercises provide an opportunity to create automating processes with common Excel functions including VLookup, HLookup, Transpose, Split Text, Combine Data, Remove Duplicates, and how to design a drop down list within cells. You 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.
- Working through a functional spreadsheet and adding formulas and Excel features to automate an entire spreadsheet
- Creating a simple macro to automate a complex and repetitive formula and redundant formatting tasks.
To register for this workshop
Benefits of Attending Excel Intermediate – Level 2
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 will finally all make sense. You will also learn the many secret attributes provided in Excel you might have never known.
Who Should Attend
Supervisors, team leaders, team members with reporting responsibilities, or anyone with the desire to master their Excel skills.
Tue., Jun. 25, 2019, 9 a.m.- 4 p.m.
Human Resources, 2225 W University Dr, Boise, ID 83706
Andy Lanning – Andy is a self-taught computer “nerd” and has been training individuals and groups since 1996. She has taught computer vo-tech classes at both Boise State and CWI, 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.
$340 per person, includes all materials and parking.
Contact Us For More Information About Boise State Center for Professional Development
Phone: (208) 426-1709
Address: 2950 Magic View Dr., Ste. 188, Meridian, ID 83642