Shelley Gaskin, Alicia Vargas, Debra Geoghan, Nancy Graviett
Go! with Microsoft Office 365, 2019 Edition Introductory
Schade – dieser Artikel ist leider ausverkauft. Sobald wir wissen, ob und wann der Artikel wieder verfügbar ist, informieren wir Sie an dieser Stelle.
Shelley Gaskin, Alicia Vargas, Debra Geoghan, Nancy Graviett
Go! with Microsoft Office 365, 2019 Edition Introductory
- Broschiertes Buch
- Merkliste
- Auf die Merkliste
- Bewerten Bewerten
- Teilen
- Produkt teilen
- Produkterinnerung
- Produkterinnerung
Now live! SUMMER 2020 DIGITAL UPDATE for digital content Microsoft Office 365 updates are reflected in the eText and associated MyLab for this title. To learn more, contact your Pearson representative. For introductory courses in Microsoft-« Office. Seamless digital instruction, practice, and assessment For over 17 years, instructors have relied upon the GO! series to teach Microsoft Office successfully. The series uses a project-based approach that clusters learning objectives around projects, rather than software features, so students can practice solving real business problems. Gaskin uses…mehr
Andere Kunden interessierten sich auch für
- McGraw HillGlencoe Keyboarding with Computer Applications, Microsoft Office 2007, Student Manual47,99 €
- Edward G. MartinDiscovering Microsoft Office 2007: Windows XP and Vista, Word, Excel, Access, PowerPoint72,99 €
- Lonnie E. MoseleyMastering Microsoft Office 9735,99 €
- U. C. BooksMicrosoft Office 365/2016 Keyboard Shortcuts For Macintosh15,99 €
- June Jamnich ParsonsPractical Microsoft Office 2013 [With CDROM]136,99 €
- U. C. BooksMicrosoft Office 2010 Keyboard Shortcuts For Windows15,99 €
- U. C. BooksMicrosoft Office 2016 Keyboard Shortcuts For Windows19,99 €
-
-
-
Now live! SUMMER 2020 DIGITAL UPDATE for digital content Microsoft Office 365 updates are reflected in the eText and associated MyLab for this title. To learn more, contact your Pearson representative. For introductory courses in Microsoft-« Office. Seamless digital instruction, practice, and assessment For over 17 years, instructors have relied upon the GO! series to teach Microsoft Office successfully. The series uses a project-based approach that clusters learning objectives around projects, rather than software features, so students can practice solving real business problems. Gaskin uses easy-to-follow Microsoft Procedural Syntax so students always know where to go on the ribbon; she combines this with a Teachable Moment approach that offers learners tips and instructions at the precise moment theyGÇÖre needed. Updated to Office 365, GO! with Microsoft-« Office 365-«, 2019 Edition, Introductory adds tips for Mac users, revised instructional projects, and improved coverage of the what, why, and how of skills application. Also available with MyLab IT MyLabGäó is the teaching and learning platform that empowers you to reach every student. By combining trusted author content with digital tools and a flexible platform, MyLab personalizes the learning experience and improves results for each student. MyLab IT 2019 delivers trusted content and resources through an expansive course materials library, including new easy-to-use Prebuilt Learning Modules that promote student success. Through an authentic learning experience, students become sharp critical thinkers and proficient in Microsoft Office, developing essential skills employers seek. Learn more about MyLab IT.
Produktdetails
- Produktdetails
- Verlag: Pearson Education
- Seitenzahl: 1056
- Erscheinungstermin: 1. Juni 2021
- Englisch
- Abmessung: 277mm x 213mm x 36mm
- Gewicht: 2132g
- ISBN-13: 9780135417812
- ISBN-10: 0135417813
- Artikelnr.: 57176198
- Herstellerkennzeichnung
- Libri GmbH
- Europaallee 1
- 36244 Bad Hersfeld
- 06621 890
- Verlag: Pearson Education
- Seitenzahl: 1056
- Erscheinungstermin: 1. Juni 2021
- Englisch
- Abmessung: 277mm x 213mm x 36mm
- Gewicht: 2132g
- ISBN-13: 9780135417812
- ISBN-10: 0135417813
- Artikelnr.: 57176198
- Herstellerkennzeichnung
- Libri GmbH
- Europaallee 1
- 36244 Bad Hersfeld
- 06621 890
About 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 a faculty member in Business Information Technology at Pasadena City College. She holds a master's and a bachelor's degree in business education from California State University, Los Angeles, and has authored several textbooks and training manuals on Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Debra Geoghan (PowerPoint author) is a Professor of Computer Science in the STEM department at Bucks County Community College, teaching computer classes ranging from basic computer literacy to cybercrime, computer forensics, and networking. She has certifications from Microsoft, CompTIA, and Apple. Deb has taught at the college level since 1996 and alsospent 11 years in the high school classroom. She holds a B.S. in Secondary Science Education from Temple University and an M.A. in Computer Science Education from Arcadia University. Throughout her teaching career Deb has worked with educators to integrate technology across the curriculum. At BCCC she serves on many technology committees, presents technology workshops for BCCC faculty, and heads the Computer Science Area. Deb is an avid user of technology, which has earned her the nickname gadget lady. Nancy Graviett (Access author) is a professor and department chair in Business Technology at St. Charles Community College inCottleville, Missouri. She holds a bachelor's degree in marketing and a master's degree in business education from the University of Missouri and has completed a certificate in online education. Nancy has authored textbooks on WordPerfect, Google, Microsoft Outlook, and Microsoft Access.
MICROSOFT OFFICE
* Chapter 1: Microsoft Office Common Features and Windows 10 Features
and File Management
1. Explore Microsoft Office
2. Create a Folder for File Storage
3. Download and Extract Zipped Files and Enter, Edit, and Check
the Spelling of Text in an Office Program
4. Perform Office Commands and Apply Office Formatting
5. Finalize an Office Document
6. Use the Office Help Features
7. Explore Windows 10
8. Prepare to Work with Folders and Files
9. Use File Explorer to Extract Zipped Files and to Display
Locations, Folders, and Files
10. Start Programs and Open Data Files
11. Create, Rename, and Copy Files and Folders
WORD
* Introducing Microsoft Word 2019
* Chapter 1: Creating Documents with Microsoft Word
1. Create a New Document and Insert Text
2. Insert and Format Graphics
3. Insert and Modify Text Boxes and Shapes
4. Preview and Print a Document
5. Change Document and Paragraph Layout
6. Create and Modify Lists
7. Set and Modify Tab Stops
8. Insert a SmartArt Graphic and an Icon
* Chapter 2: Creating Cover Letters and Using Tables to Create Resumes
1. Create a Table for a Resume
2. Format a Table
3. Present a Word Document Online
4. Create a Letterhead for a Cover Letter
5. Create a Cover Letter and Correct and Reorganize Text
6. Use the Word Editor to Check Your Documents
7. Print an Envelope, Change Style Sets, Create a Word Template
and Use Learning Tools
* Chapter 3: Creating Research Papers, Newsletters, and Merged Mailing
Labels
1. Create a Research Paper
2. Insert Footnotes in a Research Paper
3. Create Citations and a Bibliography in a Research Paper
4. Use Read Mode and PDF Reflow
5. Format a Multiple-Column Newsletter
6. Use Special Character and Paragraph Formatting
7. Create Mailing Labels Using Mail Merge
EXCEL
* Introducing Microsoft Excel 2019
* Chapter 1: Creating a Worksheet and Charting Data
1. Create, Save, and Navigate an Excel Workbook
2. Enter Data in a Worksheet
3. Construct and Copy Formulas and Use the SUM Function
4. Format Cells with Merge & Center, Cell Styles, and Themes
5. Chart Data to Create a Column Chart and Insert Sparklines
6. Print a Worksheet, Display Formulas, and Close Excels
7. Check Spelling in a Worksheet
8. Enter Data by Range
9. Construct Formulas for Mathematical Operations
10. Edit Values in a Worksheet
11. Format a Worksheet
* Chapter 2: Using Functions, Creating Tables, and Managing Large
Workbooks
1. Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX
Functions
2. Move Data, Resolve Error Messages, and Rotate Text
3. Use COUNTIF and IF Functions and Apply Conditional Formatting
4. Use Date & Time Functions and Freeze Panes
5. Create, Sort, and Filter an Excel Table
6. View, Format, and Print a Large Worksheet
7. Navigate a Workbook and Rename Worksheets
8. Enter Dates, Clear Contents, and Clear Formats
9. Copy and Paste by Using the Paste Options Gallery
10. Edit and Format Multiple Worksheets at the Same Time
11. Create a Summary Sheet with Column Sparklines
12. Format and Print Multiple Worksheets in a Workbook
* Chapter 3: Analyzing Data with Pie Charts, Line Charts, and What-If
Analysis Tools
1. Chart Data with a Pie Chart
2. Format a Pie Chart
3. Edit a Workbook and Update a Chart
4. Use Goal Seek to Perform What-If Analysis
5. Design a Worksheet for What-If Analysis
6. Answer What-If Questions by Changing Values in a Worksheet
7. Chart Data with a Line Chart
ACCESS
* Introduction to Microsoft Access 2019
* Chapter 1: Getting Started with Microsoft Access 2019
1. Identify Good Database Design
2. Create a Table and Define Fields in a Blank Desktop Database
3. Change the Structure of Tables and Add a Second Table
4. Create a Query, Form, and Report
5. Close a Database and Close Access
6. Use a Template to Create a Database
7. Organize Objects in the Navigation Pane
8. Create a New Table in a Database Created with a Template
9. View a Report
* Chapter 2: Sort and Query a Database
1. Open and Save an Existing Database
2. Create Table Relationships
3. Sort Records in a Table
4. Create a Query in Design View
5. Create a New Query From an Existing Query
6. Sort Query Results
7. Specify Criteria in a Query
8. Specify Numeric Criteria in a Query
9. Use Compound Criteria in a Query
10. Create a Query Based on More Than One Table
11. Use Wildcards in a Query
12. Create Calculated Fields in a Query
13. Calculate Statistics and Group Data in a Query
14. Create a Crosstab Query
15. Create a Parameter Query
* Chapter 3: Forms, Filters, and Reports
1. Create and Use a Form to Add and Delete Records
2. Filter Records
3. Create a Form by Using the Form Wizard
4. Modify a Form in Layout View and in Design View
5. Create a Report by Using the Report Tool and Modify the Report
in Layout View
6. Create a Report by Using the Report Wizard
7. Modify the Design of a Report
8. Keep Grouped Data Together in a Printed Report
POWERPOINT
* Introducing Microsoft PowerPoint 2019
* Chapter 1: Getting Started with Microsoft PowerPoint
1. Create a New Presentation
2. Edit a Presentation in Normal View
3. Add Pictures to a Presentation
4. Print and View a Presentation
5. Edit an Existing Presentation
6. Format a Presentation
7. Use Slide Sorter View
8. Apply Slide Transitions
* Chapter 2: Formatting PowerPoint Presentations
1. Format Numbered and Bulleted Lists
2. Insert Online Pictures
3. Insert Text Boxes and Shapes
4. Format Objects
5. Remove Picture Backgrounds and Insert WordArt
6. Create and Format a SmartArt Graphic
* Chapter 3: Enhancing a Presentation with Animation, Video, Tables,
and Charts
1. Customize Slide Backgrounds and Themes
2. Animate a Slide Show
3. Insert a Video
4. Create and Modify Tables
5. Create and Modify Charts
INTEGRATED PROJECTS
* Chapter 1: Integrating Word, Excel, Access, and PowerPoint
* Chapter 1: Microsoft Office Common Features and Windows 10 Features
and File Management
1. Explore Microsoft Office
2. Create a Folder for File Storage
3. Download and Extract Zipped Files and Enter, Edit, and Check
the Spelling of Text in an Office Program
4. Perform Office Commands and Apply Office Formatting
5. Finalize an Office Document
6. Use the Office Help Features
7. Explore Windows 10
8. Prepare to Work with Folders and Files
9. Use File Explorer to Extract Zipped Files and to Display
Locations, Folders, and Files
10. Start Programs and Open Data Files
11. Create, Rename, and Copy Files and Folders
WORD
* Introducing Microsoft Word 2019
* Chapter 1: Creating Documents with Microsoft Word
1. Create a New Document and Insert Text
2. Insert and Format Graphics
3. Insert and Modify Text Boxes and Shapes
4. Preview and Print a Document
5. Change Document and Paragraph Layout
6. Create and Modify Lists
7. Set and Modify Tab Stops
8. Insert a SmartArt Graphic and an Icon
* Chapter 2: Creating Cover Letters and Using Tables to Create Resumes
1. Create a Table for a Resume
2. Format a Table
3. Present a Word Document Online
4. Create a Letterhead for a Cover Letter
5. Create a Cover Letter and Correct and Reorganize Text
6. Use the Word Editor to Check Your Documents
7. Print an Envelope, Change Style Sets, Create a Word Template
and Use Learning Tools
* Chapter 3: Creating Research Papers, Newsletters, and Merged Mailing
Labels
1. Create a Research Paper
2. Insert Footnotes in a Research Paper
3. Create Citations and a Bibliography in a Research Paper
4. Use Read Mode and PDF Reflow
5. Format a Multiple-Column Newsletter
6. Use Special Character and Paragraph Formatting
7. Create Mailing Labels Using Mail Merge
EXCEL
* Introducing Microsoft Excel 2019
* Chapter 1: Creating a Worksheet and Charting Data
1. Create, Save, and Navigate an Excel Workbook
2. Enter Data in a Worksheet
3. Construct and Copy Formulas and Use the SUM Function
4. Format Cells with Merge & Center, Cell Styles, and Themes
5. Chart Data to Create a Column Chart and Insert Sparklines
6. Print a Worksheet, Display Formulas, and Close Excels
7. Check Spelling in a Worksheet
8. Enter Data by Range
9. Construct Formulas for Mathematical Operations
10. Edit Values in a Worksheet
11. Format a Worksheet
* Chapter 2: Using Functions, Creating Tables, and Managing Large
Workbooks
1. Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX
Functions
2. Move Data, Resolve Error Messages, and Rotate Text
3. Use COUNTIF and IF Functions and Apply Conditional Formatting
4. Use Date & Time Functions and Freeze Panes
5. Create, Sort, and Filter an Excel Table
6. View, Format, and Print a Large Worksheet
7. Navigate a Workbook and Rename Worksheets
8. Enter Dates, Clear Contents, and Clear Formats
9. Copy and Paste by Using the Paste Options Gallery
10. Edit and Format Multiple Worksheets at the Same Time
11. Create a Summary Sheet with Column Sparklines
12. Format and Print Multiple Worksheets in a Workbook
* Chapter 3: Analyzing Data with Pie Charts, Line Charts, and What-If
Analysis Tools
1. Chart Data with a Pie Chart
2. Format a Pie Chart
3. Edit a Workbook and Update a Chart
4. Use Goal Seek to Perform What-If Analysis
5. Design a Worksheet for What-If Analysis
6. Answer What-If Questions by Changing Values in a Worksheet
7. Chart Data with a Line Chart
ACCESS
* Introduction to Microsoft Access 2019
* Chapter 1: Getting Started with Microsoft Access 2019
1. Identify Good Database Design
2. Create a Table and Define Fields in a Blank Desktop Database
3. Change the Structure of Tables and Add a Second Table
4. Create a Query, Form, and Report
5. Close a Database and Close Access
6. Use a Template to Create a Database
7. Organize Objects in the Navigation Pane
8. Create a New Table in a Database Created with a Template
9. View a Report
* Chapter 2: Sort and Query a Database
1. Open and Save an Existing Database
2. Create Table Relationships
3. Sort Records in a Table
4. Create a Query in Design View
5. Create a New Query From an Existing Query
6. Sort Query Results
7. Specify Criteria in a Query
8. Specify Numeric Criteria in a Query
9. Use Compound Criteria in a Query
10. Create a Query Based on More Than One Table
11. Use Wildcards in a Query
12. Create Calculated Fields in a Query
13. Calculate Statistics and Group Data in a Query
14. Create a Crosstab Query
15. Create a Parameter Query
* Chapter 3: Forms, Filters, and Reports
1. Create and Use a Form to Add and Delete Records
2. Filter Records
3. Create a Form by Using the Form Wizard
4. Modify a Form in Layout View and in Design View
5. Create a Report by Using the Report Tool and Modify the Report
in Layout View
6. Create a Report by Using the Report Wizard
7. Modify the Design of a Report
8. Keep Grouped Data Together in a Printed Report
POWERPOINT
* Introducing Microsoft PowerPoint 2019
* Chapter 1: Getting Started with Microsoft PowerPoint
1. Create a New Presentation
2. Edit a Presentation in Normal View
3. Add Pictures to a Presentation
4. Print and View a Presentation
5. Edit an Existing Presentation
6. Format a Presentation
7. Use Slide Sorter View
8. Apply Slide Transitions
* Chapter 2: Formatting PowerPoint Presentations
1. Format Numbered and Bulleted Lists
2. Insert Online Pictures
3. Insert Text Boxes and Shapes
4. Format Objects
5. Remove Picture Backgrounds and Insert WordArt
6. Create and Format a SmartArt Graphic
* Chapter 3: Enhancing a Presentation with Animation, Video, Tables,
and Charts
1. Customize Slide Backgrounds and Themes
2. Animate a Slide Show
3. Insert a Video
4. Create and Modify Tables
5. Create and Modify Charts
INTEGRATED PROJECTS
* Chapter 1: Integrating Word, Excel, Access, and PowerPoint
MICROSOFT OFFICE
* Chapter 1: Microsoft Office Common Features and Windows 10 Features
and File Management
1. Explore Microsoft Office
2. Create a Folder for File Storage
3. Download and Extract Zipped Files and Enter, Edit, and Check
the Spelling of Text in an Office Program
4. Perform Office Commands and Apply Office Formatting
5. Finalize an Office Document
6. Use the Office Help Features
7. Explore Windows 10
8. Prepare to Work with Folders and Files
9. Use File Explorer to Extract Zipped Files and to Display
Locations, Folders, and Files
10. Start Programs and Open Data Files
11. Create, Rename, and Copy Files and Folders
WORD
* Introducing Microsoft Word 2019
* Chapter 1: Creating Documents with Microsoft Word
1. Create a New Document and Insert Text
2. Insert and Format Graphics
3. Insert and Modify Text Boxes and Shapes
4. Preview and Print a Document
5. Change Document and Paragraph Layout
6. Create and Modify Lists
7. Set and Modify Tab Stops
8. Insert a SmartArt Graphic and an Icon
* Chapter 2: Creating Cover Letters and Using Tables to Create Resumes
1. Create a Table for a Resume
2. Format a Table
3. Present a Word Document Online
4. Create a Letterhead for a Cover Letter
5. Create a Cover Letter and Correct and Reorganize Text
6. Use the Word Editor to Check Your Documents
7. Print an Envelope, Change Style Sets, Create a Word Template
and Use Learning Tools
* Chapter 3: Creating Research Papers, Newsletters, and Merged Mailing
Labels
1. Create a Research Paper
2. Insert Footnotes in a Research Paper
3. Create Citations and a Bibliography in a Research Paper
4. Use Read Mode and PDF Reflow
5. Format a Multiple-Column Newsletter
6. Use Special Character and Paragraph Formatting
7. Create Mailing Labels Using Mail Merge
EXCEL
* Introducing Microsoft Excel 2019
* Chapter 1: Creating a Worksheet and Charting Data
1. Create, Save, and Navigate an Excel Workbook
2. Enter Data in a Worksheet
3. Construct and Copy Formulas and Use the SUM Function
4. Format Cells with Merge & Center, Cell Styles, and Themes
5. Chart Data to Create a Column Chart and Insert Sparklines
6. Print a Worksheet, Display Formulas, and Close Excels
7. Check Spelling in a Worksheet
8. Enter Data by Range
9. Construct Formulas for Mathematical Operations
10. Edit Values in a Worksheet
11. Format a Worksheet
* Chapter 2: Using Functions, Creating Tables, and Managing Large
Workbooks
1. Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX
Functions
2. Move Data, Resolve Error Messages, and Rotate Text
3. Use COUNTIF and IF Functions and Apply Conditional Formatting
4. Use Date & Time Functions and Freeze Panes
5. Create, Sort, and Filter an Excel Table
6. View, Format, and Print a Large Worksheet
7. Navigate a Workbook and Rename Worksheets
8. Enter Dates, Clear Contents, and Clear Formats
9. Copy and Paste by Using the Paste Options Gallery
10. Edit and Format Multiple Worksheets at the Same Time
11. Create a Summary Sheet with Column Sparklines
12. Format and Print Multiple Worksheets in a Workbook
* Chapter 3: Analyzing Data with Pie Charts, Line Charts, and What-If
Analysis Tools
1. Chart Data with a Pie Chart
2. Format a Pie Chart
3. Edit a Workbook and Update a Chart
4. Use Goal Seek to Perform What-If Analysis
5. Design a Worksheet for What-If Analysis
6. Answer What-If Questions by Changing Values in a Worksheet
7. Chart Data with a Line Chart
ACCESS
* Introduction to Microsoft Access 2019
* Chapter 1: Getting Started with Microsoft Access 2019
1. Identify Good Database Design
2. Create a Table and Define Fields in a Blank Desktop Database
3. Change the Structure of Tables and Add a Second Table
4. Create a Query, Form, and Report
5. Close a Database and Close Access
6. Use a Template to Create a Database
7. Organize Objects in the Navigation Pane
8. Create a New Table in a Database Created with a Template
9. View a Report
* Chapter 2: Sort and Query a Database
1. Open and Save an Existing Database
2. Create Table Relationships
3. Sort Records in a Table
4. Create a Query in Design View
5. Create a New Query From an Existing Query
6. Sort Query Results
7. Specify Criteria in a Query
8. Specify Numeric Criteria in a Query
9. Use Compound Criteria in a Query
10. Create a Query Based on More Than One Table
11. Use Wildcards in a Query
12. Create Calculated Fields in a Query
13. Calculate Statistics and Group Data in a Query
14. Create a Crosstab Query
15. Create a Parameter Query
* Chapter 3: Forms, Filters, and Reports
1. Create and Use a Form to Add and Delete Records
2. Filter Records
3. Create a Form by Using the Form Wizard
4. Modify a Form in Layout View and in Design View
5. Create a Report by Using the Report Tool and Modify the Report
in Layout View
6. Create a Report by Using the Report Wizard
7. Modify the Design of a Report
8. Keep Grouped Data Together in a Printed Report
POWERPOINT
* Introducing Microsoft PowerPoint 2019
* Chapter 1: Getting Started with Microsoft PowerPoint
1. Create a New Presentation
2. Edit a Presentation in Normal View
3. Add Pictures to a Presentation
4. Print and View a Presentation
5. Edit an Existing Presentation
6. Format a Presentation
7. Use Slide Sorter View
8. Apply Slide Transitions
* Chapter 2: Formatting PowerPoint Presentations
1. Format Numbered and Bulleted Lists
2. Insert Online Pictures
3. Insert Text Boxes and Shapes
4. Format Objects
5. Remove Picture Backgrounds and Insert WordArt
6. Create and Format a SmartArt Graphic
* Chapter 3: Enhancing a Presentation with Animation, Video, Tables,
and Charts
1. Customize Slide Backgrounds and Themes
2. Animate a Slide Show
3. Insert a Video
4. Create and Modify Tables
5. Create and Modify Charts
INTEGRATED PROJECTS
* Chapter 1: Integrating Word, Excel, Access, and PowerPoint
* Chapter 1: Microsoft Office Common Features and Windows 10 Features
and File Management
1. Explore Microsoft Office
2. Create a Folder for File Storage
3. Download and Extract Zipped Files and Enter, Edit, and Check
the Spelling of Text in an Office Program
4. Perform Office Commands and Apply Office Formatting
5. Finalize an Office Document
6. Use the Office Help Features
7. Explore Windows 10
8. Prepare to Work with Folders and Files
9. Use File Explorer to Extract Zipped Files and to Display
Locations, Folders, and Files
10. Start Programs and Open Data Files
11. Create, Rename, and Copy Files and Folders
WORD
* Introducing Microsoft Word 2019
* Chapter 1: Creating Documents with Microsoft Word
1. Create a New Document and Insert Text
2. Insert and Format Graphics
3. Insert and Modify Text Boxes and Shapes
4. Preview and Print a Document
5. Change Document and Paragraph Layout
6. Create and Modify Lists
7. Set and Modify Tab Stops
8. Insert a SmartArt Graphic and an Icon
* Chapter 2: Creating Cover Letters and Using Tables to Create Resumes
1. Create a Table for a Resume
2. Format a Table
3. Present a Word Document Online
4. Create a Letterhead for a Cover Letter
5. Create a Cover Letter and Correct and Reorganize Text
6. Use the Word Editor to Check Your Documents
7. Print an Envelope, Change Style Sets, Create a Word Template
and Use Learning Tools
* Chapter 3: Creating Research Papers, Newsletters, and Merged Mailing
Labels
1. Create a Research Paper
2. Insert Footnotes in a Research Paper
3. Create Citations and a Bibliography in a Research Paper
4. Use Read Mode and PDF Reflow
5. Format a Multiple-Column Newsletter
6. Use Special Character and Paragraph Formatting
7. Create Mailing Labels Using Mail Merge
EXCEL
* Introducing Microsoft Excel 2019
* Chapter 1: Creating a Worksheet and Charting Data
1. Create, Save, and Navigate an Excel Workbook
2. Enter Data in a Worksheet
3. Construct and Copy Formulas and Use the SUM Function
4. Format Cells with Merge & Center, Cell Styles, and Themes
5. Chart Data to Create a Column Chart and Insert Sparklines
6. Print a Worksheet, Display Formulas, and Close Excels
7. Check Spelling in a Worksheet
8. Enter Data by Range
9. Construct Formulas for Mathematical Operations
10. Edit Values in a Worksheet
11. Format a Worksheet
* Chapter 2: Using Functions, Creating Tables, and Managing Large
Workbooks
1. Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX
Functions
2. Move Data, Resolve Error Messages, and Rotate Text
3. Use COUNTIF and IF Functions and Apply Conditional Formatting
4. Use Date & Time Functions and Freeze Panes
5. Create, Sort, and Filter an Excel Table
6. View, Format, and Print a Large Worksheet
7. Navigate a Workbook and Rename Worksheets
8. Enter Dates, Clear Contents, and Clear Formats
9. Copy and Paste by Using the Paste Options Gallery
10. Edit and Format Multiple Worksheets at the Same Time
11. Create a Summary Sheet with Column Sparklines
12. Format and Print Multiple Worksheets in a Workbook
* Chapter 3: Analyzing Data with Pie Charts, Line Charts, and What-If
Analysis Tools
1. Chart Data with a Pie Chart
2. Format a Pie Chart
3. Edit a Workbook and Update a Chart
4. Use Goal Seek to Perform What-If Analysis
5. Design a Worksheet for What-If Analysis
6. Answer What-If Questions by Changing Values in a Worksheet
7. Chart Data with a Line Chart
ACCESS
* Introduction to Microsoft Access 2019
* Chapter 1: Getting Started with Microsoft Access 2019
1. Identify Good Database Design
2. Create a Table and Define Fields in a Blank Desktop Database
3. Change the Structure of Tables and Add a Second Table
4. Create a Query, Form, and Report
5. Close a Database and Close Access
6. Use a Template to Create a Database
7. Organize Objects in the Navigation Pane
8. Create a New Table in a Database Created with a Template
9. View a Report
* Chapter 2: Sort and Query a Database
1. Open and Save an Existing Database
2. Create Table Relationships
3. Sort Records in a Table
4. Create a Query in Design View
5. Create a New Query From an Existing Query
6. Sort Query Results
7. Specify Criteria in a Query
8. Specify Numeric Criteria in a Query
9. Use Compound Criteria in a Query
10. Create a Query Based on More Than One Table
11. Use Wildcards in a Query
12. Create Calculated Fields in a Query
13. Calculate Statistics and Group Data in a Query
14. Create a Crosstab Query
15. Create a Parameter Query
* Chapter 3: Forms, Filters, and Reports
1. Create and Use a Form to Add and Delete Records
2. Filter Records
3. Create a Form by Using the Form Wizard
4. Modify a Form in Layout View and in Design View
5. Create a Report by Using the Report Tool and Modify the Report
in Layout View
6. Create a Report by Using the Report Wizard
7. Modify the Design of a Report
8. Keep Grouped Data Together in a Printed Report
POWERPOINT
* Introducing Microsoft PowerPoint 2019
* Chapter 1: Getting Started with Microsoft PowerPoint
1. Create a New Presentation
2. Edit a Presentation in Normal View
3. Add Pictures to a Presentation
4. Print and View a Presentation
5. Edit an Existing Presentation
6. Format a Presentation
7. Use Slide Sorter View
8. Apply Slide Transitions
* Chapter 2: Formatting PowerPoint Presentations
1. Format Numbered and Bulleted Lists
2. Insert Online Pictures
3. Insert Text Boxes and Shapes
4. Format Objects
5. Remove Picture Backgrounds and Insert WordArt
6. Create and Format a SmartArt Graphic
* Chapter 3: Enhancing a Presentation with Animation, Video, Tables,
and Charts
1. Customize Slide Backgrounds and Themes
2. Animate a Slide Show
3. Insert a Video
4. Create and Modify Tables
5. Create and Modify Charts
INTEGRATED PROJECTS
* Chapter 1: Integrating Word, Excel, Access, and PowerPoint