Learn how to organize your data to easily create consistent pivot tables & chart.
The easiest way to organize your data if you want to use the powerful tool of pivot table in Excel is to work by columns with titles on first row, such as the example below:
Qsn: I need to share a spreadsheet with different group of people and I want only specified group access specified ranges, like sales group members should be able to edit only sales data range and human resources group members to edit personal data range. Please help me how to do it.
Ans: Apply different Passwords or Permissions to separate Ranges in a Worksheet
An easy formula that returns the quarter for a given date. There’s no built-in function in Excel that can do this. Check in here to learn how to do it quickly.
VLOOKUP is definetly a great tool to get the data from tables, however it has limitations: it can only work with one criteria for matching information. What If you need to refer two or more conditions to match a specific piece of data, VLOOKUP will only get the first match in the data. Fortunately Excel has functions called INDEX and MATCH that works same as VLOOKUP but with multiple criteria. Here’s a quick tutorial to help you learn how…
If you want to round a price to nearest nickel (multiple of 0.05), or a length to the nearest inch (multiple of 1/12), or a number of minutes to the nearest second (multiple of 1/60), you can use the following formula (where mult is the multiple to round to):
It is often easier to read lists of data if alternate rows are shaded. This article shows you how to use conditional formatting to shade alternate rows.
Lately there has been great interest in lightweight in-cell charting, using worksheet formulas and sometimes a special font, to display values graphically.
The world today has way too much data, but very little information. In this tutorial I’ll show you how to convert your data into powerful information by selecting the right charts for expressing them.
This page describes the Conditional Formatting tool. Use Excel conditional formatting to color rows, hide duplicates, highlight items or hide errors.
We all know that to make a chart we must specify a range of values as input. But what if our range is dynamic and keeps on growing or shrinking. Wouldn’t it be cool if the ranges were dynamic and charts get updated automatically when you add (or remove) rows?