Wise Owl Training - Excel blogs (page 4 of 4)

Showing blogs 61-62 (out of 62)

Using Range Names in Excel

Posted by Andrew Gould on 22 August 2011

Did you know that you don't have to use cell references in calculations in Microsoft Excel? You can use range names to create sensible, plain English names to refer to your cells and use those in your formulae instead. Read this blog to find out how.

Tags:   Excel | Formulae

Adding data labels to a chart using VBA

Posted by Andrew Gould on 08 June 2011

Adding basic data labels to a chart can be done without using any programming code. This blog, however, shows you how to fine-tune Excel chart labels using VBA (Visual Basic for Applications) macros.

Tags:   Excel | Charts    |    Writing VBA | Other    |    VBA macros | Working with charts
This page has 0 threads Add post