Atjaunināt sīkdatņu piekrišanu

E-grāmata: Office 365 All-in-One For Dummies

3.96/5 (55 ratings by Goodreads)
,
  • Formāts: PDF+DRM
  • Izdošanas datums: 23-Nov-2021
  • Izdevniecība: For Dummies
  • Valoda: eng
  • ISBN-13: 9781119830719
Citas grāmatas par šo tēmu:
  • Formāts - PDF+DRM
  • Cena: 38,06 €*
  • * ši ir gala cena, t.i., netiek piemērotas nekādas papildus atlaides
  • Ielikt grozā
  • Pievienot vēlmju sarakstam
  • Šī e-grāmata paredzēta tikai personīgai lietošanai. E-grāmatas nav iespējams atgriezt un nauda par iegādātajām e-grāmatām netiek atmaksāta.
Office 365 All-in-One For DummiesPalielināt
  • Formāts: PDF+DRM
  • Izdošanas datums: 23-Nov-2021
  • Izdevniecība: For Dummies
  • Valoda: eng
  • ISBN-13: 9781119830719
Citas grāmatas par šo tēmu:

DRM restrictions

  • Kopēšana (kopēt/ievietot):

    nav atļauts

  • Drukāšana:

    nav atļauts

  • Lietošana:

    Digitālo tiesību pārvaldība (Digital Rights Management (DRM))
    Izdevējs ir piegādājis šo grāmatu šifrētā veidā, kas nozīmē, ka jums ir jāinstalē bezmaksas programmatūra, lai to atbloķētu un lasītu. Lai lasītu šo e-grāmatu, jums ir jāizveido Adobe ID. Vairāk informācijas šeit. E-grāmatu var lasīt un lejupielādēt līdz 6 ierīcēm (vienam lietotājam ar vienu un to pašu Adobe ID).

    Nepieciešamā programmatūra
    Lai lasītu šo e-grāmatu mobilajā ierīcē (tālrunī vai planšetdatorā), jums būs jāinstalē šī bezmaksas lietotne: PocketBook Reader (iOS / Android)

    Lai lejupielādētu un lasītu šo e-grāmatu datorā vai Mac datorā, jums ir nepieciešamid Adobe Digital Editions (šī ir bezmaksas lietotne, kas īpaši izstrādāta e-grāmatām. Tā nav tas pats, kas Adobe Reader, kas, iespējams, jau ir jūsu datorā.)

    Jūs nevarat lasīt šo e-grāmatu, izmantojot Amazon Kindle.

Jam-packed with mini books to cover all Office applications, this second edition offers guidance on the core Office 365 applications as well as the tools that make collaborating with remote colleagues easy. Original.

Provides detailed coverage of each Office 365 module and offers advice on optimizing the applications, including Word, Excel, PowerPoint, Outlook, Publisher, and Access.

Multiply your productivity with the world's most straightforward guide to the world's most popular office software

Microsoft Office 365 contains straightforward tools for virtually every office task you could possibly think of. And learning how to use this powerful software is much easier than you might expect! With the latest edition of Office 365 All-in-One For Dummies, you'll get a grip on some of the most popular and effective office software on the planet, including Word, Excel, PowerPoint, Outlook, Access, Publisher, and Teams.

This expanded handbook walks you through the ins and outs of reviewing and composing documents with Word, hosting and joining meetings with Teams, crunching numbers with Excel, and answering emails with Outlook. And it's ideal for anyone who's brand new to Office and those who just need a quick refresher on the latest useful updates from Microsoft.

In this one-stop reference, you'll find:

  • Step-by-step instructions on the installation, maintenance, and navigation of all the critical components of Office 365
  • Guidance for using Office 365's built-in online and cloud functionality
  • Complete explanations of what every part of Office 365 is used for and how to apply them to your life

Office 365 All-in-One For Dummies is the last handbook you'll ever need to apply Microsoft's world-famous software suite to countless everyday tasks.

Introduction 1(4)
What Makes This Book Different
2(1)
Foolish Assumptions
3(1)
Conventions Used in This Book
3(1)
Icons Used in This Book
4(1)
Beyond the Book
4(1)
Book 1: Common Office Tasks 5(52)
Chapter 1 Office Nuts and Bolts
7(22)
Introducing Office 365
7(4)
Office 365 applications
8(1)
Office 365 cloud services
8(1)
Finding out what software and Office version you have
9(2)
Managing your Microsoft account
11(1)
Finding Your Way Around the Office Interface
11(8)
The File tab and Backstage
12(1)
The Quick Access toolbar
12(1)
The Ribbon and its tabs
13(1)
Context-sensitive tabs
13(2)
The anatomy of a tab
15(2)
Mini-toolbars and shortcut menus
17(1)
Office 365 for keyboard lovers
17(2)
Saving Your Files
19(1)
Saving a file
19(1)
Saving a file for the first time
19(1)
Saving AutoRecovery information
19(1)
Navigating the Save As and Open Windows
20(2)
Opening and Closing Files
22(1)
Opening a file
22(1)
Closing a file
22(1)
Reading and Recording File Properties
23(1)
Locking a File with a Password
24(1)
Password-protecting a file
24(1)
Removing a password from a file
25(1)
Trusting (or not Trusting) Microsoft with Your "Content"
25(4)
Chapter 2 Wrestling with the Text
29(20)
Manipulating the Text
29(3)
Selecting text
30(1)
Moving and copying text
30(1)
Taking advantage of the Clipboard task pane
31(1)
Deleting text
32(1)
Speaking, not Typing, the Words
32(2)
Changing the Look of Text
34(7)
Choosing fonts for text
35(2)
Changing the font size of text
37(1)
Applying font styles to text
37(1)
Applying text effects to text
38(1)
Underlining text
39(1)
Changing the color of text
40(1)
Quick Ways to Handle Case, or Capitalization
41(1)
Entering Symbols and Foreign Characters
42(2)
Creating Hyperlinks
44(5)
Linking a hyperlink to a web page
44(1)
Creating a hyperlink to another place in your file
45(1)
Creating an email hyperlink
46(1)
Repairing and removing hyperlinks
47(2)
Chapter 3 Speed Techniques Worth Knowing About
49(8)
Undoing and Repeating Commands
49(2)
Undoing a mistake
50(1)
Repeating an action - and quicker this time
50(1)
Zooming In, Zooming Out
51(1)
Viewing a File Through More Than One Window
52(1)
Correcting Typos on the Fly
53(2)
Entering Text Quickly with the AutoCorrect Command
55(2)
Book 2: Word 365 57(172)
Chapter 1 Speed Techniques for Using Word
59(20)
Introducing the Word Screen
59(2)
Creating a New Document
61(2)
Getting a Better Look at Your Documents
63(5)
Viewing documents in different ways
63(4)
Splitting the screen
67(1)
Selecting Text in Speedy Ways
68(1)
Moving Around Quickly in Documents
69(4)
Keys for getting around quickly
69(1)
Navigating from page to page or heading to heading
70(1)
Going there fast with the Go To command
71(1)
Bookmarks for hopping around
72(1)
Inserting a Whole File into a Document
73(1)
Getting Word to Read It
74(1)
Entering Information Quickly in a Computerized Form
74(5)
Creating a computerized form
75(2)
Entering data in the form
77(2)
Chapter 2 Laying Out Text and Pages
79(26)
Paragraphs and Formatting
79(1)
Inserting a Section Break for Formatting Purposes
80(3)
Breaking a Line
83(1)
Starting a New Page
83(1)
Setting Up and Changing the Margins
84(2)
Indenting Paragraphs and First Lines
86(2)
Clicking an Indent button (for left-indents)
86(1)
"Eyeballing" it with the ruler
86(1)
Indenting in the Paragraph dialog box
87(1)
Numbering the Pages
88(3)
Numbering with page numbers only
89(1)
Including a page number in a header or footer
89(1)
Changing page number formats
90(1)
Putting Headers and Footers on Pages
91(4)
Creating, editing, and removing headers and footers
92(2)
Fine-tuning a header or footer
94(1)
Adjusting the Space Between Lines
95(1)
Adjusting the Space Between Paragraphs
96(1)
Creating Numbered and Bulleted Lists
97(3)
Simple numbered and bulleted lists
97(1)
Constructing lists of your own
98(1)
Managing a multilevel list
99(1)
Working with Tabs
100(2)
Hyphenating Text
102(3)
Automatically and manually hyphenating a document
102(1)
Unhyphenating and other hyphenation tasks
103(2)
Chapter 3 Word Styles
105(18)
All About Styles
105(2)
Styles and templates
106(1)
Types of styles
106(1)
Applying Styles to Text and Paragraphs
107(5)
Applying a style
107(2)
Experimenting with style sets
109(1)
Choosing which style names appear on the Style menus
109(3)
Creating a New Style
112(3)
Creating a style from a paragraph
113(1)
Creating a style from the ground up
113(2)
Modifying a Style
115(1)
Creating and Managing Templates
116(7)
Creating a new template
117(3)
Opening a template so that you can modify it
120(1)
Modifying, deleting, and renaming styles in templates
121(2)
Chapter 4 Constructing the Perfect Table
123(24)
Talking Table Jargon
124(1)
Creating a Table
124(3)
Entering the Text and Numbers
127(1)
Selecting Different Parts of a Table
128(1)
Laying Out Your Table
128(5)
Changing the size of a table, columns, and rows
128(1)
Adjusting column and row size
129(1)
Inserting columns and rows
130(1)
Deleting columns and rows
131(1)
Moving columns and rows
132(1)
Aligning Text in Columns and Rows
133(1)
Merging and Splitting Cells
134(1)
Repeating Header Rows on Subsequent Pages
135(2)
Formatting Your Table
137(3)
Designing a table with a table style
137(1)
Calling attention to different rows and columns
138(1)
Decorating your table with borders and colors
139(1)
Using Math Formulas in Tables
140(1)
Neat Table Tricks
141(6)
Changing the direction of header row text
142(1)
Wrapping text around a table
142(1)
Using a picture as the table background
143(2)
Drawing diagonal lines on tables
145(1)
Drawing on a table
146(1)
Chapter 5 Taking Advantage of the Proofing Tools
147(20)
Correcting Your Spelling Errors
148(3)
Correcting misspellings one at a time
148(1)
Running a spell check
149(2)
Preventing text from being spell checked
151(1)
Correcting Grammatical Errors
151(1)
Refining Your Work with the Editor
152(2)
Finding and Replacing Text
154(8)
The basics: Finding stray words and phrases
154(1)
Narrowing your search
155(5)
Conducting a find-and-replace operation
160(2)
Finding the Right Word with the Thesaurus
162(2)
Proofing Text Written in a Foreign Language
164(1)
Telling Office which languages you will use
164(1)
Marking text as foreign language text
165(1)
Translating Foreign Language Text
165(2)
Chapter 6 Desktop Publishing with Word
167(18)
Experimenting with Themes
167(1)
Sprucing Up Your Pages
168(3)
Decorating a page with a border
169(1)
Putting a background color on pages
170(1)
Getting Word's help with cover letters
170(1)
Making Use of Charts, Diagrams, Shapes, and Photos
171(1)
Working with the Drawing Canvas
172(1)
Positioning and Wrapping Objects Relative to the Page and Text
173(4)
Wrapping text around an object
174(2)
Positioning an object on a page
176(1)
Working with Text Boxes
177(2)
Inserting a text box
178(1)
Making text flow from text box to text box
178(1)
Dropping In a Drop Cap
179(1)
Watermarking for the Elegant Effect
180(1)
Putting Newspaper-Style Columns in a Document
181(2)
Doing the preliminary work
181(1)
Running text into columns
181(2)
Landscape Documents
183(1)
Printing on Different Size Paper
184(1)
Showing Online Video in a Document
184(1)
Chapter 7 Getting Word's Help with Office Chores
185(20)
Highlighting Parts of a Document
185(1)
Commenting on a Document
186(3)
Entering comments
186(1)
Viewing and displaying comments
187(1)
Replying to and resolving comments
188(1)
Caring for and feeding comments
188(1)
Tracking Changes to Documents
189(6)
Telling Word to start marking changes
190(1)
Reading and reviewing a document with revision marks
191(1)
Marking changes when you forgot to turn on revision marks
191(3)
Accepting and rejecting changes to a document
194(1)
Printing an Address on an Envelope
195(1)
Printing a Single Address Label (Or a Page of the Same Label)
196(2)
Churning Out Letters, Envelopes, and Labels for Mass Mailings
198(7)
Preparing the source file
198(1)
Merging the document with the source file
199(4)
Printing form letters, envelopes, and labels
203(2)
Chapter 8 Tools for Reports and Scholarly Papers
205(24)
Alphabetizing a List
206(1)
Outlines for Organizing Your Work
206(2)
Viewing the outline in different ways
207(1)
Rearranging document sections in Outline view
208(1)
Collapsing and Expanding Parts of a Document
208(2)
Generating a Table of Contents
210(4)
Creating a TOC
210(1)
Updating and removing a TOC
210(1)
Customizing a TOC
211(1)
Changing the structure of a TOC
212(2)
Indexing a Document
214(5)
Marking index items in the document
215(2)
Generating the index
217(2)
Editing an index
219(1)
Putting Cross-References in a Document
219(2)
Putting Footnotes and Endnotes in Documents
221(3)
Entering a footnote or endnote
222(1)
Choosing the numbering scheme and position of notes
223(1)
Deleting, moving, and editing notes
224(1)
Compiling a Bibliography
224(7)
Inserting a citation for your bibliography
225(2)
Editing a citation
227(1)
Changing how citations appear in text
227(1)
Generating the bibliography
227(2)
Book 3: Excel 365 229(108)
Chapter 1 Up and Running with Excel
231(18)
Creating a New Excel Workbook
231(2)
Getting Acquainted with Excel
233(3)
Rows, columns, and cell addresses
235(1)
Workbooks and worksheets
235(1)
Entering Data in a Worksheet
236(6)
The basics of entering data
236(1)
Entering text labels
237(1)
Entering numeric values
238(1)
Entering date and time values
238(4)
Quickly Entering Lists and Serial Data with the AutoFill Command
242(2)
Formatting Numbers, Dates, and Time Values
244(2)
Establishing Data-Validation Rules
246(3)
Chapter 2 Refining Your Worksheet
249(16)
Editing Worksheet Data
249(1)
Moving Around in a Worksheet
250(1)
Getting a Better Look at the Worksheet
251(4)
Freezing and splitting columns and rows
252(2)
Hiding columns and rows
254(1)
Notes for Documenting Your Worksheet
255(2)
Comments for Collaborating with Others on a Workbooks
257(1)
Selecting Cells in a Worksheet
258(1)
Deleting, Copying, and Moving Data
259(1)
Handling the Worksheets in a Workbook
259(3)
Keeping Others from Tampering with Worksheets
262(3)
Hiding a worksheet
262(1)
Protecting a worksheet
262(3)
Chapter 3 Formulas and Functions for Crunching Numbers
265(34)
How Formulas Work
265(6)
Referring to cells in formulas
266(2)
Referring to formula results in formulas
268(1)
Operators in formulas
268(3)
The Basics of Entering a Formula
271(1)
Speed Techniques for Entering Formulas
271(6)
Clicking cells to enter cell references
272(1)
Entering a cell range
272(1)
Naming cell ranges so that you can use them in formulas
273(3)
Referring to cells in different worksheets
276(1)
Copying Formulas from Cell to Cell
277(2)
Detecting and Correcting Errors in Formulas
279(3)
Correcting errors one at a time
279(2)
Running the error checker
281(1)
Tracing cell references
281(1)
Working with Functions
282(5)
Using arguments in functions
284(1)
Entering a function in a formula
284(3)
A Look at Some Very Useful Functions
287(12)
AVERAGE for averaging data
287(2)
COUNT and COUNTIF for tabulating data items
289(1)
CONCAT for combining values
290(1)
PMT for calculating how much you can borrow
291(2)
IF for identifying data
293(1)
LEFT, MID, and RIGHT for cleaning up data
294(1)
PROPER for capitalizing words
294(1)
LARGE and SMALL for comparing values
294(2)
NETWORKDAY and TODAY for measuring time in days
296(1)
LEN for Counting Characters in Cells
297(2)
Chapter 4 Making a Worksheet Easier to Read and Understand
299(18)
Laying Out a Worksheet
299(6)
Aligning numbers and text in columns and rows
300(2)
Inserting and deleting rows and columns
302(1)
Changing the size of columns and rows
303(2)
Decorating a Worksheet with Borders and Colors
305(5)
Cell styles for quickly formatting a worksheet
305(2)
Formatting cells with table styles
307(1)
Slapping borders on worksheet cells
308(1)
Decorating worksheets with colors
309(1)
Getting Ready to Print a Worksheet
310(7)
Making a worksheet fit on a page
310(4)
Making a worksheet more presentable
314(1)
Repeating row and column headings on each page
315(2)
Chapter 5 Advanced Techniques for Analyzing Data
317(20)
Getting Quick Analyses from Excel
317(4)
Running a rough-and-ready data analysis
318(1)
Seeing what the sparklines say
319(1)
Generating a forecast sheet
320(1)
Conditional Formats for Calling Attention to Data
321(1)
Managing Information in Lists
322(4)
Sorting a list
323(1)
Filtering a list
324(2)
Forecasting with the Goal Seek Command
326(2)
Performing What-If Analyses with Data Tables
328(3)
Using a one-input table for analysis
328(2)
Using a two-input table for analysis
330(1)
Analyzing Data with PivotTables
331(8)
Getting a PivotTable recommendation from Excel
333(1)
Creating a PivotTable from scratch
334(1)
Putting the finishing touches on a PivotTable
334(3)
Book 4: Powerpoint 365 337(94)
Chapter 1 Getting Started in PowerPoint
339(22)
Getting Acquainted with PowerPoint
340(1)
A Brief Geography Lesson
341(1)
A Whirlwind Tour of PowerPoint
342(1)
Creating a New Presentation
343(3)
Advice for Building Persuasive Presentations
346(2)
Creating New Slides for Your Presentation
348(4)
Inserting a new slide
349(1)
Speed techniques for inserting slides
350(1)
Conjuring slides from Word document headings
350(1)
Selecting a different layout for a slide
351(1)
Getting a Better View of Your Work
352(2)
Changing views
352(1)
Looking at the different views
353(1)
Hiding and Displaying the Slides Pane and Notes Pane
354(1)
Selecting, Moving, and Deleting Slides
354(1)
Selecting slides
354(1)
Moving slides
355(1)
Deleting slides
355(1)
Putting Together a Photo Album
355(4)
Creating your photo album
356(2)
Putting on the final touches
358(1)
Editing a photo album
359(1)
Hidden Slides for All Contingencies
359(2)
Hiding a slide
359(1)
Showing a hidden slide during a presentation
360(1)
Chapter 2 Fashioning a Look for Your Presentation
361(16)
Looking at Themes and Slide Backgrounds
362(2)
Choosing a Theme for Your Presentation
364(1)
Creating Slide Backgrounds on Your Own
365(7)
Using a solid (or transparent) color for the slide background
366(1)
Creating a gradient color blend for slide backgrounds
366(2)
Placing a picture in the slide background
368(1)
Using a photo of your own for a slide background
369(2)
Using a texture for a slide background
371(1)
Changing the Background of a Single or Handful of Slides
372(1)
Choosing the Slide Size
372(1)
Using Master Slides and Master Styles for a Consistent Design
373(4)
Switching to Slide Master view
373(1)
Understanding master slides and master styles
374(1)
Editing a master slide
375(1)
Changing a master slide layout
375(2)
Chapter 3 Entering the Text
377(16)
Entering Text
377(4)
Choosing fonts for text
378(1)
Changing the font size of text
379(1)
Changing the look of text
379(2)
Fun with Text Boxes and Text Box Shapes
381(2)
Controlling How Text Fits in Text Frames and Text Boxes
383(2)
Choosing how AutoFit works in text frames
383(2)
Choosing how AutoFits works in text boxes
385(1)
Positioning Text in Frames and Text Boxes
385(1)
Handling Bulleted and Numbered Lists
386(3)
Creating a standard bulleted or numbered list
387(1)
Choosing a different bullet character, size, and color
387(2)
Choosing a different list-numbering style, size, and color
389(1)
Putting Footers (and Headers) on Slides
389(4)
Some background on footers and headers
389(1)
Putting a standard footer on all your slides
390(1)
Creating a nonstandard footer
391(1)
Removing a footer from a single slide
392(1)
Chapter 4 Making Your Presentations Livelier
393(16)
Suggestions for Enlivening Your Presentation
393(1)
Presenting Information in a Table
394(3)
Exploring Transitions and Animations
397(3)
Showing transitions between slides
397(2)
Animating parts of a slide
399(1)
Making Audio Part of Your Presentation
400(4)
Inserting an audio file on a slide
401(1)
Telling PowerPoint when and how to play an audio file
402(1)
Playing audio during a presentation
403(1)
Playing Video on Slides
404(1)
Inserting a video on a slide
404(3)
Fine-tuning a video presentation
404(2)
Experimenting with the look of the video
406(1)
Recording a Voice Narration for Slides
407(2)
Chapter 5 Delivering a Presentation
409(22)
All about Notes
409(1)
Rehearsing with a Robot Coach
410(1)
Rehearsing and Timing Your Presentation
411(2)
Showing Your Presentation
413(3)
Starting and ending a presentation
413(1)
Going from slide to slide
414(2)
Tricks for Making Presentations a Little Livelier
416(3)
Wielding a pen or highlighter in a presentation
417(2)
Blanking the screen
419(1)
Zooming in
419(1)
Delivering a Presentation When You Can't Be There in Person
419(14)
Providing handouts for your audience
420(1)
Creating a self-running, kiosk-style presentation
421(2)
Creating a user-run presentation
423(2)
Presenting a presentation online
425(2)
Creating a presentation video
427(1)
Showing a presentation as an animated GIF
428(3)
Book 5: Outlook 365 431(60)
Chapter 1 Outlook Basics
433(12)
What Is Outlook, Anyway?
433(1)
Navigating the Outlook Apps
434(1)
Categorizing Items
435(2)
Creating a category
435(1)
Assigning items to categories
436(1)
Arranging items by category in folders
437(1)
Searching for Stray Folder Items
437(3)
Conducting an instant search
438(1)
Refining a search
438(1)
Conducting an advanced search
439(1)
Deleting Email Messages, Contacts, Tasks, and Other Items
440(1)
Cleaning Out Your Folders
441(4)
Archiving the old stuff
441(2)
Running the Mailbox Cleanup command
443(2)
Chapter 2 Maintaining the People App
445(12)
Entering and Editing Contact Information
446(3)
Entering information about a new contact
446(2)
Changing a contact's information
448(1)
Contact Groups for Sending Messages to Groups
449(3)
Creating a contact group
449(2)
Addressing email to a contact group
451(1)
Editing a contact group
451(1)
Finding a Contact
452(1)
Sharing Contacts with Coworkers
452(2)
Sharing your Contacts folder
452(2)
Sharing someone else's contacts
454(1)
Printing the Contacts Folder
454(3)
Different ways to print contact information
454(1)
Changing the look of printed pages
455(2)
Chapter 3 Handling Your Email
457(22)
Setting Up an Email Account
457(1)
Addressing and Sending Email Messages
458(6)
The basics: Sending an email message
459(2)
Addressing an email message
461(1)
Sending copies and blind copies of messages
461(2)
Replying to and forwarding email messages
463(1)
Sending Files and Photos
464(2)
Sending a file along with a message
464(1)
Including a photo in an email message
465(1)
Receiving Email Messages
466(2)
Getting your email
467(1)
Being notified that email has arrived
467(1)
Reading Your Email in the Inbox Window
468(1)
Handling Files That Were Sent to You
469(2)
Opening a file you received
470(1)
Saving a file you received
470(1)
Techniques for Organizing Email Messages
471(3)
Flagging email messages
472(1)
Rules for earmarking messages as they arrive
473(1)
All about Email Folders
474(2)
Moving email messages to different folders
475(1)
Creating a new folder for storing email
475(1)
Yes, You Can Prevent Junk Mail (Sort of)
476(3)
Defining what constitutes junk email
477(1)
Preventative medicine for junk email
477(2)
Chapter 4 Managing Your Time and Schedule
479(12)
Introducing the Calendar
479(2)
The Different Kinds of Activities
481(1)
Seeing Your Schedule
482(1)
Going to a different day, week, or month
482(1)
Rearranging the Calendar window
482(1)
Scheduling Appointments and Meetings
483(3)
Scheduling an event: The basics
483(1)
Scheduling a recurring appointment
484(1)
Scheduling an all-day appointment
485(1)
Canceling, Rescheduling, and Altering Activities
486(1)
Managing Meetings with the Calendar
486(7)
Scheduling and inviting colleagues to a meeting
486(2)
Accepting (or declining) meeting invitations
488(1)
Canceling and rescheduling meetings
489(2)
Book 6: Access 365 491(82)
Chapter 1 Introducing Access
493(16)
What Is a Database, Anyway?
494(1)
Tables, Queries, Forms, and Other Objects
494(5)
Database tables for storing information
494(2)
Forms for entering data
496(1)
Queries for getting the data out
497(1)
Reports for presenting and examining data
498(1)
Macros and modules
499(1)
Creating a Database File
499(2)
Creating a blank database file
500(1)
Getting the help of a template
500(1)
Finding Your Way Around the Navigation Pane
501(2)
Designing a Database
503(6)
Deciding what information you need
503(1)
Separating information into different database tables
504(2)
Choosing fields for database tables
506(1)
Deciding on a primary key field for each database table
506(1)
Mapping the relationships between tables
507(2)
Chapter 2 Building Your Database Tables
509(28)
Creating a Database Table
509(4)
Creating a database table from scratch
510(1)
Creating a database table from a template
511(1)
Importing a table from another database
512(1)
Opening and Viewing Tables
513(1)
Entering and Altering Table Fields
514(6)
Creating a field
514(2)
All about data types
516(2)
Designating the primary key field
518(1)
Moving, renaming, and deleting fields
519(1)
Field Properties for Making Sure That Data Entries Are Accurate
520(8)
A look at the Field Properties settings
521(5)
Creating a lookup data-entry list
526(2)
Indexing for Faster Sorts, Searches, and Queries
528(3)
Indexing a field
529(1)
Indexing based on more than one field
529(2)
Establishing Relationships among Database Tables
531(6)
Types of relationships
532(1)
Handling tables in the Relationships window
533(1)
Forging relationships between tables
534(2)
Editing table relationships
536(1)
Chapter 3 Entering the Data
537(10)
The Two Ways to Enter Data
537(1)
Entering the Data in Datasheet View
538(4)
Entering data
539(1)
Two tricks for entering data quicker
540(1)
Changing the appearance of the datasheet
541(1)
Entering the Data in a Form
542(2)
Creating a form
542(1)
Entering the data
543(1)
Finding a Missing Record
544(1)
Finding and Replacing Data
545(2)
Chapter 4 Sorting, Querying, and Filtering for Data
547(20)
Sorting Records in a Database Table
547(1)
Ascending vs. descending sorts
548(1)
Sorting records
548(1)
Filtering to Find Information
548(6)
Different ways to filter a database table
549(2)
"Unfiltering" a database table
551(1)
Filtering by selection
551(1)
Filtering for input
552(1)
Filtering by form
553(1)
Querying: The Basics
554(8)
Creating a new query
555(1)
Viewing queries in Datasheet and Design views
555(1)
Finding your way around the Query Design window
556(1)
Choosing which database tables to query
557(1)
Choosing which fields to query
557(1)
Sorting the query results
558(1)
Choosing which fields appear in query results
559(1)
Entering criteria for a query
560(2)
At last - saving and running a query
562(1)
Six Kinds of Queries
562(5)
Select query
562(1)
Top-value query
562(1)
Summary query
563(1)
Calculation query
564(2)
Delete query
566(1)
Update query
566(1)
Chapter 5 Presenting Data in a Report
567(6)
Creating a Report
567(2)
Opening and Viewing Reports
569(1)
Tweaking a Report
569(4)
Book 7: Publisher 365 573(36)
Chapter 1 Introducing Publisher
575(12)
"A Print Shop in a Can"
575(1)
Introducing Frames
576(1)
Creating a Publication
577(1)
Redesigning a Publication
578(2)
Choosing a different template
578(1)
Choosing a color scheme
579(1)
Choosing a font scheme
579(1)
Setting up your pages
579(1)
Getting a Better View of Your Work
580(1)
Zooming in and out
580(1)
Viewing single pages and two-page spreads
581(1)
Going from page to page
581(1)
Understanding and Using the Layout Guides
581(6)
Making use of layout guides
582(2)
Aligning objects to ruler and grid lines
584(3)
Chapter 2 Refining a Publication
587(12)
Entering Text on the Pages
587(2)
Making Text Fit in Text Frames
589(3)
Fitting overflow text in a single frame
589(1)
Making text flow from frame to frame
590(1)
Filling out a text frame
591(1)
Formatting Text
592(1)
Making Text Wrap around a Frame or Graphic
592(1)
Replacing the Placeholder Pictures
593(1)
Inserting Frames on the Pages
594(2)
Inserting a new frame
594(1)
Changing the size and position of frames
595(1)
Making Frames Overlap
596(1)
Inserting, Removing, and Moving Pages
597(2)
Chapter 3 Putting on the Finishing Touches
599(10)
Decorating the Text
599(3)
Drawing a horizontal rule on a frame
600(1)
Dropping in a drop cap
601(1)
Techniques for Decorating Pages
602(3)
Plugging in a page part
602(1)
Experimenting with borders and accents
602(2)
Taking advantage of attention getters
604(1)
Backgrounds for pages
604(1)
Master Pages for Handling Page Backgrounds
605(2)
Switching to Master Page view
605(1)
Changing the look of a master page
606(1)
Applying (or unapplying) a master page to publication pages
606(1)
Running the Design Checker
607(1)
Commercially Printing a Publication
608(1)
Book 8: Working With Charts And Graphics 609(92)
Chapter 1 Creating a Chart
611(20)
The Basics: Creating a Chart
611(2)
Choosing the Right Chart
613(2)
Providing the Raw Data for Your Chart
615(2)
Positioning Your Chart in a Workbook, Page, or Slide
617(1)
Changing a Chart's Appearance
618(6)
Changing the chart type
618(1)
Changing the size and shape of a chart
619(1)
Choosing a new look for your chart
620(1)
Changing the layout of a chart
620(2)
Handling the gridlines
622(1)
Changing a chart element's color, font, or other particular
622(2)
Saving a Chart as a Template So That You Can Use It Again
624(1)
Saving a chart as a template
624(1)
Creating a chart from a template
625(1)
Chart Tricks for the Daring and Heroic
625(3)
Decorating a chart with a picture
625(1)
Annotating a chart
626(1)
Placing a trendline on a chart
627(1)
Troubleshooting a Chart
628(3)
Chapter 2 Making a SmartArt Diagram
631(20)
The Basics: Creating SmartArt Diagrams
631(3)
Choosing a diagram
632(1)
Making the diagram your own
633(1)
Creating the Initial Diagram
634(2)
Creating a diagram
634(1)
Swapping one diagram for another
635(1)
Changing the Size and Position of a Diagram
636(1)
Laying Out the Diagram Shapes
636(6)
Selecting a diagram shape
636(1)
Removing a shape from a diagram
637(1)
Moving diagram shapes to different positions
637(1)
Adding shapes to diagrams apart from hierarchy diagrams
637(1)
Adding shapes to hierarchy diagrams
638(2)
Adding shapes to Organization charts
640(2)
Promoting and demoting shapes in hierarchy diagrams
642(1)
Handling the Text on Diagram Shapes
642(3)
Entering text on a diagram shape
643(1)
Entering bulleted lists on diagram shapes
643(2)
Changing a Diagram's Direction
645(1)
Choosing a Look for Your Diagram
645(1)
Changing the Appearance of Diagram Shapes
646(3)
Changing the size of a diagram shape
647(1)
Exchanging one shape for another
647(1)
Changing a shape's color, fill, or outline
648(1)
Changing fonts and font sizes on shapes
648(1)
Creating a Diagram from Scratch
649(2)
Chapter 3 Handling Graphics and Photos
651(16)
All about Picture File Formats
651(3)
Bitmap and vector graphics
652(1)
Resolution
652(1)
Compression
653(1)
Color depth
653(1)
Choosing file formats for graphics
654(1)
Inserting a Picture in an Office File
654(4)
Inserting a picture of your own
654(2)
Obtaining a picture online
656(2)
Touching Up a Picture
658(7)
Softening and sharpening pictures
658(1)
Correcting a picture's brightness and contrast
659(1)
Recoloring a picture
660(1)
Choosing an artistic effect
661(1)
Selecting a picture style
662(1)
Cropping off part of a picture
663(1)
Removing the background
664(1)
Compressing Pictures to Save Disk Space
665(2)
Chapter 4 Drawing and Manipulating Lines, Shapes, and Other Objects
667(34)
The Basics: Making Lines, Arrows, and Shapes
668(2)
Handling Lines, Arrows, and Connectors
670(4)
Changing the length and position of a line or arrow
670(1)
Changing the appearance of a line, arrow, or connector
670(1)
Attaching and handling arrowheads on lines and connectors
671(1)
Connecting shapes by using connectors
672(2)
Handling Rectangles, Ovals, Stars, and Other Shapes
674(4)
Drawing a shape
675(1)
Changing a shape's symmetry
676(1)
Using a shape as a text box
676(2)
Drawing by Freehand
678(3)
Freehand drawing with a pen or highlighter
678(1)
Changing the look of freehand drawings
678(2)
Drawing a math expression
680(1)
Decorating Your Work with Icons
681(1)
Inserting a 3-D Model
682(1)
WordArt for Embellishing Letters and Words
682(2)
Creating WordArt
683(1)
Editing WordArt
683(1)
Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects
684(3)
Selecting objects so that you can manipulate them
685(1)
Hiding and displaying the rulers and grid
686(1)
Changing an Object's Size and Shape
687(1)
Changing an Object's Color, Outline Color, and Transparency
688(5)
Filling an object with color, a picture, or a texture
689(1)
Making a color transparent
690(2)
Putting the outline around an object
692(1)
Moving and Positioning Objects
693(10)
Tricks for aligning and distributing objects
693(3)
When objects overlap: Choosing which appears above the other
696(2)
Rotating and flipping objects
698(1)
Grouping objects to make working with them easier
699(2)
Book 9: Office 365: One Step Beyond 701(24)
Chapter 1 Customizing an Office Program
703(14)
Customizing the Ribbon
703(6)
Displaying and selecting tab, group, and command names
705(1)
Moving tabs and groups on the Ribbon
706(1)
Adding, removing, and renaming tabs, groups, and commands
706(2)
Creating new tabs and groups
708(1)
Resetting your Ribbon customizations
708(1)
Customizing the Quick Access Toolbar
709(3)
Adding buttons to the Quick Access toolbar
709(1)
Changing the order of buttons on the Quick Access toolbar
710(1)
Removing buttons from the Quick Access toolbar
711(1)
Placing the Quick Access toolbar above or below the Ribbon
712(1)
Customizing the Status Bar
712(1)
Changing the Screen Background and Office Theme
713(1)
Customizing Keyboard Shortcuts in Word
714(3)
Chapter 2 Ways of Distributing Your Work
717(8)
Printing - the Old Standby
717(2)
Distributing a File in PDF Format
719(2)
About PDF files
720(1)
Saving an Office file as a PDF
720(1)
Sending Your File in an Email Message
721(1)
Saving an Office File as a Web Page
722(5)
Turning a file into a web page
723(1)
Opening a web page in your browser
724(1)
Book 10: Microsoft Teams 725(110)
Chapter 1 Getting around in Teams
727(26)
Viva la Teams!
728(2)
Taking a quick tour of Teams
728(1)
Introducing Microsoft Viva
729(1)
Navigating in Teams
730(10)
Personalizing Teams to Use It Effectively
731(1)
Adding a profile photo
731(1)
Setting your status
732(4)
Managing settings
736(4)
Filtering and Searching
740(4)
Filtering your Activity feed
740(1)
Searching for a post, message, or other content
741(1)
Using slash commands
741(3)
Using Teams to Know Your Colleagues Better
744(2)
Viewing a person's profile card
744(2)
Viewing the org chart
746(1)
Enhancing Your Teams Experience with Helpful Extras
746(7)
Using built-in apps
747(1)
Using tabs
748(3)
Using the Teams app store
751(2)
Chapter 2 Getting Up to Speed with Teams and Channels
753(16)
Diving in to Microsoft Teams
754(8)
Seeing the benefits of using a Team
754(1)
Creating a Team
755(2)
Joining a Team
757(1)
Opening a Team and viewing its channels
758(1)
Adding people to a Team
758(1)
Sharing a Team
759(1)
Managing Team settings
760(2)
Leaving a Team
762(1)
Getting to Know Channels
762(7)
Creating a channel
762(2)
Using private channels
764(1)
Pinning a channel
765(1)
Muting a channel
765(1)
Hiding a channel
766(3)
Chapter 3 Communicating through Channels and Private Chat
769(24)
The Advantages of Channel Conversations over Private Chat
770(2)
Carrying on Channel Conversations
772(11)
Starting a conversation
772(3)
Replying to a conversation
775(1)
@mentioning in a conversation message
776(1)
Reacting to conversations
777(1)
Setting conversation options
778(1)
Bouncing between Teams conversations and Outlook emails
779(4)
Getting Familiar with Using Private Chats
783(8)
Starting a chat with one person or a group
784(2)
Reacting to chat messages
786(1)
@mentioning in a chat
786(1)
Renaming a chat
787(1)
Adding and removing people (including yourself) from a chat
788(1)
Setting chat and message options
789(2)
Setting Up a Buddy List
791(2)
Chapter 4 Organizing Your Files in Teams
793(16)
Getting to Your Files in Teams: The Files App and Files Tab
794(2)
Creating, Uploading, and Sharing Files in Teams and Chats
796(13)
Creating files in a Team
796(1)
Sharing files in a Team
797(6)
Sharing files in a private chat
803(6)
Chapter 5 Getting Together for Online Meetings
809(26)
Understanding Channel Meetings
809(2)
Scheduling a Meeting
811(4)
Scheduling from Teams or Outlook
811(1)
Kicking off a meeting through Meet Now or a private chat
812(1)
Managing meeting options and participant roles
812(1)
Using dial-in conference lines
813(2)
Joining a Meeting
815(3)
Joining from a browser
815(1)
Setting your video, audio, and background
816(2)
Engaging in a Meeting
818(14)
Changing your view and using Together mode
818(1)
Pinning and spotlighting participants
819(1)
Muting yourself and others
820(1)
Sharing your screen and content
821(2)
Using PowerPoint Live
823(2)
Sharing files in a meeting
825(1)
Viewing the participants list
825(1)
Viewing the meeting chat
826(1)
Recording the meeting
826(1)
Using live captions and transcription
827(1)
Adding people to an ongoing meeting
828(1)
Reacting and raising your hand
828(1)
Managing meeting options and participant roles during a meeting
829(1)
Using breakout rooms
830(1)
Leaving and ending the meeting
831(1)
Finding Resources after a Meeting
832(5)
Sharing the meeting recording
832(1)
Working with the meeting chat
833(2)
Book 11: File Sharing And Collaborating 835(60)
Chapter 1 File Sharing and Collaborating
837(14)
Knowing when to Use OneDrive, SharePoint, or Teams
838(2)
When to use OneDrive
838(1)
When to use SharePoint
839(1)
Syncing Office 365 Files to Your Devices
840(3)
Installing the OneDrive app and syncing files
840(2)
Keeping files always available on your device
842(1)
Syncing Teams and SharePoint files to your device
842(1)
Staying Sane When Editing Files
843(3)
Editing Office files in their desktop versus browser versions
844(1)
Editing Office files with colleagues
844(1)
Keeping track of a file's version history
845(1)
Using the Recycle Bin to Restore Deleted Files
846(1)
Copying and Moving Files among SharePoint, OneDrive, and Teams
847(1)
Sharing Files Outside Your Organization
848(3)
External sharing
848(2)
File sharing and email
850(1)
Chapter 2 Making the Most of OneDrive
851(14)
Getting Started in OneDrive
851(3)
Managing Your OneDrive Content
854(6)
Viewing and locating folders in the OneDrive window
854(2)
Selecting files and folders
856(1)
Creating a file or folder
856(1)
Uploading files and folders
857(1)
Viewing file and folder options
858(2)
Seeing Files and Folders Others Shared with You
860(1)
Managing File and Folder Permissions
861(1)
Adding SharePoint and Teams Files to OneDrive
862(3)
Chapter 3 Collaborating in SharePoint
865(30)
Getting Started with SharePoint
865(3)
Introducing Team Sites
868(13)
Understanding the connection between SharePoint team sites and Microsoft 365 Groups
870(2)
Finding your way around a team site
872(1)
Getting familiar with site permissions
873(4)
Working with SharePoint pages
877(3)
Connecting an existing SharePoint team site to Microsoft Teams
880(1)
Working with Document Libraries
881(11)
Creating a new document library
882(1)
Uploading files to a document library
883(1)
Opening and editing a file in a document library
884(1)
Sharing files from a document library
884(4)
Viewing file and folder options
888(1)
Working with columns and views
888(4)
Taking a Brief Look at Microsoft Lists
892(3)
Index 895
Peter Weverka is a veteran tech writer who has written dozens of Dummies titles, including the first edition of Office 365 All-in-One For Dummies. He has also authored books on PowerPoint, OneNote, Word, and Quicken.
Biežāk uzdotie jautājumi par e-grāmatām Biežāk uzdotie jautājumi par e-grāmatām
Permanent link: https://www.kriso.lv/db/97811198307192e.html
Keywords: