Learn Excel Formula Auditing with examples to take you to the next level! It allows you to graphically display the relationship between formulas and cells. Features: Easy Auditing of formula dependents and precedents, including object dependencies (charts, pivot tables, form controls, Validation formulas, Conditional formatting formulas, etcetera). The example helps you master Formula Auditing quickly and easily.
If you have data from an alternative source, you may be able to import it into Excel 2010 instead of having to re-enter all the information again. Depending on the type of data you would like to import, you can select from a number of options. We’ll look at one of the most common import types – a text file.
Another underused feature of Excel is Named Ranges. Named Ranges allow you to assign a meaningful name to a cell or a range of cells and then use that name instead of the actual cell reference in your formulas. A name is easier to remember when you are constructing your formulas.
We are often asked by Microsoft Office power users whether, why, and when they should use Microsoft Access versus Microsoft Excel. Especially when they are very comfortable using MS Excel and don’t understand the reasons why anyone would use MS Access or databases. Here’s our perspective.
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:
At times you may want to select the cells that have specified type of data in it, by which you can distinguish between cells that contain different types of data, which allows you to delete, fill or lock cells by the data type for various other reasons.
Bonus Tip: How to use formulas to highlight the cells that only contain Text, Number or Errors
You can use conditional formatting to format or color the cells based on their contents. For example, you have a cell to turn red when it contains text ‘No’ or a value less than 90%. But how do you highlight an entire row? When a cell contain specified content.
This tutorial will help you learn how to highlight other cells based on a cell’s value? To see how this was done, read on.
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
Three tips that will help you to reset Excel’s default formatting. Set them once, and never again
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…