ViewTube

ViewTube
Sign inSign upSubscriptions
Filters

Upload date

Type

Duration

Sort by

Features

Reset

59 results

Essential Excel
Filter Data Dynamically with the Excel FILTER Function | How to Tutorial

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

5:23
Filter Data Dynamically with the Excel FILTER Function | How to Tutorial

820 views

3 years ago

Abiola David - Databricks and Microsoft MVP
Dynamically Append Multiple Data Across Sheets using FILTERXML

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

9:11
Dynamically Append Multiple Data Across Sheets using FILTERXML

886 views

5 years ago

Roel Van de Paar
How does one use LibreOffice FILTERXML function on XML documents with namespaces?

https://amzn.to/4aLHbLD You're literally one click away from a better setup — grab it now! As an Amazon Associate I earn ...

1:52
How does one use LibreOffice FILTERXML function on XML documents with namespaces?

132 views

5 years ago

Abiola David - Databricks and Microsoft MVP
#Excel: Split Text using Multiple Text Functions

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 ...

5:26
#Excel: Split Text using Multiple Text Functions

135 views

6 years ago

Roel Van de Paar
Find and Replace ':' colon gives "That function isn't valid" error on Replace All (2 Solutions!!)

https://amzn.to/4aLHbLD You're literally one click away from a better setup — grab it now! As an Amazon Associate I earn ...

2:16
Find and Replace ':' colon gives "That function isn't valid" error on Replace All (2 Solutions!!)

52 views

5 years ago

Abiola David - Databricks and Microsoft MVP
TEXTSPLIT Custom Function with New LAMBDA Function

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

6:41
TEXTSPLIT Custom Function with New LAMBDA Function

4,195 views

5 years ago

Abiola David - Databricks and Microsoft MVP
SUMBETWEENMONTH with SUMIFS  LET LAMBDA Functions

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

7:26
SUMBETWEENMONTH with SUMIFS LET LAMBDA Functions

1,169 views

5 years ago

Roel Van de Paar
Unix & Linux: filter xml documents matching certains ids

https://amzn.to/4aLHbLD You're literally one click away from a better setup — grab it now! As an Amazon Associate I earn ...

2:34
Unix & Linux: filter xml documents matching certains ids

4 views

5 years ago

Abiola David - Databricks and Microsoft MVP
Brand New TEXTSPLIT, TEXTAFTER & TEXTBEFORE Functions

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

8:04
Brand New TEXTSPLIT, TEXTAFTER & TEXTBEFORE Functions

598 views

4 years ago

Abiola David - Databricks and Microsoft MVP
APPEND Data From Multiple Sheets & Get Total Row using VSTACK & HSTACK

In this Microsoft Excel video, I demo how to stack data from multiple sheets and Get Total Row using HSTACK & VSTACK ...

4:34
APPEND Data From Multiple Sheets & Get Total Row using VSTACK & HSTACK

670 views

4 years ago

Abiola David - Databricks and Microsoft MVP
Multiple SUBSTITUTE Function To Replace Square Bracket with Single Pipe

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

2:51
Multiple SUBSTITUTE Function To Replace Square Bracket with Single Pipe

1,092 views

6 years ago

Abiola David - Databricks and Microsoft MVP
Track Forbes MPP Birthday Status using IFS Function in #Excel

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

8:14
Track Forbes MPP Birthday Status using IFS Function in #Excel

56 views

5 years ago

Abiola David - Databricks and Microsoft MVP
New STOCKHISTORY Function

In this Excel video tutorial, we see how to use the newly released STOCKHISTORY Function to fetch historical stock records.

5:18
New STOCKHISTORY Function

416 views

6 years ago

Roel Van de Paar
How to apply a 'comma separated list' as a filter in Excel?

https://amzn.to/4aLHbLD You're literally one click away from a better setup — grab it now! As an Amazon Associate I earn ...

2:48
How to apply a 'comma separated list' as a filter in Excel?

64 views

5 years ago

Roel Van de Paar
Filter large CSV using MS powershell (2 Solutions!!)

https://amzn.to/4aLHbLD You're literally one click away from a better setup — grab it now! As an Amazon Associate I earn ...

2:02
Filter large CSV using MS powershell (2 Solutions!!)

33 views

4 years ago

Roel Van de Paar
Sorting XML files so that differences can then be found

https://amzn.to/4aLHbLD You're literally one click away from a better setup — grab it now! As an Amazon Associate I earn ...

1:47
Sorting XML files so that differences can then be found

112 views

5 years ago

Roel Van de Paar
Sum values with same name

https://amzn.to/4aLHbLD You're literally one click away from a better setup — grab it now! As an Amazon Associate I earn ...

1:35
Sum values with same name

17 views

5 years ago

Roel Van de Paar
Dynamic Filtering on LibreOffice Base Reports (2 Solutions!!)

https://amzn.to/4aLHbLD You're literally one click away from a better setup — grab it now! As an Amazon Associate I earn ...

1:54
Dynamic Filtering on LibreOffice Base Reports (2 Solutions!!)

137 views

4 years ago

Syed Ashrafuddin
How to use Data validation and Filter in MS Excel

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

5:01
How to use Data validation and Filter in MS Excel

59 views

8 years ago

Roel Van de Paar
XPath Data Scraping From Online Community Using Excel

https://amzn.to/4aLHbLD You're literally one click away from a better setup — grab it now! As an Amazon Associate I earn ...

2:11
XPath Data Scraping From Online Community Using Excel

65 views

5 years ago