This chapter is a brief overview of Microsoft Excel. Excel is one of the top-used business applications across virtually any industry. It’s much more than graphed paper; the programing in this application streamlines and solves complicated business problems. It has data management abilities, meaning you can store a database of customer information and perform analysis to gather important data about your business like sales data, popular items, etc.
Understanding how to properly use Excel is a highly employable skill and can lead to opportunities for promotion. It helps you lead in resolving challenging issues and share the most important information.
This textbook provides practice instructions to understand how to use Excel. Take your time to use this text to practice and rework skills in Excel to quickly learn how to use the program. It will take practice and effort, but as you learn Excel, you will see benefits throughout your life. Speak with your instructor, tutors, and group chats to better understand this content.
Let’s get started by learning some of the Excel basics:
To install Excel on your computer, follow the steps located in the class syllabus. It’s important to note that you cannot use the online version of Excel for this class. You need the full version of Excel not the mobile app or browser version.
After downloading Excel on your computer, open it by accessing the Start Menu and searching Excel. Open the application.
The first menu available to you will show you template workbooks and recent workbooks. A workbook is a collection of one or more spreadsheets, or worksheets, in a single file.
Open a blank workbook. It should look like Figure 38.1.
Let’s take a look at different elements of a workbook.
The Ribbon has a selection of Tabs that offer different tools available in Excel. (See Figure 38.2)
The Name Box indicates what cell is selected.
The Formula Box is where you can see or type in the information for selected cell(s).
A row is the horizontal selection of cells, indicated by numbers on the left side of the worksheet.
A column is the vertical selection of cells, indicated by letters at the top of the worksheet.
Cells are the individual boxes within the grids. A single cell is indicated by the column letter and row number (for example, A1 or F26).
Objects are images, illustrations, charts etc. that float above the cells rather than rest inside of a specific cell.
A worksheet is a spreadsheet within a workbook. Multiple worksheets can exist in a workbook. They can be added by selecting the Plus sign ( + ) next to the most recent worksheet. Worksheets can be renamed by double-clicking the current title.
There are three essential data types in Excel: Text, Numbers, and Functions.
Text is just letters or words. If you type a word into a cell and it’s recognized as text, Excel defaults to align the text to the left of the cell. You can use text to organize elements of your worksheet by labeling rows or columns according to the data you add.
Numbers come in multiple formats, including general data. Numbers are automatically aligned to the right of a cell. The special type of numbers you’ll encounter frequently are Date or Time.
You can format dates in Excel. You can use long-form dates (January 1, 2000) or short-form dates (1/1/2000). You can also represent a date as a serial number by using the General format.
If you type in a serial number and then change the format from General to Date, it will change the serial number to its respective date. For example, if you type in the number 1 in a General format and change the format to Date, the date will show you 1/1/1900, which is the first date available in Excel.
You can change the format of the date by going to the Home tab and selecting the drop-down menu in Number. (See Figure 38.18)
Times are similar to dates in the fact that they use serial numbers as well. For example, if we type 1.8 into a cell and change the format to Time, it will show us 7:12:00 PM in the cell. In the formula bar, it will read, 1/1/1900 7:12:00 PM because the serial number is attributed to that day, at that time. (See Figures 38.19 and 38.20)
You won’t need to memorize serial numbers of dates or times; this is only important to know because it makes it easier to add or subtract days or time. Let’s test out how you can add days to a date in Excel:
Functions are predefined formulas that perform calculations using specific values in a particular order. Excel has dozens of functions available for your use. Functions are viewable in the formula bar, and vary from adding, multiplying, subtracting, and sorting data. This section will teach you how to insert a basic function:
In Figure 38.25, you can see there are numbers in cells C13, C14, and C15. Use a SUM function in C16 to add them all together.
Functions are helpful because if you change one of the numbers from the selection, it will change the answer in the cell with the function. For example, if you change the number 1 in C13 to 5, the number in C16 will change to 10. (See Figure 38.26)
Note: If you have text and numbers in a cell together, Excel will recognize the cell as text-based as shown in Figure 38.27. If you ever need to label a row or column, separate it from the data to ensure you can use the appropriate functions.
You can change how the text or numbers in a cell appears. You can change it to bold, italic, or underline.
For example, you can change the text in a cell to bold:
Changing the position of the text within a cell is text alignment. The text can be centered, and aligned right or left. (See Figure 38.29)
You can use the Wrap Text if the text is too long.
To use Wrap Text:
You can add borders to a cell or multiple cells. There is a variety of types of borders you can select.
For example, you can apply All Borders to a particular range like B2:D5.
Many times, you want to make sure your spreadsheet prints properly. You can adjust how many pages a spreadsheet prints on.
Saving an Excel workbook is easy.