Month: January 2009

Complex Excel reports made easy

Posted by cloud – January 29, 2009

With a PivotTable in Microsoft Excel can summarize thousands of rows and columns of data in a concise summary. For example, you could have an Excel spreadsheet with a long list of foods ordered. Each line shows the product is sold in the region and the city where it was sold, the date of publication, for the quantity discounts and other details.
With some hard work, you can create a report of these data, and enter complex formulas to calculate the number of orders by region and category. If you create a PivotTable instead, you’ll have a full report in just a few mouse clicks.

Accountants know the value of PivotTables as they are an excellent tool for the analysis of management data, too. PivotTable allows creating multidimensional data for the drag and dropping to move the column headers of data around

Creating reports

With a PivotTable, just drag the data into one of four areas – the line labels, column labels, and the values of the filter. The label row and column in the report that the region and category. Number of sales data could be in the field of values, and the total amounts are automatically calculated. You can add a filter to display only those orders with a discount, instead of all orders.

After creating a PivotTable, with a little more than mouse clicks, you can quickly transform the data, to view a summary.

Once the PivotTable is organized the way you want, a few clicks to create a PivotTable with the image of a summary of sales.

Audit and control functions

Professional accountants have a responsibility to ensure they have accurate data. To eliminate the possibility of serious errors which must ensure that the spreadsheets were well designed and rigorously controlled? The use of IF () and TEXT () function support, allowing the examination of the error messages will be integrated and to show that the models have been resigned and are properly conducted.

Data Management

Before you can create a PivotTable, you need to organize your data so that you can use Excel. Data can be in an Excel or a database or other sources, even in a text file.

Create your own Pivot Tables

Spending hour or two hours to learn the basics of PivotTables, you can impress your boss or your customers with amazing reports with minimal effort!

Whether you’re using Excel, it is important to obtain the knowledge necessary to perform their daily tasks. Excel training can give you the knowledge and equipment with the skills needed to work more accurately and efficiently.

  • Share/Bookmark

Choose right excel chart type

Posted by cloud – January 22, 2009

One factor to consider as you want to choose the best type of chart in Excel is the relative strengths and weaknesses of each type of graph. One could, of course, write an entire book on this subject. However, May you find it useful to examine the strengths and weaknesses described in the paragraphs that follow to choose a graphic.

Graphic area charts

Areas plot point values using the data lines. Optionally, the model cell so that the accumulation of data are point values and areas of color between the lines.

With the two advantages you can view the trend of the first data set and the total of all data sets, and can often create data sets total implied.

For example, suppose you draw two sets of data in a graph: one for a total cost and benefits. In this situation, in fact, a third set of data – revenue – because the total data sets implicitly to create a third data set for total income.

Areas too, it is virtually impossible to compare the values of data points in the second and the data series. You can get a very good idea of the first set of data values of data points, however.

Cylinder, cone and pyramid Letters

Cylinder, cone and pyramid chart types have the same strengths and experience the same weaknesses as well as column and bar charts.

In addition, cylinder, cone and pyramid chart types, their three dimensions, which also suffer from a weakness. The new dimension, while interesting, it is often more accurate to compare various points of the given values.

Bubble charts

Bubble Maps allow you to visually explore relationships between sets of data by processing the horizontal axis as the second value axis. To achieve this objective, the bubble charts plot pairs of data points.

For example, a bubble is income and the contribution of visual data in May suggests that people who earn more money, but only slightly increase their donations.

Bubble XY graphics cards, which also show the same information on the size of bubbles Excel with the values of a third data point.

Standing Up to the column charts

The column data tables to plot the different values of the bars, but to organize through the bars of a vertical axis calibrated values.

Accordingly, the column of graphics work really well when you want to see data on a point value of the whole question of the whole issue of comparing data and that data are periods of weather.

Doughnut Charts

Doughnut Charts work similar to pie chart, the presentation of data in serial and concentric rings indicating the value of each data point as a segment, or biting the ring.

Compared to those graphs, charts gifts have an advantage: it can take more than one data series. In practice, that suffers the same deficiencies as pie charts: do not compare data between the values of the series.

They are limited to small data sets. Almost always, something that appears in a doughnut graph must be of a different type of graph.

Line charts

Line plot maps in general the individual data points on a line, or using a different marker symbols or lines of different colors to distinguish data sets, and the use of a horizontal data category.

The graphics on the line de-emphasize the different data points, which work well for large data sets. With a line graph, you can draw thousands of data points. Moreover, all types of Excel charts, graphs tend to highlight the changes and trends in the values of data points that May be helpful.

However, the line graphs suffer from several shortcomings: a focus on each of the values of data points that can hide small data sets in an inappropriate manner and that it is impossible to compare the different data points, a tendency to show trends based on time that does not exist, and a tendency to show the relationship between the data sets that do not exist.

Pie Charts

Pie charts, as almost everyone knows, the display of a single set of data and data points represent segments of a circle, or slices of cake.

All this means that people can compare the values of data points for the total of all values of points and it could be argued this is a force in general, these charts are not based, as it can display a small set of data.

Almost always, something that appears in a graph should be on a table.

Stocks charts

Stock of letters on a plot prices opened high-low-close format, as seen in a newspaper or a television.

Although this type of chart shows the safety analysis technique, the type of graph can be useful even for non-safe price. You can use this table, for example, to draw daily temperatures.

Surface charts

Plot maps of a series of data in three dimensions, the network does not usually use colors to identify the data series, but rather to indicate the value varies axis.

The greatest strength of the surface is a graph that allows you to display with the same emphasis on the relationships within a set of data and data within a category.

A graph of the surface, however, suffers from two weaknesses: first, because the graph shows three-dimensional surface, it is easy for the topography of the plot area to hide data from valleys to peaks hide.

With a circulation of XY charts

Charts also known as XY scatter plot, it allows you to visually explore relationships between sets of data by processing the horizontal axis as the second value axis.

To do this, the graphics really intrigue XY pairs of data points. For example, an XY graph to trace the relationship between income and charitable donations.

The strength of an XY chart is that it allows you to explore the fundamental relationship, between two sets of data. In fact, the XY table is the only type of Excel chart that allows you to do so.

  • Share/Bookmark