Monday 23 December 2013

Making a line break within a cell

By , Director, Naturally Sales Ltd.


Have you ever wondered how to add a line break within a cell? That is, how to make a paragraph, rather than just one long line of text? You’ve tried pressing <Enter> but it always moves you down to the cell below? Well, today is your lucky day!

To create a line break within a cell, use <CTRL> and <ENTER>, and you can create paragraphs to your heart’s content!

Monday 9 December 2013

Using the SUMPRODUCT function to sum multiple criteria / advanced cell references

By , Director, Naturally Sales Ltd.

We guide you through creating a two-dimensional table to display information from large data sets.

In the first part, we’ll familiarize ourselves with a useful advanced lookup formula: SUMPRODUCT, then we’ll learn how we can save time populating tables by using a combination of absolute and relative references.

These are best looked at in an example, so you’ll find details in a file which you can download just here.  


www.nsales.co.uk/excel-examples/Populating-a-table-with-absolute-and-relative-references-using-SUMPRODUCT.xlsx