headermask image

Business Tools Blog

category archive listing Category Archives: Microsoft

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, Excel | 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 | Also posted in Excel | 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 | Also posted in Excel | 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 | Also posted in Excel | Comments (0)

Sumif formula automates summing

July 2, 2008 – 12:51 am

How to use the sumif formula

By Sandi Mays | Also posted in Excel | Comments (0)

Align Objects in PowerPoint

July 1, 2008 – 12:00 am

How to align objects in PowerPoint

By Sandi Mays | Also posted in PowerPoint | Comments (0)

Preventing objects from Printing in Excel

June 30, 2008 – 12:19 am

Prevent objects from printing in excel

By Sandi Mays | Also posted in Excel | 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 | Also posted in Excel | Comments (0)

Compress & Reduce the size of a PowerPoint Presentation

June 24, 2008 – 12:22 am

How to compress a PowerPoint Presentation

By Sandi Mays | Also posted in PowerPoint, SnagIt | 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 Excel, Outlook, PowerPoint, Publisher, Word | Comments (0)