Learn Microsoft Office 2019 by Foulkes, Linda -- Read -- Imperial Library of Trantor

Index

Title Page Copyright and Credits

Learn Microsoft Office 2019

Dedication About Packt

Why subscribe?

Contributors

About the author About the reviewers Packt is searching for authors like you

Preface

Who this book is for What this book covers To get the most out of this book

Download the example code files Code in Action Download the color images Conventions used

Get in touch

Reviews

Section 1: Word Exploring the Interface and Formatting Elements

Technical requirements An overview of the interface features

The title bar The QAT Using tabs and groups Using shortcut keys to access the ribbon Accessing the rulers Minimizing the ribbon Adding items to the status bar Using the help facility

Creating documents Setting the printing options

Changing the page margins Changing the page orientation Changing the paper size Changing the print options Setting the collate and page options Printing background colors and images Setting pages to print Inserting page breaks

Formatting text, styles, and paragraphs

Basic text formatting Changing the font colors Adding text effects Removing text formatting Changing the casing of text Copying multiple formats Formatting using font attributes Changing the text alignment options Applying a drop cap Inserting special characters and symbols Indenting paragraphs Setting spacing before or after a paragraph Adjusting the line spacing Creating a new style

Modifying a style

Summary

Creating Lists and Constructing Advanced Tables

Technical requirements Creating bulleted and numbered lists

Constructing a list automatically

Editing AutoFormat Options

Constructing a list manually Modifying a bulleted or numbered list

Defining a new bullet symbol Editing bulleted list font attributes Inserting a custom picture as a bullet

Working with multilevel lists

Creating a multilevel list

Creating an outline (multilevel list) before typing a list Creating an outline (multilevel list) after typing a list

Removing a multilevel list

Restarting numbering for a new list LaTeX math

Working with tabbed lists

Selecting tab types Typing a new tabbed list Creating a list using the leader dot tab Removing tabs in a document

Creating tables

Selecting skills

Editing and formatting tables

Merging cells Splitting cells Changing row/column height or width Inserting rows or columns Deleting rows or columns Aligning cells in tables Changing text direction Distributing rows and columns evenly Applying borders and shading

Customizing advanced tables

Converting a table to text Defining the header row Adding up cell values in a table Sorting table contents

Summary

Creating Professional Documents

Technical requirements Word-referencing features

Creating and updating the TOC Using citations to build a bibliography

Adding citation sources Generating the bibliography Editing the citation style

Working with master documents or subdocuments Constructing endnotes and footnotes

Inserting footnotes/endnotes Converting footnotes into endnotes

Inserting links in a document

Performing a mail merge

Creating a mail merge manually Creating a mail merge using the wizard

Constructing forms

Working with the Developer tab and form controls Creating a basic form Adding and modifying legacy form controls Protecting a form

Customizing page layouts

Inserting a cover page quick part Converting text into columns Inserting and modifying section breaks

Viewing section breaks Adding section breaks

Headers and footers

Inserting a header and footer Inserting page numbers Choosing a different first page Numbering from a specific page number Different header and footer sections

Summary

Versions, Restrictions, and Comparisons

Technical requirements Recovering draft versions

Enabling the AutoSave and AutoRecover features Recovering documents

Restricting access to documents and workbooks

Restricting access to document contents Restricting access to workbook contents

Restricting changes to parts of a worksheet

Comparing and combining documents Summary

Section 2: PowerPoint The PowerPoint Interface and Presentation Options

Technical requirements Introduction and new features

Creating presentation templates Setting up slides and working with files

Setting slide size Changing the slide orientation Adding tags to a presentation

Searching using tags

Embedding fonts

Saving presentations in different formats

Saving presentation slides as pictures Saving as a template Saving a presentation as an outline Saving as a presentation show Exporting file types

Setting print options and layouts

Adjusting print settings Previewing presentations

Using view and zoom options

Presentation Views using the ribbon Using the status bar commands Setting presentation zoom options Switching between multiple presentations

Summary

Formatting Slides, Tables, Charts, and Graphic Elements

Technical requirements Setting up slides and applying layouts

Adding new slides Duplicating selected slides Deleting multiple slides simultaneously Copying non-contiguous slides to other presentations Inserting an outline Reusing presentation slides Applying slide layouts Changing slide layouts

Working with themes and text manipulation

Duplicating, moving, and pasting text Inserting and formatting lists Add headers and footers to slides Applying and modifying themes

Applying a theme to selected slides Creating your own custom theme

Working with text boxes

Formatting text boxes

Applying a theme fill color Applying a gradient Applying a picture Changing the outline color and weight

Arranging and manipulating objects

Arranging objects

Sending an object forward or backward Flipping an object Rotating an object Aligning objects

Aligning objects to the top

Using the selection and visibility pane Grouping objects Resizing objects Resetting objects

Constructing and modifying tables

Inserting a table Inserting an Excel spreadsheet Setting table style options

Inserting and modifying charts

Selecting a chart type Entering chart data Changing chart style Changing the chart's quick layout Working with chart elements

Data labels Adding a data table Displaying the chart legend Adding objects to a chart Changing the chart's title

Inserting audio and video

Inserting a video clip Applying styles to video content Resizing and positioning video content Applying a style to an audio clip Adjusting playback options

Summary

Photo Albums, Sections, and Show Tools

Technical requirements Creating and modifying photo albums

Adding picture captions Inserting text Removing images Inserting pictures in black and white Reordering pictures Adjusting image rotation, brightness, and contrast Changing album layout

Picture layout Frame shape Theme

Working with presentation sections

Formatting sections

Applying animations and transitions

Adding animation effects Applying effect options Previewing animations automatically Applying an animation effect to multiple objects Using the Animation Pane Setting up advanced animations Removing animations Setting animation timing

Setting start options Selecting delay or duration options Working with 3D models and cube animations

Inserting a 3D model Animating a 3D model

Attaching sound to an animation Using the Animation Painter features Reordering animations

Working with transitions

Modifying the transition effect Adding a transition sound Modifying transition duration Setting manual or automatic time advance options Using the Morph transition

Using hyperlinks, actions, and comments

Adding hyperlinks

Launching a hyperlink Hyperlinking to a slide in the same presentation Easy linking Editing a hyperlink

Adding actions Using Zoom Inserting and editing comments

Editing comments Showing or hiding markup Deleting comments

Inking feature

Exploring slide show options and custom shows

Setting up a slide show Playing narrations Setting up the presenter view Using timings Showing media controls Creating a custom slide show

Using master slides and hiding slides

Creating master slides Hiding slides

Summary

Section 3: Excel Formatting, Manipulating, and Presenting Data Visually

Technical requirements Introducing the interface and setting options

Identifying rows, columns, and cells Workbooks and worksheets Name Box and Formula Bar Status bar Setting view options Using the help facility Proofing tools Changing default options

Changing the default username Changing the default document location Changing the default number of workbooks Saving automatically

Constructing and formatting an Excel worksheet

Inputting data efficiently

Entering data into a set range Entering data in non-contiguous ranges Using fill down Using a data entry form Using Alt + down arrow Entering dates and times Copying data using AutoFill Incrementing values

Modifying cell formatting

Aligning text Changing text orientation Wrapping text Merging cells Hiding and showing rows and columns Inserting and deleting rows and columns Setting column widths and row heights Using the Format Painter Creating and applying cell styles Applying number formats

Working with worksheets and sheet tabs

Inserting worksheets Deleting worksheets Moving or copying worksheets Renaming worksheets Applying coloring to worksheet tabs

Sorting and filtering data

Finding and replacing data Sorting ascending or descending Filtering data

Defining a filter Applying a filter Removing a filter

Applying conditional formatting Icon sets, data bars, and color scales

Setting print options

Adjusting breaks in the worksheet Inserting manual breaks into the worksheet Constructing headers and footers

Setting the header and footer distance

Setting the worksheet orientation Setting the worksheet scale Checking the paper size Setting page margins Aligning data horizontally and vertically Printing a single worksheet Printing selected worksheets

Creating charts based on worksheet data

Plotting non-contiguous data Selecting a chart Resizing a chart Changing chart placement Changing the chart type Changing the chart style Changing the Quick Layout Changing chart elements manually

Changing the chart and axis titles Displaying gridlines Displaying the legend Adding data labels Adding a data table Deleting a data series Adding a data series Changing the chart scale Formatting the chart background Adding objects to a chart Using the sunburst chart type Using funnel charts

Summary

Applying Formulas and Functions

Technical requirements Learning basic formula operations

Order of evaluation

Constructing a formula

Learning Excel functions Using the Show Formulas command Converting values and percentage increase Working out the percentage change Working out a percentage increase or decrease

Percentage increase Percentage decrease

Getting results using the status bar

Using the Function Library

Using the formula composer (Insert Function icon) Editing formulas Understanding relative versus absolute Applying dates in calculations

To insert the current date To insert the current date and time To separate the day from a date To calculate the number of days, years, and months between two dates

Using mathematical functions

The INT and ROUND functions The ROUNDUP and ROUNDDOWN functions The SUMIF function

Using the COUNTIF statistical function Using financial functions - PMT Applying conditional logic in a formula

The IF function The AND function The OR function

Using text functions

The CONCAT function The TRIM function

Investigating formula errors

Applying named ranges in a formula

Defining a named range

Naming a range of cells Editing a named range Creating a named range from selected cells Using range names in a formula

Summary

Analyzing and Organizing Data

Technical requirements Consolidating data and investigating macros

Creating a summary sheet Creating a macro Adding a macro to the ribbon for easy access

Adding a macro to the QAT Adding the macro to the ribbon tab Removing a macro from the personal macro workbook

Creating and managing PivotTables and PivotCharts

Creating a PivotTable Adding PivotTable fields

Grouping with PivotTables Using slicers and timelines

Creating a PivotChart in Excel

Working with the 3D Maps feature Using tools for analysis in Excel

Analysis ToolPak What-if analysis

Understanding data models Summary

Section 4: Common Tasks Exporting and Optimizing Files and the Browser View

Technical requirements Exporting files by changing the file type

Exporting a file as a previous version Checking the compatibility mode of a file Converting a file using compatibility mode Exporting a file in .csv format (Excel only) Exporting files as a PDF Exporting slides as image files (PowerPoint only) Exporting presentations as a video (PowerPoint only) Packaging a presentation for transfer

Document properties (metadata) Inspecting a file Packaging a presentation (PowerPoint only)

Sending handouts from PowerPoint to Word

Optimizing and compressing media in PowerPoint Investigating the browser view options (Excel only) Summary

Sharing and Protecting Files

Technical requirements Sharing and collaborating in Office 2019

Sharing a file via email

Sending as an attachment Sharing via an email link Sharing as a PDF Sharing via the Adobe Acrobat license (Adobe PDF)

Sharing a file to OneDrive Sending a document as a blog post Sending a copy of a document via instant messaging Sharing workbooks with others (Excel only)

Presenting online

Presenting online via Skype for Business Presenting online via the Office Presentation Service

Protecting files in Office 2019

Marking a file as final Using Protected View Applying file protection

Requiring a password to access a file

Removing a password from a file

Summary

Section 5: Access Database Organization and Setting Relationships

Technical requirements Introduction to Access and the settings options

Advantages of using a database Planning the database design Operating a database Orientation in the Access environment Learning about database objects

Investigating tables Querying data Presenting with forms Creating reports

Creating a new database Setting up Access options

Setting up tabbed mode Switching objects Setting Shutter Bar options

Renaming objects Switching between view modes Applying application parts

Constructing tables and manipulating data

Creating tables in Datasheet View Creating tables using the design view Inserting table fields and data types

Building relationships

Learning relationship types and rules

Defining the primary key, join type, and referential integrity

Defining primary keys Using a primary key to create a relationship Deleting or editing relationships Discussing join types Changing join types Setting up referential integrity Cascading and updating

Summary

Building Forms and Report Design

Technical requirements Building forms

Using the form wizard Working with form views Adding a new record to a form Navigating and deleting form records Applying and editing form headers Adding existing fields to a form Searching for data on a form

Form customization and layout

Resizing and moving form fields Inserting a form's background image Changing the form's background color Applying a theme to a form Using the Position options on a form

The report design, controls, and output

The Report View modes Creating a report based on a table or query Calculating in a report Formatting values on a report Creating a report header or footer Applying the report formatting options Applying the report's page setup tab options

Summary

Constructing Queries to Analyze Data

Technical requirements Constructing basic queries

Creating a Select query in Design View Creating a Select query using the Query Wizard

Manipulating query fields and the Total row

Adding fields Removing and rearranging fields Sorting query data Compiling query criteria Using wildcards in queries Calculating totals with a query

Constructing advanced queries

Creating a two-table query in Design View Constructing a calculated query Creating a Make Table query Using an Update query to replace data Adding new records using an Append query Building a Crosstab query How relationships affect a query result Using a Delete query Creating a Parameter query

Summary

Section 6: Outlook Creating and Attaching Item Content

Technical requirements Investigating the Outlook environment

Accessing the Mini toolbar Using the To-Do Bar Using the Message pane to display folder items The Navigation Pane The Peek bar

Creating a shortcut to an item

Previewing Outlook items

Previewing emails in the Message pane Using the Reading Pane

Manipulating Outlook program options

Using the Focused inbox option Investigating mail options

Manipulating item tags

Categorizing items Renaming categories Assigning categories to items Setting up a Quick Click Setting flags

Adding a flag to a message and contact Sending out a flag for recipients

Marking mail items as read/unread Checking for new messages

Working with views, filtering, and printing

Changing the view type Using the Reminders Window Applying search and filter tools Printing Outlook items

Printing attachments Printing calendars Printing tasks, notes, and contacts

Creating and sending email messages

Specifying a message theme Showing/hiding the From and Bcc... fields Configuring message delivery options

Setting the level of importance

Configuring voting and tracking options Sending a message to a contact group Moving, copying, and deleting email messages Replying to and forwarding email messages Sorting email messages

Creating and managing Quick Steps Attaching item content

Attaching an Outlook item Attaching external files

Summary

Managing Mail and Contacts

Technical requirements Cleaning up the mailbox and managing rules

Cleaning up the mailbox

Viewing the mailbox size Saving message attachments Saving a message in an external format Ignoring a conversation Using cleanup tools

Creating and managing rules

Modifying rules Deleting rules Changing Rule order

Managing junk mail and automatic message content

Allowing a specific message (not junk) Filtering junk mail with Never Block Sender Viewing the safe senders' list Blocking senders Managing signatures

Creating a signature Specifying the font for new HTML messages Specifying options for replies and forwards Setting a default theme for all HTML messages, stationery, and fonts

Creating contact information and groups

Modifying a default business card Forwarding a contact Creating and manipulating contact groups

Creating a contact group Managing contact group membership Showing notes about a contact group Deleting a contact group Sending a meeting to a contact group Searching for a contact

Summary

Calendar Objects, Tasks, Notes, and Journal Entries

Technical requirements Working with the calendar, appointments, and events

Creating and manipulating appointments and events

Setting the appointment options Printing the appointment details Forwarding an appointment Scheduling a meeting with someone who sent a message Sharing a calendar

Modifying meeting requests and manipulating the calendar pane

Setting the response options Updating a meeting request Canceling a meeting or invitation Proposing a new time for a meeting Viewing the tracking status of a meeting Editing a meeting series Manipulating the calendar pane

Arranging the calendar view Changing the calendar color Changing the calendar's font settings Displaying or hiding calendars

Creating a calendar group

Creating and managing tasks

Creating tasks Managing the task details Sending a status report Assigning a task to another Outlook contact Marking a task as complete Accepting or declining a task assignment

Creating and manipulating notes and journal entries

Creating a note Changing the current view Categorizing notes Working with journal entries Tracking Outlook items and files

Setting out-of-office options Summary

Other Books You May Enjoy

Leave a review - let other readers know what you think

← Prev
Back
Next →

← Prev
Back
Next →