Session Description: Microsoft Excel is an intimidating program. In this half-day session, join Bill Jelen from MrExcel.com to learn how you can efficiently use Microsoft Excel for reporting Infection Control trends. Bill will show you powerful tips and tricks in Excel. Learn how to link data from multiple workbooks to one reporting dashboard workbook. Use the amazing Transform tools in Excel to clean and summarize large data sets. Use Excel Graphs to show trends over time. Use the Excel Forecasting tools to forecast flu season. Using Excel’s mapping tools to illustrate outbreak tracing. Everyone who attends will receive a printed copy of Bill’s book with powerful Excel tricks and a download folder with all of the examples from the class that you can adapt for your own use. Bill offers all students in his classes free Excel support after the class.
Laptops are optional. There will be some hands-on examples that you can follow along with. But most of the half day will be spent showing you how to use powerful but hidden features in Excel.
Learning Objectives:
Learn how to link data from multiple workbooks into one workbook.
Customize Excel graphs for showing CLABSI rates.
Use Excel’s mapping tools to show outbreaks.
Use forecast tools in Excel to predict seasonal influenza.