Microsoft Excel Tip: Watch Window

8 March 2017 in Excel Basics, How To
0 comments 2 minutes 1,322 views

A watch window will allow you to view the value within defined cells within your workbooks More...

Tags: , , , ,

Never Suffer from Print Area Error Again

8 February 2017 in Excel Basics, How To
0 comments 2 minutes 867 views

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...

Tags: , , , ,

Microsoft Excel Absolute and Relative Cell References

6 February 2017 in Excel Basics, Formula, How To
0 comments 2 minutes 1,262 views

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...

Tags: , , , , , ,

Use Conditional Formatting to Highlight the Minimum and Maximum Values

5 January 2017 in Excel Basics, How To
0 comments 2 minutes 1,006 views

Stop searching for the minimum and maximum values in your range and let Excel do the work for you by using conditional formatting This will take you all of two minutes to read and understand More...

Tags: , , , ,

How To: Shade Alternate Rows in Excel

2 January 2017 in Formula, How To
0 comments 2 minutes 739 views

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...

Tags: , , , , ,

Top 3 Articles From the Last 30 Days

31 December 2016 in Excel Basics, Formula, How To, List, Top 3
0 comments 2 minutes 511 views

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...

Tags: , , , , , ,

How To Use IFERROR

29 December 2016 in Formula, How To
0 comments 2 minutes 674 views

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...

Tags: , , ,

How To: Dynamic Chart Titles in Excel

24 October 2016 in How To
0 comments 2 minutes 715 views

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...

Tags: , , , ,

How To: Send an Email from Excel

22 October 2016 in How To
0 comments 2 minutes 729 views

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...

Tags: , , ,