Learn how to use the world’s most powerful office suite.
Microsoft Office 2016 includes five main applications: Word, Excel, PowerPoint, Access, and Outlook, each designed to handle different types of data. Word is for text, Excel for numbers, PowerPoint for creating slide shows with text and images, Access for managing organized, repetitive data like inventories, and Outlook for personal information such as emails and contacts.
Despite handling different data types, all Office 2016 programs operate similarly. First, you input data by typing or importing from an existing file. Next, you instruct Office 2016 on how to process your data, whether it’s underlining, sorting, arranging, or deleting. Finally, you save your data as a file. This course bundle will guide you through these steps and more.
Microsoft introduced significant updates in Office 2016 for Windows, though many of these enhancements are subtly integrated into a familiar interface. This 2016 version of the world’s leading office suite surpasses its online and desktop competitors, particularly with its seamless and robust collaboration features.
After completing the Microsoft Office Suite (MOS) 2016 eLearning Course Bundle, you will be able to:
- Create and modify databases in Access
- Manage relationships and keys
- Navigate through a database
- Protect and maintain databases
- Print and export data
- Create and manage tables
- Manage records in tables
- Create and modify fields
- Create a query
- Modify a query
- Create calculated fields and grouping within queries
- Create worksheets and workbooks using Excel
- Navigate in worksheets and workbooks
- Format worksheets and workbooks
- Change views and configurations
- Print and distribute worksheets and workbooks
- Manage data cells and ranges
- Create tables, charts and objects
- Perform operations with formulas and functions
- Create Presentations from scratch or PowerPoint templates
- Insert and format slides, handouts and notes
- Change Presentation views and configurations
- Insert and work with text, pictures, audio and video
- Work with tables, charts, and SmartArt
- Use transitions and animations
- Prepare for a presentation, including the slide size, narration, and timing
- Manage multiple presentations
- Connect one or more email accounts
- Preview, read, reply to and forward messages
- Process, create, format and check messages
- Use advanced message options
- Organise messages
- Use signatures and stationary
- Automate replies and organisation
- Clean up and archive messages
- Create, organize and manage calendars, appointments, meetings and events
- Create and manage notes and tasks
- Create and manage contacts and contact groups
- Customise the Outlook environment settings
- Print and save information
- Perform search operations in Outlook
- Create and manage documents
- Format text, paragraphs, and sections
- Create tables and lists
- Create and manage references
- Insert and format graphic elements in Word
