• 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
    • 0
  • 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
    • 0
  • 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
    • 2
  • 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
    • 0
  • 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
    • 0
  • 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
    • 0