Create Project from a Blank Microsoft Excel 2013 Workbook

Edited by Alexander Avdeev, Visihow Admin

Welcome to VisiHow! In this tutorial, we are going to start a new project by using a blank workbook in Microsoft Excel 2013. If you have never used Microsoft Excel 2013 before, then refer to https://visihow.com/Navigate_Microsoft_Excel_2013 to see the tutorial on how to familiarize yourself with the program.

Create Project from a Blank MS Excel 2013 workbook.mp4-canvas461 590057.jpg

Steps

  1. 1
    Locate Microsoft Excel 2013
    .
    In this video, Microsoft Excel 2013 is actually pinned to the taskbar on the desktop. The icon looks like a green book with a white "X" on it.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas44 176775.jpg
    Was this step helpful? Yes | No| I need help
  2. 2
    If the Microsoft Excel 2013 icon cannot be found on the taskbar, simply go to the search function on the operating system
    .
    For Windows 8 and Windows 8.1, move the cursor to the right side of the desktop and click "Search". For Windows 7, click the start button. Then, type "excel" to find Microsoft Excel 2013.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas57 149812.jpg
    Was this step helpful? Yes | No| I need help
  3. 3
    Open up Microsoft Excel and wait for it to load
    .
    The first page in Microsoft Excel 2013 will be introductory.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas62 919912.jpg
    Was this step helpful? Yes | No| I need help
  4. 4
    Let's review the green section
    .
    The starting page has a green section that shows "Excel" on the left-hand side of the screen. For example, if some new workbooks were created, or there were recently opened workbooks, then some shortcuts to those items would be displayed here, in the "Recent" area.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas89 169392.jpg
    Was this step helpful? Yes | No| I need help
  5. 5
    Click "Open Other Workbooks"
    .
    For example, if a workbook was downloaded to your computer, sent by a colleague or friend who wanted it to be looked at, then the particular file can be opened up by clicking this option. Select the place from where the file should be opened to start to work on it.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas102 331446.jpg
    Was this step helpful? Yes | No| I need help
  6. 6
    Click the back button in the top left corner of the screen to go back
    .
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas106 615209.jpg
    Was this step helpful? Yes | No| I need help
  7. 7
    Let's review the white section
    .
    In the white portion on the screen, there is an assortment of templates. One of the good features of the Microsoft Office is that these templates can be chosen, which is an advantage for a beginner or for a person who is in a hurry. Choose and create a template by clicking one of the templates. After that, data can be filled into the template, replacing the generic information that has been put into the template by default.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas117 479482.jpg
    Was this step helpful? Yes | No| I need help
  8. 8
    If the template that serves the required purpose is not immediately on the screen, then a search can be performed in the upper section of the area right under the search bar
    .
    It is also possible to type something specific in the search bar at the top and then click on the magnifying glass icon to bring up the found templates. For the purpose of the tutorial, a blank workbook template is required.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas151 685829.jpg
    Was this step helpful? Yes | No| I need help
  9. 9
    Click "Blank workbook"
    .
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas166 831991.jpg
    Was this step helpful? Yes | No| I need help
  10. 10
    Start the project by naming and saving the workbook
    .
    Not doing so may cause problems in the future. To check this problem off the list, save the workbook. There are several ways to do it. The first is to click the "Save" icon at the top in the quick access toolbar. The icon looks like a floppy disc. Click the icon. The option to save it will be automatically given as the file has not been saved before.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas202 829913.jpg
    Was this step helpful? Yes | No| I need help
  11. 11
    The other way to name and save the project is to click "FILE"
    .
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas213 774846.jpg
    Was this step helpful? Yes | No| I need help
  12. 12
    Click "Save As" to select the location for the saved workbook
    .
    For the demonstration, the desktop on the current computer is chosen.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas215 866397.jpg
    Was this step helpful? Yes | No| I need help
  13. 13
    Click "Computer"
    .
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas222 472336.jpg
    Was this step helpful? Yes | No| I need help
  14. 14
    Click the "Desktop" folder
    .
    Give the name for the workbook.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas225 399783.jpg
    Was this step helpful? Yes | No| I need help
  15. 15
    Type the name
    .
    In this example, it is "Monthly Sales Figures".
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas234 611318.jpg
    Was this step helpful? Yes | No| I need help
  16. 16
    Click "Save"
    .
    The name at the top of the Excel window will be changed to the saved name.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas236 872157.jpg
    Was this step helpful? Yes | No| I need help
  17. 17
    If more than one sheet is needed, add new worksheets by clicking the little plus button at the bottom of the screen
    .
    By default the first one is called "Sheet1". Add "Sheet2", "Sheet3", and "Sheet4".
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas260 721569.jpg
    Was this step helpful? Yes | No| I need help
  18. 18
    Toggle between the numbered sheets in the workbook by clicking them
    .
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas267 134211.jpg
    Was this step helpful? Yes | No| I need help
  19. 19
    Excessive sheets can be deleted by right-clicking their respective names
    .
    Right-click "Sheet 4".
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas270 826496.jpg
    Was this step helpful? Yes | No| I need help
  20. 20
    Click "Delete" to delete the selected sheet
    .
    Repeat the last two steps for "Sheet 3" and "Sheet 2".
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas273 160689.jpg
    Was this step helpful? Yes | No| I need help
  21. 21
    Click "Sheet1" to rename it
    .
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas279 40244.jpg
    Was this step helpful? Yes | No| I need help
  22. 22
    Type the name for the sheet
    .
    In this example, "May 2015" is typed as a new name. Press Enter.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas293 498664.jpg
    Was this step helpful? Yes | No| I need help
  23. 23
    Make sure to save the document often by clicking the disc icon
    .
    That prevents data loss if the system freezes or the client crashes. Also, ensure that the document is named and the sheet is labelled to start creating the project.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas297 922344.jpg
    Was this step helpful? Yes | No| I need help
  24. 24
    Click on the column number to highlight the whole column
    .
    The columns are named alphabetically ("A", "B", "C", "D", and so on). The letters represent each vertical column in the workbook.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas324 751038.jpg
    Was this step helpful? Yes | No| I need help
  25. 25
    Click on the row number to highlight the whole row
    .
    There rows are numerically labelled ("1", "2", "3", and so on). To highlight a row, click its number. The whole row will be highlighted. Highlighting the entire row or column may have many purposes, one of which is formatting.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas336 867705.jpg
    Was this step helpful? Yes | No| I need help
  26. 26
    To highlight a column, click its letter
    .
    The whole column will be selected.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas348 109756.jpg
    Was this step helpful? Yes | No| I need help
  27. 27
    Click the A1 cell to start filling data for the project
    .
    In this example, salespeople names and weeks will be used.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas361 601664.jpg
    Was this step helpful? Yes | No| I need help
  28. 28
    Type "Week 1" to label the column "A" as weeks
    .
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas367 485006.jpg
    Was this step helpful? Yes | No| I need help
  29. 29
    Type "Week 2" in B1, "Week 3" in C1 and "Week 4" in D1
    .
    The cells can also be navigated by the arrow keys on the keyboard.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas394 809494.jpg
    Was this step helpful? Yes | No| I need help
  30. 30
    To insert a new column with salespeople names to the left of the column "A", select the whole column A
    .
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas407 000237.jpg
    Was this step helpful? Yes | No| I need help
  31. 31
    Right-click "A"
    .
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas409 298206.jpg
    Was this step helpful? Yes | No| I need help
  32. 32
    Click "Insert" from the drop-down menu
    .
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas413 645631.jpg
    Was this step helpful? Yes | No| I need help
  33. 33
    Alternatively, click "INSERT" in the ribbon to insert the column
    .
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas418 326361.jpg
    Was this step helpful? Yes | No| I need help
  34. 34
    Enter some names for the employees
    .
    "Bob", "Bert", "Diana", and "Lucy" are used for the example.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas431 609133.jpg
    Was this step helpful? Yes | No| I need help
  35. 35
    Remember to save the changes often by clicking the disc icon or by clicking "FILE", and then "SAVE"
    .
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas438 635001.jpg
    Was this step helpful? Yes | No| I need help
  36. 36
    The document can also be saved by pressing the Ctrl+S key combination, which is the hotkey to save the document automatically
    .
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas443 323743.jpg
    Was this step helpful? Yes | No| I need help
  37. 37
    Put in individual numerical figures for the salespeople
    .
    Continue filling all of the cells pertinent to the weeks and salespeople.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas472 238995.jpg
    Was this step helpful? Yes | No| I need help
  38. 38
    Save the workbook
    .
    The "skeleton" workbook part with the basic figures for the sales has been created. The data that the document has can be altered, visually and mathematically analyzed, or formatted. Formatting the data visually will make them look more representative of the original idea.
    Create Project from a Blank MS Excel 2013 workbook.mp4-canvas481 842418.jpg
    If you wish, you can search for more videos on how to format and create formulas. Thank you for watching VisiHow!
    Was this step helpful? Yes | No| I need help

Video: Create Project from a Blank Microsoft Excel 2013 Workbook

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

Comments

Article Info

Categories : Software

Recent edits by: Alexander Avdeev

Share this Article:

Thanks to all authors for creating a page that has been read 326 times.

x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No