Excel provides various formatting options for charts. This How To explains how to adjust the scale of your chart, format data points, create trendlines, along with adding graphics to your chart.
Sometimes you need to number the rows in Excel.
For formatting purposes it is sometimes necessary to increase the width of a column or the height of a row. Row heights will change automatically to accommodate the size of the data in a row. In some cases, column widths will adjust automatically, but in most cases you will need to adjust column widths manually to make the columns fit the data you put in them.
One of the features of Excel is the ability to save the workbook, worksheet or chart in HTML format. This How To gives you an idea of what settings you might use when configuring Excel for Web Output and why.
Excel allows you to summarize data from worksheets through Data Consolidation. Data can be consolidated by position when all the referring data is in the same location and order, but you must consolidate by category when location and order is not the same.
In more complex worksheets, you may want to create formulas that refer to data on another worksheet. 3-D formulas allow us to do this, fairly easily.
You can combine two or more chart types in a single chart. This type of chart is called a combination chart and is commonly used to show different types of information.
If you are working with a large document that contains many calculations or details you can use an outline to create summary reports. The outline can summarize either an entire worksheet or a selected portion of it. When you create the outline, Excel organizes the data by levels. It's almost like an outline used for PowerPoint or when writing a report. Each level can be expanded or collapsed. A worksheet can have up to eight levels of detail.
A style is a collection of formats that are saved in an application and are applied as a group. Excel has many pre-defined styles but when none of the built-in styles meet your requirements, you can create a custom style.You can also modify a custom or built-in style.
Excel allows you to link information from another workbook to your existing workbook. You need to use a fomula to do this task.
Excel has many toolbars and menus that you can turn on and off. You can customize these by removing or adding buttons to fit your needs and preferences.
While working in a worksheet, you can move data from one location to another. You can either remove it from it's original location and move it to another location OR you can copy the original information and paste it to another location.
You can use formulas to perform numerical calculations in your Excel spreadsheet. Formulas range from elementary to very complex.
A function is a pre-defined formula that performs a particular type of calculation. The SUM function is one of the most commonly used functions in Excel. MIN, MAX, and AVERAGE are other simple functions used frequently. These functions only works if there are numbers in the specific cells.
When you working with columns of information it is nice to be able to sort it in ascending or descending order.
Excel doesn't come with a built in way to add a watermark, but there's a pretty painless way to do it: just place a pre-built .PNG graphic file in the header of your Excel worksheet and it displays as a watermark.
From PCWorld's Business Center, this How To page helps you learn how to use one of the most powerful tools Microsoft Excel has to offer.
Unlike Microsoft Word, Excel does not have a button for you to use to number all of the rows in your worksheet.
To quickly and clearly display data of different types, it can be helpful to plot varying data sets either with different chart types or on different axes. This Excel Blog post walks you through the steps and includes a sample worksheet to help you learn.
Counting open ended survey answers can be difficult. You might have a column with a range of numbers (which are codes for survey question answers). Also, you might have cells with multiple numbers separated by commas (multiple opinions for a survey question). Excel's COUNTIF and COUNTBLANK functions are just what you need for help in counting your answers.