Excel C1L1 Basic Use
- Open Excel and start a Blank Workbook
- Save the file as EC1L1YourName in OneDrive. File -> Save As -> Choose the location you want to save it in
- Watch the following video about how to navigate in Excel:
-
- Try some navigation by following the directions below:
- Select cell A1
- Press the right arrow key four times to move to cell E1
- Press the down arrow key four times to move to cell E5
- Click in Cell H9 to make H9 the active cell
- Go to cell T98 using the name box. -> type T98 in the name box -> click ok
- Go to cell B1492 using the name box. Click in the name box -> Type B1492 -> hit enter
- Go to XFD1048576 using the name box.
- Go to cell A1
- In cell A1 Type your Name
- Type in cell A2 the largest row # you can go to and hit enter.
- Type in cell A3 the largest column # you can go to and hit enter.
- Add a sheet2. Click the + button by Sheet 1
- Click on sheet2.
- Type your name in Cell A1
- Resize column A so that all the text you entered fits in the cells. Place your mouse between A and B in the column headers -> Double Click
- Select Sheet1.
-
- Put a header in your Excel Document with the following:
- Put in a header with Your name on the left. See the video below to learn how to add a header:
- Put in a date code in the middle
- Put in a page number code on the right
- Your Spread sheet should like the picture below:
-
- Switch back to normal view. Click on the following in the status bar:
- Type Invoice in cell A5 and press enter twice
- Type Address: and press Tab
- Type ES Electrical Solutions, Inc. and press enter
- Select cell B8
- Type 4981 41st St. SW and press enter
- Type Berthoud, CO 80515 and press enter
- Select cell A11
- Type Date: and press enter
- Type Number: and press enter
- Type Due Date: and press enter twice
- In cell A15 type in Customer Number: and press enter
- Type Customer Name: and press enter
- Undo the last two instructions. Click on
- Redo the two instructions. Click on
- Select B7:B9. Click and drag the mouse over B7:B9
- Clear the contents of those cells. Click Home -> Clear -> Clear Contents
- Undo the last action. Ctrl-z
- Insert Invoice in front of the word number in cell A12. Click on Cell A12 -> Click in front of Number in the formula bar -> Type in Invoice.
- Select Cell A13
- Type Terms: and press enter to replace Due Date: with Terms:
- Resize Column A so that all text in the column is autofited. Put your mouse between A and B in the header area and double click
- Resize Column B so that all text in the column is autofited
- Your spreadsheet should look similar to the picture below but you will have different information in the first 3 cells in Column A
- Turn it your file
COPYRIGHT © 2023-2024 LEARNSOFTWARETODAY.COM