Atjauninât sîkdatòu piekriðanu

Shelly Cashman Series® Microsoft® 365® & Office® 2021 Intermediate New edition [Mîkstie vâki]

(Indiana University, Purdue University at Indianapolis), (NA), (University of Central Florida), (University of Delaware), (Purdue University Calumet), (NA), (NA)
  • Formâts: Paperback / softback, 1056 pages, height x width x depth: 35x213x274 mm, weight: 1973 g
  • Izdoðanas datums: 31-Jan-2023
  • Izdevniecîba: Course Technology Inc
  • ISBN-10: 0357676831
  • ISBN-13: 9780357676837
Citas grâmatas par ðo tçmu:
  • Mîkstie vâki
  • Cena: 91,62 €*
  • * ði ir gala cena, t.i., netiek piemçrotas nekâdas papildus atlaides
  • Standarta cena: 114,53 €
  • 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:
  • Ielikt grozā
  • Piegâdes laiks - 4-6 nedçïas
  • Pievienot vçlmju sarakstam
Shelly Cashman Series® Microsoft® 365® & Office® 2021 Intermediate New editionPalielinât
  • Formâts: Paperback / softback, 1056 pages, height x width x depth: 35x213x274 mm, weight: 1973 g
  • Izdoðanas datums: 31-Jan-2023
  • Izdevniecîba: Course Technology Inc
  • ISBN-10: 0357676831
  • ISBN-13: 9780357676837
Citas grâmatas par ðo tçmu:
Permanent link: https://www.kriso.lv/db/9780357676837.html
Keywords:
Helping you quickly get up to speed, THE SHELLY CASHMAN SERIES® MICROSOFT® 365® & OFFICE® 2021 INTERMEDIATE, 1st edition, includes the latest on Microsoft 365 and Office 2021 features along with enhanced support for Mac users. Its trademark step-by-step, screen-by-screen, project-based approach enables you to expand your understanding of Office applications through hands-on experimentation and critical thinking. Module Learning Objectives are mapped to Microsoft Office Specialist (MOS) certification objectives, reinforcing the critical skills needed for college and career success. Other Ways boxes reveal alternate click paths to achieve a step, while BTW call-outs offer helpful hints as you work through your projects so you can make the most of Microsoft Office tools. In addition, MindTap and SAM (Skills Assessment Manager) online resources help maximize your study time -- and results.
Getting to Know Microsoft Office Versions 1(1)
Using SAM Projects and Textbook Projects 1(1)
Microsoft Word 2021
Module Four Creating a Multipage Document Objectives
1(1)
Introduction
1(1)
Project: Sales Proposal
1(3)
To Start Word, Open the Proposal Draft File, Save It with a New File Name, and Specify Word Settings
2(2)
Creating a Cover Page
4(5)
To Insert a Cover Page
5(1)
To Enter Text in Content Controls
6(1)
To Format Characters in Small Caps and Modify Character Spacing
7(2)
Modifying Page Formatting
9(10)
To Print Specific Pages in a Document
9(3)
To Delete a Page Break
12(1)
To Apply Heading Styles
12(1)
To Change Left Paragraph Indent
13(1)
To Insert a Different First Page Formatted Header
14(1)
To Remove a Content Control
15(1)
To Insert a Different First Page Formatted Footer
16(2)
To Format Page Numbers
18(1)
To Format Text Using the Font Dialog Box
19(1)
Editing and Formatting Lists
19(11)
To Select a Predefined Bullet Character for a List
20(1)
To Change Bullet Color
20(2)
To Change Left Paragraph Indent
22(1)
To Change Right Paragraph Indent
22(1)
To Insert a Page Break
23(1)
To Create a Multilevel List
23(3)
To Change the Bullet Character to Picture Bullets
26(2)
To Change the Bullet Character to a Predefined Bullet Character
28(1)
To Sort Paragraphs
29(1)
Editing and Formatting Tables
30(25)
To Change Column Width
30(2)
To Change Row Height
32(1)
To Apply a Table Style
33(1)
To Align Data in Cells
34(1)
To Center a Table
35(1)
To Sort a Table
36(1)
To Add a Row to a Table
37(1)
To Insert a Formula in a Table
38(2)
To Change Cell Spacing
40(1)
To Change Margins in Table Cells
41(1)
To Distribute Columns
41(1)
To Delete a Blank Paragraph
42(1)
To Show Gridlines
42(1)
To Split a Table Cell
43(1)
To Move a Cell Boundary
44(1)
To Enter Text in Cells
45(1)
To Distribute Rows
45(1)
To Insert a Column
46(1)
To Merge Table Cells
47(1)
To Change the Direction of Text in a Table Cell
48(2)
To Resize Table Columns Using AutoFit
50(1)
To Change Column Width
51(1)
To Insert a Row and Merge Cells
51(1)
To Shade a Table Cell
52(1)
To Change Row Height
53(1)
To Hide Gridlines
53(1)
To Add a Table Border
53(2)
Creating a Watermark
55(2)
To Change the Zoom to Multiple Pages
55(1)
To Create a Watermark
55(2)
To Check Spelling, Save, Print, and Exit Word
57(1)
Summary
57(1)
Apply Your Knowledge
58(3)
Extend Your Knowledge
61(2)
Expand Your World
63(2)
In the Lab
65
Module Five Creating a Resume and Sharing Documents Objectives
1(1)
Introduction
1(1)
Project: Resume
1(2)
To Start Word and Specify Settings
3(1)
Using a Template to Create a Resume
3(28)
To Create a New Document from an Online Template
3(3)
To Change Theme Colors
6(1)
To Set Custom Margins
7(1)
To Change Theme Fonts
8(1)
To View Gridlines
8(1)
To Enter Text in a Content Control
9(1)
To Enter Text in More Content Controls
10(1)
To Create Custom Theme Fonts
11(1)
To Create Custom Theme Colors
12(2)
To Enter Text in a Content Control
14(1)
To Use Cut and Paste to Move Table Rows and Paragraphs with Source Formatting
14(2)
To Copy and Paste a Table Row
16(1)
To Delete a Row and Paragraph
17(1)
To Create a Building Block
17(1)
To Modify a Building Block
18(1)
To Use AutoComplete
19(1)
To Insert a Building Block
20(1)
To Enter Text in Content Controls
21(1)
To Delete a Row
22(1)
To Enter Text in Content Controls
22(1)
To Remove Bullets from a Paragraph
23(1)
To Resize Table Columns
24(1)
To Enter Text in a Content Control
24(1)
To Enter a Line Break
25(1)
To Enter Text in Content Controls
25(1)
To Decrease Indent of a Paragraph
26(1)
To Change a Bullet to a Predefined Symbol
27(1)
To Create a Paragraph Style
28(1)
To Apply a Style
29(1)
To Reveal Formatting
29(1)
To Modify a Style Using the Styles Dialog Box
30(1)
To Center Page Contents Vertically
31(1)
Sharing a Document with Others
31(15)
To Insert a Quick Part
32(2)
To Export a Word Document to a PDF File and View the PDF File in Adobe Reader
34(2)
To Open a PDF File from Word to Edit It
36(2)
To Check Document Compatibility
38(1)
To Save a Word 365 Document in an Earlier Word Format
39(3)
To Share a Document on OneDrive
42(1)
To Get a Sharing Link
43(1)
To Remove a Watermark
44(1)
To Send a Document Using Email
45(1)
Creating a Webpage from a Word Document
46(8)
To Save a Word Document as a Webpage
47(2)
To Format Text as a Hyperlink
49(1)
To Edit a Hyperlink
50(1)
To Change the Style Set
50(1)
To Highlight Text
51(2)
To Test a Webpage in a Browser
53(1)
Summary
54(1)
Apply Your Knowledge
55(2)
Extend Your Knowledge
57(2)
Expand Your World
59(2)
In the Lab
61
Module Six Using Mail Merge Objectives
1(1)
Introduction
1(1)
Project: Form Letters, Mailing Labels, and a Directory
1(3)
To Start Word and Specify Settings
2(2)
Identifying the Main Document for Form Letters
4(8)
To Start the Mail Merge Wizard
4(3)
To Change Theme Colors
7(1)
To Enter and Format the Sender Information
7(1)
To Change a Picture and Format It
7(1)
To Shade Cells and a Shape
8(1)
To Change Margin Settings
9(1)
To Specify the Position of a Graphic
10(1)
To Create a Folder while Saving
11(1)
Creating a Data Source
12(8)
To Type a New Recipient List for a Data Source
13(5)
To Enter More Recipients
18(1)
To Save a Data Source when Prompted by Word
18(2)
Composing the Main Document for the Form Letters
20(13)
To Display the Next Step in the Mail Merge Wizard
21(1)
To Enter the Date from a Content Control
21(2)
To Insert the AddressBlock Merge Field
23(1)
To Preview Results in the Main Document
24(1)
To Insert the GreetingLine Merge Field
25(1)
To View Merge Fields in the Main Document
26(1)
To Begin Typing the Body of the Form Letter
26(1)
To Insert a Merge Field in the Main Document
27(1)
To Enter More Text and Merge Fields in the Main Document
28(1)
To Insert an IF Field in the Main Document
29(1)
To Enter the Remaining Text in the Main Document
30(1)
To Toggle Field Codes
31(2)
Merging the Recipient List in the Data Source with the Main Document to Generate Form Letters
33(8)
To Preview a Mail Merge Using the Mail Merge Wizard
33(1)
To Merge the Form Letters to a New Document Using the Mail Merge Wizard
34(2)
To Select Mail Merge Recipients
36(1)
To Merge the Form Letters to a New Document Using the Ribbon
37(2)
To Remove a Merge Condition
39(1)
To Sort a Recipient List
39(1)
To Find Mail Merge Recipients
40(1)
Addressing Mailing Labels and Envelopes
41(7)
To Address and Print Mailing Labels Using an Existing Data Source
42(6)
Merging All Data Records to a Directory
48(8)
To Change Page Orientation
49(1)
To Merge to a Directory
50(2)
To Merge to a New Document
52(1)
To Convert Text to a Table
52(2)
To Modify and Format a Table
54(1)
To Sort a Table by Multiple Columns
54(2)
Summary
56(1)
Apply Your Knowledge
57(2)
Extend Your Knowledge
59(2)
Expand Your World
61(2)
In the Lab
63
Module Seven Creating a Newsletter Objectives
1(1)
Introduction
1(1)
Project: Newsletter
2(3)
To Start Word and Specify Settings
4(1)
To Change Spacing above and below Paragraphs and Adjust Margins
4(1)
To Change Theme Colors and Fonts
5(1)
Creating the Nameplate
5(14)
To Convert Text to WordArt
6(1)
To Resize WordArt
7(1)
To Change the Font and Font Size of WordArt Text
7(1)
To Change an Object's Text Wrapping
7(1)
To Change the Text Fill Color of WordArt
8(3)
To Change the WordArt Shape Using the Transform Effect
11(1)
To Set Custom Tab Stops Using the Tabs Dialog Box
12(1)
To Enter Text
13(1)
To Border One Edge of a Paragraph
13(1)
To Insert a Picture
14(1)
To Change the Color of a Graphic
15(1)
To Crop a Graphic
16(1)
To Change an Object's Text Wrapping and Size
17(1)
To Move a Graphic
17(1)
To Use the Selection Pane
18(1)
To Rotate a Graphic
18(1)
Formatting the First Page of the Body of the Newsletter
19(13)
To Clear Formatting
20(1)
To Format Text as a Heading Style, Modify a Heading Style, and Adjust Spacing before and after the Paragraph
20(1)
To Insert a Continuous Section Break
21(1)
To Format Text in Columns
22(1)
To Justify a Paragraph
23(1)
To Insert Text from a File into a Document
24(1)
To Adjust the Width of Columns and Place a Vertical Line between Columns
25(1)
To Hyphenate a Document
26(1)
To Format a Character as a Drop Cap
27(1)
To Format the Drop Cap
28(1)
To Insert a Next Page Section Break
29(1)
To Enter Text
30(1)
To Insert a Column Break
30(1)
To Insert Text from a File in to a Document
31(1)
Creating a Pull-Quote
32(6)
To Insert a Preformatted Text Box
32(1)
To Split the Word Window
33(1)
To Copy and Paste Using Split Windows
34(2)
To Remove a Split Window
36(1)
To Edit and Format Text in the Text Box
36(1)
To Resize a Text Box
36(1)
To Apply a Shape Style to a Text Box
37(1)
To Position a Text Box
37(1)
Formatting the Second Page of the Newsletter
38(14)
To Change Column Formatting
39(2)
To Set Custom Tab Stops Using the Tabs Dialog Box
41(1)
To Format and Enter Text and Add a Border
42(1)
To Enter Text
42(1)
To Balance Columns
43(1)
To Open a Document from Word
44(1)
To Change the Layout of a SmartArt Graphic
45(1)
To Add a Shape to a SmartArt Graphic
45(1)
To Use the Text Pane to Add Text to a SmartArt Graphic
46(1)
To Format SmartArt Graphic Text
47(1)
To Copy a SmartArt Graphic Using the Office Clipboard
48(1)
To Switch from One Open Document Window to Another
48(1)
To Paste from the Office Clipboard
49(1)
To Format a Graphic as Floating
50(1)
To Format, Resize, and Position the SmartArt Graphic
50(1)
To Edit Wrap Points in an Object
50(2)
Finishing the Newsletter
52(2)
To Turn Off Formatting Marks and Zoom Multiple Pages
52(1)
To Add an Art Page Border
52(2)
To Save and Print the Newsletter and then Exit Word
54(1)
Summary
54(1)
Apply Your Knowledge
55(2)
Extend Your Knowledge
57(2)
Expand Your World
59(2)
In the Lab
61
Microsoft PowerPoint 2021
Module Four Customizing Slide Masters and Presentations Objectives
1(1)
Introduction
1(1)
Project: Presentation with Customized Slides
2(4)
To Run PowerPoint, Apply a Theme, and Save the Presentation
6(1)
Customizing Presentation Slide Master Backgrounds and Fonts
6(8)
Slide Master
6(1)
To Switch to Slide Master View
6(2)
To Apply a Theme to a Slide Master
8(1)
To Change the Theme Colors
8(1)
To Create Custom Theme Colors
9(2)
To Change the Theme Fonts
11(1)
To Customize Theme Fonts
11(1)
To Delete a Content Placeholder
12(1)
To Change the Theme Effects
13(1)
Adding and Formatting Placeholders
14(23)
To Insert a Placeholder into a Blank Layout
14(1)
To Add and Format Placeholder Text
15(4)
To Cut a Placeholder and Paste It into a Slide Master
19(1)
To Insert a Picture Placeholder
20(1)
To Size and Format the Picture Content Layout
21(2)
To Format a Slide Master Background and Apply a Quick Style
23(1)
To Crop a Picture to a Shape
24(2)
To Rename a Slide Master and a Slide Layout
26(1)
To Delete a Slide Layout
27(3)
To Close Master View
30(1)
To Save a Presentation as a Template
30(1)
To Open a Template and Save a Presentation
31(1)
To Change the Title Slide Layout and Add Text
32(1)
To Insert Slide 2 and Add Text
33(1)
To Insert Slide 3 and Add Text
33(1)
To Insert Slide 4 and Add Text
34(1)
To Insert Slide 5 and Add Text
35(1)
To Use the Thesaurus
35(2)
Customizing Slide Elements
37(2)
To Change the Theme of a Single Slide
37(1)
To Change the Theme Variant
38(1)
Formatting Slide Backgrounds
39(8)
To Change the Slide Background to a Gradient Fill
40(1)
To Change the Slide Background to a Picture
41(1)
To Change the Transparency of a Slide Background
42(1)
To Change the Slide Background to a Pattern
43(1)
To Change the Slide Background to a Texture
44(1)
Hiding a Slide
45(1)
To Hide a Slide
46(1)
To Add a Slide Transition
47(1)
Protecting and Securing a Presentation
47(2)
To Inspect a Presentation
48(1)
Navigating to a Slide During a Slide Show
49(3)
Navigating to a Slide Using the Control Bar
50(1)
To Highlight Text
50(1)
To Use Pen and Pointer Options During a Slide Show
51(1)
Rehearsing Slide Timings
52(4)
To Rehearse Slide Timings
53(1)
To Advance a Slide After a Specified Number of Seconds
54(1)
To Run a Slide Show with Timings
55(1)
To Save and Print the Presentation
55(1)
Summary
56(1)
Apply Your Knowledge
57(2)
Extend Your Knowledge
59(4)
Expand Your World
63(1)
In the Lab
64
Module Five Collaborating and Adding Animation Objectives
1(1)
Introduction
1(1)
Project: Presentation with Comments and Animation
2(1)
Collaborating on a Presentation
2(18)
To Merge a Presentation
5(1)
To Preview the Presentation Changes
6(2)
To Review, Accept, and Reject Presentation Changes
8(2)
To Review, Accept, and Reject Slide Changes
10(1)
To Review Comments
11(2)
To Reply to a Comment
13(1)
To Insert a Comment
14(1)
To Edit a Comment
15(1)
To Delete a Comment
15(1)
To Review and Accept Slide Changes on the Remaining Slides
16(1)
To Run the Revised Presentation in Reading View
17(1)
To End the Review and Hide Markup
18(1)
To Resize Slides
19(1)
Formatting and Managing Text
20(5)
To Change Line Spacing
20(1)
To Change Paragraph Spacing
21(1)
To Change Column Spacing
22(1)
To Format Text in Columns
23(1)
To Find Text
23(1)
To Find and Replace Text
24(1)
Formatting Pictures
25(5)
To Add an Artistic Effect to a Picture
25(1)
To Recolor a Picture
26(1)
To Add a Picture Border
27(1)
To Change a Picture Border Color
27(1)
To Apply a Picture Effect
28(1)
To Add Alt Text
29(1)
Modifying Bullets and Adding Effects
30(12)
To Change a Bullet Character to a Picture
30(2)
To Change Bullet Size
32(1)
To Change a Bullet to a Symbol
33(2)
To Format Bullet Color
35(1)
To Change a Bullet Character to a Number
36(1)
To Change the List Numbering Style
36(1)
To Change the Margins for Text in a Shape
37(1)
To Format Shape Text
38(1)
To Apply a Glow Text Effect
39(1)
To Apply a Glow Shape Effect
39(1)
Format Painter
40(1)
To Use the Format Painter with Text
40(1)
To Use the Format Painter with Objects
41(1)
Animating Slide Content
42(14)
To Animate a Picture Using an Entrance Effect
42(1)
To Add an Emphasis Effect Animation
43(1)
To Add a Delay to an Animation
44(1)
To Animate Text
44(1)
To Dim Text after Animation
45(1)
To Reorder Animations on a Slide
46(1)
To Use the Animation Painter
47(1)
To Animate an Object Using a Preset Motion Path
48(1)
To Animate an Object Using a Custom Motion Path
49(4)
To Trigger an Animation Effect
53(1)
To Insert a Connector
54(1)
To Align Content Placeholders
55(1)
Creating and Managing Sections
56(9)
To Add a Section to a Presentation
57(1)
To Rename a Section
57(2)
To Collapse Sections
59(1)
To Reorder Sections
60(1)
Zoom Links
61(1)
To Insert Section Zoom Links and Slide Zoom Links
61(2)
To Change the Zoom Icon Image
63(2)
To Run a Presentation with Section Zoom Links and Slide Zoom Links
65(1)
To Save and Print the Presentation
65(1)
Summary
65(1)
Apply Your Knowledge
66(1)
Extend Your Knowledge
67(2)
Expand Your World
69(1)
In the Lab
70
Module Six Formatting Tables and Charts Objectives
1(1)
Introduction
1(1)
Project: Presentation with Embedded and Linked Files and Formatted Table and Chart
2(3)
Creating a Presentation from a Word Outline
5(2)
Converting Documents for Use in PowerPoint
5(1)
To Insert Slides from an Outline
5(2)
Inserting Graphics or Other Objects from a File
7(4)
To Delete a Placeholder
8(1)
To Embed an Object from Another App
9(1)
To Edit an Embedded File
10(1)
Drawing and Formatting a Table
11(22)
To Draw a Table
12(1)
To Draw Table Rows
13(2)
To Draw Table Columns
15(2)
To Erase a Table Border
17(2)
To Split Table Cells
19(3)
To Select a Table and Apply Shading to Table Cells
22(1)
To Apply a Bevel Effect to Table Cells
23(1)
To Apply a Shadow Effect to Table Cells
24(1)
To Apply a Reflection Effect to Table Cells
25(1)
To Add an Image to a Table Cell
26(1)
To Distribute Table Rows
27(2)
To Resize a Table Column and Row
29(1)
To Align Data in a Table Cell
30(2)
To Align a Table
32(1)
Inserting a Linked Excel Worksheet
33(5)
To Link an Excel Worksheet
33(3)
To Align a Worksheet
36(1)
To Update a Linked Worksheet
36(2)
Copying and Modifying a Linked Excel Chart
38(21)
To Copy an Excel Chart
38(2)
To Resize a Chart Proportionally
40(1)
To Align a Chart
41(2)
To Switch Chart Rows and Columns
43(1)
To Change the Chart Type
43(2)
To Change the Chart Layout
45(1)
To Apply a Style to a Chart
46(1)
To Change Chart Colors
46(1)
To Add an Axis to a Chart
47(3)
To Add a Title at a Specified Position in a Chart
50(1)
To Add a Border to a Chart Element
51(1)
To Edit the Source File of a Linked Chart
52(2)
To Add a Link to Text
54(1)
Changing Views
55(1)
To Navigate between Slides in Reading View
56(1)
To Switch to Outline View
57(1)
To Navigate between Slides in Outline View
57(1)
To Move a Slide in Outline View
57(1)
To Enter Text in Outline View
58(1)
Summary
59(1)
Apply Your Knowledge
60(2)
Extend Your Knowledge
62(3)
Expand Your World
65(1)
In the Lab
66
Module Seven Adding Media and Enhancing SmartArt Objectives
1(1)
Introduction
1(1)
Project: Presentation with Audio and Video Clips, SmartArt, and Hyperlinks
2(3)
Modifying a Slide by Changing a Picture and Inserting an Audio and a Video Clip
5(19)
To Open and Save a Presentation
5(1)
To Change a Picture
5(2)
To Resize a Picture to Exact Dimensions
7(1)
To Insert an Audio Clip from a File
8(2)
To Change the Audio Clip Start Option
10(1)
To Loop an Audio Clip
10(1)
To Hide an Audio Clip Object during a Slide Show
11(1)
To Change the Volume of an Audio Clip
11(1)
To Trim an Audio Clip
12(1)
To Insert a Video File without Using a Content Placeholder
13(2)
To Trim a Video File
15(2)
To Change the Video Start Option
17(1)
To Play a Video Full Screen
18(1)
To Change the Video Volume
18(1)
To Resize a Video Proportionally
19(1)
To Apply a Video Style
20(1)
To Compress a Video and an Audio File
21(1)
To Add a Video Poster Frame
22(2)
Creating and Formatting a SmartArt Graphic
24(17)
To Insert SmartArt Using a Content Placeholder
24(2)
To Show or Hide the SmartArt Text Pane
26(1)
To Enter Text in SmartArt
27(1)
To Format Text Pane Characters
27(2)
To Insert a Picture into a SmartArt Shape
29(1)
To Add a Shape to SmartArt
30(1)
To Apply 3-D Effects to SmartArt
31(1)
To Change the Color of SmartArt
32(2)
To Increase the Size of a SmartArt Shape
34(1)
To Resize SmartArt to Exact Dimensions
34(2)
To Move a SmartArt Shape Up
36(1)
To Move a SmartArt Shape Down
37(1)
To Demote a SmartArt Shape
38(1)
To Promote a SmartArt Shape
39(2)
Formatting Pictures
41(10)
To Remove a Picture Background
41(1)
To Refine Background Removal
42(3)
To Flip a Picture
45(1)
To Change the Brightness and Contrast of a Picture
46(1)
To Change the Color Saturation of a Picture
46(2)
To Compress a Picture
48(1)
To Insert a Screen Clipping
49(2)
Adding Hyperlinks and Action Buttons
51(16)
To Insert a Hyperlink to a Place in the Current Presentation
51(1)
To Edit a Hyperlink
52(1)
To Add a ScreenTip to a Hyperlink
53(2)
To Add a Hyperlink Action Setting to a Picture
55(1)
To Add a Hyperlink Action Setting to a Shape
56(1)
To Insert a Hyperlink to a File
57(3)
Action Buttons
60(1)
To Insert an Action Button
60(2)
To Change an Action Button Fill Color
62(1)
To Edit an Action Button Setting
63(2)
To Save the Presentation as a PDF
65(1)
To Run, Save, and Exit PowerPoint
66(1)
Summary
67(1)
Apply Your Knowledge
68(2)
Extend Your Knowledge
70(3)
Expand Your World
73(1)
In the Lab
74
Microsoft Excel 2021
Module Four Financial Functions, Data Tables, and Amortization Schedules Objectives
1(1)
Introduction
1(1)
Project: Mortgage Payment Calculator with Data Table and Amortization Schedule
2(4)
To Apply a Theme to the Worksheet
4(1)
To Enter the Section and Row Titles and System Date
4(1)
To Adjust the Column Widths and Row Heights
5(1)
To Change the Sheet Tab Name
6(1)
Creating Cell Names
6(9)
To Format Cells before Entering Values
6(1)
To Enter the Loan Data
7(1)
To Create Names Based on Row Titles
8(1)
To Enter the Loan Amount Formula Using Names
9(1)
The PMT Function
10(1)
To Enter the PMT Function
11(1)
Other Financial Functions
12(1)
To Determine the Total Interest and Total Cost
13(1)
To Enter New Loan Data
13(1)
To Enter the Original Loan Data
14(1)
Using a Data Table to Analyze Worksheet Data
15(5)
To Enter the Data Table Title and Column Titles
16(1)
To Create a Percentage Series Using the Fill Handle
16(2)
To Enter the Formulas in the Data Table
18(1)
To Define a Range as a Data Table
19(1)
More about Data Tables
20(1)
Creating an Amortization Schedule
20(17)
To Change Column Widths and Enter Titles
21(1)
To Create a Series of Integers Using the Fill Handle
22(1)
Formulas in the Amortization Schedule
23(1)
To Enter the Formulas in the Amortization Schedule
24(2)
To Copy the Formulas to Fill the Amortization Schedule
26(1)
To Enter the Total Formulas in the Amortization Schedule
27(1)
To Format the Numbers in the Amortization Schedule
28(1)
Formatting the Worksheet
29(1)
To Add Custom Borders to a Range
29(2)
To Add Borders to the Varying Interest Rate Schedule
31(1)
To Add Borders to the Amortization Schedule
32(1)
To Use Borders and Fill Color to Visually Define and Group the Financial Tools
33(1)
Highlighting Cells in the Data Table Using Conditional Formatting
33(1)
To Add a Pointer to the Data Table Using Conditional Formatting
34(2)
To Enter New Loan Data
36(1)
To Enter the Original Loan Data
36(1)
Printing Sections of the Worksheet
37(4)
To Set Up a Worksheet to Print
37(1)
To Set the Print Area
38(1)
To Name and Print Sections of a Worksheet
38(3)
Protecting and Hiding Worksheets and Workbooks
41(8)
Creating Formulas with Defined Names
41(1)
To Protect a Worksheet
42(2)
More about Worksheet Protection
44(1)
To Hide and Unhide a Worksheet
44(1)
To Hide and Unhide a Workbook
45(1)
Formula Checking
46(1)
To Enable Background Formula Checking
47(1)
More about Background Formula Checking
48(1)
Summary
49(1)
Apply Your Knowledge
50(1)
Extend Your Knowledge
51(2)
Expand Your World
53(1)
In the Lab
54
Module Five Working with Multiple Worksheets and Workbooks Objectives
1(1)
Introduction
1(1)
Project: Consolidated Expenses Worksheet
2(2)
Creating the Consolidated Worksheet
4(2)
To Start Excel and Open a File
4(1)
To Format the Worksheet
5(1)
To Enter Column Titles
6(1)
Fill Series
6(2)
To Create Linear Series
6(2)
Date, Time, and Round Functions
8(8)
To Use the TODAY Function
10(1)
To Enter Formulas Using the ROUND Function
11(3)
To Format the Title and Subtitle
14(1)
To Format the Column Titles and Total Row
15(1)
To Format with a Floating Dollar Sign
15(1)
Format Codes
16(3)
To Create a Custom Format Code
17(2)
To Format with the Comma Style
19(1)
Creating a Cell Style
19(4)
To Create a New Cell Style
20(2)
To Apply a New Style
22(1)
To Use the Spelling Checker
23(1)
Working with Multiple Worksheets
23(8)
To Add a Worksheet to a Workbook
24(1)
To Copy and Paste from One Worksheet to Another
24(1)
To Copy a Worksheet Using a Shortcut Menu
25(1)
To Copy a Worksheet Using CTRL
26(1)
To Drill an Entry through Worksheets
27(1)
Selecting and Deselecting Sheets
28(1)
Customizing the Individual Worksheets
28(1)
To Modify the Lady Lobster Worksheet
28(1)
To Modify the Henry Haddock Sheet
29(1)
To Modify the Sharon Shrimp Worksheet
30(1)
Referencing Cells Across Worksheets
31(4)
To Modify the Consolidated Worksheet
32(1)
To Enter a 3-D Reference
32(2)
To Use the Paste Gallery
34(1)
Formatting Pie Charts
35(13)
To Insert a 3-D Pie Chart on a Worksheet
36(1)
To Move a Chart on the Same Worksheet
36(1)
To Resize a Chart
37(1)
To Explode a Slice
38(1)
To Rotate the 3-D Pie Chart
39(1)
To Format Data Labels
39(3)
To Add a Chart Border
42(1)
Printing Multiple Worksheets
43(1)
To Change Margins and Center the Printout Horizontally
43(1)
To Add a Header
44(1)
To Add a Footer
45(1)
To Preview and Print All Worksheets in a Workbook
46(2)
Creating Separate Files from Worksheets
48(1)
To Create a Separate File from a Worksheet
48(1)
Consolidating Data by Linking Separate Workbooks
49(8)
Moving Linked Workbooks
49(1)
To Open a Data File and Save It to a New Location
50(1)
To Search for and Open Workbooks
50(1)
To Switch to a Different Open Workbook
51(1)
To Arrange Multiple Workbooks
52(1)
To Hide Workbooks
53(1)
To Consolidate Data by Linking Workbooks
54(3)
To Close All Workbooks at One Time
57(1)
Summary
57(1)
Apply Your Knowledge
58(1)
Consolidating Payroll Worksheets
58(2)
Extend Your Knowledge
60(1)
Creating and Editing Custom Format Codes
60(1)
Consolidating and Charting Weather Data in a Workbook
61(1)
In the Lab
62
Module Six Creating, Sorting, and Querying a Table Objectives
1(1)
Introduction
1(1)
Project: Rating Bank Account Managers
2(5)
To Open and Save a File
6(1)
Table Guidelines
7(1)
Creating a Table
7(7)
To Format a Range as a Table
8(1)
To Wrap Text
9(1)
To Name the Table
10(1)
To Remove Duplicates
10(1)
To Enter New Rows and Records into a Table
11(1)
To Add New Columns to the Table
12(1)
To Center Across Selection
13(1)
Using a Lookup Table
14(3)
To Create an Area for Lookup and Return Arrays
15(1)
To Use the XLOOKUP Function
16(1)
Adding Calculated Fields to the Table
17(2)
To Create Calculated Fields
17(2)
Conditional Formatting
19(3)
To Add a Conditional Formatting Rule with an Icon Set
20(2)
Finding Duplicates with Conditional Formatting
22(1)
Data Bars
22(1)
Working with Tables in Excel
22(3)
To Insert a Total Row
22(2)
To Print the Table
24(1)
Sorting a Table
25(5)
To Sort Ascending
26(1)
To Sort Descending
27(1)
To Custom Sort a Table
27(3)
Querying a Table Using AutoFilter
30(7)
To Sort a Table Using AutoFilter
30(1)
To Query a Table Using AutoFilter
31(1)
To Remove Filters
32(1)
To Search a Table Using AutoFilter
33(1)
To Enter Custom Criteria Using AutoFilter
34(2)
More about AutoFilters
36(1)
To Turn Off AutoFilter
36(1)
Using Criteria and Extract Ranges
37(4)
To Create a Criteria Range
37(1)
To Query Using a Criteria Range
38(1)
To Create an Extract Range
39(1)
To Extract Records
40(1)
More about the Criteria Range
41(1)
Using Database Functions
41(3)
To Create an Output Area
42(1)
To Use the DAVERAGE and DCOUNT Database Functions
43(1)
Using the SUMIF, COUNTIF, MATCH, and INDEX Functions
44(3)
To Use the SUMIF Function
44(1)
To Use the COUNTIF Functions
45(1)
To Use the MATCH and INDEX Functions
46(1)
Summarizing Data
47(4)
Other Functions
47(1)
To Sort the Data
48(1)
To Convert a Table to a Range
48(1)
To Display Subtotals
48(1)
To Use the Outline Feature
49(1)
Auto Outline
50(1)
To Remove Automatic Subtotals
50(1)
Treemap Charts
51(4)
To Create a Treemap Chart
51(1)
To Move the Chart and Edit Fonts
52(1)
To Edit Treemap Settings
53(2)
More about Data Series
55(1)
Summary
55(1)
Apply Your Knowledge
56(2)
Extend Your Knowledge
58(1)
Expand Your World
59(1)
In the Lab
60
Module Seven Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots Objectives
1(1)
Introduction
1(1)
Project: Meyor Insurance
2(3)
Creating Templates
5(7)
To Open a Blank Workbook and Format the Rows and Columns
5(1)
To Enter Titles in the Template
6(1)
To Enter Column Titles in the Template
7(1)
To Enter Sample Data in the Template
7(1)
To Enter Formulas and Functions in the Template
8(1)
To Save the Template
9(2)
To Open a Template-Based File and Save It as a Workbook
11(1)
Importing Data
12(21)
Text Files
14(1)
To Import Data from a Text File
14(2)
To Format the CSV Data
16(1)
Text Formatting
17(1)
To Use the Trim Function
18(1)
To Paste Values Only
19(1)
Access Files
20(1)
To Import Data from an Access Table
20(2)
To Delete a Column Using Power Query
22(2)
To Format the Access Data
24(1)
Web Data
24(1)
To Import Data from a Webpage
24(3)
Using Word Data
27(1)
To Copy from Word and Paste to Excel
28(1)
To Transpose Columns and Rows
28(1)
To Delete, Cut, and Paste Data
29(1)
To Convert Text to Columns
30(1)
To Replicate Formulas
31(2)
Using the Quick Analysis Gallery
33(2)
To Format Using the Quick Analysis Gallery
33(1)
To Total Data
34(1)
Using the Find and Replace Commands
35(4)
To Find Data
35(2)
Working with the Find and Replace Dialog Box
37(1)
To Find and Replace
37(1)
To Format Styles and Borders
38(1)
Inserting a Bar Chart
39(8)
To Insert a Chart Using the Quick Analysis Gallery
40(1)
To Format the Chart
41(3)
To Format Axis Options
44(1)
To Add Data Labels
45(1)
To Display a Data Table
46(1)
To Format the Chart Title
46(1)
Working with SmartArt Graphics
47(6)
To Create a New Sheet
48(1)
To Insert a SmartArt Graphic
49(1)
To Color and Resize the SmartArt Graphic
50(1)
To Add a Shape to a SmartArt Graphic
51(1)
To Add Text to a SmartArt Graphic
51(1)
To Add a Style to a SmartArt Graphic
52(1)
Pictures and Icons
53(8)
To Add a Picture to a SmartArt Graphic
54(2)
To Apply Picture Effects
56(2)
To Insert Icons
58(2)
To Format Text Using WordArt Styles
60(1)
Text Boxes
61(1)
To Draw a Text Box
61(1)
Alternative Text
62(1)
To Add ALT Text
62(1)
Object Linking and Embedding
63(3)
Copy and Paste
64(1)
Embedded Objects
64(1)
Linked Objects
64(2)
Using Screenshots on a Worksheet
66(5)
To Create Another New Sheet
66(1)
To Insert a Screenshot on a Worksheet
67(2)
To Move an Object
69(1)
To Add a Picture Border
69(2)
Shapes
71(5)
To Create a Shape and Copy It
71(1)
To Add a Shape Style and Shape Effect
72(2)
Using the Format Painter with Objects
74(1)
To Align Shapes
75(1)
Summary
76(1)
Apply Your Knowledge
77(2)
Extend Your Knowledge
79(2)
Expand Your World
81(1)
In the Lab
82
Microsoft Access 2021
Module Four Creating Reports and Forms Objectives
1(1)
Introduction
1(1)
Project -- Reports and Forms
1(3)
Report Creation
4(16)
Report Sections
4(1)
To Group and Sort in a Report
5(3)
Grouping and Sorting Options
8(1)
Report Controls
8(1)
To Add Totals and Subtotals
9(2)
To Remove the Group, Sort, and Total Pane
11(1)
To Conditionally Format Controls
12(5)
To Filter Records in a Report
17(1)
To Clear a Report Filter
18(1)
The Arrange and Page Setup Tabs
19(1)
Multiple-Table Reports
20(15)
To Create a Report that Involves Multiple Tables
21(5)
To Modify the Report
26(3)
Creating a Report in Layout View
29(1)
To Create a Report in Layout View by Creating a Blank Report
30(2)
Using Themes
32(2)
Live Preview for Themes
34(1)
To Create a Summary Report
35(1)
Form Creation
35(13)
To Use the Form Wizard to Create a Form
36(2)
Form Sections
38(1)
Form Controls
38(1)
Views Available for Forms
38(1)
To Place Controls in a Control Layout
38(2)
To Enhance a Form by Adding a Time
40(1)
To Change the Format of a Control
41(1)
To Move a Control
42(1)
To Move Controls in a Control Layout
43(1)
To Add a Field
44(1)
To Filter and Sort Using a Form
45(2)
To Clear a Form Filter
47(1)
The Arrange Tab
47(1)
Mailing Labels
48(3)
To Create Labels
48(3)
Summary
51(2)
Apply Your Knowledge
53(1)
Extend Your Knowledge
54(2)
Expand Your World
56(1)
In the Labs
57
Module Five Multiple-Table Forms Objectives
1(1)
Introduction
1(1)
Project -- Multiple-Table Forms
1(1)
Adding Special Fields
2(6)
To Add Fields with New Data Types to a Table
3(1)
To Use the Input Mask Wizard
4(3)
Adding Fields in Datasheet View
7(1)
Updating the New Fields
8(8)
To Enter Data Using an Input Mask
8(2)
To Enter Data in Yes/No Fields
10(1)
To Enter Data in Long Text Fields
10(1)
To Change the Row and Column Size
10(1)
Undoing Changes to Row Height and Column Width
11(1)
To Enter Images in Attachment Fields
12(2)
To Insert the Remaining Pictures
14(1)
To Enter More Data in Attachment Fields
14(2)
To Save the Properties
16(1)
Viewing Document Attachments in Datasheet View
16(1)
Multiple-Table Form Techniques
16(24)
To Create a Form in Design View
17(1)
To Add a Control for a Field to the Form
18(1)
To Add Controls for Additional Fields
19(1)
To Align Controls on the Left
19(2)
To Align Controls on the Top and Adjust Vertical Spacing
21(1)
To Add Controls for the Remaining Fields
22(1)
To Use a Shortcut Menu to Change the Fill/Back Color
23(1)
To Add a Title
24(1)
To Place a Subform
25(3)
To Modify a Subform and Move the Picture
28(2)
To Change a Label
30(1)
To Change Label Effects and Colors
31(4)
To Modify the Appearance of a Form Title
35(1)
To Change a Tab Stop
36(1)
Changing the Tab Order
37(1)
To Use the Form
37(2)
Navigation in the Form
39(1)
Object Dependencies
40(1)
To View Object Dependencies
40(1)
Date/Time, Long Text, and Yes/No Fields in Queries
41(2)
To Use Date/Time, Long Text, and Yes/No Fields in a Query
41(2)
Datasheets in Forms
43(3)
Creating a Simple Form with a Datasheet
43(1)
Creating a Form with a Datasheet in Layout View
44(2)
Creating a Multiple-Table Form Based on the Many Table
46(1)
Summary
47(1)
Apply Your Knowledge
48(1)
Extend Your Knowledge
49(1)
Expand Your World
50(1)
In the Labs
51
Module Six Advanced Report Techniques Objectives
1(1)
Introduction
1(1)
Project -- Creating Detailed Reports
1(2)
Additional Tables
3(6)
To Create the New Tables
4(2)
To Import the Data
6(1)
Linking versus Importing
6(1)
To Relate the New Tables
7(2)
Creating Reports in Design View
9(37)
To Create a Query for the Report
9(1)
To Create an Additional Query for the Report Using Expression Builder
10(4)
To Create an Initial Report in Design View
14(1)
To Group and Sort
15(3)
Controls and Sections
18(1)
To Add Fields to the Report in Design View
18(2)
To Change Labels
20(1)
Using Other Tools in the Controls Group
20(1)
To Add Text Boxes
21(3)
To View the Report in Print Preview
24(1)
To Format a Control
25(1)
To Group Controls
26(1)
To Modify Grouped Controls
27(1)
To Modify Multiple Controls That Are Not Grouped
28(2)
Undoing and Saving
30(1)
To Add a Subreport
30(3)
To Open the Subreport in Design View
33(1)
Print Layout Issues
34(1)
To Modify the Controls in the Subreport
35(1)
To Change the Can Grow Property
35(2)
To Change the Appearance of the Controls in the Subreport
37(1)
To Resize the Subreport and the Report in Design View
38(2)
To Change the Can Grow Property
40(1)
To Modify Section Properties
40(1)
To Add a Title, Page Number, and Date
41(1)
To Remove the Header Background Color and the Alternate Color
42(2)
Headers and Footers
44(2)
Creating a Second Report
46(19)
To Create a Second Report
46(1)
To Remove the Color from the Report Header
47(1)
To Add and Move Fields in a Report
47(3)
To Add the Remaining Fields
50(2)
Totals and Subtotals
52(2)
To Add Subtotals and Other Calculations
54(1)
To Add a Header and Footer to the Discount Report
55(1)
To Change the Can Grow Property
56(1)
To View the Report
57(1)
To Use Expression Builder to Add a Calculation
58(2)
To Add a Title
60(1)
To Change the Border Style
61(1)
To Remove the Alternate Color
61(1)
Obtaining Help on Functions
62(1)
Report Design Tools Page Setup Tab
62(2)
To Change the Report Margins
64(1)
Fine-Tuning a Report
64(1)
To Make Room For Resizing or Adding Controls
65(1)
Summary
65(2)
Apply Your Knowledge
67(1)
Extend Your Knowledge
68(1)
Expand Your World
68(1)
In the Labs
69
Module Seven Advanced Form Techniques Objectives
1(1)
Introduction
1(1)
Project -- Advanced Form Techniques
1(2)
Creating a Form with Combo Boxes and Command Buttons
3(30)
To Create a Form in Design View
4(1)
To Add Fields to the Form Design
5(1)
Combo Boxes
6(1)
To Add a Combo Box That Selects Values
6(4)
To Use the Background Color Button
10(1)
To Format a Control
10(1)
To Use the Format Painter
11(1)
To View the Form
12(1)
To Add a Title and Expand the Form Header Section
13(1)
To Change the Background Color of the Form Header
14(1)
Headers and Footers
14(1)
Images
15(1)
Command Buttons
15(1)
To Add Command Buttons to a Form
16(2)
To Add a Combo Box for Finding a Record
18(4)
To Place a Rectangle
22(1)
To Open the Appointment View and Update Form
23(1)
Using the Buttons
23(1)
To Test the Add Record Button
23(1)
To Use the Combo Box
24(1)
Issues with the Add Record Button
25(1)
Issues with the Combo Box
26(1)
Macros
26(1)
To Modify the Macro for the Add Record Button
26(3)
To Modify the Combo Box
29(1)
To Correct Issues with the Combo Box
30(1)
Using the Modified Form
31(2)
Creating a Multipage Form
33(16)
To Import a Table
33(1)
To Create a Form in Design View
34(1)
To Use the Text Box Tool with Concatenation
34(1)
To Use Tab Controls to Create a Multipage Form
35(1)
To Add a Subform
36(2)
To Modify a Subform
38(1)
To Resize the Subform
39(1)
To Change the Background Color
40(1)
To Insert Charts
40(3)
To Use the Form
43(1)
To Modify a Chart Type
44(3)
To Format a Chart
47(2)
Summary
49(1)
Apply Your Knowledge
50(1)
Extend Your Knowledge
51(1)
Expand Your World
51(1)
In the Labs
52
Index 1
Sandra Cable is the author and co-author of numerous books with Course Technology, including both introductory and advanced levels of Microsoft Excel and Access. In addition to working full time for an international corporation in Dallas, she volunteers to teach at seminars and in classrooms, sharing her simple, proven approaches for mastering today's computer applications. She holds a Ph.D. in education from Texas A&M University-Commerce. Steven M. Freund serves as a lead instructor of various Microsoft® Office, computer concepts, programming and internet technology courses throughout Central Florida. An integral author for the successful Shelly Cashman Series® since 2001, he has presented at the annual customer conference, the Shelly Cashman Series Institute and other customer events. Freund has co-authored multiple editions of DISCOVERING COMPUTERS, MOZILLA FIREFOX, WINDOWS® INTERNET EXPLORER, WINDOWS® OFFICE and DREAMWEAVER books. In addition, he has written numerous successful instructor supplements. He attended the University of Central Florida. Ellen F. Monk is an Assistant Professor of Management Information Systems in the Lerner College of Business and Economics at the University of Delaware. Her areas of interest encompass enterprise resource planning systems and undergraduate MIS education, including databases, advanced spreadsheets and data analytics. Dr. Monk holds a B.S. in chemical engineering, an M.B.A., and a Ph.D. in MIS. Susan L. Sebok is a retired professor at South Suburban College in South Holland, Illinois. She also is a licensed attorney. Working with the leading SHELLY CASHMAN SERIES® since 1993, she has co-authored several successful textbooks, including multiple versions of DISCOVERING COMPUTERS and MICROSOFT® POWERPOINT® books. She holds both Master of Arts and Juris Doctor degrees. Joy Starks has taught at Indiana University Purdue University Indianapolis for 20 years. She has written chapters in several of the best-selling Shelly Cashman Series Office books and has authored the Photoshop, Java Programming, and Microsoft® Publisher series of books. She speaks and presents at various conferences, seminars and forums across the U.S. Misty E. Vermaat has more than 30 years of experience in the field of computer and information technology. In addition to consulting in the field, she was Associate Professor at Purdue University Calumet, teaching or developing Microsoft® Office, computer concepts, database management, systems analysis and design and programming courses. Since 1990, Ms. Vermaat has led the development of THE SHELLY CASHMAN SERIES and has authored and co-authored numerous Series textbooks, including many editions of DISCOVERING COMPUTERS, DISCOVERING COMPUTERS FUNDAMENTALS, MICROSOFT® PUBLISHER and MICROSOFT® WORD books. NA