What Does DSum Do In Excel? 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. … [Read more...] about what does excel dsum do

What Does Vlookup Do In Excel? 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 … [Read more...] about what does vlookup do