Tag: Excel MOOC

Know the Excel Worksheet Layout

Know the Excel Worksheet Layout



In Excel, a spreadsheet file is called a workbook, and each workbook consists of one or more worksheets. These worksheets are where you do most of your work in Excel, including entering your data and formulas, so you need to know the layout of a typical worksheet.

Cell: A cell is a box in which you enter your spreadsheet data.

Column: A column is a vertical line of cells. Each column has a unique letter that identifies it. For example, the leftmost column is A, and the next column is B.

Row: A row is a horizontal line of cells. Each row has a unique number that identifies it. For example, the top most row is 1, and the next row is 2.

Cell Address: Each cell has its own address, which is determined by the letter and number of the intersecting column and row. For example, the cell at the intersection of column C and row 10 has the address C10.

Mouse Pointer: Use the Excel mouse to select cells.

Range: A range is a rectangular grouping of two or more cells. The range address is given by the address of the top left cell and the address of the bottom right cell. H12:K16 is an example of a range of cells, and it refers to all of the cells selected between column H, cell 12 and column K, cell 16.

Worksheet Tab: The worksheet tab displays the worksheet name. Most workbooks contain multiple worksheets, and you use the tabs to navigate between the worksheets.

Modify Excel Worksheet Colors

Modify the Excel Workbook Colors



You can give your workbook a new look by selecting a different color scheme. Each color scheme affects the workbook’s text colors, background colors, border colors, and more. Excel offers more than 20 color schemes.



Select a different Chart Type in Excel

Change the Type of a Chart in Excel




If you feel that the current chart type is not showing your data in the best way, you can change the chart type with just a few mouse clicks. For example, you might want to change a bar chart to a pie chart or a line chart to a stock chart.

You can also save yourself some work by configuring Excel with a new default chart type, and by saving the current chart type and chart formatting as a template that you can reuse later on.



Learn How to Create a Chart in Excel

How to Create a Chart in Excel




You can create a chart from your Excel worksheet data with just a few mouse clicks. As shown in “Understanding Chart Types”, Excel comes with 11 main chart types.

However, each of these types has several predefined varieties, so in all Excel offers more than 70 default chart configurations, which means there should always be a type that best visualizes your data. Regardless of the chart type you choose originally, you can change to a different chart type at any time.


Use a Range Name in a Formula in Excel

Use a Range Name in a Formula in Excel



You can make your formulas easier to build, more accurate, and easier to read by using range names as operands. For example, the formula =SUM(B2:B10) is difficult to decipher on its own because you cannot tell at a glance what kind of data is in the range B2:B10. However, with the formula =SUM(Expenses), it is immediately obvious that the formula is adding a range of expense values. In a previous video we explain how to define range names.

Reference Another Worksheet Range in a Formula: You can add flexibility to your formulas by adding references to ranges that reside in other worksheets. This enables you to take advantage of work you have done in other worksheets so you do not have to waste time repeating your work on the current worksheet. You can even add references to ranges that reside in other workbooks.



Protect an Excel Workbook

Protect an Excel Workbook




Protect a Worksheet’s Data: If you will be distributing a workbook to other people, you can enable Excel’s options for safeguarding worksheet data by activating the sheet’s protection feature. You can also configure the worksheet to require a password to unprotect it.

There are two main methods you can use to safeguard worksheet data: You can unlock only those cells that users are allowed to edit, and you can configure a range to require a password before it can be edited.

Protect a Workbook’s Structure and Windows: You can prevent unwanted changes to a workbook by activating protection for the workbook’s windows and structure. You can also configure the workbook to require a password to unprotect it.

You should protect a workbook’s structure when you do not want others to perform actions such as adding or deleting worksheets; you should protect a workbook’s windows when you do not want others to perform actions such as splitting a window or freezing panes.



Add Comments to an excel Workbook

Add Comments in an Excel Workbook




If you have received a workbook from another person, you can provide feedback to that person by adding a comment to a cell in the workbook. A comment is often the best way to give feedback because it does not change anything on the worksheet itself. Comments are attached to a particular cell, and Excel displays an indicator on any cell that has a comment. When you hover your mouse pointer over such a cell, Excel displays the comment in a balloon.



Convert Ranges to a Table in Excel

Convert Ranges to a Table in Excel




You can apply Excel’s powerful table tools to any range by first converting that range to a table. In Excel, a table is a collection of related information with an organizational structure that makes it easy to add, edit, and sort data. A table is a type of database where the data is organized into rows and columns: Each column represents a database field, and each row represents a database record.



Move or Copy a Formula in Excel

How to Move or Copy a Formula in Excel




You can restructure or reorganize a worksheet by moving an existing formula to a different part of the worksheet. When you move a formula, Excel preserves the formula’s range references.

Excel also enables you to make a copy of a formula, which is a useful technique if you require a duplicate of the formula elsewhere or if you require a formula that is similar to an existing formula. When you copy a formula, Excel adjusts the range references to the new location.


Knowing the Excel Window

Knowing the Microsoft Excel Window



The Excel Window, Now, we are going to learn the excel window parts. To get up to speed quickly with excel, it helps to understand the various elements of the excel window. These include standard window elements such as, the title bar and status bar, as well as office-specific elements such as the ribbon and the file tab.