What’s New in Excel 2010?

When a new version of Microsoft Office is released, sometimes Excel gets lots of new features. And sometimes it gets very few new features. In the case of Office 2010, Excel got very few new features. Here’s a quick summary of what’s new in Excel 2010, relative to Excel 2007:…

What Is Microsoft Excel Good For?

Microsoft Excel, as you probably know, is the world’s most widely used spreadsheet program, and is part of the Microsoft Office suite. Other spreadsheet programs are available, but Excel is by far the most popular and has become the world standard. Much of the appeal of Excel is due to…

How To Use Column Differences In Excel

Column Differences: All cells that differ from the active cell in a selected row. If more than one row is selected, the comparison is performed for each row of that selection. The cell that is used in the comparison for each additional row is located in the same column as…

5 Ways To Get Unique Values In Excel

Are you looking to get unique values (or remove duplicate values) in Excel, and as quick as possible? Have no fear – doing so is easy! Excel formula, Advanced Filter, Remove Duplicates command, PivotTable, and VBA as ways of extract unique values quick. Method 1 of 5: extract unique values using Excel formula…

CELL function

Description The CELL function returns information about the formatting, location, or contents of a cell. Syntax CELL(info_type, [reference]) Parameters info_type Required. A text value that specifies what type of cell information you want to return. The following list shows the possible values of the info_type argument and the corresponding results….

HYPERLINK function

Description HYPERLINK function Creates a shortcut or jump that opens a document stored on the Internet. When you click the cell that contains the HYPERLINK function, Microsoft Excel opens the file that is stored at link_location. Syntax HYPERLINK(link_location, [friendly_name]) Parameters Link_location Required. The path and file name to the document…

Excel VBA: Change Calculation Mode To Manual

Sub WorkbookCalculationManual() With Application ‘Workbook calculation settings .Calculation = xlCalculationManual ‘Change calculation mode to manual ‘.CalculateBeforeSave = True ‘Recalculate workbook before saving, if saving a workbook takes a long time, set to False. ‘.Calculation = xlCalculationAutomatic ‘Change calculation mode to automatic ‘.Calculation = xlCalculationSemiautomatic ‘Automatic except for data tables ‘Iterative…

How To Count Unique Values In Excel Using Formula

Sometimes you may want to count unique values exist in a range that contains duplicate values. You can count the number of unique values by using a filter, but in this article we use Excel formula to solve it. Count the unique values (not contain blank cells) =SUMPRODUCT(1/COUNTIF(range,range)) or {=SUM(1/COUNTIF(range,range))}…