Excel 2016 for Mac Introduction Quick Reference
The following topics are covered:
Page Layout vs. Normal View, Entering and Editing Data, Entering Data into a Selected Range, Replacing Cells, Clearing Cells, Inserting and Deleting Rows Columns and Cells, Column Width and Row Height, Best Fit, Formatting Numbers, Aligning Cell Contents, Borders and Shading, Clearing Formatting, Entering Dates, Entering a Sequence of Numbers.
Entering Formulas & Functions (SUM, AVERAGE, MAX, MIN, TODAY), Entering Functions Quickly, Absolute vs. Relative Cell References, Moving or Copying Data: Copying to Adjacent Cells; Cut, Copy, Paste & Drag/Drop.
Sheet Features: Renaming, Moving, Copying, Selecting, Inserting, Deleting.
Previewing, Printing and Page Breaks, Scaling the Printout, Repeating Rows/Columns on Every Page.
Also includes: Lists of Selection and Movement Shortcuts