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.
Steps
- 1In 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.Locate Microsoft Excel 2013.
- 2For 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.If the Microsoft Excel 2013 icon cannot be found on the taskbar, simply go to the search function on the operating system.
- 3The first page in Microsoft Excel 2013 will be introductory.Open up Microsoft Excel and wait for it to load.
- 4The 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.Let's review the green section.
- 5For 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.Click "Open Other Workbooks".
- 6Click the back button in the top left corner of the screen to go back.
- 7In 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.Let's review the white section.
- 8It 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.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.
- 9Click "Blank workbook".
- 10Not 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.Start the project by naming and saving the workbook.
- 11The other way to name and save the project is to click "FILE".
- 12For the demonstration, the desktop on the current computer is chosen.Click "Save As" to select the location for the saved workbook.
- 13Click "Computer".
- 14Give the name for the workbook.Click the "Desktop" folder.
- 15In this example, it is "Monthly Sales Figures".Type the name.
- 16The name at the top of the Excel window will be changed to the saved name.Click "Save".
- 17By default the first one is called "Sheet1". Add "Sheet2", "Sheet3", and "Sheet4".If more than one sheet is needed, add new worksheets by clicking the little plus button at the bottom of the screen.
- 18Toggle between the numbered sheets in the workbook by clicking them.
- 19Right-click "Sheet 4".Excessive sheets can be deleted by right-clicking their respective names.
- 20Repeat the last two steps for "Sheet 3" and "Sheet 2".Click "Delete" to delete the selected sheet.
- 21Click "Sheet1" to rename it.
- 22In this example, "May 2015" is typed as a new name. Press Enter.Type the name for the sheet.
- 23That 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.Make sure to save the document often by clicking the disc icon.
- 24The columns are named alphabetically ("A", "B", "C", "D", and so on). The letters represent each vertical column in the workbook.Click on the column number to highlight the whole column.
- 25There 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.Click on the row number to highlight the whole row.
- 26The whole column will be selected.To highlight a column, click its letter.
- 27In this example, salespeople names and weeks will be used.Click the A1 cell to start filling data for the project.
- 28Type "Week 1" to label the column "A" as weeks.
- 29The cells can also be navigated by the arrow keys on the keyboard.Type "Week 2" in B1, "Week 3" in C1 and "Week 4" in D1.
- 30To insert a new column with salespeople names to the left of the column "A", select the whole column A.
- 31Right-click "A".
- 32Click "Insert" from the drop-down menu.
- 33Alternatively, click "INSERT" in the ribbon to insert the column.
- 34"Bob", "Bert", "Diana", and "Lucy" are used for the example.Enter some names for the employees.
- 35Remember to save the changes often by clicking the disc icon or by clicking "FILE", and then "SAVE".
- 36The document can also be saved by pressing the Ctrl+S key combination, which is the hotkey to save the document automatically.
- 37Continue filling all of the cells pertinent to the weeks and salespeople.Put in individual numerical figures for the salespeople.
- 38The "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.Save the workbook.If you wish, you can search for more videos on how to format and create formulas. Thank you for watching VisiHow!
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
