Recent Posts

The ROMAN function converts Arabic numerals into Roman numerals in a text format. It can return the classic Roman numeral style or more...

Often times you'll want to create copies of existing worksheets to tweak or use as a template elsewhere in your workbook. There are a few...

Changing text color can highlight specific areas on your worksheet that may otherwise go unnoticed. Specific problems, important...

The Format Painter tool will help you quickly copy the formatting from anywhere in your workbook, saving you the time and hassle of...

Sometimes it is necessary to remove duplicate items from a column or duplicate rows out of an entire table. Removing duplicates will help...

Often times when scrolling through data in Excel, you want to keep the top few rows visible so you can easily see the column headers...

Often, you won't want every worksheet in your workbook to be able to easily be viewed by everyone. Hiding and unhiding sheets will let you p

When working in Excel, it can sometimes be difficult to get an overview of an entire worksheet, especially if you're working on a smaller...

If you're working on an older or alternate SQL server, the IIF function may not be supported, instead you'll want to use a CASE...

When working in a workbook with a lot of different tabs, being able to pull, reference, and use specific sheet names can save you a lot...

Paste special allows you to copy any cell or range of cells, and paste specific characteristics from those cells, it is also one of the...

The IMTAN function is used to return the tangent of a complex number input in a "x + yi" or "x + yj" format. Contents: Syntax What is a...

The IMSINH function is used to return the hyperbolic sine of a complex number input in a "x + yi" or "x + yj" format. Contents: Syntax...

The IMSIN function is used to return the sine of a complex number input in a "x + yi" or "x + yj" format. Contents: Syntax What is a...

The IMSECH function is used to return the hyperbolic secant of a complex number input in a "x + yi" or "x + yj" format. Contents: Syntax...