Phu Xuan University Library
|
PXU E-LIB
Sign in
Workplace Software and Skills

External

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

Information TechnologyWorkforce
Author
OpenStax
Publisher
LibreTexts
Source
LibreTexts
License
CC BY
Language
EN
Category
Information Technology
Read online Download PDF (open licence)
Contents· 208 sections
  1. 01: Technology in Everyday Life and Business
  2. 1.00: Chapter Scenario
  3. 1.01: Computing from Inception to Today
  4. 1.02: Computer Hardware and Networks
  5. 1.03: The Internet Cloud Computing and the Internet of Things
  6. 1.04: Safety Security Privacy and the Ethical Use of Technology
  7. 1.05: Chapter Review - Key Terms
  8. 1.06: Chapter Review - Summary
  9. 1.07: Chapter Review - Review Questions
  10. 1.08: Chapter Review - Practice Exercises
  11. 1.09: Chapter Review - Written Questions
  12. 1.10: Chapter Review - Case Exercises
  13. 02: Essentials of Software Applications for Business
  14. 2.00: Chapter Scenario
  15. 2.01: Software Basics
  16. 2.02: Files and Folders
  17. 2.03: Communication and Calendar Applications
  18. 2.04: Essentials of Microsoft 365
  19. 2.05: Essentials of Google Workspace
  20. 2.06: Collaboration
  21. 2.07: Chapter Review - Key Terms
  22. 2.08: Chapter Review - Summary
  23. 2.09: Chapter Review - Review Questions
  24. 2.10: Chapter Review - Practice Exercises
  25. 2.11: Chapter Review - Written Questions
  26. 2.12: Chapter Review - Case Exercises
  27. 03: Creating and Working in Documents
  28. 3.00: Chapter Scenario
  29. 3.01: Navigating Microsoft Word
  30. 3.02: Formatting Document Layout in Microsoft Word
  31. 3.03: Formatting Document Content in Microsoft Word
  32. 3.04: Collaborative Editing and Reviewing in Microsoft Word
  33. 3.05: Document Design
  34. 3.06: Navigating Google Docs
  35. 3.07: Formatting Layout and Content in Google Docs
  36. 3.08: Collaborative Editing and Reviewing in Google Docs
  37. 3.09: Versions and Version History
  38. 3.10: Chapter Review - Key Terms
  39. 3.11: Chapter Review - Summary
  40. 3.12: Chapter Review - Review Questions
  41. 3.13: Chapter Review - Practice Exercises
  42. 3.14: Chapter Review - Written Questions
  43. 3.15: Chapter Review - Case Exercises
  44. 04: Document Preparation
  45. 4.00: Chapter Scenario
  46. 4.01: Microsoft Word- Advanced Formatting Features
  47. 4.02: Working with Graphics and Text Tools in Microsoft Word
  48. 4.03: Managing Long Documents in Microsoft Word
  49. 4.04: Google Docs- Enhanced Formatting Features
  50. 4.05: Working with Graphics and Text Tools in Google Docs
  51. 4.06: Managing Long Documents in Google Docs
  52. 4.07: Chapter Review - Key Terms
  53. 4.08: Chapter Review - Summary
  54. 4.09: Chapter Review - Review Questions
  55. 4.10: Chapter Review - Practice Exercises
  56. 4.11: Chapter Review - Written Questions
  57. 4.12: Chapter Review - Case Exercises
  58. 05: Advanced Document Preparation
  59. 5.00: Chapter Scenario
  60. 5.01: Creating Different Document Types in Microsoft Word
  61. 5.02: Mail Merge in Microsoft Word
  62. 5.03: Creating Forms in Microsoft Word
  63. 5.04: Creating Different Document Types in Google Docs
  64. 5.05: Creating Forms in Google Docs
  65. 5.06: Advanced Collaboration in Google Docs
  66. 5.07: Chapter Review - Key Terms
  67. 5.08: Chapter Review - Summary
  68. 5.09: Chapter Review - Review Questions
  69. 5.10: Chapter Review - Practice Exercises
  70. 5.11: Chapter Review - Written Questions
  71. 5.12: Chapter Review - Case Exercises
  72. 06: Preparing Presentations
  73. 6.00: Chapter Scenario
  74. 6.01: Presentation and Design Essentials
  75. 6.02: Designing a Presentation in Microsoft PowerPoint
  76. 6.03: Formatting Microsoft PowerPoint Slides- Layout and Design Principles
  77. 6.04: Adding Visuals and Features to Microsoft PowerPoint Slides
  78. 6.05: Designing a Presentation in Google Slides
  79. 6.06: Creating Google Slides- Layout and Text
  80. 6.07: Adding Visuals and Features to Google Slides
  81. 6.08: Chapter Review - Key Terms
  82. 6.09: Chapter Review - Summary
  83. 6.10: Chapter Review - Review Questions
  84. 6.11: Chapter Review - Practice Exercises
  85. 6.12: Chapter Review - Written Questions
  86. 6.13: Chapter Review - Case Exercises
  87. 07: Advanced Presentation Skills
  88. 7.00: Chapter Scenario
  89. 7.01: Effective Presentation Skills
  90. 7.02: Finalizing a Slide Collection
  91. 7.03: Preparing a Microsoft PowerPoint Collection for Presentation
  92. 7.04: Preparing a Google Slides Collection for Presentation
  93. 7.05: Chapter Review - Key Terms
  94. 7.06: Chapter Review - Summary
  95. 7.07: Chapter Review - Review Questions
  96. 7.08: Chapter Review - Practice Exercises
  97. 7.09: Chapter Review - Written Questions
  98. 7.10: Chapter Review - Case Exercises
  99. 08: Content Management Systems and Social Media in Business
  100. 8.00: Chapter Scenario
  101. 8.01: What Are Content Management Systems
  102. 8.02: Common Content Management Systems
  103. 8.03: Creating Content with a Content Management System
  104. 8.04: Search Engine Optimization
  105. 8.05: Social Media in Business
  106. 8.06: Chapter Review - Key Terms
  107. 8.07: Chapter Review - Summary
  108. 8.08: Chapter Review - Review Questions
  109. 8.09: Chapter Review - Practice Exercises
  110. 8.10: Chapter Review - Written Questions
  111. 8.11: Chapter Review - Case Exercises
  112. 09: Working with Spreadsheets
  113. 9.00: Chapter Scenario
  114. 9.01: Microsoft Excel Basics
  115. 9.02: Text and Numbers in Microsoft Excel
  116. 9.03: Calculations and Basic Formulas in Microsoft Excel
  117. 9.04: Formatting and Templates in Microsoft Excel
  118. 9.05: Google Sheets Basics
  119. 9.06: Text and Numbers in Google Sheets
  120. 9.07: Calculations and Basic Formulas in Google Sheets
  121. 9.08: Formatting and Templates in Google Sheets
  122. 9.09: Chapter Review - Key Terms
  123. 9.10: Chapter Review - Summary
  124. 9.11: Chapter Review - Review Questions
  125. 9.12: Chapter Review - Practice Exercises
  126. 9.13: Chapter Review - Written Questions
  127. 9.14: Chapter Review - Case Exercises
  128. 10: Advanced Excel Formulas Functions and Techniques
  129. 10.00: Chapter Scenario
  130. 10.01: Data Tables and Ranges
  131. 10.02: More About Formulas
  132. 10.03: Using Arithmetic Statistical and Logical Functions
  133. 10.04: PivotTables
  134. 10.05: Auditing Formulas and Fixing Errors
  135. 10.06: Advanced Formatting Techniques
  136. 10.07: Chapter Review - Key Terms
  137. 10.08: Chapter Review - Summary
  138. 10.09: Chapter Review - Review Questions
  139. 10.10: Chapter Review - Practice Exercises
  140. 10.11: Chapter Review - Written Questions
  141. 10.12: Chapter Review - Case Exercises
  142. 11: Advanced Excel Spreadsheets- Statistical and Data Analysis
  143. 11.00: Chapter Scenario
  144. 11.01: Understanding Data Data Validation and Data Tables
  145. 11.02: Statistical Functions
  146. 11.03: What-If Analysis
  147. 11.04: PivotTables Charts
  148. 11.05: Data Analysis Charts
  149. 11.06: Chapter Review - Key Terms
  150. 11.07: Chapter Review - Summary
  151. 11.08: Chapter Review - Review Questions
  152. 11.09: Chapter Review - Practice Exercises
  153. 11.10: Chapter Review - Written Questions
  154. 11.11: Chapter Review - Case Exercises
  155. 12: Using Excel in Accounting and Financial Reporting
  156. 12.00: Chapter Scenario
  157. 12.01: Basic Accounting
  158. 12.02: Financial Functions in Microsoft Excel
  159. 12.03: Integrating Microsoft Excel and Accounting Programs
  160. 12.04: Chapter Review - Key Terms
  161. 12.05: Chapter Review - Summary
  162. 12.06: Chapter Review - Review Questions
  163. 12.07: Chapter Review - Practice Exercises
  164. 12.08: Chapter Review - Written Questions
  165. 12.09: Chapter Review - Case Exercises
  166. 13: Understanding and Using Databases
  167. 13.00: Chapter Scenario
  168. 13.01: What Is a Database
  169. 13.02: Microsoft Access- Main Features and Navigation
  170. 13.03: Querying a Database
  171. 13.04: Maintaining Records in a Database
  172. 13.05: Creating Reports in Microsoft Access
  173. 13.06: Creating Forms in Microsoft Access
  174. 13.07: Chapter Review - Key Terms
  175. 13.08: Chapter Review - Summary
  176. 13.09: Chapter Review - Review Questions
  177. 13.10: Chapter Review - Practice Exercises
  178. 13.11: Chapter Review - Written Questions
  179. 13.12: Chapter Review - Case Exercises
  180. 14: Advanced Database Use
  181. 14.00: Chapter Scenario
  182. 14.01: Advanced Queries in Microsoft Access
  183. 14.02: Multiple Table Forms
  184. 14.03: Customizing Forms
  185. 14.04: Customizing Reports
  186. 14.05: Using Macros
  187. 14.06: Data Analysis and Integration
  188. 14.07: Chapter Review - Key Terms
  189. 14.08: Chapter Review - Summary
  190. 14.09: Chapter Review - Review Questions
  191. 14.10: Chapter Review - Practice Exercises
  192. 14.11: Chapter Review - Written Questions
  193. 14.12: Chapter Review - Case Exercises
  194. 15: Integrating Applications
  195. 15.00: Chapter Scenario
  196. 15.01: Microsoft 365- Collaboration and Integration
  197. 15.02: Microsoft Word- Integration with Microsoft Excel and Microsoft Access
  198. 15.03: Microsoft Word and Microsoft PowerPoint Integration
  199. 15.04: Microsoft Excel and Microsoft PowerPoint Integration
  200. 15.05: Microsoft Excel and Microsoft Access Integration
  201. 15.06: Integrating Data from Other Programs into Google Workspace
  202. 15.07: New Developments- The Role of Artificial Intelligence
  203. 15.08: Mastering Workplace Software Skills- A Project
  204. 15.09: Chapter Review - Key Terms
  205. 15.10: Chapter Review - Summary
  206. 15.11: Chapter Review - Review Questions
  207. 15.12: Chapter Review - Practice Exercises
  208. 15.13: Chapter Review - Written Questions