MS Excel Tips (6)

Rate this item
(1 Vote)
Data tables are used to see how changing one or two variable data in a formula affects the result in a Microsoft Excel Worksheet. It creates a range of cells in a table form that shows the results when the variable data is applied in the calculation. Data table allows you to easily calculate multiple results in a single operation and compare the results of all the different variations of one or two data in a single worksheet. For example, data table can be used if you want to easily calculate loan repayment for varying interest rate and you can…
Rate this item
(0 votes)
Sometimes you may have to work with very large list of data in Excel Spreadsheets. Browsing through the entire list to look for important data can be tedious. One way to deal with this kind of situation is by grouping and summarizing the entire data. Outline feature in Excel helps you to group data, making it easier to read the data by hiding or showing detail data. In addition to grouping the data and show or hide the details from displaying, Outline also helps you to create Subtotals to show a quick summary of the entire data. You can create…
Rate this item
(0 votes)
Usually we use cell numbers in formuals whenever we work on an Excel spreadsheet. Remembering each cell numbers and what it contains is really hard. There is an easy way - you can use names in formulas instead of cell numbers. For example: imagine that cell C10 contains Price and cell D10 contains Quantity and you need the Total in cell E10. You can use "Price x Quantity" in cell E10 instead of "C10 x D10". This makes your formulas much easier to remember and understand.
Rate this item
(0 votes)
There may be times when we need to experement with several different values in an Excel Spreadsheet to make predictions and forecasts. For example, you are selling various products. Assume that you have a profit target to meet and you want to see how much profit you will make if you sell x number of each product. You can do this in an Excel Spreadsheet easily by making use of Scenarios in the What-If-Analysis tool. By using Scenarios, you are able to enter a set of different values in a spreadsheet, and Excel will automatically calculate the resulting values.
Rate this item
(0 votes)
In my previous post, we looked at how to create conditional formatting in order to highlight or make some cells standout from other cells based on it's values. Today, I am going to show you how to re-arrange data in Excel from columns to rows and rows to columns easily by using transpose data feature. What Does Transposing Data Mean? Transposing data in Excel means re-arranging data entered in columns (vertical range) to rows (horizontal range) or rows to column because you may want to re-layout your spreadsheet. Many time what most of us tend to do is to start…
Rate this item
(0 votes)
Microsoft Excel is one of the very advanced spreadsheet application that lets you easily create and manage complex spreadsheets. Imagine having a spreadsheet with large amount of data. Making some sense out of this data is a task by itself. Scanning through rows and columns to read and interpret the data can be really difficult. For example, if we have a spreadsheet to capture the activities in a production line. Your employees may be feeding various data into this spreadsheet. If you're required to make changes in your production line because the reject rate in the line has increased, but…
Sunday the 28th. ©Sarayoo.info 2012. Reproduction without permission is not permitted. All rights reserved.
Copyright 2012

©

Joomla template poker