Muutke küpsiste eelistusi

Illustrated Microsoft®Office 365 & Office 2019 Advanced New edition [Pehme köide]

(NA), (Capilano College), (NA), (Johnson County Community College), (NA)
  • Formaat: Paperback / softback, 664 pages, kõrgus x laius x paksus: 15x215x274 mm, kaal: 793 g
  • Ilmumisaeg: 12-Jun-2019
  • Kirjastus: Course Technology Inc
  • ISBN-10: 0357360133
  • ISBN-13: 9780357360132
Teised raamatud teemal:
  • Pehme köide
  • Hind: 72,43 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 90,54 €
  • Säästad 20%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 2-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
Illustrated Microsoft®Office 365 & Office 2019 Advanced New editionSuurem pilt
  • Formaat: Paperback / softback, 664 pages, kõrgus x laius x paksus: 15x215x274 mm, kaal: 793 g
  • Ilmumisaeg: 12-Jun-2019
  • Kirjastus: Course Technology Inc
  • ISBN-10: 0357360133
  • ISBN-13: 9780357360132
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780357360132.html
Märksõnad:
Now students can master the nuances of Microsoft® Office quickly with ILLUSTRATED MICROSOFT® OFFICE 2019 & OFFICE 365 ADVANCED, part of today's popular Illustrated Series. This focused, user-friendly approach uses a proven two-page layout that allows students to work through an entire task without turning the page. Clear Learning Outcomes outline the skills for each lesson, while large full-color screen images reflect exactly what students see on their own computers. Each module begins with a brief overview of the principles covered in the lesson and introduces a real-world case scenario to engage students and reinforce critical skills to make them successful in their educational and professional careers. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.
Getting to Know Microsoft Office Versions OFF-1
Using SAM Projects and Textbook Projects SAM-1
Word 2019
Module 8 Integrating with Other Programs and Collaborating
WD 8-1
Embed an Excel File
WD 8-2
Understanding Object Linking and Embedding
Insert Objects
WD 8-4
Publishing a blog directly from Word
Link an Excel Chart
WD 8-6
Using the Object dialog box to create a linked file
Link a PowerPoint Slide
WD 8-8
Creating a PowerPoint presentation from a Word outline
Manage Document Links
WD 8-10
Create Charts
WD 8-12
Format and Edit Charts
WD 8-14
Track Changes
WD 8-16
Using Paste and Paste All with tracked changes
Work with Tracked Changes
WD 8-18
Manage Reviewers
WD 8-20
Compare Documents
WD 8-22
Practice
WD 8-24
Module 9 Developing Multi-page Documents
WD 9-1
Build a Document in Outline View
WD 9-2
Work in Outline View
WD 9-4
Navigate a Document
WD 9-6
Using bookmarks
Create and Modify Screenshots
WD 9-8
Create and Modify Screenshots (Continued)
WD 9-10
Use Advanced Find and Replace Options
WD 9-12
Add and Modify Captions
WD 9-14
Table of Authorities
Insert a Table of Contents
WD 9-16
Mark Text for an Index
WD 9-18
Generate an Index
WD 9-20
Insert Footers in Multiple Sections
WD 9-22
Insert Footers in Multiple Sections (Continued)
WD 9-24
Using text flow options
Insert Headers in Multiple Sections
WD 9-26
Understanding headers, footers, and sections
Insert Headers in Multiple Sections (Continued)
WD 9-28
Finalize a Multi-Page Document
WD 9-30
Finalize a Multi-Page Document (Continued)
WD 9-32
Using Advanced Print Options
Work with Equations
WD 9-34
More equation options
Create Master Documents and Subdocuments
WD 9-36
Inserting endnotes
Practice
WD 9-38
Module 10 Building Forms
WD 10-1
Convert Tables and Text
WD 10-2
Construct a Form Template
WD 10-4
Editing a Template
Add Text Content Controls
WD 10-6
Add Date Picker and Picture Content Controls
WD 10-8
Add Repeating Section and Check Box Content Controls
WD 10-10
Add Building Block Content Controls
WD 10-12
Add Drop-Down Content Controls
WD 10-14
Insert Legacy Tools Controls
WD 10-16
Using ActiveX controls
Format and Protect a Form
WD 10-18
Edit a Form
WD 10-20
Protecting documents with formatting and editing restrictions
Fill in a Form as a User
WD 10-22
Practice
WD 10-24
Module 11 Automating and Customizing Word
WD 11-1
Manage Pages
WD 11-2
Edit Pictures
WD 11-4
Applying 3-D and 3-D Rotation effects to a picture
Use Layering Options
WD 11-6
Arrange and Compress Graphics
WD 11-8
Create Character Styles
WD 11-10
Identifying paragraph, character, and linked styles
Manage Styles
WD 11-12
More ways to manage styles
Plan a Macro
WD 11-14
Record Macro Steps
WD 11-16
Pausing when recording a macro
Run a Macro
WD 11-18
Finding keyboard shortcuts
Edit a Macro in Visual Basic
WD 11-20
Creating a Macro in Visual Basic
Customize Word
WD 11-22
Copying a Macro to Another Document
Sign a Document Digitally
WD 11-24
Customizing the Quick Access toolbar
Acquiring a Digital ID
Practice
WD 11-26
Excel 2019
Module 9 Automating Worksheet Tasks
EX 9-1
Plan a Macro
EX 9-2
Enable a Macro
EX 9-4
Adding security to your macro projects Disabling macros
Record a Macro
EX 9-6
Run a Macro
EX 9-8
Running a macro automatically
Creating a main procedure
Edit a Macro
EX 9-10
Using relative referencing when creating a macro
Assign a Macro to a Button
EX 9-12
Copying a macro to another workbook
Assign a macro to a command button
EX 9-14
Working with ActiveX text boxes
Assign a Macro to a Form Control
EX 9-16
Working with option buttons
Practice
EX 9-18
Module 10 Advanced Worksheet Management
EX 10-1
Create and Apply a Template
EX 10-2
Creating a new workbook using a template
Import HTML Data
EX 10-4
Importing XML data
Importing HTML files directly into Excel
Create a Custom AutoFill List
EX 10-6
Work with Themes
EX 10-8
Work with Cell Comments
EX 10-10
Sharing Excel workbooks
Customize an Excel Workbook
EX 10-12
Tracking changes in a workbook
Encrypt a Workbook with a Password
EX 10-14
Working with a previous version of an Excel workbook
Work with Ideas
EX 10-16
Working with Funnel charts
Practice
EX 10-18
Module 1 Advanced Formulas and Functions
EX 11-1
Separate Data Using Flash Fill
EX 11-2
Working with Excel series
Format Data Using Text Functions
EX 11-4
Working with other text functions
Sum a Data Range Based on Conditions
EX 11-6
Find Values Based on Conditions
EX 11-8
Working with logical functions
Construct Formulas Using Named Ranges
EX 11-10
Using formulas to conditionally format data
Consolidate Worksheet Data
EX 11-12
Audit a Worksheet
EX 11-14
Watching formulas
Circling invalid data
Calculate Payments with the PMT Function
EX 11-16
Working with other financial functions
Practice
EX 11-18
Module 12 Performing What-If Analysis
EX 12-1
Define What-If Analysis
EX 12-2
Track What-If Analysis with Scenario Manager
EX 12-4
Merging scenarios
Generate a Scenario Summary
EX 12-6
Project Figures Using a Data Table
EX 12-8
Creating a two-input data table
Use Goal Seek
EX 12-10
Predicting data trends with Forecast Sheet
Find Solutions Using Solver
EX 12-12
Analyzing data using the Analysis ToolPak
Creating an Answer Report
Manage Data Using a Data Model
EX 12-14
Using Power View to create visualizations
Analyze Data Using Power Pivot
EX 12-16
Using the Excel 3D Maps tool
Practice
EX 12-18
Access 2019
Module 9 Creating Action Queries
AC 9-1
Create a Make Table Query
AC 9-2
Create an Append Query
AC 9-4
1900 versus 2000 dates
Create a Delete Query
AC 9-6
Create an Update Query
AC 9-8
Show hidden objects
Create an Outer Join
AC 9-10
Reviewing referential integrity
Apply an Outer Join
AC 9-12
Null versus zero-length string values
Create a Self-Join
AC 9-14
Practice
AC 9-16
Module 10 Creating Macros
AC 10-1
Understand Macros
AC 10-2
Create a Macro
AC 10-4
Modify Actions and Arguments
AC 10-6
Assigning a macro to a key combination
Assign a Macro to a Command Button
AC 10-8
Using a trusted database and setting up a trusted folder
Use Macro If Statements
AC 10-10
Use the Macro Else Clause
AC 10-12
Create a Data Macro
AC 10-14
Troubleshoot Macros
AC 10-16
Practice
AC 10-18
Module 11 Creating Modules and VBA
AC 11-1
Understand Modules and VBA
AC 11-2
Converting macros to VBA
Compare Macros and Modules
AC 11-4
Create Functions
AC 11-6
Use VBA If statements
AC 11-8
Document Procedures
AC 11-10
Using comments for debugging
Build Class Modules
AC 11-12
Modify Procedures
AC 11-14
Troubleshoot VBA
AC 11-16
Debugging
Practice
AC 11-18
Module 12 Completing the Application
AC 12-1
Create a Navigation Form
AC 12-2
Setting Navigation Pane options
Set Startup Options
AC 12-4
Analyze Database Performance
AC 12-6
Viewing object dependencies
Secure a Database
AC 12-8
Trusting a database to automatically enable content
Split a Database
AC 12-10
Document a Database
AC 12-12
Practice
AC 12-14
Power Point 2019
Module 8 Delivering Presentations
PPT 8-1
Work with Presentation Views
PPT 8-2
Recording a narration on a slide
Customize Handout and Notes Masters
PPT 8-4
Creating handouts in Microsoft Word
Set Up a Slide Show
PPT 8-6
Installing and managing Office Add-ins
Create a Custom Show
PPT 8-8
Linking to a custom slide show
Prepare a Presentation for Distribution
PPT 8-10
Digitally signing a presentation
Deliver a Presentation Online
PPT 8-12
Coauthoring a presentation
Create a Photo Album
PPT 8-14
Working with macros
Practice
PPT 8-16
Index Index 1
David W. Beskeen has authored or co-authored over 65 successful computer books since 1992, including more than 40 educational titles for Course Technology and Cengage. He has guided readers in mastering PowerPoint®, Word, Excel, Internet Explorer, Outlook, Windows®, LiveMotion and other leading proprietary software packages. An expert in applied technology, Beskeen has extensive teaching and consulting experience in today's computer technology. Carol M. Cram is the author of more than 35 textbooks on computer applications, business communications and Internet-related subjects. Ms. Cram was also a long-time faculty member at Capilano College in North Vancouver, where she served as the Convenor of the Executive Support Program and the Program Consultant for Business and Computers in Continuing Education as well as instructor of business and computer-related courses. NA Lisa Friedrichsen is a professor at Johnson County Community College in Overland Park, Kansas, where she teaches database and web development classes. She also has written several prominent Access, Office and web-related textbooks. Friedrichsen spent a decade at IBM Corp. before becoming a consultant, author and college professor. Combining her extensive industry experience with her passion for teaching, she creates clear, practical presentations. She earned a B.S. in engineering from Iowa State University and an MBA from Drake University. Lynn Wermers is a professor in the computer science department at North Shore Community College in Massachusetts, where she teaches IT, data management, data analysis and web development courses. She also teaches part time in the math department for the College of Professional Studies at Northeastern University. Wermers has authored numerous leading books focusing on Excel for Cengage.