Teach Yourself VISUALLY Microsoft 365

ISBN-13: 9781119893516 / Angielski / Miękka / 2022 / 352 str.

Paul McFedries

Spis treści

Part I Microsoft 365 FeaturesChapter 1 Microsoft 365 BasicsStart and Exit Microsoft 365 Apps 4Explore the App Window 6Work with Backstage View 7Change the Color Scheme 8Search for a Ribbon Command 10Work with the Ribbon 12Customize the Quick Access Toolbar 14Using a Microsoft 365 App with a Touch Screen 16Chapter 2 Working with FilesCreate a New File 18Save a File 20Open a File 22Print a File 24Select Data 26Chapter 3 Microsoft 365 Graphics ToolsInsert a Picture from Your PC 28Insert an Online Picture 30Resize and Move Graphic Objects 32Understanding Graphics Modification Techniques 34Chapter 4 Working with Microsoft 365 Files OnlineMicrosoft 365 and the Cloud 36Sign In to Microsoft 365 38Share a Document from Microsoft 365 40Sign In to OneDrive 42Using an Online App in OneDrive 44Open a Document in a Desktop App from OneDrive 46Upload a Document to OneDrive 48Share a Document Using OneDrive 50Part II WordChapter 5 Adding TextChange Word's Views 54Type and Edit Text 56Insert Quick Parts 58Insert Symbols 60Chapter 6 Formatting TextChange the Font, Size, and Color 62Align Text 66Set Line Spacing 67Indent Text 68Set Tabs 70Set Margins 72Create Lists 74Copy Formatting 76Clear Formatting 77Format with Styles 78Using a Template 80Chapter 7 Adding Extra TouchesInsert an Online Video 82Assign a Theme 84Add Borders 86Create Columns 88Insert a Table 90Apply Table Styles 92Insert Table Rows or Columns 93Add Headers and Footers 94Insert Footnotes and Endnotes 96Chapter 8 Reviewing DocumentsWork in Read Mode View 98Find and Replace Text 102Navigate Document Content 104Check Spelling and Grammar 106Customize AutoCorrect 108Using Word's Thesaurus and Dictionary 110Translate Text 112Track and Review Document Changes 114Lock and Unlock Tracking 116Combine Reviewers' Changes 118Work with Comments 120Part III ExcelChapter 9 Building SpreadsheetsEnter Cell Data 124Select Cells 126Using AutoFill for Faster Data Entry 128Turn On Text Wrapping 130Center Data Across Columns 131Adjust Cell Alignment 132Change the Font and Size 134Change Number Formats 136Increase or Decrease Decimals 137Add Cell Borders and Shading 138Format Data with Styles 140Apply Conditional Formatting 142Insert Rows and Columns 144Resize Columns and Rows 146Freeze Column and Row Titles On-Screen 147Name a Range 148Clear or Delete Cells 150Chapter 10 Worksheet BasicsAdd a Worksheet 152Rename a Worksheet 153Change Page Setup Options 154Move or Copy Worksheets 156Delete a Worksheet 157Find and Replace Data 158Create a Table 160Filter or Sort Table Information 162Analyze Data Quickly 164Understanding Data Analysis Choices 165Insert a Note 166Chapter 11 Working with Formulas and FunctionsUnderstanding Formulas 168Create a Formula 170Apply Absolute and Relative Cell References 172Understanding Functions 174Insert a Function 176Total Cells with AutoSum 178Chapter 12 Working with ChartsCreate a Chart 180Move and Resize Charts 182Change the Chart Type 184Change the Chart Style 185Change the Chart Layout 186Add Chart Elements 187Format Chart Elements 188Change the Chart Data 189Using Sparklines to View Data Trends 190Understanding PivotTables 192Create a PivotTable 194Create a PivotChart 196Insert a PivotTable Slicer 198Part IV PowerPointChapter 13 Creating a PresentationCreate a New Presentation 202Create a Photo Album Presentation 204Change PowerPoint Views 206Insert Slides 208Change the Slide Layout 210Change the Slide Size 212Chapter 14 Populating Presentation SlidesAdd and Edit Slide Text 214Change the Font, Size, and Color 216Apply a Theme 220Set Line Spacing 221Align Text 222Add a Text Box to a Slide 223Add a Table to a Slide 224Add a Chart to a Slide 226Add a Video Clip to a Slide 228Move a Slide Object 230Resize a Slide Object 231Chapter 15 Assembling and Presenting a SlideshowReorganize Slides 232Reuse a Slide 234Organize Slides into Sections 236Define Slide Transitions 238Add Animation Effects 240Create a Custom Animation 242Record Narration 244Insert a Background Song 245Create Speaker Notes 246Rehearse a Slideshow 248Run a Slideshow 250Part V AccessChapter 16 Database BasicsUnderstanding Database Basics 256Create a Database Based on a Template 258Create a Blank Database 260Create a New Table 262Change Table Views 264Add a Field to a Table 266Delete a Field from a Table 267Hide a Field in a Table 268Move a Field in a Table 269Create a Form 270Change Form Views 272Move a Field in a Form 273Delete a Field in a Form 274Format Form Fields 275Chapter 17 Adding, Finding, and Querying DataAdd Records to a Table 276Add a Record Using a Form 278Navigate Records Using a Form 280Search for a Record Using a Form 281Delete a Record from a Table 282Delete a Record Using a Form 283Sort Records 284Filter Records 286Perform a Simple Query 288Create a Report 292Part VI OutlookChapter 18 Organizing with OutlookNavigate in Outlook 298Schedule an Appointment 300Create a New Contact 302Create a New Task 304Add a Note 306Customize the Navigation Bar 308Peek at Appointments and Tasks 310Chapter 19 E-mailing with OutlookCompose and Send a Message 312Send a File Attachment 314Read an Incoming Message 315Reply to or Forward a Message 316Add a Sender to Your Outlook Contacts 318Delete a Message 319Screen Junk E-Mail 320Create a Message Rule 322Index 324