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

Explain Main Difference Between System Software and Application Software

Topic: Explain Main Difference Between System Software and Application Software            Differentiate between system software and application software Before , explaining the main differences between application software and system software, let us know the definitions of Application software and System software with examples. What is System Software: System software is a set of programs to control all components of computer and to manage overall operations of computer system. Differences between System software and application software System software is used as a base to install and run all application software. Examples of system software include: Operating Systems, like Microsoft Windows, DOS, Unix and Linux Device Drivers like Device driver software of a Printer (found on CD normally provided with the printer) Utility Programs like AVAST anti virus, Disk Scanners and File Viewers etc. What is Applicat...

Explain Different Types of Data Processing and Advantages Disadvantages

Today we will discuss different types or levels of data processing in detail. Let us define Data processing first. DATA PROCESSING Data processing is the sequence of operations performed on data to convert it into useful information . These operations may be arithmetic, statistical or logical operations. We can arrange or classify data. We can send and receive data from one point to another. Explain different types of data processing TYPES OF DATA PROCESSING (OR) LEVELS OF DATA PROCESSING) There are three types of data processing . 1) Manual data processing 2) Mechanical data processing 3) Electronic data processing We may also use the term Levels of data processing. First level of data processing was manual data processing when there were no calculating devices (before the invention of calculators). Therefore all processing jobs were performed manually by hand with the help of pen , paper and mind. In second level of data processing, machines like calculat...

Explain Different Types Of Computer Networks - LAN, MAN, WAN

Explain different types of computer networks:(LAN,WAN,MAN) Today, we will discuss the main types of computer networks on the basis of the maximum distance covered where they can be accessed and operate. The main types of computer networks are: LAN, WAN, MAN Explain different types of computer networks 1.    LAN - Local-Area Network 2.    WAN - Wide-Area Network 3.    MAN - Metropolitan-Area Network 1)LAN (Local Area Network) What is LAN or Local Area Network LAN stands for Local Area Network . It covers a small area. Most LANs are used to connect computers in a single building or group of near buildings. A network contained within a relatively small area, such as a classroom, school, or single building, is commonly referred to as a local area network. Hundreds or thousands of computers may be connected through LAN . LANs are used in office buildings, college or university campus etc. Local Area Networks can t...