- Navigating the calendar views
- Adding and modifying calendar events
- Creating and responding to meeting requests
- Navigating the Web App
- Creating and reading email
- Formatting text, adding hyperlinks, and attaching documents
- Defining dynamic array functions
- Listing the characteristics of dynamic arrays
- Using the seven new dynamic array functions
- Defining Workplace Violence
- Defining Threat of Violence
- Differentiating among the 4 Workplace Violence types
- Defining Workplace Violence and the 4 types of workplace violence
- Listing actions employers can take to help prevent workplace violence incidents
- Discussing potential behaviors that may lead to a workplace violence incident
- Describing the differences between OneDrive, OneDrive for Business, and SharePoint Document Libraries
- Accessing, editing, and sharing files using the web version of OneDrive for Business
- Accessing OneDrive documents from Microsoft apps on your PC, Mac, or mobile device
- Applying and modifying PivotTable styles
- Formatting numbers
- Refreshing a PivotTable
- Creating PivotTables using multiple methods
- Configuring the layout of a PivotTable
- Creating hierarchies and subtotals
- Creating Dual-Axis and Combo charts
- Applying and modifying Trendlines on a chart
- Creating and applying Chart Templates
- Creating a table from existing data
- Applying table tools to modify a table
- Formatting a table with Table Styles
- Calculating aggregates based on changing criteria using database functions such as DSUM and DAVERAGE
- Applying and modifying the SUBTOTAL function within a filtered list
- Adding Subtotals to data using the Subtotals feature
- Sorting data using Quick Sort options
- Sorting by multiple columns, custom lists, or colors using the Sort Options dialog box
- Applying Autofilter to view specific data