by admin | Oct 10, 2012 | Excel | Advanced Lessons, Excel | Useful tricks
As part of the Excel Hero Academy that I’ m now doing, one of the first things we did was learn more about named ranges. Daniel Ferry showed us a really useful trick that allows you to view your ranges (with their names on their sheet). The trick is to reduced...
by admin | Sep 19, 2012 | Excel | Advanced Lessons
So first of all what does this mean and why would you bother? Let me give you two examples =sum(a1:a10) or =sum(salaries) Which do you think looks easier to read and understand? Yes, the second one. So a very useful way to help document and clarify your spreadsheet is...
by admin | Jun 5, 2012 | Excel | Advanced Lessons, Excel | Conditional Formatting
Conditional formatting Conditional formatting in Excel 2007 (and later) allows us to colour cells on a spreadsheet depending on whether or not they meet certain conditions. While it existed to some degree in Excel 2003, it has been seriously beefed up in Excel 2007...