In this tutorial you'll see how to import a text file that's got 1.5 million rows of data, that's roughly 500K more rows than Excel can handle. Get the spreadsheet and data file. Also get updates when new blog or video tutorials are released. Submitting... … [Read more...] about How To Use Power Query In Excel To Import Large Files
Excel
What Does Excel Sumif and Sumifs Do?
Excel's Sumif and Sumifs allows you to query your tabular data for numerical answers to your questions like what was our sales or costs for January last year?Or in the case of this example here what was the total volume traded on the NYSE for ticker "abev"? The YouTube video above takes you through a practical example of sumif and sumifs using the tabular … [Read more...] about What Does Excel Sumif and Sumifs Do?
what does excel dsum do
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
what does vlookup 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
Code Execution Has Been Interrupted – The best fix to this Excel VBA Problem
I first came across this Microsoft Excel vba error back in 2009, when the vba dialog box interrupted macro processing with the message "Code Execution Has Been Interrupted" and it quite literally did my head in.It's a weird error because it doesn't have an error number and in fact it isn't really an error but rather a bug for which a lot of misinformation existed on … [Read more...] about Code Execution Has Been Interrupted – The best fix to this Excel VBA Problem