Request for consultation
Thanks for your request. You’ll soon be chatting with a consultant to get the answers you need.
Your form is submitting...
{{formPostErrorMessage.message}} [{{formPostErrorMessage.code}}]
Quick Navigation
Overview
IAC MT ILLUSTRATED COLLECTION OFFICE 365/OFFICE
- Microsoft Teams coverage includes three digital modules available in MindTap, authored by Corinne Hoisington.
- This text is updated to reflect Microsoft 365 features, including Accessibility Checker.
- New features for Excel include a new lesson on using dynamic array functions, including UNIQUE, FILTER, RANDARRAY, SEQUENCE, SORT, SORTBY, TRANSPOSE and information on spill ranges and using array formulas. There are also new clues on data types (geography, stocks, new data types) and on LET function.
- New features for PowerPoint include the new teamwork features of marking and highlighting changes made when collaborating with others to create a presentation. There is also coverage of a new live rehearsing experience that enables the user to rehearse their presentation and then receive a report with recommendations on how to improve their speaking performance.
- New features for Word include enhanced text prediction and accessibility features.
- New features for Access include completely updated projects implementing brand new case scenarios to ensure database mastery.
- This concise, student-friendly approach uses a proven two-page layout that allows you to work through an entire task without turning the page.
- Introductory Textbook Projects have been redesigned to ensure successful completion by Mac users for Word, Excel and PowerPoint.
- Embracing Change modules in MindTap help students navigate through Microsoft 365 continual software changes. Each module includes accessibility features, application-specific tips, a Microsoft ribbon and toolbar visual overview and review and discussion questions.
- This title is part of the Illustrated Office 365 Collection, giving you access to a complete digital library of content spanning Computer Concepts, Operating Systems (for Windows and Mac) and the Microsoft Office Suite -- all for one price, including low-cost rental options. Learn more about Cengage Unlimited at https://www.cengage.com/unlimited.
- Module Learning Objectives are mapped to the Microsoft Office Specialist (MOS) exam. Users of MindTap Collections and SAM will have access to exam preparation materials and the option to purchase a discounted MOS exam voucher.
- Students carefully examine the context for their projects, increasing the motivation to learn as students understand the “why” behind each step in the process.
- Each module begins with a brief overview of the principles covered while large, full-color screen images illustrate what you see on your computer.
Part I: COURSE ORIENTATION.
1. Getting to Know Office Versions.
2. Introduction to MindTap & SAM.
3.Using SAM Projects and Textbook Projects.
4. Getting Started with File Management.
5.Getting Started with Microsoft OneNote.
6. Getting Started with Microsoft Office Online and OneDrive.
7. Getting Started with Microsoft Teams.
8. Getting Started with Office for Mac.
9. Embracing Change in Technology.
Part II: TECHNOLOGY FOR SUCCESS: COMPUTER CONCEPTS.
Module 1: Impact of Digital Technology.
Module 2: The Web.
Module 3: Hardware and Processors.
Module 4: Operating Systems and File Management.
Module 5: App Use.
Module 6: Cybersecurity and Safety.
Module 7: Digital Media.
Module 8: App Development.
Module 9: Web Development.
Module 10: Networking.
Module 11: Digital Communication.
Module 12: Digital Transformation.
Module 13: Databases.
Module 14: Digital Ethics and Lifestyle.
Part III: OPERATING SYSTEMS (FROM THE SHELLY CASHMAN SERIES).
Module 1: Introduction to Windows 11.
Module 2: Working with the Windows 11 Desktop.
Module 3: File and Folder Management.
Module 4: Personalizing you Work Environment.
Module 5: Advanced Personalization and Customization.
Module 6: Advanced Searching Techniques.
Module 7: Microsoft Edge.
Module 8: Mastering Digital Media.
Module 9: Understanding Security, Networking and Utilities.
Module 10: Getting Started with Mac OS.
Part IV: MICROSOFT TEAMS.
Module 1: Introduction to Teams.
Module 2: Making Meetings More Productive.
Module 3: Build an Effective Work Team.
Part V: MICROSOFT WORD.
Introduction to Microsoft Word for Mac.
Embracing Change in Word.
Module 1. Creating Documents with Word.
Module 2. Editing and Formatting Documents.
Module 3. Formatting Text and Graphics.
Module 4. Formatting Tables and Documents.
Module 5. Working with Styles, Themes, and Building Blocks.
Module 6. Merging Word Documents.
Module 7. Illustrating Documents with Graphics.
Module 8. Integrating with Other Programs and Collaborating.
Module 9. Developing Multi-page Documents.
Module 10. Building Forms.
Module 11. Automating and Customizing Word.
Part VI: MICROSOFT EXCEL.
Introduction to Microsoft Excel for Mac.
Embracing Change in Excel.
Module 1. Getting Started with Excel.
Module 2. Formatting a Worksheet.
Module 3. Analyzing Data Using Formulas.
Module 4. Working with Charts.
Module 5. Working with Tables.
Module 6. Managing Workbook Data.
Module 7. Working with Images and Integrating with Other Programs.
Module 8. Analyzing Data with PivotTables.
Module 9. Automating Worksheet Tasks.
Module 10. Managing Worksheets.
Module 11. Using Formulas and Functions.
Module 12. Performing What-if Analysis.
Part VII: MICROSOFT ACCESS.
Part VIII: Embracing Change in Access.
Module 1. Getting Started with Access.
Module 2. Building Tables and Relationships.
Module 3. Creating Queries.
Module 4. Working with Forms and Reports.
Module 5. Improving Tables and Creating Advanced Queries.
Module 6. Creating Forms.
Module 7. Creating Reports.
Module 8. Importing and Exporting Data.
Module 9. Creating Action Queries.
Module 10. Creating Macros.
Module 11. Creating Modules and VBA.
Module 12. Completing the Application.
Part IX: POWERPOINT.
Introduction to Microsoft PowerPoint for Mac.
Embracing Change in PowerPoint.
Module 1: Creating a Presentation in PowerPoint®.
Module 2: Modifying a Presentation.
Module 3: Inserting Objects into a Presentation.
Module 4: Formatting Slide Masters and Background.
Module 5: Working with Advanced Tools.
Module 6: Enhancing Charts and Tables.
Module 7: Inserting Graphics, Media, and Objects.
Module 8: Delivering Presentations.
Part X: INTEGRATION.
Module 1: Integrating Word and Excel.
Module 2: Integrating Word, Excel, and Access.
Module 3: Integrating Word, Excel, Access, and PowerPoint.
Module 4: Integrating Word and Excel.
Module 5: Integrating Word, Excel, and Access.
Module 6: Integrating Word, Excel, Access, and PowerPoint.
Part XI: MICROSOFT OUTLOOK (FROM THE SHELLY CASHMAN SERIES).
Module 1: Managing Email Messages with Outlook.
Module 2: Managing Calendars with Outlook.
Module 3: Managing Contacts and Personal Contact Information with Outlook.
Module 4: Creating and Managing Tasks with Outlook.
Module 5: Customizing Outlook.
Part XII: CAREER READINESS.
Creating Your Resume, Launching Your Career.
Microsoft Office Specialist (MOS) Certification Resources.
1. Getting to Know Office Versions.
2. Introduction to MindTap & SAM.
3.Using SAM Projects and Textbook Projects.
4. Getting Started with File Management.
5.Getting Started with Microsoft OneNote.
6. Getting Started with Microsoft Office Online and OneDrive.
7. Getting Started with Microsoft Teams.
8. Getting Started with Office for Mac.
9. Embracing Change in Technology.
Part II: TECHNOLOGY FOR SUCCESS: COMPUTER CONCEPTS.
Module 1: Impact of Digital Technology.
Module 2: The Web.
Module 3: Hardware and Processors.
Module 4: Operating Systems and File Management.
Module 5: App Use.
Module 6: Cybersecurity and Safety.
Module 7: Digital Media.
Module 8: App Development.
Module 9: Web Development.
Module 10: Networking.
Module 11: Digital Communication.
Module 12: Digital Transformation.
Module 13: Databases.
Module 14: Digital Ethics and Lifestyle.
Part III: OPERATING SYSTEMS (FROM THE SHELLY CASHMAN SERIES).
Module 1: Introduction to Windows 11.
Module 2: Working with the Windows 11 Desktop.
Module 3: File and Folder Management.
Module 4: Personalizing you Work Environment.
Module 5: Advanced Personalization and Customization.
Module 6: Advanced Searching Techniques.
Module 7: Microsoft Edge.
Module 8: Mastering Digital Media.
Module 9: Understanding Security, Networking and Utilities.
Module 10: Getting Started with Mac OS.
Part IV: MICROSOFT TEAMS.
Module 1: Introduction to Teams.
Module 2: Making Meetings More Productive.
Module 3: Build an Effective Work Team.
Part V: MICROSOFT WORD.
Introduction to Microsoft Word for Mac.
Embracing Change in Word.
Module 1. Creating Documents with Word.
Module 2. Editing and Formatting Documents.
Module 3. Formatting Text and Graphics.
Module 4. Formatting Tables and Documents.
Module 5. Working with Styles, Themes, and Building Blocks.
Module 6. Merging Word Documents.
Module 7. Illustrating Documents with Graphics.
Module 8. Integrating with Other Programs and Collaborating.
Module 9. Developing Multi-page Documents.
Module 10. Building Forms.
Module 11. Automating and Customizing Word.
Part VI: MICROSOFT EXCEL.
Introduction to Microsoft Excel for Mac.
Embracing Change in Excel.
Module 1. Getting Started with Excel.
Module 2. Formatting a Worksheet.
Module 3. Analyzing Data Using Formulas.
Module 4. Working with Charts.
Module 5. Working with Tables.
Module 6. Managing Workbook Data.
Module 7. Working with Images and Integrating with Other Programs.
Module 8. Analyzing Data with PivotTables.
Module 9. Automating Worksheet Tasks.
Module 10. Managing Worksheets.
Module 11. Using Formulas and Functions.
Module 12. Performing What-if Analysis.
Part VII: MICROSOFT ACCESS.
Part VIII: Embracing Change in Access.
Module 1. Getting Started with Access.
Module 2. Building Tables and Relationships.
Module 3. Creating Queries.
Module 4. Working with Forms and Reports.
Module 5. Improving Tables and Creating Advanced Queries.
Module 6. Creating Forms.
Module 7. Creating Reports.
Module 8. Importing and Exporting Data.
Module 9. Creating Action Queries.
Module 10. Creating Macros.
Module 11. Creating Modules and VBA.
Module 12. Completing the Application.
Part IX: POWERPOINT.
Introduction to Microsoft PowerPoint for Mac.
Embracing Change in PowerPoint.
Module 1: Creating a Presentation in PowerPoint®.
Module 2: Modifying a Presentation.
Module 3: Inserting Objects into a Presentation.
Module 4: Formatting Slide Masters and Background.
Module 5: Working with Advanced Tools.
Module 6: Enhancing Charts and Tables.
Module 7: Inserting Graphics, Media, and Objects.
Module 8: Delivering Presentations.
Part X: INTEGRATION.
Module 1: Integrating Word and Excel.
Module 2: Integrating Word, Excel, and Access.
Module 3: Integrating Word, Excel, Access, and PowerPoint.
Module 4: Integrating Word and Excel.
Module 5: Integrating Word, Excel, and Access.
Module 6: Integrating Word, Excel, Access, and PowerPoint.
Part XI: MICROSOFT OUTLOOK (FROM THE SHELLY CASHMAN SERIES).
Module 1: Managing Email Messages with Outlook.
Module 2: Managing Calendars with Outlook.
Module 3: Managing Contacts and Personal Contact Information with Outlook.
Module 4: Creating and Managing Tasks with Outlook.
Module 5: Customizing Outlook.
Part XII: CAREER READINESS.
Creating Your Resume, Launching Your Career.
Microsoft Office Specialist (MOS) Certification Resources.