You Are Browsing ‘Microsoft Office’ Category

Making a Simple Excel Macro

One of the first macros people make when learning about macros is simply one that changes the colours of cells or text in a cell. What follows is macro tutorial for Excel 2007 or Excel 2010 or even earlier that does something a little more useful using the RandBetween function. If some of the wording is too complex, let me know and I’ll post a simpler example. When you are trying to generate random numbers,...

Free Spreadsheet Templates

While it can be easy to find free spreadsheet templates, it is not easy to find GOOD spreadsheet templates . I’m sure you’ll agree with me after spending a bit of time poking around the web. However the people at Vertex42 have years of experience building the largest collection of spreadsheet templates on the web. If you are looking for templates for Excel, Google Spreadsheets or OpenOffice, Vertex42...