How To Create A LibreOffice Base Split Database
How To Create a LibreOffice Or OpenOffice Base Split Database In this tutorial I’m going to create a LibreOffice split database and import some csv text files that have...
- Posted April 14, 2017
what is the difference between excel sumif and sumifs
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...
- Posted April 6, 2017
excel vba how to find last row with data
How To Find The Last Row In an Excel VBA Range You are adding data on a consistent basis to your spreadsheet, and you need to have a macro...
- Posted March 22, 2017
what does excel dsum do
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...
- Posted March 15, 2017
what does vlookup 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...
- Posted March 7, 2017
How To Resize A Range In Excel VBA
How To Resize A Named Range In Excel VBA To resize a named range in Excel VBA it’s best to get an object reference to the range and then...
- Posted February 6, 2017