By Neil Shorney, 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 23 December 2013
Monday 9 December 2013
Using the SUMPRODUCT function to sum multiple criteria / advanced cell references
By Neil Shorney, 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
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
Subscribe to:
Posts (Atom)