Peter - EXCEL 365 FOR BEGINNERS AND ADVANCED LEARNERS : A STEP-BY-STEP PRACTICAL GUIDE TO MASTER EXCEL

EXCEL 365

FOR BEGINNERS AND ADVANCED LEARNERS

A STEP-BY-STEP PRACTICAL GUIDE TO MASTER EXCEL

PETER JOHN

The information contained in this book is for information and educational purposes. No part of this book may be duplicated, transmitted, or distributed in any form or by any means, including photocopying, recording, and other mechanical or electronic methods, without the prior written permission of the publisher and the author, except in the case of brief quotations embodied in reviews and other non-commercial uses permitted by copyright law.

Copyright 2021 Peter John

All Rights Reserved

TABLE OF CONTENT

Microsoft Excel 365 is an offshoot of Office 365, which in no small way exceed the traditional Excel in term of features and capabilities.

It is no doubt that Excel is the leading spreadsheet program among every other spreadsheet program, and it is widely used by small and large scale business.

Excel 365 offers multiples features that allow users to carry out various operations such as calculations, graphs, and charts, tables, statistics, finance, data management, forecasting, track inventory, macro programming, etc.

With the use of Excel 365, you get to access your documents anytime anywhere provided you have a strong internet connection.

However, if you are posed with the problems on how to use Excel proficiently, this book is a must for you. This book contains the foundational knowledge of Excel with practical instructions to follow.

As you lay your hands on this book, I can assure you that you have just made a good decision to learning and acquiring quality skills in Excel.

Without wasting any time, lets dive into this book fully.

Before we begin to dive into Excel 365 fully, we must have in-depth knowledge about Office 365.

Office 365 is a subscription-based version of the Microsoft Office Suite, which contains the same applications as the traditional versions of Office such as Word, Excel, PowerPoint, Outlook, OneNote, and depending on the plan subscribed to, you may get to use other applications and services such as Publisher, Planner, OneDrive, Exchange, SharePoint, Access, Skype, Yammer, and Microsoft Teams.

Office 365 which was launched in 2001, was the first cloud application of Microsoft Office and generates applications, services, and data hosted in Microsofts servers.

Unlike the traditional Office Suite, Office 365 does not need to be installed for it to run. Also, Office 365 does not need any physical storage to store its information because it has an email hosting and a cloud storage space that allow the users to host their files online, and gain access to them, anytime and anywhere in as much they have an internet connection.

There is no doubt that Office 365 and the traditional Office Suite have so many similarities. Despite all these similarities, Office 365 has some exclusive features that make it different from the traditional Office suite. However, these features are the major factors that will intrigue you to use Office 365. Now let us highlight them.

• Easy Access from Anywhere: Office 365 allows you to access your file anytime and anywhere using an internet connection, from any device. The Office 365 runs in a Microsoft data center, which allows the users to connect to the internet to access the software.
• SharePoint : One of the advantages of using Office 365 is that it allows you to use SharePoint Online. Using this service allows you to share and collaborate with others. To view the document by anyone in the organization, this service set up security permission.
• Software Update: Another advantage to the use of Office 365 is that it allows the users to get frequent software updates. These updates allow access to the latest features such as security updates, and bug fixes.
• Secured Cloud Storage: Office 365 has a secure working environment with high-security measures set in place such as two-factor authentication, which obstructs any authorized people to gain access to your files even while on your devices. With this in place, your confidential files are secured without any security threat or breach.
• Improved Communication: Office 365 comes with tools such as Skype, Yammer, Microsoft Teams, and Outlook, which help to enhance communication. For instance, Skype for Business allows you to hold conference calls and meetings with staff and external agencies anywhere in the world, regardless of the distance or location. Yammer, another tool for communication in Office 365 which serves as another form of social network used in an organization is used to post news feeds, email notifications, and create different channels for different purposes.
• Automatic Upgrades : Applications such as Word, Excel, Outlook, etc. are upgraded from time to time automatically at scheduled intervals. With this in place, the stress and cost involved in buying new software are removed as updates are included in the subscription for the Office 365 licenses.
• Business Continuity: Threats such as disasters and thefts cannot affect the flow of your business no matter what happens to your physical devices, emails, files, and data. This is because all files and data needed for workflow are saved and regularly backed up in Office 365 cloud.
• Mix and Match Plans : There are several different Office 365 subscription plans with different plans and features. Because of this, not everyone is going to need the same plan. Therefore, you can mix and match plans so that you will not need to pay above or below what you need.

There are several versions of Microsoft Office 365 of which you can choose to meet your demand and specifications.

• Microsoft 365 Family: This version of Microsoft Office 365 allows for 6 users at a time across unlimited PCs/Macs, tablets, and phones. The following are the features of the Microsoft 365 Family:

1TB cloud storage per user for 6 users (6TB in total)

60 minutes monthly Skype calls to mobile and landlines

Ongoing access to updates.

Includes Word, Excel, PowerPoint, OneNote, Outlook, Publisher (PC only), Access (PC only) OneDrive, Skype, Microsoft Teams.

Access to smart assistance features, with over hundreds of premium templates, photos, icons, and fonts in Word, Excel, and PowerPoint.

Contact Support via chat or phone at no extra cost during the subscription.

Save and share files across devices with OneDrive

Experience advanced security protection in OneDrive and Outlook.

1-month free trial.

Charges $ 99.99 per year and $9.99 per month

• Microsoft 365 Personal: This uses 1 PC/Mac across unlimited PCs/Macs, tablets, and phones and advanced security for all your devices. The following are the features of Microsoft 365 Personal

1TB cloud storage per user for 1 user

60 minutes monthly Skype calls for one user

Ongoing access to updates

Includes Word, Excel, PowerPoint, OneNote, Outlook, Publisher (PC only), Access (PC only) OneDrive, Skype, Microsoft Teams, Family Safety.

Saves and shares files across devices with OneDrive

Experience advanced security protection in OneDrive and Outlook.

Charges $ 69.99 per year and $6.99 per month

• Microsoft Office 365 Education: This version of Microsoft 365 is designed for students, teachers, university faculty, or staff. It has the following features