The workshop Excel 2016: The Basics demonstrated how Excel can be used to organize information in worksheets and perform calculations on data using formulas and functions. We also created and modified simple charts from data.
Today's workshop will show how Excel can be used to import, extract, and manipulate data. In this workshop, we will explore some of Excel's table-related features, use the Auto Fill feature, specify data validation criteria, sort and filter data, and create a simple PivotTable. We will also use some Excel tools to help us manage multiple worksheets and work across worksheets. Our focus will be learning how to work more efficiently in Excel.