Office 2021

This comprehensive guide leads you through Microsoft Office 2021 and Microsoft 365. On 1,200 pages, experienced reference book author and Office expert Robert Klassen answers all your questions about Word, Excel, Outlook, and PowerPoint, showing you how to use them safely in combination with OneNote and Teams. Whether you are a beginner or have already worked with older Office versions, this book provides practical tips and professional knowledge to make your everyday Office life easier. Learn through easy-to-understand step-by-step instructions how to write and design letters, send and receive emails, create and visualize calculations, plan and present presentations, and keep track of your appointments. You'll have Office safely under control.

From the contents:

• Get to know Microsoft Office 2022
• The right edition for everyone
• Office 2022 - a brief overview of innovations
• Writing texts with Word
• Defining page layout: margins, indents, and spacing
• Working with designs
• Breaks and columns
• Document template versus style sheet
• Graphics, tables, references, and directories
• Headers and footers
• Labeling covers and labels
• Record standard formulations in quick reference blocks
• Check documents: hyphenation, thesaurus, proofreading
• Change tracking and comments
• Print
• Edit documents in a team: permissions, document versions, approvals
• Calculating and analyzing with Excel
• Navigation in table documents
• Conditional formatting
• AutoFill function
• Designing tables using themes
• Working with large spreadsheet documents
• Formulas and functions
• Importing data
• Working with forms
• Work with VBA code
• Perform extensive sorting
• Filter data according to certain characteristics (AutoFilter)
• Analyzing data with diagrams
• Mini-diagrams in table cells: Sparklines
• Working with Pivot Tables
• Power Pivot
• What-if analysis
• Tips and tricks for.