The following article will demonstrate how to build out a useful LibreOffice database without using any programming code. We're going to build a simple application to manage training courses and students for these courses. Get the database, files and sql used in the tutorial video above. Also get updates when new blog or video tutorials are … [Read more...] about Simple LibreOffice Database Without Code
Data Management
How To Use Power Query In Excel To Import Large Files
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
How To Fill Empty Cells In Excel With Values Above
You have a spreadsheet with information missing because it was summarised for viewing as a report, but this format is no good for data analysis. You know you want to fill the empty cells with values, but how do you do it quickly? Perhaps you copied data from a report somewhere, and some columns were summarised with blank spaces sorta like the spreadsheet below. As you … [Read more...] about How To Fill Empty Cells In Excel With Values Above
Excel Advanced Filter – Criteria to Show Blank Cells
Today I had a problem in Excel that crops up quite often, namely how to filter to find blank cells or how to filter to exclude blank cells. … [Read more...] about Excel Advanced Filter – Criteria to Show Blank Cells