Skip to main content

Use Microsoft Excel Online [ 2020 ] Free Spreadsheet

Topic: Use Microsoft Excel Online Free Spreadsheet

How To Create Excel Worksheet Online Free

Don't worry if you are to prepare a worksheet in Microsoft Excel and you have not purchased Microsoft Office software. You can use free online version of Microsoft Excel Online and create
worksheets as you like. Following are the instructions on how to use Microsoft Excel Online.

Use Microsoft Excel Online Free Spreadsheet
Use Microsoft Excel Online Free Spreadsheet


Here are the easy steps to create  power calculator worksheet using Microsoft Excel Online free.

1. for this purpose you need to have a Microsoft Account.

2. Type  or copy paste the following address in your web

browser's address bar
https://office.live.com/start/excel.aspx

Login To Your Microsoft Account. If you are not using any Microsoft account, please create an account now. 

3. Login to your Microsoft account ( like abc@hotmail.com or xyz@hotmail.com) or read this post to Create a new Microsoft account in easy steps.

Create Excel Workbook Online


Chose your Microsoft account


Select New Blank Workbook

4. Click on the New Blank Workbook option.

5. A blank Workbook will open. The worksheet named 'sheet1' is here to use for entring and processing your data.

Develop Power Calculator in Excel Online


6. Let's create a simple Power calculator worksheet.

7. Enter the sample data and apply some formatting as shown in the figure. Apply Merge and Center Option on the heading.

Enter Sample Data in Excel Worksheet Online


8. similarly, you can apply font color and fill color options as shown in the figure while selecting the text.
Enter Sample Data in Excel Worksheet Online

Insert a Function Power(number, power/exponent) in the required cell of the excel worksheet

9. This worksheet will use the function power(b3,c3) to calculate power of a number. The first number is in cell b3. the first power or exponent is in the cell C3.

Apply formula / Insert Function in Excel Online


10. After inserting the function in the cell D3, press Enter.

11. the result will be shown in the cell.

Copy the Formula Downwards in Excel Sheet


12. Now copy the formula by taking the mouse pointer to bottom right corner of the cell containing the formula. When a + sign appears, click left mouse button and drag down for the cells to copy formula. Note that you must keep the left mouse button pressed as long as you drag down.

How to copy formula in Excel Online


Save Excel worksheet / Workbook Online


13. Now click on nine dot button from top left corner and save the excel workbook. This workbook will bbe saved inOneDrive online storage provided free by Microsoft.

How to save Workbook in Excel Online

Download Excel worksheet / workbook to your computer


14. You can rename the workbook or download your workbook in your own computer. For this purpose use the nine dot button and the options as shown in the figure.

How to Download Workbook from Excel Online

Comments

Popular posts from this blog

Microsoft Excel Formulas and Functions Fast and Easy Way -1

Introduction Using Formulas and Functions in Microsoft Excel is really a tough job for new students. This is a series of tutorials to make the use of Formulas and Functions in worksheets, easy with various real life example worksheets. مائیکروسافٹ ایکسل میں فارمولوں اور فنکشنزکا استعمال نئے طلبا کے لیے ہمیشہ سے ایک مسئلہ رہا ہے۔ میری کوشش ہے کہ فارمولا اور فنکشن کا ٹاپک پریکٹیکلی اور پکچرز کے ساتھ تفصیل سے بیان کروں۔ Let,s start. What is Microsoft Excel? Microsoft Excel is a popular application software used to manage data in the form of rows and columns and using Excel formulas and built-in Excel functions to perform various calculations on these data. Microsoft Excel is a part of Microsoft Office. We can make different types of worksheets in Excel, for example: Employee Pay Sheet Student Test Score Result Sheet with Grades Calculation Simple Electricity Bill Calculation Formula What is an Excel Formula? Excel Formula is a proper combination of operators (like +...

How To Create Yahoo E-Mail Account

Today, we are discussing the procedure for Creating a New Yahoo Free E-Mail Account. Yahoo.Com is one of the most popular and oldest Free Email Provider world wide. Yahoo provides many free features to its email account holders including Yahoo Email account. How To Create Free Yahoo Email Account in Seconds Sponsored Links We can easily create a new yahoo email account by performing the following steps in the given order. Actually first of all you have to be connected with a fast internet connection. The second step is obviously to open a web browser. you can use any web browser but I prefer Google Chrome or Mozilla Firefox because they provide the best smooth less browsing experience.  So, here are the Main steps to create a new Yahoo Free E-mail Account: Open web browser, For example Google Chrome, Mozilla Firefox or Internet Explorer. Always use latest updated versions of web browsers for your computers security from hackers and malware. I re...

Definition and History of ECommerce

What do you mean by E-Commerce? Electronic Commerce (e-Commerce) is a general concept covering any form of business transaction or information exchange executed using information and communication technologies (ICTs). e-Commerce takes place between companies, between companies and their customers, or between companies and public administrations. Electronic Commerce includes electronic trading of goods, services and electronic material. BRIEF HISTORY OF E-COMMERCE + E-commerce started in early 1970’s with invention of electronic fund transfer(EFT). + Only used by large organizations, financial institutions and a few small business at that time. + After invention of EDI (Electronic Data Interchange) from financial institutions to manufacturers retailers, services and so on. + Many other e-commerce applications started from stock trading to travel reservation system. + With commercialization of internet in early 1990’s. The term electronic commerce was used. Interne...