Take your Microsoft Office skills to the next level by mastering the exciting new features and enhancements in Microsoft Office 2021, including communicating, collaborating, and presenting using Teams
Key Features
Get a progressive walkthrough of the new desktop and web apps with real-world examples
Enrich your skillset by learning new productivity feature enhancements for Office web and desktop
Discover how to use Microsoft Teams to communicate, collaborate, and present during meetings
Book Description
This second edition book covers the new and exciting features of Microsoft Office 2021 for desktop and web apps, helping you broaden the skills from the previous edition. Using real-world experiences, this book will guide you through practical examples that set off your thought process to boost productivity.
To build new skills in each application, the book ensures that you gain a thorough understanding of new functions, such as PivotTables, Dashboards, and data manipulation methods in Excel.
You'll explore PowerPoint tools such as Presenter Coach, Presenter View, the record tool, and setting reading order to mention a few. You'll also manipulate slide elements using Auto Fix, draw features, insert video captions, explore playback options, and rehearse presentations using the body language Presenter Coach feature. The book demystifies the Transform feature and shows you how to dictate directly in Word. You'll even be able to work with Styles by refining the layout and multiple tables of contents. Finally, you'll focus on making the best use of Outlook enhancements and working remotely using Teams.
By the end of this book, you'll have understood the features of each app inside out and enhanced your existing skills using new techniques to make your professional life more efficient.
What you will learn
Uncover OneDrive features and Word enhancements such as dictation, co-authoring, embedding, styles, referencing, and media tools
Manage Word document layouts, online forms, recording document automation, and track, compare, and combine
Create engaging PowerPoint presentations using Presenter Coach, Auto Fix, Record, and drawing tools
Explore Excel functions such as XLOOKUP, LET, XMATCH IFS, arrays and IFERROR, and VLOOKUP
Work with database and COUNTIF functions, Advanced Filter, clean data, and PivotTables and Dashboards
Explore Outlook enhancements
Who this book is for
If you work with Microsoft Office applications but are yet to discover the complete range of features, this second edition is tailored to broaden your skillset with new features and functionalities. It would be of value for those working in any industry and for students moving into the workplace or preparing for Microsoft Office certification. The book uses real-world practical workplace examples to help you get ready to apply your skills and make the most of the recent features of Microsoft Office.
Although not a prerequisite, a solid understanding of the Microsoft Office applications will be beneficial.
Table of Contents
Exploring the New Interface and Managing OneDrive
Dictation, Co-authoring, and Embedding
Styles, Referencing, and Media
Managing Professional Documents
The PowerPoint Interface and Presentation Options
Formatting Slides, Charts, and Graphic Elements
Photo Albums, Sections, and Show Tools
Mastering Best Practices with Presentations
New Features, Filters, and Cleaning Data
Exploring New and Useful Workflow Functions
Date-Time Functions and Enhancing PivotTable Dashboards
(N.B. Please use the Look Inside option to see further chapters)
Author(s): Jaime Buelta
Publisher: Packt Publishing
Year: 2020
Language: English
Commentary: Python Automation Cookbook, Python , 75 automation ideas
Pages: 654
Tags: Python Automation Cookbook, Python , 75 automation ideas
Contents
Preface
Who this book is for
What this book covers
To get the most out of this book
Get in touch
Let's Begin Our Automation Journey
Activating a virtual environment
Getting ready
How to do it…
How it works…
There's more…
See also
Installing third-party packages
Getting ready
How to do it…
How it works…
There's more…
See also
Creating strings with formatted values
Getting ready
How to do it…
How it works…
There's more…
See also
Manipulating strings
Getting ready
How to do it…
How it works…
There's more…
See also
Extracting data from structured strings
Getting ready
How to do it…
How it works…
There's more…
See also
Using a third-party tool—parse
Getting ready
How to do it…
How it works…
There's more…
See also
Introducing regular expressions
Getting ready
How to do it…
How it works…
There's more…
See also
Going deeper into regular expressions
How to do it…
How it works…
There's more…
See also
Adding command-line arguments
Getting ready
How to do it…
How it works…
There's more…
See also
Automating Tasks Made Easy
Preparing a task
Getting ready
How to do it...
How it works…
There's more...
See also
Setting up a cron job
Getting ready
How to do it...
How it works...
There's more...
See also
Capturing errors and problems
Getting ready
How to do it...
How it works...
There's more...
See also
Sending email notifications
Getting ready
How to do it...
How it works...
There's more...
See also
Building Your First Web Scraping Application
Downloading web pages
Getting ready
How to do it...
How it works...
There's more...
See also
Parsing HTML
Getting ready
How to do it...
How it works...
There's more...
See also
Crawling the web
Getting ready
How to do it...
How it works...
There's more...
See also
Subscribing to feeds
Getting ready
How to do it...
How it works...
There's more...
See also
Accessing web APIs
Getting ready
How to do it...
How it works...
There's more...
See also
Interacting with forms
Getting ready
How to do it...
How it works...
There's more...
See also
Using Selenium for advanced interaction
Getting ready
How to do it...
How it works...
There's more...
See also
Accessing password-protected pages
Getting ready
How to do it...
How it works...
There's more...
See also
Speeding up web scraping
Getting ready
How to do it...
How it works...
There's more...
See also
Searching and Reading Local Files
Crawling and searching directories
Getting ready
How to do it...
How it works...
There's more...
See also
Reading text files
Getting ready
How to do it...
How it works...
There's more...
See also
Dealing with encodings
Getting ready
How to do it...
How it works...
There's more...
See also
Reading CSV files
Getting ready
How to do it...
How it works...
There's more...
See also
Reading log files
Getting ready
How to do it...
How it works...
There's more...
See also
Reading file metadata
Getting ready
How to do it...
How it works...
There's more...
See also
Reading images
Getting ready
How to do it...
How it works...
There's more...
See also
Reading PDF files
Getting ready
How to do it...
How it works...
There's more...
See also
Reading Word documents
Getting ready
How to do it...
How it works...
There's more...
See also
Scanning documents for a keyword
Getting ready
How to do it...
How it works...
There's more...
See also
Generating Fantastic Reports
Creating a simple report in plain text
Getting ready
How to do it...
How it works...
There's more...
See also
Using templates for reports
Getting ready
How to do it...
How it works...
There's more...
See also
Formatting text in Markdown
Getting ready
How to do it...
How it works...
There's more...
See also
Writing a basic Word document
Getting ready
How to do it...
How it works...
There's more...
See also
Styling a Word document
Getting ready
How to do it...
How it works...
There's more...
See also
Generating structure in Word documents
Getting ready
How to do it...
How it works...
There's more...
See also
Adding pictures to Word documents
Getting ready
How to do it...
How it works...
There's more...
See also
Writing a simple PDF document
Getting ready
How to do it...
How it works...
There's more...
See also
Structuring a PDF
Getting ready
How to do it...
How it works...
There's more...
See also
Aggregating PDF reports
Getting ready
How to do it...
How it works...
There's more...
See also
Watermarking and encrypting a PDF
Getting ready
How to do it...
How it works...
There's more...
See also
Fun with Spreadsheets
Writing a CSV spreadsheet
Getting ready
How to do it...
How it works...
There's more...
See also
Updating CSV files
Getting ready
How to do it...
How it works...
There's more...
See also
Reading an Excel spreadsheet
Getting ready
How to do it...
How it works...
There's more...
See also
Updating an Excel spreadsheet
Getting ready
How to do it...
How it works...
There's more...
See also
Creating new sheets in an Excel spreadsheet
Getting ready
How to do it...
How it works...
There's more...
See also
Creating charts in Excel
Getting ready
How to do it...
How it works...
There's more...
See also
Working with cell formats in Excel
Getting ready
How to do it...
How it works...
There's more...
See also
Creating a macro in LibreOffice
Getting ready
How to do it...
How it works...
There's more...
See also
Cleaning and Processing Data
Preparing a CSV spreadsheet
Getting ready
How to do it...
How it works...
There's more...
See also
Appending currency based on location
Getting ready
How to do it...
How it works...
There's more...
See also
Standardizing the date format
Getting ready
How to do it...
How it works...
There's more...
See also
Aggregating results
Getting ready
How to do it...
How it works...
There's more...
See also
Process data in parallel
Getting ready
How to do it...
How it works...
There's more...
See also
Process data with Pandas
Getting ready
How to do it...
How it works...
There's more...
See also
Developing Stunning Graphs
Plotting a simple sales graph
Getting ready
How to do it...
How it works...
There's more...
See also
Drawing stacked bars
Getting ready
How to do it...
How it works...
There's more...
See also
Plotting pie charts
Getting ready
How to do it...
How it works...
There's more...
See also
Displaying multiple lines
Getting ready
How to do it...
How it works...
There's more...
See also
Drawing a scatter plot
Getting ready
How to do it...
How it works...
There's more...
See also
Visualizing maps
Getting ready
How to do it...
How it works...
There's more...
See also
Adding legends and annotations
Getting ready
How to do it...
How it works...
There's more...
See also
Combining graphs
Getting ready
How to do it...
How it works...
There's more...
See also
Saving charts
Getting ready
How to do it...
How it works...
There's more...
See also
Dealing with Communication Channels
Working with email templates
Getting ready
How to do it...
How it works...
There's more...
See also
Sending an individual email
Getting ready
How to do it...
How it works...
There's more...
See also
Reading an email
Getting ready
How to do it...
How it works...
There's more...
See also
Adding subscribers to an email newsletter
Getting ready
How to do it...
How it works...
There's more...
See also
Sending notifications via email
Getting ready
How to do it...
How it works...
There's more...
See also
Producing SMS messages
Getting ready
How to do it...
How it works...
There's more...
See also
Receiving SMS
Getting ready
How to do it...
How it works...
There's more...
See also
Creating a Telegram bot
Getting ready
How to do it...
How it works...
There's more...
See also
Why Not Automate Your Marketing Campaign?
Introduction
Detecting opportunities
Getting ready
How to do it...
How it works...
There's more...
See also
Creating personalized coupon codes
Getting ready
How to do it...
How it works...
There's more...
See also
Sending a notification to a customer on their preferred channel
Getting ready
How to do it...
How it works...
There's more...
See also
Preparing sales information
Getting ready
How to do it...
How it works...
There's more...
See also
Generating a sales report
Getting ready
How to do it...
How it works
There's more...
See also
Machine Learning for Automation
Introduction
Analyzing images with Google Cloud Vision AI
Getting ready
How to do it...
How it works...
There's more...
See also
Extracting text from images with Google Cloud Vision AI
Getting ready
How to do it...
How it works...
There's more...
See also
Analyzing text with Google Cloud Natural Language
Getting ready
How to do it...
How it works...
There's more...
See also
Creating your own custom machine learning model to classify text
Getting ready
How to do it...
How it works...
There's more...
See also
Automatic Testing Routines
Introduction
Writing and executing test cases
Getting ready
How to do it...
How it works...
There's more...
See also
Testing external code
Getting ready
How to do it...
How it works...
There's more...
See also
Testing using dependency mocking
Getting ready
How to do it...
How it works...
There's more...
See also
Testing using HTTP call mocking
Getting ready
How to do it...
How it works...
There's more...
See also
Preparing testing scenarios
Getting ready
How to do it...
How it works...
There's more...
See also
Running tests selectively
Getting ready
How to do it...
How it works...
There's more...
See also
Debugging Techniques
Introduction
Learning Python interpreter basics
How to do it...
How it works...
There's more...
See also
Debugging through logging
Getting ready
How to do it...
How it works...
There's more...
See also
Debugging with breakpoints
Getting ready
How to do it...
How it works...
There's more...
See also
Improving your debugging skills
Getting ready
How to do it...
How it works...
There's more...
See also
Other Books You May Enjoy
Index
