Wednesday April 23, 2014
One of the features I really like in Excel, and one that I use frequently is the format painter. My affection for this feature stems from how easy it is to use, and how quickly it allows you to add formatting options to a spreadsheet.
What format painter allows you to do is, with the single click of the icon, copy all the formatting options from one cell and paste them into another cell or cells in a spreadsheet. The cells don't even need to be adjacent to each other when you do this.
To find out about using this feature, read the article on Excel's Format Painter.
Monday April 21, 2014
Insert a Watermark in Excel
© Ted French
Excel does not include a true watermark feature, but you can approximate a visible watermark by inserting an image file into a header or footer of a worksheet.
In visible watermarking, the information is typically text or a logo which identifies the owner or marks the media in some way.
Since headers and footers are normally displayed on every page of a workbook, this method of watermarking is an easy way to ensure that a logo or other necessary information is present on all pages.
To find out all the details read this short tutorial on how to Insert a Watermark in Excel.
Other Formatting Tutorials
Saturday April 19, 2014
By combining the SUM function with the OFFSET function
we can create a lookup formula that uses a dynamic range to incorporate new data as it is added to the worksheet.
The SUM function, by itself, will usually accommodate inserted cells of data with one exception - when the data is inserted into the cell where the function is currently located.
By using the SUM and OFFSET functions together, however, the range that is totaled becomes dynamic. Or, in other words, it changes to accommodate new cells of data. The addition of new cells of data does not cause problems because the range continues to adjust as each new cell is added.
To find out all the details, read this tutorial on the Excel SUM OFFSET Formula
Thursday April 17, 2014
In addition to counting cells that meet multiple conditions set by the user, the SUMPRODUCT function can also sum the contents of those cells.
Even though Excel has the better known SUMIF and SUMIFS functions to add up values that meet one or more conditions, SUMPRODUCT still has its uses.
One such use is summing the data in cells that fall between two values.
For more information, read this short tutorial on how to Sum Cells between Two Values with SUMPRODUCT.