Using worksheets and workbooks.

Creating a basic workbook

1. Open Excel
2. Select Blank Workbook or press Ctrl + N

Creating a workbook from a template

1. Select File > New.
2. Double-Click a template you would like to use.
3. Click and start typing.

Insert a worksheet

• Select the New Sheet plus icon at the bottom of the workbook.
• Or, select Home > Insert > Insert Sheet.

Rename a worksheet

• Double-Click the sheet name on the Sheet tab to quickly rename it.
• Or, right-click on the Sheet tab, click Rename, and type a new name.

Move a worksheet

• To move the tab to the end, right-click the Sheet tab then Move or Copy > (move to end) > OK.
• Or, click and drag the tab to any spot.

Delete a worksheet

• Right-Click the Sheet tab and select Delete.
• Or, select the sheet, and then select Home > Delect > Delete Sheet.

Move worksheets or worksheet data

• Move a worksheet within a workbook
• Select the worksheet tab and drag it to where you want it.
• Caution: When moving a sheet to another workbook, check any formulas or charts that refer to data on the sheet, as moving the sheet might cause errors or produce unintended results in the data.
• Copy a worksheet in the same workbook
1. Press Ctrl and drag the worksheet tab to the tab location you want

OR

1. Right-Click the worksheet tab and select Move or Copy.
2. Select the Creat a copy checkbox.
3. Under Before sheet, select when you want to place a copy.
4. Select OK.

Back to Questions

How to enter data.

Manual data entry

1. Select an empty cell, such as A1, and then type text or a number.
2. Press Enter to move horizontally and press Tab to move vertically

Filling data in a series

1. Enter the beginning of the series in two cell: such as Jan and Feb or 2014 and 2015
2. Select the two cells containing the series, and then drag the fill handle across or down the cells.

Automatically filling a column with flash fill

For example, automatically fill a First Name column from a Full Name column.


1. In the cell under First Name, type Molly and press Enter.
2. In the next cell, type the first few letter of Garret.
3. When the list of suggested values appears, press Enter.

Quickly calculate with AutoSum

1. Select the cell below the numbers you want to add.
2. Select Home > AutoSum
3. Press Enter

Tip: For more calculations, select the down arrow next to AutoSum, and select a calculation. You can also select a ranger of numbers to see common calculations in the status bar.

Create a chart

Use the Quick Analysis tool to pick the right chart for your data.

1. Select the data you want to show in a chart.
2. Select the Quick Analysis button to the bottom-right of the selected cells.
3. Select Charts, hover over the options, and pick the chart you want.

Use conditional formatting

Use Quick Analysis to highlight important data or show data trends.

1. Select the data to conditionally format
2. Select the Quick Analysis button to the bottom-right of the selected cells.
3. Select Formatting, hover over the options, then pick the one you want.

Freeze the top row of headings

1. Press Enter or Esc to make sure you are done editing a cell.
2. Select View > Freeze Panes > Freeze Top Row.

Use Excel as a calculator

• You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values.
• All formula entries begin with an equal sign (=). For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use — the plus sign (+) to add, the minus sign (-) to subtract, the asterisk (*) to multiply, and the forward slash (/) to divide. Then, press ENTER, and Excel instantly calculates and displays the result of the formula.
• The formula that you enter in a cell remains visible in the formula bar, and you can see it whenever that cell is selected.
• For example, when you type =12.99+16.99 in cell C5 and press ENTER, Excel calculates the result and displays 29.98 in that cell.

Back to Questions

Saving to Onedrive.

Save a workbook to OneDrive to access it from different devices, and share or collaborate with other

1. Select File > Save As.
• For work or school work, select OneDrive - (Company Name)
• For personal files, select OneDrive - Personal
2. Enter a file name and select Save

Back to Questions

How to collaborate in Excel.

1. Select Share on the ribbon or select File > Share
2. Select who you want to share with from the drop-down, or enter a name or email address.
3. Add an optional message, then hit Send.

Note: If your file is not already saved to OneDrive, you will be prompted to upload the file to OneDrive before sharing.

Back to Questions

How to print from Excel.

Print one or several worksheets

1. Select the worksheets you want to print.
2. Select File > Print, or press Ctrl + P.
3. Adjust any setting, then select print.

Print one of several workbooks

Note: All workbook files that you want to print must be in the same folder.

1. Select File > Open.
2. Hold down Ctrl, click the name of each workbook to print, and the select Print.

Print all or part of a worksheet

1. Click the worksheet, and then select the range of data that you want to print.
2. Select File, and then click Print.
3. Under Settings, select the arrow next to Print Active Sheets and select the appropriate option for your needs.
4. Select Print

Print an Excel table

1. Select a cell within the table to enable the table.
2. Select File > Print.
3. Under Settings, select the arrow next to Print Active Sheets and select the appropriate option for your needs.
4. Select Print

Print a workbook to a file

1. Select File, and then select Print, or press Crtl + P
2. Under Printer, select Print to File
3. Select Print
4. In the Save Print Output As dialog box, enter a file name and then select OK. The file will be saved in your folder.

Back to Questions