Excel Articles

Excel for Managers

Excel: Search and Replace

February 29, 2012

Read about nested formulas to replace characters in a string. Step up your use of advanced Excel!

continue reading

Excel for Managers

Excel: Days in Month

November 4, 2011

A simple trick to calculate those pesky dates!

continue reading

Excel for Managers

Excel – Using the CELL function

August 17, 2011

There are a number of useful options if you type =CELL( into excel.

continue reading

Excel for Managers

Excel: Dynamic Summing To-Date

June 14, 2011

You can set a SUM or AVERAGE formula to dynamically sum only to-date, so that it updates dynamically at period-end.

continue reading