Discover Excel Workbook basics: create, organize, and manage your data efficiently. Perfect for beginners and pros to enhance their Excel skills. Start mastering Excel now!
An Excel workbook is a collection of one or more worksheets. A worksheet is a grid of rows and columns that can be used to store data. Each cell in a worksheet can contain text, numbers, formulas, or dates.
Introduction
To create a new workbook, open Excel and click on the “New” button. You can then select a blank workbook or a template. A template is a pre-made workbook that can be used as a starting point for your own workbook.
Once you have created a new workbook, you can start entering data into the cells. To select a cell, click on it. You can then type text or numbers into the cell. To enter a formula, click on the cell and then type the formula into the formula bar.
Once you have entered some data into your workbook, you can start to format it. You can change the font, size, and color of the text, as well as the alignment of the text in the cells. You can also add borders and shading to the cells.
To save your workbook, click on the “Save” button. You can then enter a name for your workbook and save it to a location on your computer.
Here are some basic Excel commands that you will need to know:
- Enter: This command is used to enter data into a cell.
- Delete: This command is used to delete data from a cell.
- Cut: This command is used to cut data from a cell and copy it to the clipboard.
- Copy: This command is used to copy data from a cell to the clipboard.
- Paste: This command is used to paste data from the clipboard into a cell.
- Format Painter: This command is used to copy the formatting of one cell to another cell.
- Sort: This command is used to sort data in a column or row.
- Filter: This command is used to filter data in a column or row.
- Chart: This command is used to create a chart from data in a worksheet.
Open an Existing Workbook
To open a workbook you’ve created in the past, execute the following steps.
1. On the File tab, click Open.
2. Recent shows you a list of your recently used workbooks. You can quickly open a workbook from here.
3. Click Browse to open a workbook that is not on the list.
Close a Workbook
To close a workbook (and Excel), click the upper right X. If you have multiple workbooks open, clicking the upper right X closes the active workbook.
Create a New Workbook
Sometimes you want to start all over again. To create a new workbook, execute the following steps.
1. On the File tab, click New.
2. Click Blank workbook.
Turn off the Start screen
When you start Excel, it shows a start screen that lists recently used Excel files and templates. To skip the start screen and always start with a blank workbook, execute the following steps.
1. On the File tab, click Options.
2. Under Start up options, uncheck ‘Show the Start screen when this application starts.
3. Click OK.
