Productivity

From managing data to creating presentations, IT Training has a range of resources to help you learn about programs that will boost your productivity.

Many of our productivity titles focus on working with the Microsoft Office suite, and will help you get started with programs like Word, Excel, PowerPoint, Access, and Outlook. We also have resources focusing on making Microsoft Office documents accessible.

Learn more about our productivity courses and resources in the following sections of the page.

Getting Started

Are you just starting out with Microsoft Office? Check out the IT Training Microsoft 365 page for training on Microsoft 365 products (including Microsoft Teams, OneDrive, and SharePoint).

Microsoft 365 training

Certificates and resources

Earn a certificate

Earn a certificate focusing on productivity-related skills, including Access, Excel, and general Office productivity.

Excel Essentials certificate series [IU Expand]
Access Essentials certificate series [IU Expand]
Office Productivity certificate series [IU Expand]

Accessibility resources

Accessibility is important - following are trainings that will help you make sure your documents are accessible.

Creating Accessible Documents at Work [IU Expand]
Creating an Accessible Syllabus Using Microsoft Word [IU Expand]

Additional resources

Here are some additional resources focusing on productivity-related topics:

Office 365 Training from Microsoft: Microsoft's collection of free training resources, covering all Microsoft Office programs.
Microsoft Office Training on LinkedIn Learning: Explore an extensive collection of beginner and advanced training on Microsoft Office.

All productivity training

Explore the productivity titles offered by IT Training.

Access: Analyzing and Modifying Data with Queries

Gain familiarity with building queries and using advanced functions.

Access: Designing the Database Interface

Customize databases for your forms and reports

Access: Structuring and Relating Data

Learn how to define relationships and create relational queries

Access: The Basics

Take an intro to database terminology and relationship concepts

Creating Accessible Documents at Work

Use Microsoft Word's built-in tools to create accessible documents

Creating an Accessible Syllabus Using Microsoft Word

Discover how to use Microsoft Word's built-in tools to create an accessible syllabus

Documents: Formatting for Reports

Explore how to create attractive documents that are accessible to all.

Excel: Analyzing Data with PivotTables

Discover how PivotTables can simplify tasks and data analysis in Excel.

Excel: Basic Automation Using Macros

Explore ways to automate actions by recording and storing macros

Excel: Charts and Graphics

Focus on creating effective, accurate charts and templates

Excel: Formatting and Analyzing IUIE Data

Increase your comfort with formatting text and numeric IUIE data

Excel: The Basics

Work through essential skills like data entry, formulas, functions, and creating basic charts.

Excel: Working with Non-Numeric Data

Learn about some of Excel's many features for organizing non-numeric data.

Getting started with institutional storage at IU

Learn more about how to use IU's institutional file cloud storage solutions, Google Shared Drives and Microsoft shared storage.

Getting started with managing permissions for Microsoft and Google storage owners

Learn about the different ways to manage permissions in both Microsoft Teams and Google Shared Drives in this webinar recording.

Getting started with Microsoft Excel

Rows & columns? Numbers & letters? Formulas & functions? How do I even get started in Microsoft Excel? Attend this quick webinar and jump into Microsoft Excel spreadsheets!

Getting started with Microsoft PowerPoint

A brief introduction to using Microsoft PowerPoint to create presentations.

Getting Started with Microsoft Teams Calls

Familiarize yourself with the telephony features of Microsoft Teams.

Getting Started with Microsoft Teams Mobile

Communicate with colleagues, co-workers, and peers at IU on the go with the Microsoft Teams mobile app.

Getting started with PivotTables

A webinar covering the basics of creating and using PivotTables

Getting started with sorting and filtering in Microsoft Excel

A quick introduction to how to sort and filter

Getting started with Zoom - Hosting edition

Do you attend online Zoom meetings, but now you need to host one? How can you make it a productive meeting for you and your attendees? Zoom in to this webinar to learn how to be a great Zoom host!

Getting started with Zoom - Participant edition

Have you been invited to Zoom meetings, but don't know how to get started? How can you be the best attendee you can be? Zoom in and watch this recorded webinar to learn how to be an awesome meeting participant!

Google at IU My Drive: Individual File Management Basics

Learn more about Google at IU My Drive, including how to organize your files and collaborate with others.

Google Docs: The Basics

Explore the basics of creating and editing documents with Google Docs.

Google Sheets: Analyzing Data with Pivot Tables

Discover how pivot tables in Google Sheets make it easier to analyze data.

Google Sheets: Sorting and Filtering

Learn how to sort and filter data in Google Sheets.

Google Sheets: The Basics

Learn essential skills for working with Google Sheets like data entry, formulas, functions, and chart creation.

Google Sheets: Working with Non-Numeric Data

Learn about features in Google Sheets that help with organizing non-numeric data in spreadsheets.

Google Slides: Enhancing Your Presentation

Learn how to make your Google Slides presentation look its best

Google Slides: The Basics

Get started making presentations with Google Slides

Microsoft OneDrive at IU: Individual file management basics

Ready to unpack after the big move? Where are your boxes and how can you see what's in them? Plus share the contents? Watch this video after your individual files have been moved to your OneDrive account from Box at IU to learn how to find, organize, edit, and share your files on OneDrive.

Microsoft Planner: Managing Group Projects

Learn more about Microsoft Planner, a Kanban solution that allows teams to manage projects, tasks, and assignments.

Microsoft Teams Calls Desktop: Adding Someone to an In-Progress Call

Start a conference call by adding an additional person to a call that's already in progress in the desktop version of Microsoft Teams.

Microsoft Teams Calls Desktop: Configuring Your Voicemail

Configure your voicemail in Teams Calls through the Microsoft Teams desktop app.

Microsoft Teams Calls Desktop: Forwarding Calls to a Call Group

Set up a call group in Microsoft Teams for forwarding calls to.

Microsoft Teams Calls Desktop: Forwarding Calls to an Individual

Forward calls to an individual number in Teams Calls through the Microsoft Teams desktop app.

Microsoft Teams Calls Desktop: How to Answer a Call

See how to answer a phone call when using the Microsoft Teams desktop app.

Microsoft Teams Calls Desktop: How to Listen to Your Voicemail

See where to find your voicemail and how to listen to messages in the Microsoft Teams desktop app.

Microsoft Teams Calls Desktop: How to Make a Call

Make a phone call using the desktop version of Microsoft Teams.

Microsoft Teams Calls Desktop: How to Put a Call On Hold

Learn how to put a phone call on hold in the Microsoft Teams desktop app.

Microsoft Teams Calls Desktop: Transferring a Call

See how to transfer a call in Teams Calls through the Microsoft Teams desktop app.

Microsoft Teams Calls Mobile: Adding Someone to an In-Progress Call

Add someone to a call made using Teams Calls in the Microsoft Teams mobile app.

Microsoft Teams Calls Mobile: Calling Someone Using Their Phone Number

See how to call someone using their phone number using the Microsoft Teams mobile app.

Microsoft Teams Calls Mobile: Calling Someone Using Their Username

Call someone by searching for their username in Teams Calls through the Microsoft Teams mobile app.

Microsoft Teams Calls Mobile: How to Listen to Your Voicemail

See where to find your voicemail and how to listen to messages in Teams Calls through the Microsoft Teams mobile app.

Microsoft Teams Calls Mobile: How to Put a Call on Hold

Explore how to put a call on hold while in a call in the Microsoft Teams mobile app.

Microsoft Teams Calls Mobile: Transferring a Call

Transfer calls in Teams Calls using the Microsoft Teams mobile app.

Microsoft Teams: Attending Meetings

See how to join a meeting hosted in Microsoft Teams using your laptop or desktop, as well as how to join using a video conferencing device.

Microsoft Teams: Basic Collaboration and Project Management Tools

Learn about the basics of collaborating in Microsoft Teams at IU.

Microsoft Teams: Requesting and Managing a Team

Learn more about tasks related to requesting and managing a team in Microsoft Teams at IU.

Microsoft Teams: Scheduling Meetings

Learn about the different ways you can schedule a meeting in Microsoft Teams.

Microsoft Teams: Text Collaboration and Communication

Explore the text-based communication tools available in Microsoft Teams.

Microsoft To Do: Managing Individual Tasks

Create lists, organize tasks and more with Microsoft To Do.

Outlook: Calendar Essentials

Get the most out of Outlook features to personalize your calendar

Outlook: Managing Your Email

Turn your attention to organizing your inbox with advanced features

PowerPoint: The Basics

Tap into this broad overview to create a professional presentation

SharePoint Training Resources

Online resources to learn about Sharepoint.

Spreadsheets: Using the VLOOKUP Function

Explore how to use VLOOKUP in Microsoft Excel and Google Sheets

Understanding Storage in Microsoft Teams

Learn how to access Microsoft storage through Microsoft Teams, as well as how to share files stored in a team with others.

Understanding Storage with OneDrive and Microsoft 365

Gain a better understanding of how Microsoft storage works in OneDrive and the Microsoft 365 app.

Word: The Basics

Dig into Word's most popular formatting and organization features

Working with Mail Merge in Microsoft Office

Explore the basic and advanced features of Mail Merge in Microsoft Office.

Zoom: Automatic Live Transcription

Learn about Zoom's automatic live transcription feature.

Zoom: Installing and Updating the Zoom Desktop Client

Learn how to install the Zoom desktop client, as well as how to check for updates to Zoom.

Zoom: Logging in using Single Sign-on (SSO)

Many Zoom features are only available if you are signed in to the service. Learn how to sign-in to Zoom with Single Sign-On (or SSO) in this video.

Zoom: Managing disruptions during meetings

This video and article contain instructions about how to manage disruptive attendees during a Zoom meeting.

Zoom: Recording meetings

Learn how to record from zoom and save it to your computer.

Zoom: Scheduling and starting meetings

Learn how to schedule and start class sessions using Zoom.

Zoom: Setting Your Profile Picture and

Explore how to set your profile picture and change your display name in Zoom.

Zoom: Setting Your Profile Picture and Display Name

Explore how to change your profile picture and displayed name in Zoom.

Zoom: The Basics

This session covers the basics of installing and using Zoom.

Zoom: Tools for securing meetings

This video contains instructions on how you can secure your Zoom sessions to prevent unwanted disruptions before starting a meeting.

Zoom: Using breakout rooms

Learn how to use breakout rooms in Zoom.