Workplace Software and Skills

Workplace Software and Skills is designed to flexibly support a range of courses covering computer literacy, Microsoft Office, and Google Suite applications. The textbook covers both hard and soft skills that are applicable to a broad range of academic majors and careers. Chapters combine studio learning and guided practice with scaffolded activities designed to reinforce a student’s ability to perform higher-order tasks independently. Workplace Software and Skills leverages complementary product features in spreadsheet, word processing, presentation, and similar applications. Modules are designed for maximum flexibility by including both Microsoft Office Suite and Google Suite applications, in order to best reflect the skills needed for today’s workforce. Authentic activities and real-world contexts develop a cumulative and thorough understanding, which reinforces the importance of cross-platform proficiency. Highly visible features also note Apple/Mac functions as needed.

Senior Contributing Authors

Tammie Bolling, Pellissippi State Community College
Angela Mitchell, Wilmington College
Tanya Scott, Southern New Hampshire University/University of Arizona Global Campus
Nyrobi Wheeler, Bellevue University

Contributing Authors

Bridget Lepore, Lehman College
Janine Walton, Louisiana State University Shreveport
Timothy Burgoyne, Wilmington College
Rick Arguello, Independent researcher
Valeree Falduto, Broward College

Errata
All OpenStax textbooks undergo a rigorous review process. However, like any professional-grade textbook, errors sometimes occur. The good part is, since our books are web-based, we can make updates periodically. If you have a correction to suggest, submit it here. We review your suggestion and make necessary changes.

Preface

1. Technology in Everyday Life and Business
• Chapter Scenario
• 1.1Computing from Inception to Today
• 1.2Computer Hardware and Networks
• 1.3The Internet, Cloud Computing, and the Internet of Things
• 1.4Safety, Security, Privacy, and the Ethical Use of Technology
• Chapter Review

2. Essentials of Software Applications for Business
• Chapter Scenario
• 2.1Software Basics
• 2.2Files and Folders
• 2.3Communication and Calendar Applications
• 2.4Essentials of Microsoft 365
• 2.5Essentials of Google Workspace
• 2.6Collaboration
• Chapter Review

3. Creating and Working in Documents
• Chapter Scenario
• 3.1Navigating Microsoft Word
• 3.2Formatting Document Layout in Microsoft Word
• 3.3Formatting Document Content in Microsoft Word
• 3.4Collaborative Editing and Reviewing in Microsoft Word
• 3.5Document Design
• 3.6Navigating Google Docs
• 3.7Formatting Layout and Content in Google Docs
• 3.8Collaborative Editing and Reviewing in Google Docs
• 3.9Versions and Version History
• Chapter Review

4. Document Preparation
• Chapter Scenario
• 4.1Microsoft Word: Advanced Formatting Features
• 4.2Working with Graphics and Text Tools in Microsoft Word
• 4.3Managing Long Documents in Microsoft Word
• 4.4Google Docs: Enhanced Formatting Features
• 4.5Working with Graphics and Text Tools in Google Docs
• 4.6Managing Long Documents in Google Docs
• Chapter Review

5. Advanced Document Preparation
• Chapter Scenario
• 5.1Creating Different Document Types in Microsoft Word
• 5.2Mail Merge in Microsoft Word
• 5.3Creating Forms in Microsoft Word
• 5.4Creating Different Document Types in Google Docs
• 5.5Creating Forms in Google Docs
• 5.6Advanced Collaboration in Google Docs
• Chapter Review

6. Preparing Presentations
• Chapter Scenario
• 6.1Presentation and Design Essentials
• 6.2Designing a Presentation in Microsoft PowerPoint
• 6.3Formatting Microsoft PowerPoint Slides: Layout and Design Principles
• 6.4Adding Visuals and Features to Microsoft PowerPoint Slides
• 6.5Designing a Presentation in Google Slides
• 6.6Creating Google Slides: Layout and Text
• 6.7Adding Visuals and Features to Google Slides
• Chapter Review

7. Advanced Presentation Skills
• Chapter Scenario
• 7.1Effective Presentation Skills
• 7.2Finalizing a Slide Collection
• 7.3Preparing a Microsoft PowerPoint Collection for Presentation
• 7.4Preparing a Google Slides Collection for Presentation
• Chapter Review

8. Content Management Systems and Social Media in Business
• Chapter Scenario
• 8.1What Are Content Management Systems?
• 8.2Common Content Management Systems
• 8.3Creating Content with a Content Management System
• 8.4Search Engine Optimization
• 8.5Social Media in Business
• Chapter Review

9. Working with Spreadsheets
• Chapter Scenario
• 9.1Microsoft Excel Basics
• 9.2Text and Numbers in Microsoft Excel
• 9.3Calculations and Basic Formulas in Microsoft Excel
• 9.4Formatting and Templates in Microsoft Excel
• 9.5Google Sheets Basics
• 9.6Text and Numbers in Google Sheets
• 9.7Calculations and Basic Formulas in Google Sheets
• 9.8Formatting and Templates in Google Sheets
• Chapter Review

10. Advanced Excel Formulas, Functions, and Techniques
• Chapter Scenario
• 10.1Data Tables and Ranges
• 10.2More About Formulas
• 10.3Using Arithmetic, Statistical, and Logical Functions
• 10.4PivotTables
• 10.5Auditing Formulas and Fixing Errors
• 10.6Advanced Formatting Techniques
• Chapter Review

11. Advanced Excel Spreadsheets: Statistical and Data Analysis
• Chapter Scenario
• 11.1Understanding Data, Data Validation, and Data Tables
• 11.2Statistical Functions
• 11.3What-If Analysis
• 11.4PivotTables/Charts
• 11.5Data Analysis Charts
• Chapter Review

12. Using Excel in Accounting and Financial Reporting
13. Understanding and Using Databases
14. Advanced Database Use
15. Integrating Applications