Office 2013 training

Access

Beginner

• Design and build tables for a database (Access basics, part 1)

• Create table relationships (Access basics, part 2)

• Create your first Access 2013 database

• Introduction to queries (Access basics, part 3)

• Webinar: Intro to Access 2013

Intermediate

• Dealing with read-only queries

• Stop a query from asking for input

• Use parameter queries to filter query results

• Use update queries to change data in Access 2013

• Query criteria 2: Using date criteria in queries

Excel

Beginner

• Freeze or lock panes

Intermediate

• Add or subtract time

Advanced

• Webinar: Understanding Power Pivot in Excel 2013

• Webinar: Understanding the Excel Data Model

OneNote

Beginner

• OneNote help & learning​​​​​​​