Update cookies preferences

New Perspectives Collection, Microsoft® 365® & Office® 2021 Intermediate New edition [Paperback / softback]

  • Format: Paperback / softback, 840 pages, height x width x depth: 35x215x276 mm, weight: 1746 g
  • Pub. Date: 06-Dec-2022
  • Publisher: Course Technology Inc
  • ISBN-10: 0357672127
  • ISBN-13: 9780357672129
Other books in subject:
  • Paperback / softback
  • Price: 95,11 €*
  • * the price is final i.e. no additional discount will apply
  • Regular price: 118,89 €
  • Save 20%
  • This book is not in stock. Book will arrive in about 2-4 weeks. Please allow another 2 weeks for shipping outside Estonia.
  • Quantity:
  • Add to basket
  • Delivery time 4-6 weeks
  • Add to Wishlist
New Perspectives Collection, Microsoft® 365® & Office® 2021 Intermediate New editionLarger Image
  • Format: Paperback / softback, 840 pages, height x width x depth: 35x215x276 mm, weight: 1746 g
  • Pub. Date: 06-Dec-2022
  • Publisher: Course Technology Inc
  • ISBN-10: 0357672127
  • ISBN-13: 9780357672129
Other books in subject:
Permanent link: https://www.kriso.ee/db/9780357672129.html
Keywords:
Using a unique in-depth, case-based approach, Cengage's NEW PERSPECTIVES COLLECTION, MICROSOFT® 365® & OFFICE® 2021 INTERMEDIATE thoroughly 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(1)
Using SAM Projects and Textbook Projects 1(1)
WORD MODULES
Module 5 Working with Templates, Themes, and Styles
Creating a Summary Report
1(1)
Session 5.1 Visual Overview: Custom Themes and Style Sets
2(2)
Creating a New Document from a Template
4(3)
Using Go To
7(2)
Using the Thesaurus to Find Synonyms
9(2)
Customizing the Document Theme
11(4)
Changing the Theme Colors
11(1)
Changing the Theme Fonts
12(2)
Saving a Custom Theme
14(1)
Selecting a Style Set
15(3)
Customizing Styles
18(6)
Changing Character Spacing
18(2)
Displaying the Styles Pane
20(2)
Updating a Style
22(2)
Session 5.2 Visual Overview: Creating a New Style
24(2)
Creating a New Style
26(4)
Displaying Information About Styles and Formatting
30(6)
Inspecting Styles
30(2)
Examining and Comparing Formatting in the Reveal Formatting Pane
32(2)
Reviewing Line and Page Break Settings
34(2)
Generating a Table of Contents
36(3)
Updating a Table of Contents
39(2)
Saving a Document as a Template
41(5)
Opening a New Document Based on Your Template
46(1)
Creating a New Quick Part
47(4)
Session 5.2 Quick Check
51(1)
Review Assignments
52(1)
Case Problem 1
53(1)
Case Problem 2
54
Module 6 Using Mail Merge Creating a Form Letter, Mailing Labels, and a Phone Directory
1(1)
Session 6.1 Visual Overview: Mail Merge
2(2)
Inserting a Date Field
4(1)
Performing a Mail Merge
5(1)
Starting the Mail Merge and Selecting a Main Document
6(1)
Creating a Data Source
7(4)
Entering Data into a Data Source
11(2)
Saving a Data Source
13(2)
Inserting Merge Fields
15(4)
Creating a Mail Merge Rule
19(2)
Previewing the Merged Document
21(2)
Merging the Main Document and the Data Source
23(3)
Session 6.2 Visual Overview: Editing a Data Source
26(2)
Reopening a Main Document
28(1)
Editing a Data Source
29(3)
Sorting Records
32(2)
Filtering Records
34(2)
Creating Mailing Labels
36(5)
Creating a Phone Directory
41(3)
Converting Text to a Table
44(5)
Review Assignments
49(2)
Case Problem 1
51(1)
Case Problem 2
52
Module 7 Collaborating with Others and Integrating Data
Preparing an Information Sheet
1(1)
Session 7.1 Visual Overview: Tracking Changes
2(2)
Editing a Document with Tracked Changes
4(4)
Adjusting Track Changes Options
8(2)
Comparing and Combining Documents
10(6)
Accepting and Rejecting Changes
16(3)
Embedding and Linking Objects from Other Programs
19(7)
Embedding an Excel Worksheet Object
21(3)
Modifying an Embedded Worksheet Object
24(2)
Session 7.2 Visual Overview: Linking an Excel Chart Object
26(2)
Linking an Excel Chart Object
28(7)
Modifying the Linked Chart Object
30(3)
Breaking Links
33(2)
Using Hyperlinks in Word
35(5)
Inserting a Hyperlink to a Bookmark in the Same Document
35(4)
Creating Hyperlinks to Other Documents
39(1)
Optimizing a Document for Online Viewing
40(6)
Applying a Background Fill Effect
42(1)
Inserting Horizontal Lines
43(3)
Editing Hyperlinks
46(1)
Creating and Publishing a Blog Post
47(3)
Review Assignments
50(1)
Case Problem 1
51(1)
Case Problem 2
52
EXCEL MODULES
Module 5 Generating Reports from Multiple Worksheets and Workbooks
Summarizing Profit and Loss Statements
1(1)
Session 5.1 Visual Overview: Worksheet Groups and 3-D References
2(2)
Working with Multiple Worksheets
4(2)
Copying a Worksheet
4(2)
Viewing a Workbook in Multiple Windows
6(4)
Arranging Multiple Workbook Windows
7(2)
Using Synchronized Scrolling Between Windows
9(1)
Working with Worksheet Groups
10(4)
Editing a Worksheet Group
11(2)
Ungrouping a Worksheet Group
13(1)
Writing 3-D References
14(6)
Referencing Cells in Other Worksheets
14(1)
Applying 3-D References to Formulas and Functions
14(6)
Session 5.2 Visual Overview: External References and Links
20(2)
Linking to External Workbooks
22(7)
Creating an External Reference
22(3)
Updating Workbook Links
25(1)
External References and Security Concerns
26(1)
Reviewing Links Within a Workbook
27(1)
Managing Workbook Links
28(1)
Creating Hyperlinks
29(5)
Linking to a Location Within a Workbook
29(2)
Linking to an Email Address
31(3)
Session 5.3 Visual Overview: Named Ranges and Templates
34(2)
Simplifying Formulas with Named Ranges
36(11)
Defining a Named Range
36(3)
Using Named Ranges in Formulas
39(3)
Determining the Scope of Named Ranges
42(2)
Using Defined Names in Existing Formulas
44(3)
Exploring Workbook Templates
47(7)
Setting Up a Workbook Template
48(2)
Creating a Workbook Based on a Template
50(4)
Review Assignments
54(1)
Case Problem 1
55(1)
Case Problem 2
56
Module 6 Managing Data with Data Tools Analyzing Employment Data
1(1)
Session 6.1 Visual Overview: Data Ranges, Workbook Panes, and Subtotals
2(2)
Handling Data in Excel
4(2)
Using Panes to View Data
6(4)
Dividing the Workbook Window into Panes
6(2)
Freezing Panes
8(2)
Locating Duplicate Records
10(3)
Highlighting Duplicate Values
10(2)
Removing Duplicate Records
12(1)
Sorting Records in a Data Range
13(6)
Sorting by a Single Field
13(2)
Sorting by Multiple Fields
15(2)
Sorting with a Custom List
17(2)
Calculating Subtotals
19(5)
Creating a Subtotal Row
19(2)
Using the Subtotal Outline View
21(3)
Session 6.2 Visual Overview: Filters and Excel Tables
24(2)
Locating Cells Within a Worksheet
26(1)
Finding and Selecting Multiple Cells
26(1)
Finding Cells by Type
27(1)
Filtering Data
27(10)
Filtering Based on One Field
28(1)
Filtering Based on Multiple Fields
29(1)
Using Criteria Filters
30(3)
Clearing Filters
33(1)
Applying an Advanced Filter
33(4)
Creating an Excel Table
37(11)
Converting a Range to a Table
37(2)
Using Table Styles
39(2)
Adding a Total Row
41(1)
Adding and Deleting Records
42(1)
Creating a Calculated Field
43(2)
Structural References and Excel Tables
45(3)
Session 6.3 Visual Overview: Slicers and Dashboards
48(2)
Filtering Data with Slicers
50(2)
Creating a Dashboard
52(12)
Formatting a Slicer
54(1)
Using the SUBTOTAL Function
55(3)
Creating Dynamic Charts
58(4)
Looking Up Data with Tables
62(2)
Review Assignments
64(2)
Case Problem 1
66(1)
Case Problem 2
67
Module 7 Summarizing Data with PivotTables
Preparing a Social Media Marketing Report
1(1)
Session 7.1 Visual Overview: Summary IF Functions and VLOOKUP
2(2)
Using Lookup Functions
4(8)
Creating Approximate Match Lookups
6(6)
Performing Two-Way Lookups with the XLOOKUP Function
12(2)
Retrieving Data with Index Match Lookups
14(2)
Exploring Logical Functions
16(3)
Using the IFS Function
17(1)
Combining Conditions with the OR and AND Functions
17(2)
Applying Summary IF Functions
19(9)
Conditional Counting with COUNTIF
20(2)
Calculating Conditional Sums with SUMIF
22(2)
Calculating Conditional Averages with AVERAGEIF
24(1)
Using Summary IFS Functions
25(3)
Session 7.2 Visual Overview: PivotTables
28(2)
Creating PivotTables
30(9)
Inserting a PivotTable
31(2)
Creating a PivotTable Layout
33(1)
Modifying the PivotTable Layout
34(1)
Adding Multiple Fields to a Row or Column
35(2)
Filtering a PivotTable
37(2)
Formatting a PivotTable
39(7)
Changing Labels and Number Formats
40(2)
Choosing a PivotTable Summary Function
42(3)
Reordering PivotTable Categories
45(1)
Setting PivotTable Options
46(1)
Setting the PivotTable Design
47(3)
Session 7.3 Visual Overview: PivotCharts and Slicers
50(2)
Introducing PivotCharts
52(8)
Creating a PivotChart
53(2)
Moving a PivotChart to Another Worksheet
55(1)
Creating a Pie PivotChart
56(4)
Using Slicers and PivotTables
60(5)
Applying a Slicer to Multiple PivotTables
61(2)
Creating a Timeline Slicer
63(2)
Drilling Down a PivotTable
65(3)
Review Assignments
68(2)
Case Problem
70(1)
Case Problem 2
71
Module 8 Performing What-If Analyses Maximizing Profits with the Right Product Mix
1(1)
Session 8.1 Visual Overview: Data Tables and What-If Analysis
2(2)
Understanding Cost-Volume Relationships
4(5)
Comparing Expenses and Revenue
4(2)
Exploring the Break-Even Point
6(1)
Finding the Break-Even Point with What-If Analysis
7(2)
Working with Data Tables
9(5)
Creating a One-Variable Data Table
9(3)
Charting a One-Variable Data Table
12(1)
Modifying a Data Table
13(1)
Creating a Two-Variable Data Table
14(8)
Formatting the Result Cell
17(1)
Charting a Two-Variable Data Table
18(4)
Session 8.2 Visual Overview: What-If Scenarios
22(2)
Exploring Financial Scenarios with Scenario Manager
24(6)
Defining a Scenario
25(3)
Viewing Scenarios
28(1)
Editing a Scenario
29(1)
Creating Scenario Summary Reports
30(6)
Session 8.3 Visual Overview: Optimal Solutions with Solver
36(2)
Optimizing a Product Mix
38(2)
Finding the Optimal Solution with Solver
40(10)
Activating Solver
41(1)
Setting the Objective Cell and Variable Cells
42(2)
Adding Constraints to Solver
44(6)
Exploring the Iterative Process
50(1)
Creating a Solver Answer Report
51(2)
Saving and Loading Solver Models
53(5)
Review Assignments
58(1)
Case Problem 1
59(2)
Case Problem 2
61
ACCESS MODULES
Module 5 Creating Advanced Queries and Enhancing Table Design
Making the Clinic Database Easier to Use
1(1)
Session 5.1 Visual Overview: Calculated Field
2(2)
Reviewing the Clinic Database
4(1)
Using a Pattern Match in a Query
5(3)
Using a List-of-Values Match in a Query
8(1)
Using the Not Logical Operator in a Query
9(4)
Using an AutoFilter to Filter Data
10(3)
Assigning a Conditional Value to a Calculated Field
13(4)
Creating a Parameter Query
17(4)
Creating a More Flexible Parameter Query
19(2)
Session 5.1 Quick Check
21(1)
Session 5.2 Visual Overview: Advanced Query Wizards
22(2)
Creating a Crosstab Query
24(6)
Creating a Find Duplicates Query
30(2)
Creating a Find Unmatched Query
32(2)
Creating a Top Values Query
34(1)
Session 5.2 Quick Check
35(1)
Session 5.3 Visual Overview: Lookup Fields and Input Masks
36(2)
Creating a Lookup Field
38(4)
Using the Input Mask Wizard
42(5)
Identifying Object Dependencies
47(1)
Defining Data Validation Rules
48(4)
Defining Field Validation Rules
49(1)
Defining Table Validation Rules
50(2)
Working with Long Text Fields
52(3)
Designating a Trusted Folder
55(2)
Session 5.3 Quick Check
57(1)
Review Assignments
58(1)
Case Problems
59
Module 6 Using Form Tools and Creating Custom Forms
Creating Forms for Lakewood Community Health Services
1(1)
Session 6.1 Visual Overview: Anchoring Controls
2(2)
Designing Forms
4(3)
Changing a Lookup Field to a Short Text field
4(3)
Creating a Relationship Report and Using the Documenter
7(4)
Creating Forms Using Form Tools
11(10)
Creating a Form Using the Datasheet Tool
11(2)
Creating a Form Using the Multiple Items Tool
13(1)
Creating a Form Using the Split Form Tool
14(1)
Modifying a Split Form in Layout View
15(4)
Anchoring Controls in a Form
19(2)
Session 6.1 Quick Check
21(1)
Session 6.2 Visual Overview: Custom Form in Design View
22(2)
Planning and Designing a Custom Form
24(1)
Creating a Custom Form in Design View
24(4)
Working in the Form Window in Design View
25(2)
Adding Fields to a Form
27(1)
Selecting, Moving, and Aligning Form Controls
28(4)
Resizing and Deleting Controls
32(2)
Adding a Combo Box Control to a Form
34(6)
Using Form Headers and Form Footers
40(3)
Adding a Title to a Form
41(2)
Session 6.2 Quick Check
43(1)
Session 6.3 Visual Overview: Custom Form in Form View
44(2)
Adding a Combo Box to Find Records
46(4)
Adding a Subform to a Form
50(3)
Displaying a Subform's Calculated Controls in the Main Form
53(8)
Adding Calculated Controls to a Subform's Form Footer Section
54(2)
Adding Calculated Controls to a Main Form
56(2)
Resizing, Moving, and Formatting Calculated Controls
58(3)
Changing the Tab Order in a Form
61(3)
Improving a Form's Appearance
64(5)
Adding a Line to a Form
64(1)
Adding a Rectangle to a Form
65(1)
Modifying the Visual Effects of the Controls in a Form
66(3)
Session 6.3 Quick Check
69(1)
Review Assignments
70(2)
Case Problems
72
Module 7 Creating Custom Reports Creating Custom Reports for Lakewood Community Health Services
1(1)
Session 7.1 Visual Overview: Report Sections
2(2)
Customizing Existing Reports
4(1)
Viewing a Report in Report View
4(4)
Copying and Pasting a Report into Word
6(2)
Modifying a Report in Layout View
8(7)
Modifying a Report in Design View
15(4)
Session 7.1 Quick Check
19(1)
Session 7.2 Visual Overview: Form in Design View and Print Preview
20(2)
Planning and Designing a Custom Report
22(1)
Creating a Query for a Custom Report
23(2)
Creating a Custom Report
25(7)
Sorting and Grouping Data in a Report
27(5)
Working with Controls in Design View
32(6)
Hiding Duplicate Values in a Report
38(1)
Session 7.2 Quick Check
39(1)
Session 7.3 Visual Overview: Custom Form in Design View
40(2)
Understanding Page Header and Page Footer Sections
42(8)
Adding the Date to a Report
42(4)
Adding Page Numbers to a Report
46(2)
Adding a Report Title to a Page Header Section
48(2)
Creating Mailing Labels
50(4)
Session 7.3 Quick Check
54(1)
Review Assignments
55(1)
Case Problems
56
Module 8 Sharing, Integrating, and Analyzing Data
Importing, Exporting, Linking, and Analyzing Data in the Clinic Database
1(1)
Session 8.1 Visual Overview: Exporting Data to XML and HTML
2(2)
Exporting an Access Query to an HTML Document
4(3)
Viewing an HTML Document in a Web Browser
6(1)
Importing a CSV File as an Access Table
7(5)
Analyzing a Table with the Table Analyzer
11(1)
Working with XML Files
12(11)
Importing Data from an XML File
13(1)
Saving and Running Import Specifications
14(3)
Exporting an Access Table as an XML File
17(3)
Saving and Running Export Specifications
20(3)
Session 8.1 Quick Check
23(1)
Session 8.2 Visual Overview: Tabbed Control with a Chart
24(2)
Using a Tab Control in a Form
26(4)
Creating a Chart Using the Chart Wizard
30(6)
Using Templates and Application Parts
36(4)
Exporting a Report to a PDF File
40(2)
Integrating Access with Other Applications
42(5)
Linking Data from an Excel Worksheet
43(4)
Session 8.2 Quick Check
47(1)
Review Assignments
48(1)
Case Problems
49
POWERPOINT MODULES
Module 3 Applying Advanced Formatting to Objects
Formatting Objects in a Presentation for a Sales and Marketing Company
1(1)
Session 3.1 Visual Overview: Creating a Chart on a Slide
2(2)
Working with SmartArt Graphics
4(12)
Creating a SmartArt Graphic
4(4)
Changing the Appearance of a SmartArt Graphic
8(2)
Animating a SmartArt Graphic
10(6)
Adding Audio to Slides
16(2)
Adding a Chart to a Slide
18(7)
Creating a Chart
18(4)
Modifying a Chart
22(3)
Inserting and Formatting Text Boxes
25(3)
Applying WordArt Styles to Text
28(4)
Session 3.2 Visual Overview: Formatting Shapes and Pictures
32(2)
Removing the Background from Pictures
34(3)
Editing Pictures
37(3)
Creating a Custom Shape
40(4)
Rotating Shapes with Text
44(6)
Applying Advanced Formatting to Shapes
50(4)
Making Presentations Accessible
54(7)
Checking for Accessibility Issues
55(3)
Checking the Order Objects Will Be Read by a Screen Reader
58(3)
Review Assignments
61(3)
Case Problem 1
64(1)
Case Problem 2
65
Module 4 Advanced Animations and Distributing Presentations
Creating an Advanced Presentation for Agricultural Development
1(1)
Session 4.1 Visual Overview: Understanding Advanced Animations
2(2)
Using Guides
4(2)
Adding More Than One Animation to an Object
6(4)
Using the Animation Pane
10(7)
Setting Animation Triggers
17(2)
Changing the Slide Background
19(6)
Creating and Editing Links
25(9)
Creating and Editing Text Links
25(4)
Changing the Color of Text Links
29(1)
Creating Object Links
30(2)
Inserting Action Buttons
32(2)
Creating Slide Zooms
34(5)
Creating Slide Zooms
34(3)
Modifying Slide Zooms
37(2)
Hiding a Slide
39(3)
Session 4.2 Visual Overview: Automatic Slide Timings
42(2)
Creating Self-Running Presentations
44(8)
Setting Slide Timings Manually
44(2)
Rehearsing Timings
46(2)
Recording a Slide Show
48(3)
Applying Kiosk Browsing
51(1)
Using the Document Inspector
52(3)
Saving a Presentation in Other Formats
55(9)
Saving a Presentation as a Video
55(2)
Saving Slides as Pictures and a Presentation as a Picture Presentation
57(3)
Save a Presentation as a PDF
60(2)
Save a Presentation as a PowerPoint Show
62(2)
Review Assignments
64(2)
Case Problem 1
66(2)
Case Problem 2
68
Index 1