Description
Book SynopsisAbout our authors
Margo Chaney Adkins is an associate professor of information technology at Carroll Community College in Westminster, Maryland. She holds a bachelor's degree in information systems and a master's degree in post-secondary education from Salisbury University.
Stephanie Murre-Wolf is a technology and computer applications instructor at Moraine Park Technical College in Wisconsin. She is a graduate of Alverno College and enjoys teaching, writing curriculum, and authoring textbooks. In addition to classroom instruction, Stephanie actively performs corporate training in technology. She is married and has two sons; together, the family enjoys the outdoors.
Table of ContentsPART 1: TECHNOLOGY FUNDAMENTALS
- Getting Started with Computer Concepts
- Common Features of Windows and Office
- Browse the Internet
PART 2: MICROSOFT OFFICE
Microsoft Word
- Create Letters and Memos
- Create Business Reports
- Create Flyers
- Create Newsletters and Mail Merge Documents
- Capstone Project
- Integrated Project 1: Format Academic Reports and Include Information from the Web
- Integrated Project 2: Use Excel Data in Word Mail Merge
- Office Online Project: Create Flyers Using Word Online
Microsoft Excel
- Create Workbooks with Excel 2019
- Insert Summary Functions and Create Charts
- Manage Multiple Worksheets
- More Functions and Excel Tables
- Text, Statistical, Logical, and Conditional Functions
- Capstone Project
- Integrated Project 3: Copy Word Tables into Excel Worksheets
- Integrated Project 4: Link Data from Excel
- Integrated Project 5: Refer to Cells in Other Workbooks
- Excel Online Project: Create Workbooks Using Excel Online
Microsoft Access
- Create Database Tables
- Create Select Queries
- Create Forms
- Create Reports
- Capstone Project
- Integrated Project 6: Create Envelopes from Access Queries
- Integrated Project 7: Export Access Data to Word Documents
- Access Office Online Project: Create OneNote Notebooks
Microsoft PowerPoint
- Introduction to PowerPoint
- Getting Started with PowerPoint 2019
- Format a Presentation
- Enhance a Presentation with Graphics
- Present Data Using Tables, Charts, and Animation
- Capstone Project
- Integrated Project 8: Copy and Paste between Office Programs
- Integrated Project 9: Send PowerPoint Handouts to Word
- PowerPoint Online Project: Create Presentations Using PowerPoint Online App
Microsoft Office Specialist Appendixes