Contents
Preface
Chapter 1 Technology in Everyday Life and Business
Chapter Scenario
1.1 Computing from Inception to Today
1.2 Computer Hardware and Networks
1.3 The Internet, Cloud Computing, and the Internet of Things
1.4 Safety, Security, Privacy, and the Ethical Use of Technology
Chapter Review
Chapter 2 Essentials of Software Applications for Business
Chapter Scenario
2.1 Software Basics
2.2 Files and Folders
2.3 Communication and Calendar Applications
2.4 Essentials of Microsoft 365
2.5 Essentials of Google Workspace
2.6 Collaboration
Chapter Review
Chapter 3 Creating and Working in Documents
Chapter Scenario
3.1 Navigating Microsoft Word
3.2 Formatting Document Layout in Microsoft Word
3.3 Formatting Document Content in Microsoft Word
3.4 Collaborative Editing and Reviewing in Microsoft Word
3.5 Document Design
3.6 Navigating Google Docs
3.7 Formatting Layout and Content in Google Docs
3.8 Collaborative Editing and Reviewing in Google Docs
3.9 Versions and Version History
Chapter Review
Chapter 4 Document Preparation
Chapter Scenario
4.1 Microsoft Word: Advanced Formatting Features
4.2 Working with Graphics and Text Tools in Microsoft Word
4.3 Managing Long Documents in Microsoft Word
4.4 Google Docs: Enhanced Formatting Features
4.5 Working with Graphics and Text Tools in Google Docs
4.6 Managing Long Documents in Google Docs
Chapter Review
Chapter 5 Advanced Document Preparation
Chapter Scenario
5.1 Creating Different Document Types in Microsoft Word
5.2 Mail Merge in Microsoft Word
5.3 Creating Forms in Microsoft Word
5.4 Creating Different Document Types in Google Docs
5.5 Creating Forms in Google Docs
5.6 Advanced Collaboration in Google Docs
Chapter Review
Chapter 6 Preparing Presentations
Chapter Scenario
6.1 Presentation and Design Essentials
6.2 Designing a Presentation in Microsoft PowerPoint
6.3 Formatting Microsoft PowerPoint Slides: Layout and Design Principles
6.4 Adding Visuals and Features to Microsoft PowerPoint Slides
6.5 Designing a Presentation in Google Slides
6.6 Creating Google Slides: Layout and Text
6.7 Adding Visuals and Features to Google Slides
Chapter Review
Chapter 7 Advanced Presentation Skills
Chapter Scenario
7.1 Effective Presentation Skills
7.2 Finalizing a Slide Collection
7.3 Preparing a Microsoft PowerPoint Collection for Presentation
7.4 Preparing a Google Slides Collection for Presentation
Chapter Review
Chapter 8 Content Management Systems and Social Media in Business
Chapter Scenario
8.1 What Are Content Management Systems?
8.2 Common Content Management Systems
8.3 Creating Content with a Content Management System
8.4 Search Engine Optimization
8.5 Social Media in Business
Chapter Review
Chapter 9 Working with Spreadsheets
Chapter Scenario
9.1 Microsoft Excel Basics
9.2 Text and Numbers in Microsoft Excel
9.3 Calculations and Basic Formulas in Microsoft Excel
9.4 Formatting and Templates in Microsoft Excel
9.5 Google Sheets Basics
9.6 Text and Numbers in Google Sheets
9.7 Calculations and Basic Formulas in Google Sheets
9.8 Formatting and Templates in Google Sheets
Chapter Review
Chapter 10 Advanced Excel Formulas, Functions, and Techniques
Chapter Scenario
10.1 Data Tables and Ranges
10.2 More About Formulas
10.3 Using Arithmetic, Statistical, and Logical Functions
10.4 PivotTables
10.5 Auditing Formulas and Fixing Errors
10.6 Advanced Formatting Techniques
Chapter Review
Chapter 11 Advanced Excel Spreadsheets: Statistical and Data Analysis
Chapter Scenario
11.1 Understanding Data, Data Validation, and Data Tables
11.2 Statistical Functions
11.3 What-If Analysis
11.4 PivotTables/Charts
11.5 Data Analysis Charts
Chapter Review
Chapter 12 Using Excel in Accounting and Financial Reporting
Chapter Scenario
12.1 Basic Accounting
12.2 Financial Functions in Microsoft Excel
12.3 Integrating Microsoft Excel and Accounting Programs
Chapter Review
Chapter 13 Understanding and Using Databases
Chapter Scenario
13.1 What Is a Database?
13.2 Microsoft Access: Main Features and Navigation
13.3 Querying a Database
13.4 Maintaining Records in a Database
13.5 Creating Reports in Microsoft Access
13.6 Creating Forms in Microsoft Access
Chapter Review
Chapter 14 Advanced Database Use
Chapter Scenario
14.1 Advanced Queries in Microsoft Access
14.2 Multiple Table Forms
14.3 Customizing Forms
14.4 Customizing Reports
14.5 Using Macros
14.6 Data Analysis and Integration
Chapter Review
Chapter 15 Integrating Applications
Chapter Scenario
15.1 Microsoft 365: Collaboration and Integration
15.2 Microsoft Word: Integration with Microsoft Excel and Microsoft Access
15.3 Microsoft Word and Microsoft PowerPoint Integration
15.4 Microsoft Excel and Microsoft PowerPoint Integration
15.5 Microsoft Excel and Microsoft Access Integration
15.6 Integrating Data from Other Programs into Google Workspace
15.7 New Developments: The Role of Artificial Intelligence
15.8 Mastering Workplace Software Skills: A Project
Chapter Review
Index
