No VBA Archives - Page 2 of 2 - Excel TV

Category Archives for No VBA

A Dynamic Dashboard for Project Durations and Costs in Excel

Make sure to checkout A Dynamic Dashboard for Project Durations and Costs in Excel (part 2) for the example file! Let’s say you are the manager of a portfolio of projects at your company.  While each project under your aegis is different, they have a few things in common; specifically – and for the sake of our […]

Continue reading

Toward a Proper Excel Filename Style

Most importantly, use your wordsAn ideal Excel filename should be two or three succinct words and contain few numbers. Current operating systems no longer constrain filename character length, so there is neither excuse for nor cleverness in using shorthand. Capitalize each word as you would a document title.     Only abbreviate proper nounsIf your […]

Continue reading
>