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”