Security scan is checking this page.

Contents - Lessons & Practice

Business · Computer Science

Workplace Software and Skills

OpenStax book

OpenStax

Workplace Software and Skills

15 lessons

One lesson for each chapter of Workplace Software and Skills, in the book’s order. The lesson teaches what that chapter says you need to know, then checks it.

  1. 1Technology in Everyday Life and BusinessHardware components that make up a computer are the motherboard, CPU, microprocessor, and memory, as well as the keyboard, mouse, and other peripheral devices
  2. 2Essentials of Software Applications for BusinessSome best practices for organizing and cleaning your files include never storing files on your desktop, removing files from the download folder, and using descriptive folder names
  3. 3Creating and Working in DocumentsThe most frequently used tabs include Home (to set document styles), Insert (to insert graphics or other elements), Layout (to adjust margins and page settings), Review (to use comments and track change), and View (to…
  4. 4Document PreparationHeaders and footers can be inserted into Word documents using the tools on the Insert tab.
  5. 5Advanced Document PreparationIt is also important to know how to create and format documents on letterhead and printed envelopes.
  6. 6Preparing PresentationsConsistency and coherency are essential for creating a professional, finished presentation.
  7. 7Advanced Presentation SkillsA strong opening statement or hook will get the audience engaged and interested in the rest of the presentation
  8. 8Content Management Systems and Social Media in BusinessThere are seven stages of the content management lifecycle: organization, creation, storage, workflow, editing/versioning, publishing, and removal/archiving
  9. 9Working with SpreadsheetsThe spreadsheet file is called a workbook and is composed of worksheets.
  10. 10Advanced Excel Formulas, Functions, and TechniquesCell references, comparison operators, and array formulas can help analyze large sets of changing data
  11. 11Advanced Excel Spreadsheets: Statistical and Data AnalysisData verification and the Data Validation tool can ensure the quality of data in your spreadsheets
  12. 12Using Excel in Accounting and Financial ReportingFinancial accounting measures performance using financial reports and communicates results to those outside of the organization who may have an interest in the company’s performance, such as investors and creditors
  13. 13Understanding and Using DatabasesDatabases consist of objects, including tables, queries, forms, and reports.
  14. 14Advanced Database UseLearning how to build/record expressions through correct syntax can help control numerous operators in a query.
  15. 15Integrating ApplicationsCollaborative workspaces allow users from various physical locations to work together efficiently