Monthly Archives: October 2017

There are two main types of table in Excel: the formal and the informal. Formal tables are part of the Excel “toolkit”. To add one, go to the Insert tab, and Table can be found in the Tables group. Both … Continue reading →

Ranges, which can be single cells or multiple cells can be named. They can make the logic of the spreadsheet easier to understand. This is useful for the initial design and for subsequent development. Named ranges are more robust, because … Continue reading →