How to Use Microsoft Excel

Step by step
How to Use Microsoft Excel

You don’t have to be an accountant to use Microsoft Excel. Personal budgeting, small business inventory, or really any kind of data that you need to be entered and organized can be put into Excel. Numbers, names, money and more can easily be entered and sorted. But if you have never used Excel, it can be somewhat daunting. This is a guide to get you started on learning the features and the basics of how to use Microsoft Excel.

Step 1: Open Excel

Office Online on Bing.com

First thing you need to do is open Excel. To do this, you can go to the Bing homepage and at the top in the center, you can select Excel under “Office Online”.

Step 2: Sign in to Your Microsoft Account

Sign in Page

You will need a Microsoft account to use Office Online because it runs though Microsoft One Drive. Sign into your account by entering your username/email and password.

Step 3: Create a New Workbook

New Workbook Options

Create a New work book. You can use a “Blank Workbook” or you can choose from a variety of templates to get you started.

Step 4: Begin Typing or Change Settings

Home Tab

Under the “home” tab you can changes things like that font size, style and color. Or you can edit cells. If you don’t want to make any changes, you can simply begin typing your data into the cells.

Step 5: Insert Things

Insert Tab

You can choose from different things to insert into your workbook under the “Insert” tab. Tables, surveys, six or more different kinds of charts, hyperlinks and more to allow you to customize your workbook and keep track of your data more easily.

Step 6: Adjust Cell Size

Adjust Cell

Cells are separated into letters and numbers and each cell has a line dividing it from the cell beside it. If you move your cursor over the line at the top of the column or beginning of the row, you can left click and move your mouse to adjust the size of the cells in that row/column. If you already have data entered, you can double click with the left mouse button and the row/column will automatically adjust to a suitable size for the cell with the longest about out data in it.

Step 7: Add New Sheet

Add Button

At the bottom of the screen, there is a plus sign ‘+’. You can click this to add a new sheet to your workbook. This will allow you to keep multiple sets of data in the same workbook.

Step 8: Insert/Delete Columns

Insert/Delete Menu

Left clicking at the beginning of a column or row will highlight the entire column/row. Then you can right click on it and bring up a menu that allows you to insert a new column/row in front of the highlighted one or you can choose to delete the selected column/row and all data included.

Discover More

Excel is a great tool that can be as simple or as complex as you choose to make it. You can get into the more difficult aspects of the program like adding “rules” and things like that. Or you can just use it for basic data entry. The more you play around with the program, the more you will discover. Start taking advantages of all of the awesome features today.

Related articles