headermask image

Business Tools Blog

category archive listing Category Archives: Excel

REPT function to create instant bar chart

July 15, 2008 – 12:13 am

Create an instant bar chart with the REPT function

By Sandi Mays | Also posted in Charts and Graphs | Comments (0)

Calculate the Quarter for any given Date

July 11, 2008 – 12:37 am

How to calculate a quarter from a date in excel

By Sandi Mays | Comments (0)

Hide the field buttons in a Pivot Chart

July 10, 2008 – 12:40 am

Hide Field Buttons in Pivot Charts

By Sandi Mays | Comments (0)

Pivot Tables - the best way to work with data in excel

July 3, 2008 – 12:19 am

How to build a pivot table

By Sandi Mays | Comments (0)

Sumif formula automates summing

July 2, 2008 – 12:51 am

How to use the sumif formula

By Sandi Mays | Comments (0)

Preventing objects from Printing in Excel

June 30, 2008 – 12:19 am

Prevent objects from printing in excel

By Sandi Mays | Comments (0)

Hide a Worksheet, so almost no one can find it

June 25, 2008 – 12:45 am

How to hide worksheets in excel so no-one can unhide them.

By Sandi Mays | Comments (0)

Inexact searches in Excel, Word or PowerPoint

June 23, 2008 – 12:11 am

How to use an inexact search in Excel, PowerPoint or Word

By Sandi Mays | Also posted in Outlook, PowerPoint, Publisher, Word | Comments (0)

Formula Auditing

June 19, 2008 – 12:22 am

How to audit a formula in excel

By Sandi Mays | Comments (0)

Gant Chart in Excel

June 17, 2008 – 12:14 am

Gant Chart in Excel - Step by Step instructions

By Sandi Mays | Also posted in Charts and Graphs | Comments (0)