Agenda

(may be covered in two sessions)

Excel 2016 Quick Start (Microsoft Support)

Basic Tasks in Excel (Microsoft Support)

1. Tour of layout: task bar, formula bar, worksheet
2. Define terms: cells, column, row, workbook, worksheet, active cell
3. Entering data
   • Cell reference
   • Moving around in the worksheet: enter key, tab key, arrow keys
   • Editing data: making a change, replacing data, deleting data
   • Copy and paste
   • Fill
   • Drag and drop cells
   • Hide columns or rows
4. Appearance
   • Resize column width or row height
   • Formatting cells
   • Labels – format text (bold, size), text wrap
   • Merge cells, border, fill color
5. Sorting data
   • Freeze panes
   • Filters
   • Custom sort
   • multiple variables
6. Calculations with formulas
   • Autosum
   • Multiply
7. Creating a chart

Links below are to Hoonuit video tutorials. Login to Hoonuit via our Wooster portal and use your College credentials.

Excel 2016

Which version of Excel? Office 2016 is available for download for Windows and Mac

Excel 2016

New features in Excel 2016 for Mac

Office 365

• OneDrive  OneDrive Training
• Excel online  Microsoft Excel Online

How to create Charts/Tables

Creating charts and tables from data