Tag: Microsoft Excel

Chart Layout & styles

Excel Chart Layout and Styles

You can quickly format your chart by applying a different chart layout and a different chart style. The chart layout includes elements such as the titles, data labels, legend, gridlines, and data table.

Excel’s Quick Layouts feature enables you to apply these elements in different combinations with just a few mouse clicks. The chart style represents the colors used by the chart data markers and background.

Copy & Delete Worksheets in Microsoft Excel

Copy and Delete Worksheets in Excel


Copy a Worksheet: Excel enables you to make a copy of a worksheet, which is a useful technique if you require a new worksheet that is similar to an existing worksheet. Rather than re-creating the new worksheet from scratch, you can make a copy of an existing worksheet and then edit the copy as needed.

Although you will most often copy a worksheet within the same workbook, it is also possible to copy the worksheet to another workbook.

Delete a Worksheet: If you have a worksheet that you no longer need, you can delete it from the workbook. This reduces the size of the workbook, reduces clutter in the worksheet tabs, and makes the workbook easier to navigate. It is important to note that you cannot undo a worksheet deletion.

Therefore, it is always a good practice to check the worksheet contents carefully before proceeding with the deletion. If the worksheet contains any data you need but you still want to remove the worksheet, cut or copy the data and paste it into another worksheet.

Operations with Ranges in Microsoft Excel

Operations with Ranges in Microsoft Excel


In Excel, a range is a collection of two or more cells that you work with as a group rather than separately. This enables you to fill the range with values, move or copy the range, sort the range data, filter the range to show only certain values, insert and delete ranges, hide entire rows or columns, and merge two or more cells.

You learn these and other range techniques in this chapter, and in later chapters you learn techniques such as formatting a range, applying a formula to a range, and building a chart from a range.

Select a Range: To work with a range in Excel, you must select the cells that you want to include in the range. After you select the range, you can fill it with data, move or copy it to another part of the worksheet, format the cells, delete the data, and so on. You can select a range as a rectangular group of cells, as a collection of individual cells, or as an entire row or column.

Fill a Range with the Same Data: If you need to fill a range with the same data, you can save time by getting Excel to fill the range for you. The most common method for filling a range in this way is to use Excel’s AutoFill feature, which makes it easy to fill a vertical or horizontal range with the same value. However, Excel also offers an alternative method that enables you to fill any selected range. See “Select a Range,” earlier in this chapter, to learn how to select a range of cells.

Fill a Range with a Series of Values: If you need to fill a range with a series of values, you can save time by using Excel’s AutoFill feature to create the series for you. AutoFill can fill a series of numeric values such as 5, 10, 15, 20, and so on; a series of date values such as January 1, 2011, January 2, 2011, and so on; or a series of alphanumeric values such as Chapter 1, Chapter 2, Chapter 3, and so on. You can also create your own series with a custom step value, which determines the numeric.

Move or Copy a Range: You can restructure or reorganise a worksheet by moving an existing range to a different part of the worksheet. For example, if you have two related ranges that are far apart on the worksheet, you can move one of them so that the ranges appear close to each other. You can also make a copy of a range, which is a useful technique if you require either a duplicate of the range elsewhere, or if you require a range that is similar to an existing range.

Change View of the Excel Window

Change View of the Excel Window



You can adjust the Excel window to suit what you are currently working on, by changing the view to match your current task. Excel offers three different views. Page Layout, which displays worksheets as they would appear if you printed them out. Normal, which is useful for building and editing worksheets. And Full Screen view, that is useful when you want to see the maximum amount of a worksheet on the screen.

Delete Data in a Range

How to Delete Data in a Range in Excel



Delete Data in a Range: If your worksheet has a range that contains data you no longer need, you can delete that data. This helps to reduce worksheet clutter and makes your worksheet easier to read. Note that the technique in this section, only applies to deleting the data that exists within each cell in a selected range. It does not apply to deleting the actual range.

Delete a Range: If your worksheet contains a range that you no longer need, you can delete that range. Note that when you delete a range, Excel deletes not just the data within the range, but the range cells themselves. Excel shifts the remaining worksheet data to replace the deleted range. Note that the technique in this section deletes the actual cells from the selected range.

Customizing the Excel Chart Elements Outline

Customizing the Excel Chart Elements Outline



You can make a chart element stand out by customizing the element’s outline, which refers to the border that appears around the element, as well as to single-line elements, such as gridlines and axes. You can customize the outline’s color, its weight, that is, its thickness, and whether the line is solid or consists of a series of dots or dashes.

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.