In this hands-on workshop, you will use a carefully crafted Excel instructional file to learn to clean and transform messy external data into beautifully formatted and printer-friendly data. You will also practice using Excel’s built-in tools to explore data. This beginner-friendly module covers navigating, selecting, formatting, filtering, and conditional formatting. Prerequisite: Excel 2016+ for desktop. 

After attending or viewing the workshop session, you will be able to: 

• Navigate and select cells, rows, columns, and spreadsheets including with the use of keyboard shortcuts. 
• Format cells, cell ranges, rows, columns, and tables of data using cell styles, spreadsheet themes, font tools, the format painter, and several options from the format cells menu. 
• Employ the filter tool and the conditional formatting tool to explore data. 
• Recognize the most appropriate data structures to use to leverage Excel’s in-built tools and functions, identify and resolve sources of potential problems.