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

Labels:

Comments

Post a Comment

Popular posts from this blog

Convert Centimeters to Inches Python Programming | Python Program Conver...

YouTube Video Tutorial How to write a Python program to convert centimetres to inches Formula to convert centimetres to inches   Explanation of this Python Program This Python program prompts the user to enter a height in inches, converts it to centimeters, and then prints the converted value. It uses the conversion factor of 2.54 to perform the conversion and rounds the result to two decimal places before displaying it to the user. Here's an explanation of the provided Python program line by line: python inches = float ( input ( 'Enter the Height in inches to convert into centimeters:' )) This line prompts the user to enter a height in inches and assigns the entered value to the variable inches . The input() function is used to receive input from the user, and float() is used to convert the input into a floating-point number. python centimeters = inches * 2.54 This line calculates the equivalent value in centimeters by multiplying the inches variable by the conver...
Post a Comment
Read more

Converting Decimal Number system to Binary, Octal and Hexa Decimal with Examples and Vice Versa

Topics covered with examples: Converting Decimal Number system to Binary, Octal and Hexa Decimal with Examples and Vice Versa Number Systems in Computer Science and Conversion Method Conversion of Decimal number system to other  number systems Conversion of Decimal number system to binary number systems Conversion of Decimal number system to octal number systems Conversion of Decimal number system to hexadecimal number systems Conversion of    non-decimal Number system to Other non-decimal number system Conversion of other number systems to Decimal number system Conversion of binary number systems to Decimal number system Conversion of octal number systems to Decimal number system Conversion of  hexadecimal number systems to Decimal number system Q1. What is a Number System? What are different types of number system? Number system A number system is a set of digits, symbols and rules to express quantities in counting and c...
Post a Comment
Read more

Find Your Correct Age From Date of Birth

First of all click on First two digits to type Month number from keyboard like any number from 1 to 12. . Now click on next two digits and type day number of month that is date from 1 to 31. In the last step type the year of your birth in four digits like 1995.  Now click on the blue button with text "Calculate Age". Your accurate age will be displayed below the button. For example. If today is 09-16-2023 that is September 16, 2023 and you type birth date as 11-01-2000 that is November 1, 2000, your accurate age will be displayed as:Your age is 22 years, 10 months, and 15 days. Age Calculator Age Calculator Calculate Your Age Now! Enter your date of birth: Calculate Age As shown in the image below:
Post a Comment
Read more