One of the most underused lookup and reference functions in Microsoft Excel is the DROP function. This powerful yet simple ...

I use these functions to summarize data with formulas instead of dialog boxes. That makes it easier to see exactly what's ...

Excel 2007's new table feature eliminates the need to copy formulas; once you define a data range as a table, Excel will do it for you! Tables are new to Excel 2007 ...

Q. How do the TRIMRANGE function and trim references in Excel work? A. Excel’s TRIMRANGE function and trim references help users quickly tidy up datasets. This makes for a cleaner, easier-to-follow, ...

In a Microsoft Excel spreadsheet, you may have formulas sitting in one cell that require the information within another cell in order to calculate. These relationships are called references. When a ...

Take advantage of relative cell references to add the same values to two different rows in Excel. Relative cell references create relationships between cells so that values entered in one cell are ...

This useful application MS Excel uses tables to store and analyze mathematical data using formulas and functions and your office work is incomplete without this app. Like all software, it can have ...

In 7 useful Excel formulas and functions for PPC, I shared tips to quickly identify high-impact PPC optimizations that will move the needle for your brand or client. I am a firm believer in an ...