Dsum queries your Excel data and provides answers based on the criteria that you provide to the dsum function. More to the point in order to use dsum you have to decide to layout your spreadsheet using best practice spreadsheet design principles. Get the spreadsheet used in the tutorial above. Also get updates when new blog or video tutorials are … [Read more...] about what does excel dsum do

This article and associated youtube video will explain what vlookup does and the best way to organise your spreadsheet data to the get most out of vlookup and how to use it to join two datasets together. Vlookup allows you to get extra information from another data range by using a unique identifer that populates the first column of the data range that your are looking … [Read more...] about what does vlookup do