Klientu atbalsts: 27018494

Grāmatu iegāde | Jauns profils | Ienākt

New Perspectives Collection, MicrosoftĀ® 365Ā® & OfficeĀ® 2021 Introductory New edition [Mīkstie vāki]

3.50/5 (4 ratings by Goodreads)

Cengage Cengage

Formāts: Paperback / softback, 1032 pages, height x width x depth: 38x215x274 mm, weight: 1587 g
Izdošanas datums: 26-Sep-2022
Izdevniecība: Course Technology Inc
ISBN-10: 0357672089
ISBN-13: 9780357672082

Citas grāmatas par šo tēmu:

Microsoft Office

Mīkstie vāki
Cena: 89,54 €*
* ši ir gala cena, t.i., netiek piemērotas nekādas papildus atlaides
Standarta cena: 111,93 €
Ietaupiet 20%
Grāmatu piegādes laiks ir 3-4 nedēļas, ja grāmata ir uz vietas izdevniecības noliktavā. Ja izdevējam nepieciešams publicēt jaunu tirāžu, grāmatas piegāde var aizkavēties.
Daudzums:
- - 1
  - 2
  - 3
  - 4
  - 5
  - 6
  - 7
  - 8
  - 9
  - 10
Ielikt grozā
Piegādes laiks - 4-6 nedēļas
Pievienot vēlmju sarakstam

Formāts: Paperback / softback, 1032 pages, height x width x depth: 38x215x274 mm, weight: 1587 g
Izdošanas datums: 26-Sep-2022
Izdevniecība: Course Technology Inc
ISBN-10: 0357672089
ISBN-13: 9780357672082

Citas grāmatas par šo tēmu:

Microsoft Office

Permanent link: https://www.kriso.lv/db/9780357672082.html

Keywords:

Using a unique in-depth, case-based approach, Cengage's NEW PERSPECTIVES COLLECTION, MICROSOFT® 365® & OFFICE® 2021 INTRODUCTORY prepares you for the Microsoft® Office® Specialist (MOS) certification exam -- and success in your future career. As you apply Microsoft® Office® skills to real-world business scenarios based on Burning Glass market insights, you will sharpen your critical-thinking and problem-solving skills. Professional tips and insights incorporated throughout provide context and relevancy to real-world practice, while ProSkills Boxes help strengthen your employability skills, including written and verbal communication. Updated coverage of Microsoft® 365® features and enhanced support for Mac users are also included. In addition, MindTap and up-to-date SAM (Skills Assessment Manager) online resources provide interactive study tools to help maximize your study time -- and results.

Getting to Know Microsoft Office Versions

(1)

Using SAM Projects and Textbook Projects

(1)

WORD MODULES

Module 1 Creating and Editing a Document: Writing a Business Letter and Formatting a Flyer

(1)

Session 1.1 Visual Overview: The Word Window

(28)

Starting Word

(1)

Working in Touch Mode

(1)

Setting Up the Word Window

(1)

Saving a Document

(3)

Entering Text

(1)

Inserting a Date with AutoComplete

(1)

Continuing to Type the Block-Style Letter

(1)

Typing a Hyperlink

(1)

Using the Undo and Redo Buttons

(1)

Correcting Errors as You Type

(3)

Proofreading a Document

(1)

Adjusting Paragraph and Line Spacing

(4)

Adjusting the Margins

(3)

Previewing and Printing a Document

(2)

Creating an Envelope

(3)

Session 1.2 Visual Overview: Formatting a Document

(2)

Opening an Existing Document

(2)

Using the Editor Pane

(4)

Changing Page Orientation

(1)

Changing the Font and Font Size

(2)

Applying Text Effects, Font Colors, and Font Styles

(2)

Aligning Text

(2)

Adding a Paragraph Border and Shading

(2)

Copying Formatting with the Format Painter

(2)

Inserting a Picture and Adding Alt Text

(5)

Adding a Page Border

(2)

Creating Bulleted and Numbered Lists

(3)

Getting Help

(3)

Review Assignments

(2)

Case Problem 1

Module 2 Navigating and Formatting a Document: Editing an Academic Document According to MLA Style

(1)

Session 2.1 Visual Overview: The Navigation Pane and Styles

(24)

Reviewing the Document

(3)

Working with Comments

(3)

Moving Text in a Document

(1)

Dragging and Dropping Text

(1)

Cutting or Copying and Pasting Text Using the Clipboard

(4)

Using the Navigation Pane

(3)

Finding and Replacing Text

(3)

Working with Styles

(4)

Session 2.2 Visual Overview: MLA Formatting Guidelines

(2)

Reviewing the MLA Style

(2)

Indenting a Paragraph

(2)

Inserting and Modifying Page Numbers

(2)

Creating a Footnote

(3)

Creating Citations and a Bibliography

(1)

Creating Citations

(6)

Inserting a Page Break

(1)

Generating a Bibliography

(2)

Modifying an Existing Source

(1)

Updating and Finalizing a Bibliography

(2)

Review Assignments

(1)

Case Problem 1

Module 3 Creating Tables and a Multipage Report: Writing a Recommendation

(1)

Session 3.1 Visual Overview: Organizing Information in Tables

(2)

Working with Headings in the Navigation Pane

(4)

Collapsing and Expanding Body Text in the Document

(2)

Inserting a Blank Table

(2)

Entering Data in a Table

(2)

Selecting Part of a Table

(1)

Sorting Rows in a Table

(2)

Inserting Rows and Columns in a Table

(1)

Deleting Rows and Columns

(1)

Changing Column Widths and Row Heights

(2)

Formatting Tables with Styles

(4)

Adding Formulas

(2)

Merging Cells

(3)

Session 3.2 Visual Overview: Working with Headers and Footers

(2)

Setting Tab Stops

(4)

Hyphenating a Document

(1)

Formatting a Document into Sections

(2)

Creating SmartArt

(3)

Adding Headers and Footers

(5)

Inserting a Cover Page

(2)

Working with Themes

(4)

Reviewing a Document in Read Mode

(3)

Review Assignments

(1)

Case Problem 1

(1)

Case Problem 2

Module 4 Enhancing Page Layout and Design Creating a Newsletter

(1)

Session 4.1 Visual Overview: Elements of Desktop Publishing

(28)

Using Continuous Section Breaks to Enhance Page Layout

(3)

Formatting Text in Columns

(2)

Inserting Symbols and Special Characters

(3)

Introduction to Working with Objects

(1)

Inserting Graphic Objects

(1)

Distinguishing Between Inline and Floating Objects

(1)

Wrapping Text Around an Object

(1)

Inserting Text Boxes

(1)

Inserting a Preformatted Text Box

(2)

Changing the Text Wrapping Setting for the Text Box

(2)

Adding Text to a Text Box

(2)

Drawing and Formatting a Text Box Using the Shapes Menu

(6)

Inserting Drop Caps

(3)

Session 4.2 Visual Overview: Editing Pictures

(2)

Formatting Text with WordArt

(2)

Modifying WordArt

(2)

Working with Pictures

(1)

Cropping a Picture

(5)

Searching for and Inserting Online Pictures and 3D Models

(3)

Rotating a Picture

(1)

Adjusting a Picture

(1)

Removing a Picture's Background

(3)

Adding an Icon

(3)

Balancing Columns

(1)

Enhancing the Newsletter's Formatting

(2)

Saving a Document as a PDF

(1)

Converting a PDF to a Word Document

(2)

Review Assignments

(2)

Case Problem 1

(3)

Case Problem 2

EXCEL MODULES

Module 1 Getting Started with Excel Tracking Miscellaneous Expenses for a Conference

(1)

Session 1.1 Visual Overview: The Excel Workbook

(29)

Introducing Excel and Spreadsheets

(2)

Getting Help

(1)

Using Keyboard Shortcuts to Work Faster

(1)

Using Excel in Touch Mode

(2)

Exploring a Workbook

(1)

Changing the Active Sheet

(1)

Navigating Within a Worksheet

(3)

Selecting a Cell Range

(1)

Closing a Workbook

(1)

Planning a Workbook

(1)

Starting a New Workbook

(1)

Renaming and Inserting Worksheets

(1)

Moving Worksheets

(1)

Deleting Worksheets

(1)

Saving a Workbook

(1)

Entering Text, Dates, and Numbers

(1)

Entering Text

(2)

Undoing and Redoing an Action

(1)

Editing Cell Content

(1)

Understanding AutoComplete

(1)

Displaying Numbers as Text

(1)

Entering Dates

(3)

Entering Numbers

(1)

Resizing Columns and Rows

(1)

Setting a Column Width

(2)

Wrapping Text Within a Cell

(1)

Changing Row Heights

(1)

Session 1.1 Quick Check

(1)

Session 1.2 Visual Overview: Excel Formulas and Functions

(27)

Calculating with Formulas

(1)

Entering a Formula

(3)

Copying and Pasting Formulas

(1)

Calculating with Functions

(1)

Understanding Function Syntax

(1)

Inserting Functions with AutoSum

(2)

Modifying a Worksheet

(1)

Moving and Copying a Cell or Range

(2)

Using the COUNT Function

(1)

Modifying Rows and Columns

(1)

Inserting Rows and Columns

(1)

Deleting Rows and Columns

(1)

Inserting and Deleting a Range

(2)

Using Flash Fill

(2)

Formatting a Worksheet

(1)

Adding Cell Borders

(1)

Changing the Font Size

(1)

Printing a Workbook

(1)

Changing Worksheet Views

(2)

Changing the Page Orientation

(1)

Setting the Scaling Options

(1)

Setting the Print Options

(1)

Viewing Worksheet Formulas

(2)

Session 1.2 Quick Check

(1)

Review Assignments

(2)

Case Problem 1

Module 2 Formatting Workbook Text and Data

Creating a Sales Report

(1)

Session 2.1 Visual Overview: Formatting a Worksheet

(27)

Formatting Cell Text

(1)

Applying Fonts and Font Styles

(2)

Applying a Font Color

(2)

Formatting Text Selections Within a Cell

(1)

Working with Fill Colors and Backgrounds

(1)

Changing a Fill Color

(1)

Setting the Worksheet Tab Color

(1)

Adding a Background Image

(1)

Using Functions and Formulas with Sales Data

(4)

Formatting Numbers

(1)

Applying Number Formats

(3)

Displaying Percentages

(1)

Formatting Dates and Times

(1)

Formatting Worksheet Cells

(1)

Aligning Cell Content

(1)

Indenting Cell Content

(1)

Adding Borders to Cells

(2)

Merging Cells

(1)

Rotating Cell Contents

(1)

Exploring the Format Cells Dialog Box

(4)

Session 2.1 Quick Check

(1)

Session 2.2 Visual Overview: Designing a Printout

(33)

Calculating Averages

(3)

Applying Cell Styles

(2)

Creating a Custom Cell Style

(1)

Merging Custom Cell Styles

(1)

Copying and Pasting Formats

(1)

Copying Formats with the Format Painter

(2)

Copying Formats with the Paste Options Button

(1)

Copying Formats with Paste Special

(1)

Transposing Data

(1)

Finding and Replacing Text and Formats

(3)

Working with Themes

(1)

Applying a Theme

(1)

Setting Theme Colors and Fonts

(1)

Saving a Theme

(1)

Highlighting Data with Conditional Formats

(1)

Highlighting Cells Based on Their Values

(2)

Highlighting Cells with a Top/Bottom Rule

(1)

Editing a Conditional Formatting Rule

(2)

Clearing Conditional Formatting Rules

(1)

Documenting Conditional Formats

(2)

Formatting a Worksheet for Printing

(1)

Using Page Break Preview

(1)

Defining the Print Area

(1)

Inserting Page Breaks

(1)

Adding Print Titles

(2)

Designing Headers and Footers

(2)

Setting the Page Margins

(3)

Session 2.2 Quick Check

(1)

Review Assignments

(2)

Case Problem 1

Module 3 Performing Calculations with Formulas and Functions

Staffing a Call Center

(3)

Designing a Workbook for Calculations

(1)

Documenting Calculations

(1)

Constants and Units

(1)

Calculating with Dates and Times

(1)

AutoFilling Formulas and Data Patterns

(1)

AutoFilling a Formula

(1)

Exploring Auto Fill Options

(2)

Filling a Series

(2)

Applying Excel Functions

(1)

Rounding Data Values

(3)

Calculating Minimums and Maximums

(2)

Measures of Central Tendency

(3)

Nesting Functions

(2)

The Role of Blanks and Zeroes

(1)

Date and Time Functions

(2)

Interpreting Error Values

(2)

Session 3.1 Quick Check

(24)

Calculating Running Totals with the Quick Analysis Tool

(2)

Exploring Cell References

(1)

Relative Cell References

(1)

Absolute Cell References

(1)

Mixed Cell References

(1)

Entering an Absolute Cell Reference

(1)

Working with the IF Logical Function

(4)

Formatting Input, Calculated, and Output Values

(1)

Looking Up Data

(1)

Finding an Exact Match with the VLOOKUP Function

(4)

Performing What-lf Analyses with Formulas and Functions

(1)

Using Trial and Error

(3)

Using Goal Seek

(3)

Session 3.2 Quick Check

(1)

Review Assignments

(1)

Case Problem 1

Module 4 Analyzing and Charting Financial Data Preparing an Investment Report

(1)

Getting Started with Excel Charts

(2)

Creating a Pie Chart

(1)

Selecting the Data Source

(1)

Charting with the Quick Analysis Tool

(1)

Moving and Resizing a Chart

(2)

Working with Chart Elements

(1)

Formatting a Chart Element

(3)

Choosing a Chart Style

(1)

Changing the Color Scheme

(1)

Performing What-lf Analyses with Charts

(2)

Creating a Column Chart

(1)

Comparing Column Chart Subtypes

(1)

Creating a Clustered Column Chart

(1)

Editing a Chart Title

(1)

Setting the Gap Width

(1)

Adding Gridlines to a Chart

(1)

Creating a Line Chart

(1)

Editing the Category Axis

(1)

Formatting Data Markers

(2)

Creating a Combination Chart

(2)

Adding an Axis Title

(1)

Editing a Value Axis Scale

(2)

Session 4.1 Quick Check

(26)

Creating a Scatter Chart

(3)

Editing the Chart Data Source

(2)

Adding Graphic Objects to a Workbook

(1)

Adding a Data Callout to a Chart

(1)

Inserting a Graphic Shape

(1)

Inserting Graphic Icons

(2)

Tools for Managing Graphic Objects

(1)

Exploring Other Chart Types

(1)

Hierarchy Charts

(1)

Pareto Charts

(1)

Histogram Charts

(1)

Waterfall Charts

(1)

Creating Data Bars

(1)

Modifying a Data Bar Rule

(1)

Creating Sparklines

(4)

Formatting a Sparkline

(1)

Sparkline Groups and Sparkline Axes

(2)

Session 4.2 Quick Check

(1)

Review Assignments

(1)

Case Problem 1

ACCESS MODULES

Module 1 Creating a Database: Tracking Patient, Visit, and Billing Data

(1)

Session 1.1 Visual Overview: The Access Window

(23)

Introduction to Database Concepts

(1)

Organizing Data

(1)

Databases and Relationships

(2)

Relational Database Management Systems

(1)

Starting Access and Creating a Database

(2)

Working in Touch Mode

(2)

Creating a Table in Datasheet View

(1)

Renaming the Default Primary Key Field

(1)

Changing the Data Type of the Default Primary Key Field

(1)

Adding New Fields

(2)

Saving the Visit Table Structure

(1)

Creating a Table in Design View

(1)

Defining Fields

(4)

Specifying the Primary Key

(1)

Renaming Fields in Design View

(1)

Saving the Billing Table Structure

(1)

Closing a Table and Exiting Access

(1)

Session 1.1 Quick Check

(1)

Session 1.2 Visual Overview: The Create Tab Options

(27)

Entering Data into Tables

(6)

Copying Records from Another Access Database

(4)

Navigating a Datasheet

(1)

Creating a Simple Query

(3)

Creating a Simple Form

(3)

Creating a Simple Report

(3)

Printing a Report

(1)

Viewing Objects in the Navigation Pane

(1)

Using Microsoft Access Help

(1)

Managing a Database

(1)

Compacting and Repairing a Database

(1)

Backing Up and Restoring a Database

(1)

Session 1.2 Quick Check

(1)

Review Assignments

(1)

Case Problem 1

Module 2 Building a Database and Defining Table Relationships: Creating the Billing and Patient Tables

(1)

Session 2.1 Visual Overview: Table Window in Design View

(21)

Guidelines for Designing Databases

(2)

Guidelines for Setting Field Properties

(1)

Naming Fields and Objects

(1)

Assigning Field Data Types

(1)

Setting Field Sizes

(1)

Setting the Caption Property for Fields

(1)

Modifying a Table in Design View

(6)

Saving the Table Structure

(1)

Modifying the Structure of an Access Table

(1)

Moving a Field in Design View

(1)

Adding a Field in Design View

(1)

Modifying Field Properties

(1)

Changing the Format Property in Datasheet View

(2)

Changing Properties in Design View

(3)

Session 2.1 Quick Check

(1)

Session 2.2 Visual Overview: Understanding Table Relationships

(27)

Adding Records to a New Table

(2)

Importing Data from an Excel Worksheet

(4)

Creating a Table by Importing an Existing Table or Table Structure

(2)

Adding Fields to a Table Using the Data Type Gallery

(2)

Modifying the Structure of an Imported Table

(1)

Deleting Fields from a Table Structure

(2)

Renaming Fields in Design View

(1)

Changing the Data Type for a Field in Design View

(3)

Setting the Default Value Property for a Field

(2)

Adding Data to a Table by Importing a Text File

(2)

Defining Table Relationships

(1)

One-to-Many Relationships

(1)

Referential Integrity

(1)

Defining a Relationship Between Two Tables

(4)

Session 2.2 Quick Check

(1)

Review Assignments

(1)

Case Problems

Module 3 Maintaining and Querying a Database: Updating and Retrieving Information About Patients, Visits, and Invoices

(1)

Session 3.1 Visual Overview: Query Window in Design View

(23)

Updating a Database

(1)

Modifying Records

(1)

Hiding and Unhiding Fields

(2)

Finding Data in a Table

(1)

Deleting Records

(2)

Introduction to Queries

(1)

Creating and Running a Query

(3)

Updating Data Using a Query

(1)

Creating a Multitable Query

(2)

Sorting Data in a Query

(1)

Using an AutoFilter to Sort Data

(1)

Sorting on Multiple Fields in Design View

(4)

Filtering Data

(3)

Session 3.1 Quick Check

(1)

Session 3.2 Visual Overview: Selection Criteria in Queries

(29)

Defining Record Selection Criteria for Queries

(1)

Specifying an Exact Match

(2)

Modifying a Query

(3)

Using a Comparison Operator to Match a Range of Values

(2)

Defining Multiple Selection Criteria for Queries

(1)

The And Logical Operator

(2)

The Or Logical Operator

(2)

Changing a Datasheet's Appearance

(1)

Modifying the Font Size

(1)

Changing the Alternate Row Color in a Datasheet

(2)

Creating a Calculated Field

(4)

Formatting a Calculated Field

(1)

Using Aggregate Functions

(1)

Working with Aggregate Functions Using the Total Row

(1)

Creating Queries with Aggregate Functions

(3)

Using Record Group Calculations

(1)

Working with the Navigation Pane

(2)

Session 3.2 Quick Check

(1)

Review Assignments

(1)

Case Problems

Module 4 Creating Forms and Reports

Using Forms and Reports to Display Patient and Visit Data

(1)

Session 4.1 Visual Overview: Form Displayed in Form View

(25)

Creating a Form Using the Form Wizard

(3)

Modifying a Form's Design in Layout View

(1)

Applying a Theme to a Database Object

(4)

Adding a Picture to a Form

(2)

Changing the Color of Text on a Form

(2)

Navigating a Form

(1)

Finding Data Using a Form

(3)

Maintaining Table Data Using a Form

(1)

Previewing and Printing Selected Form Records

(2)

Creating a Form with a Main Form and a Subform

(5)

Session 4.1 Quick Check

(1)

Session 4.2 Visual Overview: Report Displayed in Print Preview

(15)

Creating a Report Using the Report Wizard

(4)

Modifying a Report's Design in Layout View

(1)

Applying a Theme to a Report

(1)

Changing the Alignment of Field Values

(1)

Moving and Resizing Fields on a Report

(2)

Changing the Font Color and Inserting a Picture in a Report

(1)

Using Conditional Formatting in a Report

(4)

Session 4.2 Quick Check

(1)

Review Assignments

(1)

Case Problems

POWERPOINT MODULES

Module 1 Creating a Presentation

Presenting Information About an Insurance Company

(1)

Session 1.1 Visual Overview: The PowerPoint Window

(31)

Planning a Presentation

(1)

Starting PowerPoint and Creating a New Presentation

(1)

Working in Touch Mode

(2)

Creating a Title Slide

(1)

Saving and Editing a Presentation

(3)

Adding New Slides

(2)

Creating Lists

(1)

Creating a Bulleted List

(1)

Creating a Numbered List

(2)

Creating an Unnumbered List

(2)

Formatting Text

(3)

Moving and Copying

(2)

Manipulating Slides

(3)

Changing the Theme

(4)

Closing a Presentation

(1)

Session 1.1 Quick Check

(1)

Session 1.2 Visual Overview: Slide Show and Presenter Views

(2)

Opening a Presentation and Saving It with a New Name

(1)

Inserting Pictures and Adding Alt Text

(3)

Cropping Pictures

(4)

Resizing and Moving Objects

(4)

Compressing Pictures

(2)

Converting a List to a SmartArt Graphic

(4)

Adding Speaker Notes

(1)

Editing Common File Properties

(1)

Checking Spelling

(2)

Running a Slide Show

(5)

Printing a Presentation

(4)

Closing PowerPoint

(1)

Review Assignments

(2)

Case Problem 1

(1)

Case Problem 2

Module 2 Adding Media and Special Effects Using Media in a Presentation for a Veterinary Hospital

(1)

Session 2.1 Visual Overview: Formatting Graphics

(32)

Applying a Theme Used in Another Presentation

(2)

Inserting Shapes

(3)

Formatting Objects

(1)

Formatting Shapes

(4)

Formatting Pictures

(2)

Duplicating Objects

(1)

Rotating and Flipping Objects

(1)

Creating and Formatting a Table

(1)

Creating a Table and Adding Data to It

(2)

Inserting and Deleting Rows and Columns

(1)

Formatting a Table

(6)

Filling Cells with Pictures

(2)

Inserting Symbols

(2)

Adding Footers and Headers

(4)

Session 2.2 Visual Overview: Using Animations and Transitions

(2)

Applying Transitions

(2)

Applying Animations

(1)

Animating Objects

(5)

Changing How an Animation Starts

(1)

Animating Lists

(3)

Using the Morph Transition

(4)

Adding and Modifying Video

(1)

Adding Video to Slides

(3)

Trimming Videos

(1)

Setting a Poster Frame

(1)

Modifying Video Playback Options

(2)

Understanding Animation Effects Applied to Videos

(2)

Compressing Media

(4)

Review Assignments

(2)

Case Problem 1

Index

New Perspectives Collection, MicrosoftĀ® 365Ā® & OfficeĀ® 2021 Introductory New edition [Mīkstie vāki]

Konts un iestatījumi

Meklēšana

Meklēt datubāzē

Refine By

Tēmas Grāmatas angļu valodā

Izvēlieties iepirkumu grozu