WORD

Learn how to create, format, share, and print a wide variety of documents in Word. Trainer covers creating new documents from templates and scratch, formatting text and pages, working with headers and footers, using themes and styles, adding multimedia, and more. Trainer will also show how to share documents with others and enhance your productivity with macros.

Topics include:

• Using templates to create new documents
• Creating and editing text
• Formatting text, pages, and paragraphs
• Adjusting line spacing and page breaks
• Adding headers, footers, and page numbers
• Applying styles and themes to documents
• Creating bulleted and numbered lists
• Working with tables, macros, and building blocks
• Illustrating documents
• Proofing, reviewing, and printing documents
• Collaborating with others via OneDrive and email
• Customizing Word

EXCEL

Start mastering Excel, the world's most popular and powerful spreadsheet program. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables.

Topics include:

• Working with the Excel interface
• Entering data
• Creating formulas and functions
• Formatting rows, columns, cells, and data
• Working with alignment and text wrap
• Adjusting rows and columns
• Finding and replacing data
• Printing and sharing worksheets
• Creating charts and PivotTables
• Inserting and deleting sheets
• Using power functions such as IF and VLOOKUP
• Password-protecting worksheets and workbooks
• Sorting data
• Analyzing data with Goal Seek and Solver
• Creating and running macros

POWERPOINT

Learn how to best create, edit, and share presentations with PowerPoint, the popular presentation platform. Trainer shows how to build a slideshow from scratch or leverage PowerPoint templates and themes for quick construction. Trainer then demonstrates how to add and edit text, images, graphs, video, and animation; format slides for consistency; and add speaker notes and transitions to ensure a smooth delivery.

Topics include:

• Connecting PowerPoint to OneDrive
• Creating presentations from themes and templates
• Using and editing slide masters
• Changing the layout or theme
• Adding pictures and objects
• Working with bullet points, text boxes, and tables
• Adding shapes, diagrams, and charts
• Incorporating video, audio, and animation
• Adding speaker notes and comments
• Running a slideshow
• Reusing and sharing PowerPoint presentations

OUTLOOK

Learn how to best set up and manage email, calendars, and contacts in Outlook. This course begins with a tour of the interface and shows how to connect to a wide variety of email accounts, as well as OneDrive for online file storage. Trainer then shows how to quickly create, send, and read email and reduce your inbox clutter; organize, group, and share contacts; and stay on schedule with calendars and tasks.

Topics include:

• Connecting accounts: Exchange, Office 365, IMAP, and POP
• Searching for mail
• Saving attachments
• Organizing mail with flags and folders
• Creating new messages
• Working with contacts in the People hub
• Adding delegates to act on your behalf
• Creating meetings
• Creating tasks and notes
• Backing up and moving Outlook data

ACCESS

Learn how to build databases to store and retrieve your data more efficiently with Access. Trainer shows how to use the powerful program to wrangle your data and create your first table, and highlights smart strategies to edit and modify fields and records.

The course also shows you how to build queries and action queries, create and design forms, use macros, integrate Access with the rest of the Office suite, and maintain your databases over time.

Topics include:

• Creating a new database
• Creating tables and new data types
• Importing and entering data
• Setting up relationships and primary keys
• Adding validation rules
• Sorting and filtering table data
• Building queries
• Designing forms
• Creating reports
• Attaching macros to buttons and tables
• Working with Excel and Outlook data
• Maintaining an Access database

Word

Excel

PowerPoint

Outlook

Access