Level: Beginner Number of Sessions: 6 Session Length: 2 hours In this course, you will use Microsoft Office Excel 2016 to learn how to: Create, open, save, print, edit, and close worksheets and workbooks Insert, copy, move, delete, and rename worksheets Add headers and footers and prepare print layout Select, insert, define width/height, and delete columns and rows Hide and unhide rows, columns, and worksheets Create simple formulas and use defined functions (sum, average, min, max, and count) Use relative, absolute, and mixed references Format cells, and enter and format data Sort and filter data Find and replace data Auto and flash-fill data Remove duplicates Apply “Text to Column” Apply “Freeze Panes”