Page History

...

• Excel 2016 for Mac Training

Tutorials

These links are (mostly) to Excel 2013 video tutorials. Most of these instructions will apply to Office 2016 as well. Some of the options will have different locations in the menus/ribbon in other versions of Excel.

• Creating and Editing a Workbook
• Freeze or lock panes
• Printing Excel Sheets and Workbooks
• Creating a Chart
• IF AND OR Functions
• Conditional Formatting, and Advanced Conditional Formatting
• VLOOKUP
• PivotTables
  • Filter data in a PivotTable in Excel 2016
  • Sort data in a PivotTable
• Password protect workbooks and worksheets
• Work with macros

...