Tag: Online Excel

Use Excel Galleries

Using Excel Galleries

 

 

In excel’s ribbon, a gallery is a collection of preset options that you can apply to the selected object in the worksheet. To get the most out of galleries, you need to know how they work. Although some galleries are available all the time, in most cases you must select an object, such as a range of cells or a clip art image, before you work with a gallery

Microsoft Excel Chart Elements and Types

Microsoft Excel Chart Elements and Types

 

 

A chart is a graphic representation of spreadsheet data that uses columns, points, pie wedges, and other forms to represent numbers from a select range. As the data in the spreadsheet changes, the chart also changes to reflect the new numbers. To get the most out of charts, you need to familiarize yourself with the basic chart elements.

Category Axis: The axis (usually the X axis) that contains the category groupings.

Chart Title: The title of the chart.

Data Marker: A symbol that represents a specific data value. The symbol used depends on the chart type.

Data Series: A collection of related data values. Normally, the marker for each value in a series has the same pattern.

Data Value: A single piece of data. Also called a data point.

Gridlines: Optional horizontal and vertical extensions of the axis tick marks. These make data values easier to read.

Legend: A guide that shows the colors, patterns, and symbols used by the markers for each data series.

Plot Area: The area bounded by the category and value axes. It contains the data points and gridlines.

Value Axis: The axis (usually the Y axis) that contains the data values.

Understanding Chart Types:

Excel offers 11 different types of charts, including column charts, bar charts, line charts, and pie charts. The chart type you use depends on the type of data and how you want to present that data visually. Although you must select a particular chart type when you first construct your chart, you can quickly and easily change to a different chart type later on if you need to.

Column: A chart that, like a bar chart, compares distinct items or shows single items at distinct intervals. However, a column chart is laid out with categories along the horizontal axis and values along the vertical axis.

Line: A chart that shows how a data series changes over time. The category (X) axis usually represents a progression of even increments (such as days or months), and the series points are plotted on the value (Y) axis. Pie: A chart that shows the proportion of the whole that is contributed by each value in a single data series. The whole is represented as a circle (the “pie”), and each value is displayed as a proportional “slice” of the circle.

Bar: A chart that compares distinct items or shows single items at distinct intervals. A bar chart is laid out with categories along the vertical axis and values along the horizontal axis.

Area: A chart that shows the relative contributions over time that each data series makes to the whole picture.

Scatter or X Y Chart: A chart that shows the relationship between numeric values in two different data series. It can also plot a series of data pairs in XY coordinates.

Stock: A chart that is designed to plot stock market prices, such as a stock’s daily high, low, and closing values.

Surface: A chart that analyzes two sets of data and determines the optimum combination of the two.

Doughnut: A chart that, like a pie chart, shows the proportion of the whole that is contributed by each value in a data series. The advantage of a doughnut chart is that you can plot multiple data series.

Bubble: A chart that is similar to an XY chart, except that there are three data series, and in the third series the individual plot points are displayed as bubbles (the larger the value, the larger the bubble).

Radar: A chart that makes comparisons within a data series and between data series relative to a center point. Each category is shown with a value axis extending from the center point.

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.

 

&nbsp

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.