Microsoft Excel Basics workshop

Links below are to Atomic Learning video tutorials. Login to Atomic Learning 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

New features in Excel 2016

Office 365

How to create Charts/Tables

  1. Creating charts and tables from data
  2. Changing the backgrounds
  3. APA style
  4. Make data visually appealing

Formulas/Functions

  1. Using operations
  2. Cell references: Relative and Absolute Cell References
  3. Manually typing functions
  4. AutoSum and AutoCalculate
  5. Average, Data & Time functions

Shortcuts

  1. How to duplicate to adjacent cells
  2. How to increase numbers consecutively
  3. Static versus dynamic cell references