Named Ranges in Excel 2010

Learn how to create a descriptive name to refer to a range of cells on an Excel worksheet with this guide for Excel 2010 users… What is a Named Range? A Named Range is a text label that refers to…
Read more

How to use Hyperlinks in Excel 2010

Hyperlinks are a useful concept to understand in Excel, they are particularly helpful in large reporting suites or when creating winning Excel dashboards as they can be used as an effective navigational tool.  This guide will show you how to…
Read more

Convert text case in Excel 2010

If you have ever been faced with text fields that contain poor formatting or capitalisation then you will find this guide on how to convert text fields to different cases a useful read… Convert text case with Excel 2010 Data…
Read more