STRATVERT - EXCEL 2021: Learn Excel Essentials Skill with Practical Exercises for Dummies

EXCEL 2021: Learn Excel Essentials Skill with Practical Exercises for Dummies — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "EXCEL 2021: Learn Excel Essentials Skill with Practical Exercises for Dummies" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

↓

↑

Georgia Tahoma Arial Verdana

Reset

Interval:

↓

↑

Bookmark:

Make

1234567...14

KEVIN STRATVERT 2021

All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the author.

Printed in United States of America

Contents

Chapter 3

Managing Excel Workbook and Ribbons

Chapter 1

Introduction to Microsoft Excel

Welcome to the book that will walk you through on the basics and detailed information you need to know on Excel. Microsoft Excel is used in completion of many tasks in offices, companies and by individuals. As an author, I also use this application frequently. It helps me organize my works and make them clean for future use. In this teaching, I will walk you through in step by step guide on how you can complete tasks properly on your own using this great app.

What is Microsoft Excel

Microsoft Excel is a powerful spreadsheet program created by Microsoft Corporation for data analysis and documentation. The application contains columns and rows, and each intersection of a column and a row forms what is called a cell . In addition to this information, Microsoft as a company was founded by Bill Gates and Paul Allen. I will explain some terms you will use to learn Excel application later in one of the subheadings you will read through.

How to get Microsoft Excel Application

Without having Microsoft Excel application in your computer or accessing it through any other means, there is no way you can have access to use this important application. I will walk you through on how to get this powerful spreadsheet application. You can get it through any of these ways:

1. Buying and installation of Office software
2. Getting Microsoft Excel for Free
3. Excel in Mobile phones

Buying and installation of Office software

Microsoft Office software contains all the basic software developed by Microsoft corporation. When you buy this software and install it in your computer, you can have access to many Microsoft products which among them is Excel. There are versions of Office which you can purchase from office.com website and from other retail shops which operate online as well as offline. Currently, Microsoft sells Office 2019 and 365 on their website. But more importantly, they promote Microsoft 365 (formally Office 365). So, if you do not have Office package installed in your computer currently, you can go for the 365 version which has many beautiful features added to it.

Where to buy Office Package which contains Excel

I want to inform you that Microsoft Excel or simply put Excel are just the same thing so that you do not get confused. There are some outlets through which you can buy and install office on your computer. These outlets are as follow:

1. Microsoft Office website which is accessible through www.microsoft.com and www.office.com websites
2. Amazon which is accessible through www.amazon.com
3. Indigo Software Company which is accessible through www.indigosoftwarecompany.com
4. Walmart which is accessible through www.walmart.com/
5. And many other physical computer software stores

When you visit www.microsoft.com for instance, Microsoft will recommend you buy Microsoft 365 package for your PC. The reason is because the software has many good new features added to the components that make up the package.

On the other hand, when you visit www.amazon.com , you will be landed on the homepage of the website. From the dropdown at the search box located at the top left-hand side of the site, select Software as your search option.

Fig 1: Select Software as shown by the arrow

When you visit the Indigo Software Company through the website www.indigosoftwarecompany.com , you are to use the search box to search for the version of Office you want to install in your computer. The company will guide you on the installation and activation steps.

Walmart still has different versions of Office software on their website just like Amazon. When you visit the site, you can use the search box to search for the version of the Office you want to buy, example Office 2019. This will show you the version if still available and you can pay, download, install and activate it.

You can visit any computer software seller shop close to you to also purchase any Office application of your choice. The seller will also put you through on how you can install and active the application package.

Getting Microsoft Excel for Free

This is a new development by Microsoft corporation. It allows you to have access to Microsoft Excel online without paying for the software but with limited tools. In fact, you are given access to use other Microsoft products for free including Microsoft Word, Outlook, Publisher, One Note OneDrive, Skype and others. But since our interest is on Excel, we will focus on it.

To have access to Excel for free, you are to take these steps:

1. With your computer well connected to internet, visit www.office.com preferably using your Chrome browser
2. When you land on the homepage of the site, you will be on the page that looks like the one below:

Fig 1.1: The homepage of www.office.com

If you have account with Microsoft already, you can click Sign in and then sign in with your Microsoft signin details. But if you do not have account with Microsoft, just click Sign up for the free version of Office and start creating account with the company.

But if the Sign up for the free version of Office link is not shown on the homepage of the website when you visit it, just click Sign in, and select sign up when the link opens. When you click Sign up and the new page opens, under the Create Account , just type in your email address. It can be your Gmail address, Yahoo, or any other.

A code will be sent to that email address you filled, and Microsoft system will open a box for you to fill in the code when you receive it in your email address. When you type in the code as you receive it in your email, the system may request for your phone number as well. Fill in your valid and active phone number if requested because verification code will be sent to it as well. You will be expected to fill in the code in the space that will be provided for you.

At the end of setting up your account with Microsoft, you will be logged in to the Office online platform. You will be shown a page that looks like the one below:

Fig 1.2: The free Office online homepage when logged in

As you are logged in, you can click Excel. When you click Excel, it will open, and you can then start entering your data in the cells. I will teach you more on the data entering as we go further.

Excel in Mobile phones

Another way through which you can have access to Excel is by downloading and installing the Excel application in your smartphone. Though Excel application in smart phones has limited functionalities, you can still perform basic Excel tasks in it.

If you want to install Excel application in your Android phone, just visit the Playstore in your phone, in the search box, type Microsoft Excel , and then search. The Microsoft Excel app will show up as shown below:

Next page

1234567...14

Light

Font size:

↓

↑

Georgia Tahoma Arial Verdana

Reset

Interval:

↓

↑

Bookmark:

Make

Similar books «EXCEL 2021: Learn Excel Essentials Skill with Practical Exercises for Dummies»

Look at similar books to EXCEL 2021: Learn Excel Essentials Skill with Practical Exercises for Dummies. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.

Dick Kusleika

Excel Macros For Dummies

Greg Harvey

Excel 2010 Workbook For Dummies

Paul McFedries

Excel Data Analysis For Dummies (For Dummies (Computer/Tech))

Dick Kusleika

Excel VBA Programming For Dummies (For Dummies (Computer/Tech))

Paul McFedries

Excel Workbook For Dummies (For Dummies (Computer/Tech))

Paul McFedries

Excel All-in-One For Dummies (For Dummies (Computer/Tech))

Humphrey

Excel 2019 PivotTables: Easy Excel Essentials 2019, #1

Suman

Excel Bible for Beginners: Excel for Dummies Book Containing the Most Awesome Ready to use Excel VBA Macros

Jelen

Learn Excel 2007 from Mr Excel: 377 Excel mysteries solved

Excel

Excel® sales forecasting for dummies

Greg Harvey

Excel 2013 For Dummies

Greg Harvey

Excel 2013 All-in-One For Dummies

Discussion, reviews of the book EXCEL 2021: Learn Excel Essentials Skill with Practical Exercises for Dummies and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.