excel

Close an Excel Workbook and/or Exit Excel

When you have completed work on a Workbook, you can close it to free up memory and unclutter your screen. You can close the workbook without exiting Excel or you can close the workbook and exit Excel. When you attempt to close a workbook without exiting, if you have made changes since you last saved,

Click Here to See and Read More...

Save an Excel Workbook

After creating a workbook, you will probably want to preserve your work. You can save your workbook to a local drive or to OneDrive. In this section, I will explain how to save to a local drive. Save Verses Save As When saving a workbook, you have two options: Save and Save As. As I

Click Here to See and Read More...

 

Edit a Cell

After you have entered data into an Excel cell, you can edit it, but first you must place the cell in Edit mode. Use one of the following techniques: 1) double click in the cell, 2) press the F2 key, or 3) move to the cell and then click in the Function bar. You will

Click Here to See and Read More...

Enter Data

In this section, I am going to explain how to enter data. In Excel, data can include text, numbers, dates, or formulas. An Excel worksheet is made up of rows and columns. The intersection of a row and column is called a cell. You can type data directly into a cell. Type in a Cell

Click Here to See and Read More...

Select Cells

An Excel worksheet is made up of rows and columns. The intersection of a row and column is called a cell. If you want to perform an action on the contents of cells, you must first select them. For example, if you want to bold, you must select the cells and then issue the bold

Click Here to See and Read More...

 

Issue Excel Commands

To tell a program—any program—what to do, you issue commands. Microsoft Excel gives you many ways to issue commands: clicking the command’s button, using keyboard shortcuts, using the Mini toolbar, using the Context menu, or using dialog boxes, and—if you are using a touch-sensitive screen—touching the screen. Choose the method that is appropriate and seems

Click Here to See and Read More...

Move around an Excel Worksheet

As you work in Excel, you will need to move around. In this section, I will explain how to move around an Excel worksheet. Move to a Specific Cell: If you want to move to a specific cell, click that cell. Then, if you want to insert data, begin typing. Move around a Worksheet One

Click Here to See and Read More...

 

The Excel Ribbon

You use commands to tell Microsoft Excel what to do. In Microsoft Excel 2013, you can use the Ribbon to issue commands. The Ribbon is located near the top of the window, below the Quick Access toolbar and the Title bar. A Tabs: At the top of the Ribbon are several tabs. Clicking a tab

Click Here to See and Read More...

The Excel 2016 Window

When you open an Excel worksheet, you are presented with the Excel window. You use this window to interact with the software—you type your data into the window and you use the window to tell Excel what to do. In this section, I will explain the parts of the Excel window. A Quick Access Toolbar:

Click Here to See and Read More...

The Excel 2013 Window

When you open an Excel worksheet, you are presented with the Excel window. You use this window to interact with the software—you type your data into the window and you use the window to tell Excel what to do. In this section, I will explain the parts of the Excel window. A Quick Access Toolbar:

Click Here to See and Read More...