Microsoft Excel Tip: Watch Window

8 March 2017 in Excel Basics, How To
0 comments 2 minutes 1,285 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 848 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,237 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: , , , , , ,

How To: Shade Alternate Rows in Excel

2 January 2017 in Formula, How To
0 comments 2 minutes 726 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 498 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 660 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 702 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 714 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: , , ,