Blogs from Wise Owl on Formulae in Excel

Showing blogs 1-4 (out of 4)

The new functions in Excel 2016, including IFS, SWITCH and TEXTJOIN

Posted by Andy Brown on 18 February 2017

Excel 2016 has a few interesting new functions! TEXTJOIN allows you to concatenate all the cells in a range, and IFS and SWITCH provide other ways to make choices.

Tags:   Excel | Formulae

How to refer to range names with worksheet and workbook scope

Posted by Andy Brown on 01 November 2013

Range names can have either worksheet or workbook scope - this blog shows how to make sure that you're referring to the right range names!

Tags:   Excel | Formulae

10 Excel Quick Tips

Posted by Andrew Gould on 02 December 2011

Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!

Tags:   Excel | Formulae    |    Excel | Excel functions    |    Excel | Charts

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
This page has 0 threads Add post