- Using Flash Fill, Text to Columns, and Group Mode to work with your data
- Using editing features such as Find and Replace, proofing options, and research tools to refine your workbook
- Modifying workbook views
- Accessing Groups through various apps
- Sharing files
- Coordinating meetings and sharing calendars
- Managing rows, columns, and worksheets
- Creating and using named ranges
- Adding logical and conditional functions
- Creating a new presentation from a template
- Modifying slide design
- Formatting text, text boxes, and lists
- Modifying slide design and applying themes
- Using editing tools
- Adding and modifying tabs, line spacing, and paragraph spacing
- Navigating the Word interface
- Creating, saving, and finding documents
- Managing your workspace and customizing Word documents
- Navigating the interface
- Creating and saving workbooks
- Selecting and entering data
- Navigating the Outlook interface
- Formatting and sending email
- Sending and receiving attachments
- Modifying message properties
- Customizing your Outlook interface
- Organizing, searching, and managing messages
- Using different text styles and style sets
- Adding sections and columns
- Inserting tables of contents, indexes, and concordances
- Opening PowerPoint
- Navigating PowerPoint’s interface including the ribbon, search functions, and QAT.
- Creating and saving presentations
- Customizing the interface and ribbon
- Working with advanced text editing techniques
- Grouping, arranging, and animating objects