ViewTube

In this Excel video, I demonstrate how to use the rarely known FILTERXML Function to Append Multiple Data Across Sheets.

How does one use LibreOffice FILTERXML function on XML documents with namespaces? Helpful? Please support me on ...

linktr.ee/benthompsonuk Welcome to our Excel tutorial on how to use the powerful Filter function to easily filter data by job title!

You can watch the part one of how to split text using the Excel FILTERXML function in the link below. Do remember to subscribe to ...

In this special video, I demonstrate how to use the new game changer - LAMBDA Function in Excel to create a custom function ...

Demostración del uso de la función XMLFILTRO en Microsoft Excel para extraer datos de una celda en la que se ha pegado un ...

In this Microsoft Excel video, I demo how to use the newly released TEXTSPLIT, TEXTAFTER and TEXTBEFORE functions ...

Esta función permite recibir datos de orígenes web en las celdas de Microsoft Excel.

Excel unusual sequence formula Helpful? Please support me on Patreon: https://www.patreon.com/roelvandepaar With thanks ...

Dynamic Filtering on LibreOffice Base Reports Helpful? Please support me on Patreon: https://www.patreon.com/roelvandepaar ...

In this short Excel video, I demonstrate how to replace square bracket with single pipe using multiple SUBSTITUTE Function.

In this interesting second video, we looked at how to create SUMBETWEEN Custom Function using combination of SUMIFS, LET ...

In this Excel video tutorial, we learn how to track Forbes Most Powerful Person Birthday Status for 2021 using the new IFS ...

How to apply a 'comma separated list' as a filter in Excel? Helpful? Please support me on Patreon: ...

Unix & Linux: filter xml documents matching certains ids Helpful? Please support me on Patreon: ...

Filter large CSV using MS powershell Helpful? Please support me on Patreon: https://www.patreon.com/roelvandepaar With ...

You may use the Concatenate function to type usernames (aliases) in an Excel spreadsheet.

Find and Replace ':' colon gives "That function isn't valid" error on Replace All Helpful? Please support me on Patreon: ...

In this video you will learn how to use operators in formulas.

Sorting XML files so that differences can then be found Helpful? Please support me on Patreon: ...

Do you work with, analyze and generate reports from large datasets in Excel? Do you need to create pivot tables from multiple ...

Extract numbers after a specific word in a cell Helpful? Please support me on Patreon: https://www.patreon.com/roelvandepaar ...

XPath Data Scraping From Online Community Using Excel Helpful? Please support me on Patreon: ...

In this video we will know how to use Data validation and Filter in MS Excel -~-~~-~~~-~~-~- Please watch: "how to increase views ...

LibreOffice is known as a Swiss Army knife of file formats. This is mainly du to the impressive number of import filters integrated ...