TOIT Training

30 Minutes (MS Office)

Outlook Online in 30 Minutes – Calendar

  • Navigating the calendar views
  • Adding and modifying calendar events
  • Creating and responding to meeting requests
41m
0
0

Outlook Online in 30 Minutes – Email

  • Navigating the Web App
  • Creating and reading email
  • Formatting text, adding hyperlinks, and attaching documents
27m
0
0

Brain Bites – Excel Dynamic Array Functions

  • Defining dynamic array functions 
  • Listing the characteristics of dynamic arrays  
  • Using the seven new dynamic array functions  
30m
0
0

Brain Bites – Workplace Violence Prevention (SB 553) for Employees

  • Defining Workplace Violence  
  • Defining Threat of Violence 
  • Differentiating among the 4 Workplace Violence types 
18m
0
0

Brain Bites – Workplace Violence Prevention (SB 553)for Plan Builders

  • 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 
31m
0
0

OneDrive in 30 Minutes (2024)

  • 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 
32h
0
0

Excel in 30 Minutes – Advanced PivotTables and Slicers

  • Applying and modifying PivotTable styles
  •  Formatting numbers
  •  Refreshing a PivotTable
24m
0
0

Excel in 30 Minutes – Creating PivotTables

  • Creating PivotTables using multiple methods
  •  Configuring the layout of a PivotTable
  •  Creating hierarchies and subtotals
36m
0
0

Excel in 30 Minutes – Visualizing Data with Charts

  •  Creating Dual-Axis and Combo charts
  •  Applying and modifying Trendlines on a chart
  •  Creating and applying Chart Templates
29m
0
0

Excel in 30 Minutes – Analyzing Data with Tables and Formatting

  • Creating a table from existing data
  •  Applying table tools to modify a table
  •  Formatting a table with Table Styles
32m
0
0

Excel in 30 Minutes – Querying and Subtotals with Lists

  • 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
18m
0
0

Excel in 30 Minutes- Sorting and Filtering Lists

  •  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
31m
0
0