Workplace Software and Skills

by OpenStax

Read here Read at LibreTextsPDF

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. Workplace Software and Skills leverages complementary product features in spreadsheet, word processing, presentation, and similar applications.

Description from LibreTexts.

Subjects
Workforce, Information Technology
Licence
CC BY 4.0, as LibreTexts states it
Who can read
Tweens profiles and older, judged from its title and subjects

Contents

LibreTexts writes equations in TeX, and here they show as TeX; the PDF has them typeset.

  1. Front Matter
  2. TitlePage
  3. InfoPage
  4. Table of Contents
  5. Licensing
  6. 1: Technology in Everyday Life and Business
  7. 1.0: Chapter Scenario
  8. 1.1: Computing from Inception to Today
  9. 1.2: Computer Hardware and Networks
  10. 1.3: The Internet, Cloud Computing, and the Internet of Things
  11. 1.4: Safety, Security, Privacy, and the Ethical Use of Technology
  12. 1.5: Chapter Review - Key Terms
  13. 1.6: Chapter Review - Summary
  14. 1.7: Chapter Review - Review Questions
  15. 1.8: Chapter Review - Practice Exercises
  16. 1.9: Chapter Review - Written Questions
  17. 1.10: Chapter Review - Case Exercises
  18. 2: Essentials of Software Applications for Business
  19. 2.0: Chapter Scenario
  20. 2.1: Software Basics
  21. 2.2: Files and Folders
  22. 2.3: Communication and Calendar Applications
  23. 2.4: Essentials of Microsoft 365
  24. 2.5: Essentials of Google Workspace
  25. 2.6: Collaboration
  26. 2.7: Chapter Review - Key Terms
  27. 2.8: Chapter Review - Summary
  28. 2.9: Chapter Review - Review Questions
  29. 2.10: Chapter Review - Practice Exercises
  30. 2.11: Chapter Review - Written Questions
  31. 2.12: Chapter Review - Case Exercises
  32. 3: Creating and Working in Documents
  33. 3.0: Chapter Scenario
  34. 3.1: Navigating Microsoft Word
  35. 3.2: Formatting Document Layout in Microsoft Word
  36. 3.3: Formatting Document Content in Microsoft Word
  37. 3.4: Collaborative Editing and Reviewing in Microsoft Word
  38. 3.5: Document Design
  39. 3.6: Navigating Google Docs
  40. 3.7: Formatting Layout and Content in Google Docs
  41. 3.8: Collaborative Editing and Reviewing in Google Docs
  42. 3.9: Versions and Version History
  43. 3.10: Chapter Review - Key Terms
  44. 3.11: Chapter Review - Summary
  45. 3.12: Chapter Review - Review Questions
  46. 3.13: Chapter Review - Practice Exercises
  47. 3.14: Chapter Review - Written Questions
  48. 3.15: Chapter Review - Case Exercises
  49. 4: Document Preparation
  50. 4.0: Chapter Scenario
  51. 4.1: Microsoft Word- Advanced Formatting Features
  52. 4.2: Working with Graphics and Text Tools in Microsoft Word
  53. 4.3: Managing Long Documents in Microsoft Word
  54. 4.4: Google Docs- Enhanced Formatting Features
  55. 4.5: Working with Graphics and Text Tools in Google Docs
  56. 4.6: Managing Long Documents in Google Docs
  57. 4.7: Chapter Review - Key Terms
  58. 4.8: Chapter Review - Summary
  59. 4.9: Chapter Review - Review Questions
  60. 4.10: Chapter Review - Practice Exercises
  61. 4.11: Chapter Review - Written Questions
  62. 4.12: Chapter Review - Case Exercises
  63. 5: Advanced Document Preparation
  64. 5.0: Chapter Scenario
  65. 5.1: Creating Different Document Types in Microsoft Word
  66. 5.2: Mail Merge in Microsoft Word
  67. 5.3: Creating Forms in Microsoft Word
  68. 5.4: Creating Different Document Types in Google Docs
  69. 5.5: Creating Forms in Google Docs
  70. 5.6: Advanced Collaboration in Google Docs
  71. 5.7: Chapter Review - Key Terms
  72. 5.8: Chapter Review - Summary
  73. 5.9: Chapter Review - Review Questions
  74. 5.10: Chapter Review - Practice Exercises
  75. 5.11: Chapter Review - Written Questions
  76. 5.12: Chapter Review - Case Exercises
  77. 6: Preparing Presentations
  78. 6.0: Chapter Scenario
  79. 6.1: Presentation and Design Essentials
  80. 6.2: Designing a Presentation in Microsoft PowerPoint
  81. 6.3: Formatting Microsoft PowerPoint Slides- Layout and Design Principles
  82. 6.4: Adding Visuals and Features to Microsoft PowerPoint Slides
  83. 6.5: Designing a Presentation in Google Slides
  84. 6.6: Creating Google Slides- Layout and Text
  85. 6.7: Adding Visuals and Features to Google Slides
  86. 6.8: Chapter Review - Key Terms
  87. 6.9: Chapter Review - Summary
  88. 6.10: Chapter Review - Review Questions
  89. 6.11: Chapter Review - Practice Exercises
  90. 6.12: Chapter Review - Written Questions
  91. 6.13: Chapter Review - Case Exercises
  92. 7: Advanced Presentation Skills
  93. 7.0: Chapter Scenario
  94. 7.1: Effective Presentation Skills
  95. 7.2: Finalizing a Slide Collection
  96. 7.3: Preparing a Microsoft PowerPoint Collection for Presentation
  97. 7.4: Preparing a Google Slides Collection for Presentation
  98. 7.5: Chapter Review - Key Terms
  99. 7.6: Chapter Review - Summary
  100. 7.7: Chapter Review - Review Questions
  101. 7.8: Chapter Review - Practice Exercises
  102. 7.9: Chapter Review - Written Questions
  103. 7.10: Chapter Review - Case Exercises
  104. 8: Content Management Systems and Social Media in Business
  105. 8.0: Chapter Scenario
  106. 8.1: What Are Content Management Systems?
  107. 8.2: Common Content Management Systems
  108. 8.3: Creating Content with a Content Management System
  109. 8.4: Search Engine Optimization
  110. 8.5: Social Media in Business
  111. 8.6: Chapter Review - Key Terms
  112. 8.7: Chapter Review - Summary
  113. 8.8: Chapter Review - Review Questions
  114. 8.9: Chapter Review - Practice Exercises
  115. 8.10: Chapter Review - Written Questions
  116. 8.11: Chapter Review - Case Exercises
  117. 9: Working with Spreadsheets
  118. 9.0: Chapter Scenario
  119. 9.1: Microsoft Excel Basics
  120. 9.2: Text and Numbers in Microsoft Excel
  121. 9.3: Calculations and Basic Formulas in Microsoft Excel
  122. 9.4: Formatting and Templates in Microsoft Excel
  123. 9.5: Google Sheets Basics
  124. 9.6: Text and Numbers in Google Sheets
  125. 9.7: Calculations and Basic Formulas in Google Sheets
  126. 9.8: Formatting and Templates in Google Sheets
  127. 9.9: Chapter Review - Key Terms
  128. 9.10: Chapter Review - Summary
  129. 9.11: Chapter Review - Review Questions
  130. 9.12: Chapter Review - Practice Exercises
  131. 9.13: Chapter Review - Written Questions
  132. 9.14: Chapter Review - Case Exercises
  133. 10: Advanced Excel Formulas, Functions, and Techniques
  134. 10.0: Chapter Scenario
  135. 10.1: Data Tables and Ranges
  136. 10.2: More About Formulas
  137. 10.3: Using Arithmetic, Statistical, and Logical Functions
  138. 10.4: PivotTables
  139. 10.5: Auditing Formulas and Fixing Errors
  140. 10.6: Advanced Formatting Techniques
  141. 10.7: Chapter Review - Key Terms
  142. 10.8: Chapter Review - Summary
  143. 10.9: Chapter Review - Review Questions
  144. 10.10: Chapter Review - Practice Exercises
  145. 10.11: Chapter Review - Written Questions
  146. 10.12: Chapter Review - Case Exercises
  147. 11: Advanced Excel Spreadsheets- Statistical and Data Analysis
  148. 11.0: Chapter Scenario
  149. 11.1: Understanding Data, Data Validation, and Data Tables
  150. 11.2: Statistical Functions
  151. 11.3: What-If Analysis
  152. 11.4: PivotTables/Charts
  153. 11.5: Data Analysis Charts
  154. 11.6: Chapter Review - Key Terms
  155. 11.7: Chapter Review - Summary
  156. 11.8: Chapter Review - Review Questions
  157. 11.9: Chapter Review - Practice Exercises
  158. 11.10: Chapter Review - Written Questions
  159. 11.11: Chapter Review - Case Exercises
  160. 12: Using Excel in Accounting and Financial Reporting
  161. 12.0: Chapter Scenario
  162. 12.1: Basic Accounting
  163. 12.2: Financial Functions in Microsoft Excel
  164. 12.3: Integrating Microsoft Excel and Accounting Programs
  165. 12.4: Chapter Review - Key Terms
  166. 12.5: Chapter Review - Summary
  167. 12.6: Chapter Review - Review Questions
  168. 12.7: Chapter Review - Practice Exercises
  169. 12.8: Chapter Review - Written Questions
  170. 12.9: Chapter Review - Case Exercises
  171. 13: Understanding and Using Databases
  172. 13.0: Chapter Scenario
  173. 13.1: What Is a Database?
  174. 13.2: Microsoft Access- Main Features and Navigation
  175. 13.3: Querying a Database
  176. 13.4: Maintaining Records in a Database
  177. 13.5: Creating Reports in Microsoft Access
  178. 13.6: Creating Forms in Microsoft Access
  179. 13.7: Chapter Review - Key Terms
  180. 13.8: Chapter Review - Summary
  181. 13.9: Chapter Review - Review Questions
  182. 13.10: Chapter Review - Practice Exercises
  183. 13.11: Chapter Review - Written Questions
  184. 13.12: Chapter Review - Case Exercises
  185. 14: Advanced Database Use
  186. 14.0: Chapter Scenario
  187. 14.1: Advanced Queries in Microsoft Access
  188. 14.2: Multiple Table Forms
  189. 14.3: Customizing Forms
  190. 14.4: Customizing Reports
  191. 14.5: Using Macros
  192. 14.6: Data Analysis and Integration
  193. 14.7: Chapter Review - Key Terms
  194. 14.8: Chapter Review - Summary
  195. 14.9: Chapter Review - Review Questions
  196. 14.10: Chapter Review - Practice Exercises
  197. 14.11: Chapter Review - Written Questions
  198. 14.12: Chapter Review - Case Exercises
  199. 15: Integrating Applications
  200. 15.0: Chapter Scenario
  201. 15.1: Microsoft 365- Collaboration and Integration
  202. 15.2: Microsoft Word- Integration with Microsoft Excel and Microsoft Access
  203. 15.3: Microsoft Word and Microsoft PowerPoint Integration
  204. 15.4: Microsoft Excel and Microsoft PowerPoint Integration
  205. 15.5: Microsoft Excel and Microsoft Access Integration
  206. 15.6: Integrating Data from Other Programs into Google Workspace
  207. 15.7: New Developments- The Role of Artificial Intelligence
  208. 15.8: Mastering Workplace Software Skills- A Project
  209. 15.9: Chapter Review - Key Terms
  210. 15.10: Chapter Review - Summary
  211. 15.11: Chapter Review - Review Questions
  212. 15.12: Chapter Review - Practice Exercises
  213. 15.13: Chapter Review - Written Questions
  214. Back Matter
  215. Index
  216. Detailed Licensing