Archive for 'Tutorials'
Excel Merge And Center
Often in your worksheets, you’ll need a title or heading to span multiple cells and you’ll want Excel to display the title or heading in the center. This is where Excel’s merge and center command comes in.
Full StoryTables In Excel 2010
A table is a range of cells that hold data, with each row corresponding to a single occurrence of an entity. When you create a table, you can manage and analyze the data in that table independently of data outside the table. You can format the table, filter the table columns and also publish a table to a server that is running Windows SharePoint Services 3.0 or Windows SharePoint Services “4″. Usually there is an initial row of text headings that describe the columns of data.
Full StoryExcel Sum
Summing is simply the act of adding values together. Excel provides multiple techniques that you can use to sum data.
Full StorySparklines In Excel
New to Microsoft Excel 2010 are Sparklines. Sparklines are simple and compact graphs that show trends. Its small size means that a sparkline can fit inside a single cell to give you “at a glance” information about your data. If you need to present trends very clearly in a small space, then sparklines are an ideal solution.
Full StoryAbsolute Reference In Excel
By default, cell references in Excel are relative. For example, if you have the following formula in cell C1:
Full StoryCell References In Excel
A cell reference refers to a particular cell or range of cells in your worksheet. Cell references are useful for Excel to identify data for use in formulas to calculate results based on your data.
Full StoryFreeze Panes In Excel
If you have a large table of data in Microsoft Excel and you scroll down, it can be hard to remember what each column represents. This problem becomes exacerbated when you have a large number of columns and the data in each is of a similar size. How do you remember what each number means?
Full StoryExcel PivotTables
Excel PivotTables (pivot tables) enable us to extract meaningful information from large volumes of apparently meaningless data. Using PivotTables, we can “pivot” our data to view it from different angles to give us more useful insights. As you will see, you will soon be able to quickly discover the trends and patterns that are buried deep within your data.
Full StoryExcel Line Chart
In Excel 2010, line charts can display continuous data over time, set against a common scale, and are therefore ideal for showing trends in data at equal intervals. In a line chart, category data is distributed evenly along the horizontal axis, and all value data is distributed evenly along the vertical axis.
Full StoryExcel Pie Chart
Unlike other charts in Microsoft Excel, pie charts require that data in your worksheet be contained in only one row or column (although an additional row or column can be used to indicate a “category”). Each piece of data is represented as a portion of a whole, so relative sizes are easy to compare. Here is a breakdown of the votes for each party in a particular consituency in the UK. We’ll use this data to create a pie chart. Don’t worry if you don’t know what this means as it’s just the numbers we’ll be looking at.
Full Story
