Description
Book SynopsisAbout our authors
Shelley Gaskin (series editor) is a professor in the Business and Computer Technology Division at Pasadena City College in Pasadena, California. She holds a bachelor's degree in Business Administration from Robert Morris College (Pennsylvania), a master's degree in Business from Northern Illinois University, and a doctorate in Adult and Community Education from Ball State University (Indiana). Before joining Pasadena City College, she spent 12 years in the computer industry, where she was a systems analyst, sales representative, and director of Customer Education with Unisys Corporation. She also worked for Ernst & Young on the development of large systems applications for their clients. She has written and developed training materials for custom systems applications in both the public and private sector and has also written and edited numerous computer application textbooks.
Alicia Vargas (Word and Excel author) is
Table of Contents
Table of Contents MICROSOFT OFFICE
-
Chapter 1: Microsoft Office Common Features and Windows 10 Features and File Management
- Explore Microsoft Office
- Create a Folder for File Storage
- Download and Extract Zipped Files and Enter, Edit, and Check the Spelling of Text in an Office Program
- Perform Office Commands and Apply Office Formatting
- Finalize an Office Document
- Use the Office Help Features
- Explore Windows 10
- Prepare to Work with Folders and Files
- Use File Explorer to Extract Zipped Files and to Display Locations, Folders, and Files
- Start Programs and Open Data Files
- Create, Rename, and Copy Files and Folders
WORD
- Introducing Microsoft Word 2019
-
Chapter 1: Creating Documents with Microsoft Word
- Create a New Document and Insert Text
- Insert and Format Graphics
- Insert and Modify Text Boxes and Shapes
- Preview and Print a Document
- Change Document and Paragraph Layout
- Create and Modify Lists
- Set and Modify Tab Stops
- Insert a SmartArt Graphic and an Icon
EXCEL
- Introducing Microsoft Excel 2019
-
Chapter 1: Creating a Worksheet and Charting Data
- Create, Save, and Navigate an Excel Workbook
- Enter Data in a Worksheet
- Construct and Copy Formulas and Use the SUM Function
- Format Cells with Merge & Center, Cell Styles, and Themes
- Chart Data to Create a Column Chart and Insert Sparklines
- Print a Worksheet, Display Formulas, and Close Excels
- Check Spelling in a Worksheet
- Enter Data by Range
- Construct Formulas for Mathematical Operations
- Edit Values in a Worksheet
- Format a Worksheet
ACCESS
- Introducing Microsoft Access 2019
-
Chapter 1: Getting Started with Microsoft Access 2019
- Identify Good Database Design
- Create a Table and Define Fields in a Blank Desktop Database
- Change the Structure of Tables and Add a Second Table
- Create a Query, Form, and Report
- Close a Database and Close Access
- Use a Template to Create a Database
- Organize Objects in the Navigation Pane
- Create a New Table in a Database Created with a Template
- View a Report
POWERPOINT
- Introducing Microsoft PowerPoint 2019
-
Chapter 1: Getting Started with Microsoft PowerPoint
- Create a New Presentation
- Edit a Presentation in Normal View
- Add Pictures to a Presentation
- Print and View a Presentation
- Edit an Existing Presentation
- Format a Presentation
- Use Slide Sorter View
- Apply Slide Transitions
