Added to Library on 05 Jan 2008
Length: 9 mins
View Tutorial Movie
Download File Used |
This tutorial Shows you how to take the Excel DSUM function and use it to construct a very powerfully query spreadsheet with multiple creteria.
After explaining the basics of how this function works the tutorial goes on to show how you can build an entire Profit and Loss spreadsheet using just this function in Excel!
This is one of the most powerful tutorials in the library to date. The download contains the spreadsheet at the start and end of the tutorial to ensure you can repeat what is shown here.
|
|
Related Tutorials:
Cell Referencing
Extracting Data from Lists - Part I
|
Feedback for this tutorial:
"Hi Clayton... You need to add another line after Excellent - Brilliant!!... Holy Cow... I haven't removed my jaw off the floor yet!!... I need to practise this a couple of times... then I am going to see how I can apply it to the spreadsheet I have for tracking stats for the Library I support... Cheers, Kelly..."
"As usual . .AWESOME!!!"
|
|
