How to Remove PageBreaks in Excel with VBA

This post came about as a client of mine introduced a document classification product called Titus that works as an add-on to Microsoft Excel.  The Titus classification add-on caused an unexpected consequence, when you set the security classification of the…
Read more

Add Developer Tab to Excel

Add the Excel Developer tab to Excel 2010 or 2013 to get the most out of Excel.  This tab can be added to the Excel Ribbon in four fast and simple steps, this short Excel guide will show you how……
Read more

Save in Excel

Saving your Excel file is one of those simple exercises often overlooked by an Excel beginner leaving many Excel users knowing very little about the process.  Maybe an XLSB file is a better way for you or perhaps a client…
Read more

Print in Excel

Printing in Excel is easy but something many Excel beginners can struggle with, if you are new to Microsoft Excel and are finding it difficult to print your worksheet, or get your worksheet to fit neatly onto a printed page…
Read more

Calculate Mode in Excel

To calculate the Mode in Excel you need to use the Mode Formula.  This short guide will show you how to calculate Mode in Excel and also help you understand why you should use the Mode… What is the Mode…
Read more

Median Formula in Excel

To calculate the Median in Excel all you need to do is use the Median Formula.  Using the Median formula in Excel is a basic concept that any Excel Analyst can use in their calculations and understand with ease, this…
Read more