headermask image

Business Tools Blog

category archive listing Category Archives: Excel

Use the selection arrow to select multiple objects in Excel

August 29, 2008 – 12:11 am

Easily select multiple objects in Excel

By Sandi Mays | Comments (0)

Format a bar chart with negative values

August 28, 2008 – 12:48 am

How to show x axis labels at the bottom of the chart, when values are negative.

By Sandi Mays | Also posted in Charts & Graphs, PowerPoint | Comments (2)

Forecast Recurring Revenue with Weighted Average Install Interval

August 19, 2008 – 12:53 am

How to calculate weighted average days to install, and use that metric in revenue forecasting.

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

Link Excel Chart Titles, How to

August 18, 2008 – 6:33 am

Link Microsoft Excel chart titles to any cell.

By Sandi Mays | Comments (0)

Waterfall Charts - free utility

August 10, 2008 – 12:57 am

Free Waterfall Utility from Jon Peltier

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

Excel 2007, Add Patterns to Charts with this Addin

August 8, 2008 – 2:11 pm

Add Patterns to Charts with this Free 2007 Excel Addin

By Sandi Mays | Comments (0)

Creating a Custom Toolbar in Microsoft Excel

August 7, 2008 – 12:41 am

Customize a toolbar in excel

By Sandi Mays | Comments (0)

Excel - view 2 or more worksheets at the same time

August 6, 2008 – 12:50 am

How to view multiple worksheets in Microsoft Excel

By Sandi Mays | Comments (0)

Waterfall Charts, how to create

August 5, 2008 – 12:28 am

How to build a waterfall chart in Microsoft Excel

By Sandi Mays | Comments (1)

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 & Graphs | Comments (0)