Exploring Microsoft Office: The Illustrated, Practical Guide to Using Office and Microsoft 365
By Kevin Wilson
()
About this ebook
Microsoft 365, formerly known as Office 365 offers many improved productivity features and services. Updated and revised, Exploring Microsoft Office is here to help. Packed with easy to follow step-by-step instructions, illustrations, photographs and video demos, this guide offers specifics in...
- Do
Kevin Wilson
KEVIN WILSON is Vice President of Videologies, Inc., a company that specializes in training administrative professionals in Fortune 500 companies. JENNIFER WAUSON is President of Videologies, Inc.
Read more from Kevin Wilson
The Family Fang: A Novel Rating: 4 out of 5 stars4/5The AMA Handbook of Business Documents: Gudielines and Sample Documents That Make Busienss Writing Easy Rating: 0 out of 5 stars0 ratingsNothing to See Here: A Novel Rating: 4 out of 5 stars4/5Blood and Fears Rating: 4 out of 5 stars4/5Administrative Assistant's and Secretary's Handbook Rating: 4 out of 5 stars4/5Essential Office 365 Third Edition: The Illustrated Guide to Using Microsoft Office Rating: 5 out of 5 stars5/5Handbook of Strategic Account Management: A Comprehensive Resource Rating: 0 out of 5 stars0 ratingsExploring Windows 11 - 2023 Edition Rating: 0 out of 5 stars0 ratingsThe AMA Handbook of Business Writing: The Ultimate Guide to Style, Grammar, Punctuation, Usage, Construction and Formatting Rating: 0 out of 5 stars0 ratingsEssential Computing: Concepts of ICT Rating: 0 out of 5 stars0 ratingsEssential Android Tablets: The Illustrated Guide to Using Android Rating: 0 out of 5 stars0 ratingsExploring Apple Mac - Ventura Edition: The Illustrated, Practical Guide to Using MacOS Rating: 0 out of 5 stars0 ratingsEssential iPad iOS 12 Edition: The Illustrated Guide to Using your iPad Rating: 5 out of 5 stars5/5Men of Air Rating: 0 out of 5 stars0 ratingsUnderstanding Google Docs - 2021 Edition: The Step-by-step Guide to Understanding the Fundamentals of Google Docs Rating: 0 out of 5 stars0 ratingsGospel Shaped Emotions: Learning to Lay Our Emotions Down at the Cross of Jesus Rating: 0 out of 5 stars0 ratingsExploring Chromebook - 2023 Edition: The Illustrated, Practical Guide to using Chromebook Rating: 0 out of 5 stars0 ratingsTake your Best Shot: The Illustrated Beginner's Guide to Digital Photography Rating: 0 out of 5 stars0 ratingsExploring Apple Mac - MacOS Sonoma Edition: The Illustrated, Practical Guide to Using MacOS Rating: 0 out of 5 stars0 ratingsEssential Windows 10 October 2018 Edition: The Illustrated Guide to Using Windows Rating: 2 out of 5 stars2/5Airborne in 1943 Rating: 4 out of 5 stars4/5Understanding Google Sheets - 2021 Edition: The Step-by-step Guide to Understanding the Fundamentals of Google Sheets Rating: 0 out of 5 stars0 ratings
Related to Exploring Microsoft Office
Titles in the series (17)
Exploring Windows 10 May 2020 Edition: The Illustrated, Practical Guide to Using Microsoft Windows Rating: 0 out of 5 stars0 ratingsExploring Apple Mac Big Sur Edition: The Illustrated, Practical Guide to Using your Mac Rating: 0 out of 5 stars0 ratingsExploring Windows 11: The Illustrated, Practical Guide to Using Microsoft Windows Rating: 0 out of 5 stars0 ratingsExploring Computers: Windows Edition: The Illustrated, Practical Guide to Using Computers Rating: 5 out of 5 stars5/5Exploring Apple Mac: Big Sur Edition: The Illustrated Guide to using your Mac Rating: 0 out of 5 stars0 ratingsExploring Microsoft Office: The Illustrated, Practical Guide to Using Office and Microsoft 365 Rating: 0 out of 5 stars0 ratingsExploring Apple Mac: Monterey Edition: The Illustrated Guide to using MacOS Rating: 0 out of 5 stars0 ratingsExploring Apple iPad: iPadOS 14 Edition: The Illustrated, Practical Guide to Using your iPad Rating: 0 out of 5 stars0 ratingsExploring Apple iPad: iPadOS Edition: The Illustrated, Practical Guide to Using iPad Rating: 0 out of 5 stars0 ratingsExploring Apple iPad: iPadOS 15 Edition: The Illustrated, Practical Guide to Using your iPad Rating: 0 out of 5 stars0 ratingsExploring iPad Pro: iPadOS Edition: The Illustrated, Practical Guide to Using iPad Pro Rating: 0 out of 5 stars0 ratingsExploring Galaxy Tab S4: The Illustrated, Practical Guide to using Samsung Galaxy Tab s4 Rating: 0 out of 5 stars0 ratingsExploring Chromebook 2020 Edition: The Illustrated, Practical Guide to using Chromebook Rating: 5 out of 5 stars5/5Exploring Apple iPhone: iOS 15 Edition: The Illustrated, Practical Guide to Using your iPhone Rating: 0 out of 5 stars0 ratingsExploring ChromeBook 2021 Edition: The Illustrated, Practical Guide to using Chromebook Rating: 0 out of 5 stars0 ratingsExploring Galaxy Tab A: The Illustrated, Practical Guide to using Samsung Galaxy Tab A Rating: 0 out of 5 stars0 ratings
Related ebooks
Microsoft Office 365 for Business Rating: 4 out of 5 stars4/5Access 2016: Up To Speed Rating: 5 out of 5 stars5/5Teach Yourself VISUALLY Microsoft 365 Rating: 0 out of 5 stars0 ratingsExploring Windows 11 - 2023 Edition Rating: 0 out of 5 stars0 ratingsOffice 365 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsOffice 2021 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsExcel Workbook For Dummies Rating: 4 out of 5 stars4/5Exploring Apple Mac: Big Sur Edition: The Illustrated Guide to using your Mac Rating: 0 out of 5 stars0 ratingsExcel Macros For Dummies Rating: 3 out of 5 stars3/5Essential Office 365 Third Edition: The Illustrated Guide to Using Microsoft Office Rating: 3 out of 5 stars3/5Excel 101: A Beginner's & Intermediate's Guide for Mastering the Quintessence of Microsoft Excel (2010-2019 & 365) in no time! Rating: 0 out of 5 stars0 ratingsExcel Formulas That Automate Tasks You No Longer Have Time For Rating: 5 out of 5 stars5/5Office 365 For Dummies Rating: 0 out of 5 stars0 ratingsMicrosoft Office for Beginners Rating: 0 out of 5 stars0 ratingsAccess 2019 Intermediate: Access Essentials 2019 Rating: 0 out of 5 stars0 ratingsMicrosoft Outlook 2016/2019/365 User Guide Rating: 5 out of 5 stars5/5How to Do Everything: Microsoft Office Online Rating: 0 out of 5 stars0 ratingsEXCEL: Microsoft: Boost Your Productivity Quickly! Learn Excel, Spreadsheets, Formulas, Shortcuts, & Macros Rating: 0 out of 5 stars0 ratingsMicrosoft Office Word Forms Rating: 4 out of 5 stars4/5Word 2016 For Professionals For Dummies Rating: 2 out of 5 stars2/515 Most Powerful Features Of Pivot Tables: Save Your Time With MS Excel Rating: 0 out of 5 stars0 ratingsMicrosoft Office 365 A Complete Guide - 2020 Edition Rating: 0 out of 5 stars0 ratingsMastering Excel: Excel Apps Rating: 3 out of 5 stars3/5SharePoint 2016 For Dummies Rating: 5 out of 5 stars5/5The IF Functions: Easy Excel Essentials, #4 Rating: 0 out of 5 stars0 ratings150 Most Poweful Excel Shortcuts: Secrets of Saving Time with MS Excel Rating: 3 out of 5 stars3/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5
Enterprise Applications For You
Excel 2019 For Dummies Rating: 3 out of 5 stars3/5QuickBooks 2024 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsBitcoin For Dummies Rating: 4 out of 5 stars4/5Creating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5QuickBooks 2023 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsEnterprise AI For Dummies Rating: 3 out of 5 stars3/5Excel Formulas That Automate Tasks You No Longer Have Time For Rating: 5 out of 5 stars5/5Scrivener For Dummies Rating: 4 out of 5 stars4/5Excel 101: A Beginner's & Intermediate's Guide for Mastering the Quintessence of Microsoft Excel (2010-2019 & 365) in no time! Rating: 0 out of 5 stars0 ratingsManaging Humans: Biting and Humorous Tales of a Software Engineering Manager Rating: 4 out of 5 stars4/5Excel 2016 For Dummies Rating: 4 out of 5 stars4/550 Useful Excel Functions: Excel Essentials, #3 Rating: 5 out of 5 stars5/5Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel Rating: 4 out of 5 stars4/5Access 2019 For Dummies Rating: 0 out of 5 stars0 ratingsExcel Formulas and Functions 2020: Excel Academy, #1 Rating: 4 out of 5 stars4/5SharePoint 2016 For Dummies Rating: 5 out of 5 stars5/5Notion for Beginners: Notion for Work, Play, and Productivity Rating: 4 out of 5 stars4/5Excel All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsExcel Workbook For Dummies Rating: 4 out of 5 stars4/5Statistical Analysis with Excel For Dummies Rating: 3 out of 5 stars3/5Microsoft Excel 365 Bible Rating: 0 out of 5 stars0 ratingsQuickBooks Online For Dummies Rating: 0 out of 5 stars0 ratingsChatGPT Ultimate User Guide - How to Make Money Online Faster and More Precise Using AI Technology Rating: 1 out of 5 stars1/5
Reviews for Exploring Microsoft Office
0 ratings0 reviews
Book preview
Exploring Microsoft Office - Kevin Wilson
Getting Started with Office
Microsoft 365, formerly known as Office 365 is a subscription-based version of Microsoft Office Applications that include Word, Excel, PowerPoint, Access, Outlook, and OneNote. With the subscription model, you pay a monthly or annual fee that allows you to download and use the Microsoft Office Suite of applications.
Unlike the traditional Office suites such as Office 2016 or 2019, Microsoft 365 allows you to install the latest Office applications on multiple devices. It includes some additional features, such as 15GB - 1TB of additional online storage space through OneDrive, collaboration tools and the option to install Office on Mac computers and tablets.
Microsoft 365 subscription guarantees that you’ll be able to upgrade to the latest version of Office whenever it’s available at no additional cost.
Office Packages
There are a number of different options and packages available depending on what your needs are.
Microsoft 365 Home is designed for families and allows you to assign up to 6 different microsoft accounts to the same Microsoft 365 Home subscription. Each user gets their own account and can install the Office apps on an unlimited amount of devices. The package includes Word, Excel, PowerPoint, Outlook, OneNote, Access and Publisher. Also comes with 1TB of OneDrive space for each user.
Microsoft 365 Personal is designed for one person. You get the same apps and features as with Microsoft 365 Home, and you can install the Office apps on an unlimited number of devices, but you can only use or sign into up to 5 devices at the same time.
Office Home & Student - can be installed on one PC only and includes, Word, Excel, and PowerPoint. You don’t get OneDrive, OneNote or any updates. This is a one off payment rather than a subscription.
Here is a comparison summary according to Microsoft’s website.
To help you decide, take some time to think about the features that are most important to you and how they fit into your budget.
Below are some points you may want to consider when buying:
If you just need Word, Excel, and PowerPoint - the core Office applications, it may be best to buy Office Home & Student, since it’s the cheapest option over the long term. This one is a one off payment, so it is unlikely you would get any of the updates in the future, but can only be installed on one machine.
If you need the more advanced applications such as Access, Publisher, Outlook Email, or OneDrive storage, then Microsoft 365 Personal is a good option, but can only be used by one person. Also comes with 1TB of space on OneDrive.
If you need to install Office for multiple users. For example, if your household has several users who need their own account, Microsoft 365 Home subscription is a good option. You assign up to 6 microsoft accounts and install on PCs, Macs, iPads, kindles, iPhones etc. Also comes with 1TB of space on OneDrive.
Business have different services available to them and are charged per user. So if you have 5 users, you need to multiply the price by 5.
For more details go to
www.microsoft.com/microsoft-365
Students & teachers can get discounts and free versions for either themselves with Microsoft Education.
www.microsoft.com/education
What is the Cloud?
Cloud computing is about running applications over the Internet and being able to access your files from wherever you may be - at your desk, on a train, in a coffee shop, airport and so on - using a variety of different devices. These devices could be laptops, desktops, macs, mobile phones, or tablets.
Microsoft 365 is an example of a cloud service and utilises cloud computing for storage allowing you can run applications such as Word, Excel, PowerPoint, and OneNote over the internet.
Some other major examples are Google Drive and Apple iCloud.
When you run programs from the hard drive on your computer, it’s called local storage. Everything is stored on your computer.
With cloud computing, you access your data and run your applications over the Internet.
These applications, services and data are stored on large server farms and are managed by the cloud service.
Your OneDrive files are stored on a server in this server farm rather than locally on your computer.
In the photograph above, there can be about 20 or more servers stacked up in each cabinet and hundreds of cabinets filling entire rooms serving millions of people who subscribe to the service.
The advantage is, you can log in and access your files anywhere on the internet and your files are backed up by the cloud service, so should your computer fail, your files will still be on your OneDrive.
Purchasing Office Online
First open your web browser and go to Microsoft Office website
products.office.com
In this example we are purchasing the home version. If you want to download a different version change it by clicking ‘products’ on the red bar at the top and select the version from the drop down box. The procedure is the same.
From the home page select ‘For Home’.
You can either pay a monthly subscription or pay an annual cost. Choose depending on your budget. If you want to pay monthly, click ‘or buy for £$ a month’. In this example I’m going to pay the annual fee, so click ‘buy now’ in the Microsoft 365 Family column.
Paying monthly will spread the cost over the year rather than paying one lump sum. Paying annually works out cheaper.
Sign in with your microsoft account, click ‘next’.
If you don’t have a microsoft account, you can quickly create one. To do this click ‘create one’ in the middle of the sign in window.
Click ‘next’ on the confirmation screen.
Select your payment type: credit/debit card or paypal.
Enter your payment details. If you have purchased from the Microsoft store before, then you can choose to pay with an existing card or you can add a different card number.
Click ‘save’.
Review and confirm your purchase.
Click ‘subscribe to confirm your order.
Now you can go and download Microsoft Office onto your devices. See next section on how to do this.
Downloading the Office Suite
You can download Microsoft Office from the Microsoft’s website. Open your web browser on the machine you want to install Office and navigate to...
office.com
Click ‘Sign in’ on the top right of your screen and enter your Microsoft Account email address and password.
Make sure your home page is selected on the left hand side, then click ‘install office’ on the top right of the screen.
Scroll down to ‘install office on all your computers’. Click ‘install office’.
Click ‘other options’ and select the 64bit version.
Click ‘run’ when prompted by your browser. Or save to your downloads folder.
The Office installer will run and begin downloading the necessary files to install Office on your computer.
This can take a while to complete depending on the speed of your computer and your internet connection.
The Installer will run once it has finished downloading. You may need to enter your computer’s password you used to log into Windows.
Once Office is installed, click ‘close’ on the final screen
You will be able to find your Office Apps installed on your start menu. You may have to scroll down the list of apps on the left hand side, if you don’t see the tiles or shortcuts on your start menu.
If this is your own computer then you can skip the next step.
If this is not your computer and belongs to someone else in the family, open up an office application such as Microsoft Word.
From the screen that appears, select ‘account’ from the bottom left..
In the main window, Click on ‘sign out’. This will sign out of your account.
You can allow the another person to sign in using their own Microsoft Account, rather than using yours.
Create a Microsoft Account
To set up a Microsoft Account you need to open a new web browser. To do this, click your web browser icon on the start menu.
Go to the following website:
signup.live.com
You can use your current email address if you have one, or you can create a new one. To create a new email address, just click ‘get a new email address’ and follow the prompts. In this example I’m going to use an existing email address.
Enter your first name and last name, then click next. In the next dialog box, select your country and your date of birth.
Click ‘next’ to continue.
Now go check your email for the email address you entered above. You’ll receive a message from Microsoft with a code. Enter the code into the ‘verify email’ dialog box then click ‘next’.
Enter the CAPTCHA code. If you have trouble reading the code, click ‘new’ to generate another code, or click ‘audio’ to hear the code read aloud. Click ‘next’.
Confirm your account details. Click ‘looks good’.
Once you’ve signed up, you’ll land on your Microsoft Account dashboard.
Outlook Email on your iPhone
Tap Settings > Passwords & Accounts > Add Account.
Tap ‘outlook’ from the account type list.
Enter your Microsoft Account email and password. Tap ‘next’ on the upper-right corner of the screen.
The mail app will automatically detect settings for server names etc.
If your iPhone doesn’t automatically detect the settings you can enter them manually. Use:
IMAP Server: outlook.office365.com
Port: 993
Encryption: SSL/TLS
SMTP Server: smtp.office365.com
Port: 587
Encryption: STARTTLS
Exchange ActiveSync server name is: outlook.office365.com
Select what information you want to synchronize or copy between your phone and your Microsoft 365 account, eg, Mail, Contacts, and Calendar information.
If you’re prompted to create a passcode, tap Continue and type in a numeric passcode. If you don’t set up a passcode, you can’t view your email account on your iPhone.
Outlook Email on Android
To add your Microsoft Account Outlook email to your android phone, first open the Gmail App.
Tap the icon on the top right of the mail window. From the slideout, tap your account at the top, then select ‘add account’.
Select ‘outlook, hotmail and live’ from the account types, then sign in with your Microsoft Account email address and password.
You’ll find your accounts on the slideout window. Just click the icon on the top left of the screen, then tap the account name at the top. You’ll see your Microsoft Account listed. Tap on it to view your email.
Setting up Outlook Desktop App
When you start Outlook for the first time, you will be asked to enter your Microsoft Account email address and password.
In the ‘Windows Security’ dialog box, enter your Microsoft Account password. Tick ‘remember my credentials’, then click ‘ok’.
Click ‘Next’. Microsoft Outlook will scan the email address you have entered and enter all the server and mail settings for you. Click ‘ok’ when the account setup is complete.
Office Apps for iOS
Microsoft has released its office apps for the iPad & iPhone. You can find the apps on Microsoft’s web site using the following link
products.office.com/mobile
Or search for ‘microsoft office’ in the App Store on your iPad/iPhone
Tap ‘Get’ to download the apps you want to use. You may be prompted to enter your Apple ID email address and password - this is different from your Microsoft Account.
You’ll find the apps on the home screen on your iPhone/iPad.
Setting up OneDrive on iOS
You can access your files on your iPhone or iPad. To do this, you’ll need to download OneDrive from the App Store. Open the App Store on your iPhone/iPad.
Type OneDrive into the search field on the top right of the App Store.
You will need an Apple ID to download the apps from the App store. Remember, your Apple ID is different from your Microsoft Account. Your Apple ID is just to access your iPhone/iPad’s App Store.
Open the OneDrive app on your iPhone/iPad and sign in with your Microsoft Account email address and password.
Office Apps for Android
Microsoft has released its office apps for your android device. You can find the apps on Microsoft’s web site using the following link
products.office.com/mobile
Or search for ‘microsoft office’ in the Play Store on your android device.
Tap on each of the apps you want to use, then on the screen that appears, tap ‘install’. You may be prompted to enter your GMail email address and password - this is different from your Microsoft Account.
You’ll find the apps on the home screen on your device.
Using Office on the Web
Microsoft 365 has a wealth of online applications. You can use office through your web browser using web apps, or you can stream live versions of office applications using office on demand.
You can synchronise all your files and keep them in the cloud using OneDrive, so you can access your files wherever you go. This is a useful feature, for example, if you have Office installed on your machine at work/college, you can synchronise all your files with your computer at home, or a tablet/phone when you’re out and about.
You can also get your files on your iPad, iPhone, or Android based tablet. Access them on any PC, laptop or net-book computer.
You can also run your favourite Office Apps over the internet using a web browser.
Lets begin by taking a look at Microsoft Office web apps.
Web Apps
With your Microsoft 365 subscription, you can access your favourite Office applications such as Word, Excel, PowerPoint or Outlook through your web browser. This can be useful if you need to edit a document or perhaps give a PowerPoint presentation on a computer that doesn’t have Office installed, or the same version of Office.
Open your web browser and navigate to
www.office.com
Click ‘sign in’ on the left hand side and enter your Microsoft account details.
From here, you’ll see a list or icons down the left hand side. You can open Word, Outlook Email, OneNote, PowerPoint, see your Outlook Calendar, open Excel or your OneDrive. You can use these applications in the same way you would your ordinary Office applications.
Your recently opened documents are listed down the middle of the screen.
Word
You can access Word through a web browser. If you are already signed into your account click on the icon for Word from the panel down the left hand side of the screen. Or go to
word.office.com
Here you can select a recently opened document, create a new blank document or use a template.
Select a document to open or select a template. You’ll be able to use Word as normal.
With the online version, you’ll see a simplified ribbon designed for small devices, such as tablets or phones. You can edit your document in the online version, or if you have Word installed on your computer click ‘open in desktop app’. You can also change your view mode : edit, view, review.
Excel
You can access Excel through a web browser. If you are already signed into your account click on the icon for Excel. Or go to excel.office.com
Here you can select a recently opened workbook, create a new blank workbook or use a template.
Select a workbook to open or select a template. You’ll be able to use Excel as normal.
You can edit your sheet in the online version or click ‘open in desktop app’ if you have excel