Designed to take the Intermediate user to the Advanced level, this class will build on your MS Excel skills to more efficiently organize, summarize, and interpret data. We will use pivot tables to automatically sort, count, total, or average the data stored in one table or spreadsheet. Additionally, we will also use LookUp Functions to query data tables. Finally, we will examine an array of important Data Tools, including sorting, filtering, data validation, text-to-columns, conditional formatting, and more.
Ultimately, you will leave this class with a more efficient approach to Excel for application at work or home. Students for this course should have a strong background in MS Excel. Please bring a thumb drive to back up your data. Although this course is taught in a PC lab, skills are transferable to Mac.