Most Recent YouTube Video

LibreOffice Calc Advanced Filter Using Regular Expressions Tutorial

Slice and Dice Calc Data using the Advanced Filter

This article shows you how to harness the power of the LibreOffice Calc Advanced Filter and get you started using regular expressions.

With these techniques you’ll be able to create reports with the information that you want with very little effort.

Complete LibreOffice Calc Advanced Filter With Regular Expressions Article here.

LibreOffice Base Database Tutorial – No Code

Create and populate database from scratch, just with SQL

Build a LibreOffice base database to manage courses and students for a fictional training academy.

Complete Database Article here.

How To Use The Excel VBA MsgBox

Complete Tutorial Covering All Aspects Of The VBA MsgBox

How to program it to show simple messages and customise it to alter program flow based on different buttons pressed by Excel VBA Applicaiton User

Complete Excel VBA MsgBox article here.

Practical Case Study Using Free LibreOffice Base Database

Split Database, Import And Crunch and Export Text File

In this case study, I create a split LibreOffice base database (faster and more robust than standard database), save a spreadsheet as text file in both Excel and LibreOffice CaLc (free LibreOffice spreadsheet), so that it can be easily imported to the database.

Crunch the data using some sql statements Full article here

Practical Case Study Advanced Filter And VBA

Analysis of rainfall data using VBA and the Advanced Filter

In this case study, I take you step by step through a workflow where VBA controls the Advanced Filter to process 1047,916 rows of data (288 rows per day) down to 365 data rows, being one data row for each day (the latest recorded capture on each day).

The first 3 minutes or so of the video explain how we’re going to Crunch the data and the rest of the video goes over the coding of the solution.

Excel Database Power Without Using a Database

Advanced Filter and VBA to Power Excel Form and SubForm Relationship

How to use the Advanced Filter with VBA to get database like functionality in Excel.

It covers very basic database concepts (if you understand vlookup, you should be fine) combined with vba to make Excel tabs behave like Database tables.

Useful if you don’t have Microsoft Access and you need to get your boss to pay for it, by showing what a cool app can do.

Split Out List Data To Separate Worbooks

In this video I show you how to use vba and the Excel Advanced Filter to segment your excel list based on a particular column.

In this instance the Excel Advanced Filter has been used to break out customer order data based on the city column.

In this tutorial you get to see me code in real time, mistakes and all, and see my approach to coding.

Click video and press f for full screen or watch on YouTube

Excel VBA Advanced Filter Walk Through

Here I give you an example of what you can get done with the Excel VBA Advanced Filter.

The Advanced Filter in Excel gives you fast database style functionality in a spreadsheet, getting to grips with this is an essential step towards building robust and maintainable Excel VBA data driven applications.

In this tutorial you get to see examples of an advanced Filter app and I then take you step by step through building the app showcased here.

Click video and press f for full screen or watch on YouTube

LibreOffice Database Case Study

In this video I walk you through a real life example of a LibreOffice database that’s in "version 1" status.

The purpose of this database is to monitor and imporve all aspects of content published on BusinessProgrammer and YouTube.

It showcases some of the functionality available to you in LibreOffice base, such as forms made to look better by macro code that adjusts their appearance.

"Switchboard" forms calling other forms and Google style queries (results change as you type) implemented via LibreOffice base macros and SQL.

Click video and press f for full screen or watch on YouTube