Buy New Perspectives Microsoft Office 365 & Office 2019 Advanced, 1st Edition PDF ebook by author Patrick Carey; Katherine T. Pinard; Mark Shellman – published by Cengage Learning in 2020 and save up to 80% compared to the print version of this textbook. With PDF version of this textbook, not only save you money, you can also highlight, add text, underline add post-it notes, bookmarks to pages, instantly search for the major terms or chapter titles, etc.
You can search our site for other versions of the New Perspectives Microsoft Office 365 & Office 2019 Advanced, 1st Edition PDF ebook. You can also search for others PDF ebooks from publisher Cengage Learning, as well as from your favorite authors. We have thousands of online textbooks and course materials (mostly in PDF) that you can download immediately after purchase.
Note: e-textBooks do not come with access codes, CDs/DVDs, workbooks, and other supplemental items.
- Full title: New Perspectives Microsoft Office 365 & Office 2019 Advanced, 1st Edition
- Edition: 1st
- Copyright year: 2020
- Publisher: Cengage Learning
- Author: Patrick Carey; Katherine T. Pinard; Mark Shellman
- ISBN: 9780357360545, 9780357360545
- Format: PDF
Description of New Perspectives Microsoft Office 365 & Office 2019 Advanced, 1st Edition:
Develop the Microsoft Office 365 and Office 2019 skills students need to be successful in college and beyond with the emphasis on critical-thinking, problem-solving, and in-depth coverage found in NEW PERSPECTIVES MICROSOFT OFFICE 365 & OFFICE 2019 ADVANCED. Updated with all-new case scenarios, this edition clearly applies the skills students are learning to real-world situations to make concepts even more relevant across the applications and reinforces critical skills to make them successful in their educational and professional careers. NEW PERSPECTIVES MICROSOFT OFFICE 365 & OFFICE 2019 ADVANCED demonstrates the importance of what students are learning while strengthening your skills and helping students transfer those skills to other applications and disciplines for further success. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Table of Contents of New Perspectives Microsoft Office 365 & Office 2019 Advanced, 1st Edition PDF ebook:
Brief ContentsTable of ContentsGetting to Know Microsoft Office VersionsUsing SAM Projects and Textbook ProjectsWord ModulesModule 8: Customizing Word and Automating Your Work: Automating a Document for a Rock Climbing GymSession 8.1 Visual Overview: Translating TextInserting a ShapeApplying Advanced Text FormattingCompressing Pictures in a DocumentTranslating TextAdding a Custom Paragraph BorderCreating a WatermarkSession 8.1 Quick CheckSession 8.2 Visual Overview: File PropertiesEditing Building Block PropertiesCopying a Building Block to Another Document or TemplateCopying a Style to Another Document or TemplateWorking with File PropertiesAutomating Documents Using FieldsInserting a Fill-In FieldSession 8.2 Quick CheckSession 8.3 Visual Overview: Working with MacrosPlanning a MacroExamining Trust Center SettingsRecording a MacroRunning MacrosEditing a Macro Using the Visual Basic WindowSaving a Document with MacrosCopying Macros to Another Document or TemplateRecording an AutoMacroSession 8.3 Quick CheckReview AssignmentsCase ProblemsModule 9: Creating Online Forms Using Advanced Table Techniques: Developing an Order FormSession 9.1 Visual Overview: Custom TableCreating and Using Online FormsPlanning and Designing the FormCreating a Custom Table for a FormSession 9.1 Quick CheckSession 9.2 Visual Overview: Content ControlsUnderstanding Content ControlsInserting Text Content ControlsInserting Date Picker Content ControlsInserting List Content ControlsInserting Check Box Content ControlsSession 9.2 Quick CheckSession 9.3 Visual Overview: Protecting a DocumentUsing Formulas in a TableGrouping Content ControlsRestricting Document EditingFilling in the Online FormSession 9.3 Quick CheckReview AssignmentsCase ProblemsModule 10: Managing Long Documents: Creating a Survey Report for a Personal Chef AssociationSession 10.1 Visual Overview: Master DocumentsWorking with Master DocumentsWorking in Outline ViewCreating a Master DocumentUnlinking a SubdocumentReopening a Master DocumentSession 10.1 Quick CheckSession 10.2 Visual Overview: Creating a ChartAdding Numbers to HeadingsInserting Numbered CaptionsCreating Cross-ReferencesInserting an EndnoteInserting a ChartRestricting Editing to Allow Only Tracked Changes or CommentsChecking a Document with the Document InspectorChecking Documents for AccessibilitySession 10.2 Quick CheckSession 10.3 Visual Overview: Indexing a DocumentEvaluating Section and Page Breaks in a DocumentApplying Different Page Number Formats in SectionsChanging the Footer and Page Layout for Odd and Even PagesInserting a Style Reference into a FooterInserting Nonbreaking Hyphens and SpacesCreating an IndexCreating a Table of FiguresUpdating Fields before PrintingChecking CompatibilityEncrypting a DocumentMaking a Document Read-OnlySession 10.3 Quick CheckReview AssignmentsCase ProblemsExcel ModulesModule 9: Exploring Financial Tools and Functions: Analyzing a Business PlanSession 9.1 Visual Overview: Loan and Investment FunctionsIntroducing Financial FunctionsCalculating Borrowing CostsCreating an Amortization ScheduleSession 9.1 Quick CheckSession 9.2 Visual Overview: Income Statements and DepreciationProjecting Future Income and ExpensesCalculating Depreciation of AssetsAdding Taxes and Interest Expenses to an Income StatementSession 9.2 Quick CheckSession 9.3 Visual Overview: NPV and IRR Functions and AuditingCalculating Interest Rates with the RATE FunctionViewing the Payback Period of an InvestmentCalculating Net Present ValueCalculating the Internal Rate of ReturnAuditing a WorkbookSession 9.3 Quick CheckReview AssignmentsCase ProblemsModule 10: Analyzing Data with Business Intelligence Tools: Presenting Sales and Revenue DataSession 10.1 Visual Overview: Queries and TrendlinesIntroducing Business IntelligenceWriting a Data QueryTransforming Data with QueriesCharting TrendsCreating a Forecast SheetSession 10.1 Quick CheckSession 10.2 Visual Overview: Power Pivot and the Data ModelIntroducing DatabasesExploring the Data ModelTransforming Data with Power PivotCreating a PivotTable from the Data ModelSession 10.2 Quick CheckSession 10.3 Visual Overview: Hierarchies and MapsWorking with Outlines and HierarchiesViewing Data with Map ChartsSession 10.3 Quick CheckReview AssignmentsCase ProblemsModule 11: Exploring PivotTable Design: Summarizing Sales and Revenue DataSession 11.1 Visual Overview: Layouts, Sorting, Filtering, and GroupingLaying Out a PivotTableSorting a PivotTableFiltering a PivotTableGrouping PivotTable FieldsSession 11.1 Quick CheckSession 11.2 Visual Overview: Conditional Formats and CalculationsCalculations with PivotTablesDisplaying PivotTables with Conditional FormatsExploring the PivotTable CacheWorking with Calculated Items and Calculated FieldsSession 11.2 Quick CheckSession 11.3 Visual Overview: PivotTable MeasuresIntroducing PivotTable Design under the Data ModelCalculating Distinct CountsCreating a MeasureCalculating Measures across Tables and RowsRetrieving PivotTable Data with GETPIVOTDATAExploring Database FunctionsSession 11.3 Quick CheckReview AssignmentsCase ProblemsModule 12: Developing an Excel Application: Creating a Data Entry AppSession 12.1 Visual Overview: WordArt and Funnel ChartsPlanning an Excel ApplicationCreating a WordArt GraphicDisplaying Data with a Funnel ChartHiding Error Values with the IFERROR FunctionSession 12.1 Quick CheckSession 12.2 Visual Overview: Data Validation and Workbook ProtectionValidating Data EntryHiding Workbook ContentProtecting Workbook ContentsSession 12.2 Quick CheckSession 12.3 Visual Overview: Macros and Visual Basic for ApplicationsLoading the Excel Developer TabAutomating Tasks with MacrosAssigning Macros to Shapes and ButtonsWorking with the VBA EditorProtecting against Macro VirusesSession 12.3 Quick CheckReview AssignmentsCase ProblemsAccess ModulesModule 9: Using Action Queries and Advanced Table Relationships: Enhancing User Interaction with theSession 9.1 Visual Overview: Action QueriesAction QueriesSession 9.1 Quick CheckSession 9.2 Visual Overview: Many-to-Many RelationshipUnderstanding Types of Table RelationshipsDefining M:N and 1:1 Relationships between TablesUnderstanding Join TypesUsing Indexes for Table FieldsSession 9.2 Quick CheckReview AssignmentsCase ProblemsModule 10: Automating Tasks with Macros: Creating a User Interface for the Health DatabaseSession 10.1 Visual Overview: The Macro Designer WindowIntroduction to MacrosRunning a MacroViewing a Macro in the Macro DesignerAdding Actions to a MacroSingle Stepping a MacroUsing a Command Button with an Attached MacroAdding a SubmacroAdding a Command Button to a FormAttaching a Submacro to a Command ButtonSession 10.1 Quick CheckSession 10.2 Visual Overview: A Navigation FormDesigning a User InterfaceCreating an Unbound FormAdding a List Box Control to a FormIntroduction to SQLCreating Multiple Macros for a FormCreating a Navigation FormSession 10.2 Quick CheckReview AssignmentsCase ProblemsModule 11: Using and Writing Visual Basic for Applications Code: Creating VBA Code for the Health DaSession 11.1 Visual Overview: VBA Code WindowIntroduction to Visual Basic for ApplicationsUsing an Existing VBA ProcedureCreating Functions in a Standard ModuleTesting a Procedure in the Immediate WindowSession 11.1 Quick CheckSession 11.2 Visual Overview: Example of an Event ProcedureUnderstanding How an Event Procedure Processes CommandsAdding an Event ProcedureAdding a Second Procedure to a Class ModuleAdding an Event Procedure to Change the Case of a Field ValueHiding a Control and Changing a Control’s ColorSession 11.2 Quick CheckReview AssignmentsCase ProblemsModule 12: Managing and Securing a Database: Administering the Health DatabaseSession 12.1 Visual Overview: Multivalued Fields and SubqueriesAdditional Filtering OptionsCreating a SubqueryUsing Multivalued FieldsSession 12.1 Quick CheckSession 12.2 Visual Overview: Database OptionsCreating an Attachment FieldUsing an AutoNumber FieldSaving an Access Database as a Previous VersionAnalyzing Database Performance with the Performance AnalyzerLinking Tables between DatabasesUsing the Database SplitterSecuring an Access DatabaseSetting the Database Startup OptionsSession 12.2 Quick CheckReview AssignmentsCase ProblemsPowerPoint ModulesModule 5: Integrating PowerPoint with Other Programs: Creating a Presentation for a Rowing ConventioSession 5.1 Visual Overview: Understanding LayersCreating a Presentation by Importing ContentWorking in Outline ViewOrganizing a Presentation Using Sections and ZoomsInserting IconsUsing the Effect Options Dialog Box to Modify AnimationsWorking with LayersSession 5.1 Quick CheckSession 5.2 Visual Overview: Importing, Embedding, and LinkingInserting a Word TableFormatting Cells in TablesInserting Excel Data and ObjectsBreaking LinksAnnotating Slides during a Slide ShowCreating Handouts by Exporting a Presentation to WordSession 5.2 Quick CheckReview AssignmentsCase ProblemsModule 6: Customizing Presentations and the PowerPoint Environment: Creating a Presentation for a CiSession 6.1 Visual Overview: Slide Master ViewSharing and Collaborating with OthersWorking in Slide Master ViewChanging Theme Fonts and ColorsFilling Text and Shapes with a Color Used on the SlideSaving a Presentation as a Custom ThemeSession 6.1 Quick CheckSession 6.2 Visual Overview: Advanced File PropertiesCreating a Custom ShowWorking with File PropertiesEncrypting a PresentationMaking a Presentation Read-OnlyPresenting OnlineSession 6.2 Quick CheckReview AssignmentsCase ProblemsIndex