Introducing the illustrated guide to Microsoft Office, your companion for unlocking the full potential of Microsoft's Office Suite! Whether you're a beginner or an experienced user, this newly updated and revised guide, Exploring Microsoft Office, is designed to enhance your productivity and streamline your workflow. Discover the power of Microsoft 365 (formerly Office 365) with its many productivity features and services.
This guide is packed with over 500 pages of easy-to-follow instructions, expert tips, and vivid visuals, including full-color illustrations, photographs, and video demos. Here's what you'll learn
Master Microsoft 365 and harness the benefits of cloud computing.
Seamlessly download and install the Microsoft Office Suite on your PC.
Explore Office Online, including The Cloud, OneDrive, Outlook Mail and Calendar, and web-based versions of Word, Excel, and PowerPoint.
Maximize the Office Apps on your iPad, tablet, phone, or Android device.
Create professional-looking documents in Microsoft Word with graphics, photographs, clipart, and customized fonts and formatting.
Utilize tables, graphs, and sorting techniques to organize and present your data effectively.
Master the clipboard's cut, copy, and paste functionalities.
Learn mail merge techniques for merging letters and labels effortlessly.
Create dynamic presentations for various purposes, incorporating animations, effects, and 3D and cinematic transitions.
Enhance your presentations with audio narrations, and confidently deliver them to audiences both in-person and online.
Utilize Excel's powerful features to analyze, present, and manipulate data, including creating charts, graphs, pivot tables, and using functions and formulas.
Gain an understanding of Microsoft Access databases, including tables, forms, queries, and SQL.
Stay connected with friends, family, and colleagues using Outlook, and effectively manage calendars and appointments.
Harness the note-taking capabilities of OneNote and more!
Unlike other resources, Exploring Microsoft Office prioritizes simplicity and clarity, ensuring that users of all backgrounds, from students to senior citizens, can grasp the fundamentals of Microsoft Office. Whether you're searching for an Office manual, a visual book, a simplified tutorial, a dummies guide, or a reliable reference, Exploring Microsoft Office is your go-to resource for increasing productivity and embracing the digital revolution.
Author(s): Kevin Wilson
Publisher: Elluminet Press
Year: 2023
Language: English
Pages: 808
Getting Started with Office
Office Packages
What is the Cloud?
Purchasing Office Online
Downloading the Office Suite
Create a Microsoft Account
Outlook Email on your iPhone
Outlook Email on Android
Setting up Outlook Desktop App
Office Apps for iOS
Setting up OneDrive on iOS
Office Apps for Android
Setting up OneDrive on Android
Set up OneDrive on your Mac
Using Office on the Web
Web Apps
The Ribbon
Word
Excel
PowerPoint
Mail
Calendar
Contacts
Sway
Microsoft Lens
Using OneDrive
OneDrive On the Web
Editing Files
Uploading Files
Organising Files & Creating Folders
OneDrive on your Desktop
Uploading Files
Searching for Files
Saving Files
Desktop App
Collaboration Features
Using your iPad
Accessing your Files
Upload Files to OneDrive
Editing Files on iPad
Microsoft Word
Starting Word
The Main Screen
The Ribbon
Home Ribbon Tab
Insert Ribbon Tab
Design Ribbon Tab
Page Layout Ribbon Tab
References Ribbon Tab
Review Ribbon Tab
Mailings Ribbon Tab
View Ribbon Tab
Format Ribbon Tab
File Backstage
Page Rulers
Zoom Controls
Tell Me Feature
Creating a New Document
Entering Text
Dictate Text
Selecting Text
Bold, Italic & Underlined
Superscript & Subscript
Highlighting Text
Text Colour
Change Case
Paragraph Styles
Editing Paragraph Styles
Text Justification
Paragraph Indents
First Line Indent
Hanging Indent
Paragraph Spacing
Line Spacing
Tabs
Bullet Lists
Numbered Lists
Sorting Text
Cut, Copy & Paste
Using the Clipboard
Inserting Symbols
The Character Map
Hidden Characters
Equations
Headers and Footers
Inserting Headers & Footers
Editing Headers & Footers
Page Numbering
Page Borders
Page Breaks
Creating Columns
Watermarks
Cover Pages
Contents Pages
Indexes
Adding Images
Insert from a File
Stock Images
Online Pictures
Download and Insert from Google Images
Adding Effects to Images
Wrap Text around Images
Remove Image Backgrounds
SmartArt
WordArt
Adding Tables
Formatting Tables
Cell Borders
Add a Column
Insert a Row
Resizing Rows & Columns
Merge Cells
Align Cell Text
Text Direction
Adding a Chart
Chart Elements
Chart Styles
Data Filters
Finding a Template
Making Your Own Template
Create Document from Saved Template
Printing on Envelopes
Mail Merge your Envelopes
Mail Merge a Letter
Check your Spelling & Grammar
Editing your Custom Dictionary
Thesaurus
Researcher
Search & Replace
Pen Support
Read Aloud
Reading Documents
Change Reading Speed
Changing Voices
Protecting Documents
Encrypt with Password
Restrict Editing
Saving Documents
Saving as a Different Format
Opening Saved Documents
Printing Documents
Page Setup
Microsoft Excel
What is a Spreadsheet?
Starting Excel
Main Screen
The Ribbon
Home Ribbon Tab
Insert Ribbon Tab
Page Layout Ribbon Tab
Formulas Ribbon Tab
Data Ribbon Tab
Review Ribbon Tab
View Ribbon Tab
File Backstage
Tell Me Feature
Creating a New Workbook
Entering Data
Simple Text Formatting
Text Orientation
Resizing Rows and Columns
Inserting Rows & Columns
Cut, Copy & Paste
Paste Special
Sorting Data
Formatting your Spreadsheet
Cell Alignment
Text Format
Cell Borders
Opening a New Sheet
Copy Data Between Sheets
Freeze Panes
Split Screen
Importing Data
Conditional Formatting
Using Multiple Workbooks
Printing your Spreadsheet
Page Setup
Page Options
Margins
Customising Margins
Headers & Footers
Page Print Order
Print Options
Print Row and Column Headers
Print Gridlines
Print Selection
Print Titles
Show & Print Formulas
Opening a Saved Workbook
Saving Workbooks
Save as a Different Format
Using Formulas
BIDMAS Rule
Using Functions
Count
CountIf
Auto Sum
Average
Max & Min
IF Function
VLookup
Types of Data
Cell Referencing
Relative
Absolute
Types of Chart
Creating a Chart
Formatting Charts
Chart Titles
Chart Elements
Axis Titles
Customising Charts
Change Background to Solid Colour
Change Background to Gradient Colour
Change Chart Type
Move and Resize Charts
Goal Seek
Data Analysis with Scenario Manager
Creating Scenarios
Summary Reports
Creating Pivot Tables
Using Slicers
Sorting Pivot Table Data
Pivot Charts
Validation Rules
By Data Type
Text Length
Displaying Messages
Input Message
Error Messages
Create a Drop Down List
Locking Cells
Microsoft Power Point
Getting Started
Create a Shortcut
The Ribbon
Home Ribbon Tab
Insert Ribbon Tab
Design Ribbon Tab
Transitions Ribbon Tab
Animations Ribbon Tab
Slide Show Ribbon Tab
File Backstage
Normal View
Outline View
Slide Sorter View
Note Page View
Creating a New Presentation
Designing a Slide
Adding a New Slide
Slide Masters
Adding Notes
Changing the Slide Order
Opening a Saved Presentation
Saving your Presentation
Save as a Different Format
Print your Slides
Online Collaboration
Slide Themes
Adding Images
From your PC
Online Images
Stock Images
Resizing Images
Image Arrangement
Adjusting Images
Removing Image Backgrounds
Design Ideas
Adding Objects
Shapes
Icons
SmartArt
WordArt
Insert a Table
Formatting Tables
Table Themes
Add a Chart
Formatting Charts
Chart Titles
Data Labels
Chart Legends
Edit Chart Data
Chart Styles
Chart Colour Schemes
Slide Transitions
Morph Transitions
Animations
Effects
Motion Paths
Custom Motion Paths
Effects & Timings
Animation Pane
Adding Video
Add Video on your PC to a New Slide
Add video from your PC to an Existing slide
Trimming Videos
Online
Adding Sound
Recording Audio
Audio from your PC
Screen Recording
Recording Presentations
Export your Presentation
Photo Albums
Microsoft PowerPoint Pen Support
Setting Up Projectors
DVI
HDMI
VGA
Wireless Presenting
Present Online
Microsoft Access
What is a Database
Database Models
Relational Database
Hierarchical & Network
Object Oriented
Microsoft Access Databases
Starting Access
Creating a Database
The Ribbon
Home Ribbon Tab
Create Ribbon Tab
External Data Ribbon Tab
Database Tools Ribbon Tab
Creating Tables
Relationships Between Tables
Creating Relationships
Entering Data
Adding Records
Deleting Records
Creating a Form
Forms Wizard
Creating Forms Manually
Validation Rules
Creating Queries
Query Parameters
Structured Query Language (SQL)
SELECT Statement
WHERE Condition
Insert New Record
Delete Record
Create Database
Delete Database
Create New Table
Delete Table
Update Table
Creating Reports
Microsoft Outlook
Getting Started
Create a Shortcut
The Ribbon
Home Ribbon Tab
Send/Receive Ribbon Tab
View Ribbon Tab
File BackStage
Email Message Ribbon
Message Ribbon Tab
Insert Ribbon Tab
Options Ribbon Tab
Format Text Ribbon Tab
Review Ribbon Tab
Sending Email
Adding Attachments
Saving Attachments
Previewing Attachments
Sending Email to Groups
Creating Contact Groups
Managing Email Messages
Creating Folders
Organising Messages
Creating Rules
Dealing with Junk Mail
Adding Other Email Accounts
Contacts
Adding new Contacts
Calendar
Add Appointment
Microsoft OneNote
Getting Started
Home Ribbon Tab
Insert Ribbon Tab
Draw Ribbon Tab
Review Ribbon Tab
View Ribbon Tab
Taking Notes
Pictures
Tables
Write Notes
Screen Clippings
Audio & Video
Using Tags
To-do List
Resources
File Resources
Video Resources
