Microsoft Office 365 Excel 2019 Textbook PDF

Your Office: Microsoft Office 365 Excel 2019 Comprehensive Fourth Edition Common Features Chapter 1 Understanding the...

Your Office: Microsoft Office 365 Excel 2019 Comprehensive Fourth Edition Common Features Chapter 1 Understanding the Common Features of Microsoft Office Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Learning Objectives 1.1 Understand the Office suite and applications 1.2 Start, save, and manipulate Office applications and use the Office ribbon 1.3 Manipulate, correct, and format content in Excel 1.4 Format using various Office methods 1.5 Find Help, print, and share in Office 1.6 Insert Office add-ins Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Programs in Office 2019 Word Excel PowerPoint Access OneNote Outlook Publisher Skype for Business Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Versions Multiple Suite Packages Non-Educational Platforms Consumers Windows phone Home Traditional one-time fee iPad Enterprise Subscription (Office 365) Android devices Web browser Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Microsoft Account https://signup.live.com Figure 7 Word Backstage Account name, White theme, and No Background Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Word Start Screen Figure 1 Word Start screen Copyright © 2020, 2017, 2014 Pearson All Rights Reserved The Ribbon (1 of 2) Two common tabs – File – Home Application-specific tabs – Formulas – Design – Database Tools Copyright © 2020, 2017, 2014 Pearson All Rights Reserved The Ribbon (2 of 2) Figure 3 Ribbons of Excel, Word, Access, and PowerPoint Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Top-Right Ribbon Buttons Button Keyboard Shortcut Action Ribbon Display Options Ctrl+F1 (Toggles between Auto-Hide Ribbon, Show collapsing and showing the Tabs, and Show Tabs and ribbon Commands Minimize Alt+Space Hides a window so it is visible only on the taskbar Restore Down or Maximize Alt+Space When the window is at its maximum size, the button will restore the window to a previous, smaller size. When a window is in Restore Down mode, the button expands the window to its full size. Close Alt+F4 Closes a file; also exists the program if no other files are open for that program Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Zoom and Scroll Figure 12 Zoom controls and dialog box Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Common Office Objects (1 of 3) Tabs Buttons Figure 3 Ribbons of Excel, Word, Access, and PowerPoint Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Common Office Objects (2 of 3) Figure 18 Format Cells dialog box Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Common Office Objects (3 of 3) Figure 19 Styles Live Preview Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Additional Common Office Objects (1 of 4) Figure 23 Picture Tools Format contextual tab Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Additional Common Office Objects (2 of 4) Figure 24 The Mini toolbar Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Additional Common Office Objects (3 of 4) Figure 26 The shortcut menu Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Additional Common Office Objects (4 of 4) Figure 27 The Excel Help pane Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Tell Me Figure 20 Inserted note in Excel Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Using Keyboard Shortcuts Keyboard shortcuts Equivalent of software commands Increase efficiency and save time Common shortcuts assist navigation – Copy (Ctrl+C), Cut (Ctrl+X), Paste (Ctrl+V) – Select (Ctrl+A) – Bold (Ctrl+B) – Undo (Ctrl+Z) – Move to top (Ctrl+Home) – Move to end (Ctrl+End) Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Backstage View Area Description Info Adding properties, protecting, inspecting, and managing a document. New Creating a new blank or template-based document. Open Opening a file from your computer, recent documents list, or OneDrive account. Save Save your file to your computer or OneDrive account. Save As Save your file with a new name, as a new file type, or to a different location. Print Preview and print your document. Share Share your file by invitation, e-mail, online presentation, or blog post. Export Change the file type or create a PDF/XPS document. Close Close the file without closing the application. Account User and product information, including connected services. Options Launches the Application Options dialog box with many options, including advanced options. Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Backstage - Account Figure 7 Word Backstage Account name, White theme, and No Background Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Save File Locations (1 of 3) Hard drive USB Network storage OneDrive Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Save File Locations (2 of 3) Figure 9 Word Save As Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Save File Locations (3 of 3) Figure 10 Word file in File Explorer Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Saving a File Descriptive name Cannot include: ? “/ | < > * : File extension.docx,.xlsx,.pptx,.accdb File path C:\Budget2020\January Minutes.docx Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Quick Access Toolbar Figure 12 Zoom controls and dialog box Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Roaming Settings Most Recently Used List (MRU) Documents and Places MRU Templates Office Personalization Custom Dictionary List of Connected Services Word Resume Reading Position OneNote—the custom name a notebook view PowerPoint the Last Viewed Slide Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Most Recently Used List Figure 1 Word Start screen Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Get Help (1 of 2) Figure 27 The Excel Help pane Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Get Help (2 of 2) Figure 28 ScreenTip Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Share Files Create a hard copy Create a digital copy Print Use Share link Backstage Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Share and Collaborate With Others Figure 28 ScreenTip Copyright © 2020, 2017, 2014 Pearson All Rights Reserved  Change Views (1 of 2) Figure 30 Page Break Preview Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Change Views (2 of 2) Figure 31 Page Layout view Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Print Figure 32 Backstage Print Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Add-ins (1 of 2) QUICK REFERENCE: Installing Add-ins for Office 1. Open any Office application 2. On Insert tab, select My Add-ins arrow 3. The Office Add-ins window appears. If you see the app you want, select the app, click Insert. Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Add-ins (2 of 2) QUICK REFERENCE: Installing Add-ins for Office 4. If you do not see the app you want, click Store link or Office Store button. 5. Search for the Add-in, and follow the steps online to install the Add-in to your account. 6. Once the Add-in has been installed, return to the Office application and repeat steps 2 and 3. Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Summary (1 of 2) Microsoft Office 2019 applications: Similar interface—ribbons, features, and functions Major applications—Word, Excel, PowerPoint, and Access Several versions available Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Summary (2 of 2) Microsoft Office 2019 applications: Help feature Backstage view: – Print – Share files with Windows OneDrive Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Questions? Copyright © 2020, 2017, 2014 Pearson All Rights Reserved Copyright Copyright © 2020, 2017, 2014 Pearson All Rights Reserved