Two sessions will be dedicated to the experienced Excel user to learn advanced features such as database functions, text functions, import .txt files, create advanced functions including: match/index, vlookup, countif, countifs, sumif, sumifs, if, proper, concatenate, Dbase: advanced filter options, create and edit macros, sparklines, and use data analysis using goal seek with data tables.
Note: If you also take Excel Level II, and Level IV you will earn a Certificate in Advanced Excel from USI.
ERROR: If you are seeing this message, you have reached an error. Try using an internet browser other than Internet Explorer (Google Chrome, Firefox, Safari). If you have tried a different browser and are still seeing this message, please call us at 812-464-1989.
Share this course with a friend:
“I would highly recommend the Excel classes provided by USI Outreach and Engagement. The new skills I learned, as well as the refreshers, have helped me better integrate my skills in the workplace. The spreadsheets I am creating now are being used by department leadership to assist in capacity planning and decision making, which in turn saves the hospital time and money.”
Kristin Reagan, MBA
Capacity Analyst
Information and Technology Services
Deaconess Hospital
