how to
Microsoft Excel Tip: Watch Window
A watch window will allow you to view the value within defined cells within your workbooks More...
Never Suffer from Print Area Error Again
It is insanely annoying when printing someone else’s Excel file only to find that it isn’t formatted correctly and prints across multiple pages More...
Microsoft Excel Absolute and Relative Cell References
Cell references in Excel are a big deal, getting them correct can mean the difference between time saved and time lost scratching your head. More...
How To: Shade Alternate Rows in Excel
Help make your long data lists easier to read by shading alternate rows Below are two quick and easy methods to allow you to do just that which don’t involve manually shading the rows More...
Top 3 Articles From the Last 30 Days
Below are links to the Top 3 most read articles on the website over the last 30 days If you would like an article writing, please get in contact More...
How To Use IFERROR
Do you get fed up when your formulas return #N/A when performing a VLOOKUP calculation? Learning to use =IFERROR can help solve that More...
How To: Dynamic Chart Titles in Excel
Create charts in Excel with dynamic titles Save time changing the title of your charts when adding new data to them by using a dynamic title More...
How To: Send an Email from Excel
Learn how to use the HYPERLINK function to send an email from an Excel file Do you work on a file each day and then send an email to someone with data from the file? For example, the daily cash... More...