287
1 782 166

9:13

Google Sheets Wildcard Query Hacks

6:31

Excel Filter Function - Filter as You Type

6:51

Excel Filter as You Type

8:22

Google Apps Script Group Dates by Month & Year

16:36

Excel VBA Calculate Remaining Months and Days Between Two Dates

10:27

Excel Filter Controlled by Checkboxes

This video looks at the new in cell checkbox feature in the Excel 365 insiders version. More specifically it covers how to link checkboxes to the filter function to create a filter controlled by checkboxes. In addition, the lesson shows how to link a dropdown list to the filter function to sort the columns automatically.
If you have Office 365 and want to get the BETA Version check out the link below for instructions:
insider.microsoft365.com/en-us/join/windows
Learn more about Excel Functions & Features with this book at Amazon:
amzn.to/3xtLmXp
Get a Microsoft Office 365 Personal Subscription with this Amazon link:
amzn.to/3aV9GtL
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.
#ExcelFilterFunctionWithCheckboxCriteria
#ExcelFilterFunctionControlledByCheckboxes
#ExcelFilterFormulaWithCheckboxCriteria

Відео

9:13

Excel VBA Wildcard Filter Search

Переглядів 3354 місяці тому

This video illustrates how to perform a wildcard filter in Excel VBA. In addition this filter is driven by a wildcard search type dropdown list that contains the following types of searches: Begins With Ends With Contains Learn More about Excel VBA & Macros with this Book on Amazon: amzn.to/3xnqT6R Get a Microsoft Office 365 Personal Subscription with this Amazon link: amzn.to/3aV9GtL DISCLAIME...

6:31

Google Sheets Wildcard Query Hacks

Переглядів 2874 місяці тому

This video covers creating wildcard queries in Google Sheets. The lesson includes Google Sheet Queries that "contains" certain words as well as "begins with", "ends with", and pattern matches. Learn more about Google Sheets Functions with this Book at Amazon. amzn.to/3HkHcGa Buy the complete Google Workspace User Guide at Amazon: amzn.to/3Hr9dLW DISCLAIMER: As an Amazon Affiliate I get a commis...

Excel Filter Function - Filter as You Type

6:51

Excel Filter Function - Filter as You Type

Переглядів 2644 місяці тому

This video looks at using the Filter Function in Excel to create Filtered results that update as you type in a Search Criteria Cell. In other words the results of the filter change as you continously type. If you don't have the filter function in your Excel Version click the link below to create the equivalent effect: ua-cam.com/video/p9-ffETedgo/v-deo.html Learn more about Excel Functions & Fe...

8:22

Excel Filter as You Type

Переглядів 1434 місяці тому

This video covers how to create a dynamic filter that updates results as you type in a search box. In other words it filters as you type. This can be utilized by all excel users but if you have a newer version of excel, I've made another video where you can achieve this using the Filter Function. The link to that video is below: ua-cam.com/video/_kiToxyKZY8/v-deo.html Learn more about Excel Fun...

Google Apps Script Group Dates by Month & Year

16:36

Google Apps Script Group Dates by Month & Year

Переглядів 1564 місяці тому

This video looks at how to convert full dates to month and year in Google Apps Script. The lesson also includes how to group dates by month and year and subtotal a corresponding amount column. Learn more about Google Apps Script with this Beginner's Guide Book at Amazon. amzn.to/3MMvDZs DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via this link below #GoogleAppsScrip...

Excel VBA Calculate Remaining Months and Days Between Two Dates

10:27

Excel VBA Calculate Remaining Months and Days Between Two Dates

Переглядів 2584 місяці тому

This video covers how to Calculate the difference in Months and Days between two dates in Excel VBA. Returning the Date Difference in Months and Days with VBA can be acheived using the DATEDIFF and DATEADD Functions together in your code. #ExcelVBADateDiff #ExcelVBAReturnRemainingMonthsAndDays #ExcelVBAFunctions Learn More about Excel VBA & Macros with this Book on Amazon: amzn.to/3xnqT6R Get a...

Google Sheets Query With Sequence Numbers

7:26

Google Sheets Query With Sequence Numbers

Переглядів 3665 місяців тому

This video looks at an easy solution for creating a Query in Google Sheets that includes a sequence number column in the output. I had previously posted a video on this topic, but have found an better way in this new method. This way allows you to easily add serial numbers to a Google Sheets Query output. Learn more about Google Sheets Functions with this Book at Amazon. amzn.to/3HkHcGa Buy the...

8:15

Excel Link Formulas and Chart to Slicer

Переглядів 3005 місяців тому

This video covers how to link an Excel Slicer to both formulas and charts to produce a dynamic output. In other words, we can create a mini-dashboard driven by buttons on a slicer selection menu. The result is a slicer controlled chart and a slicer controlled formula. #excelslicers #excellinkslicertoformulas #excelslicerdrivenchart

6:12

Google Sheets Non Adjacent Lookups

Переглядів 1495 місяців тому

This video looks at creating a Non-Adjcent Lookup Formula that is still Dynamic. In other words, creating a Lookup when the Lookup Columns are not parallel to the results columns. This lesson shows how this can be done without having to change the original dataset. Learn more about Google Sheets Functions with this Book at Amazon. amzn.to/3HkHcGa Buy the complete Google Workspace User Guide at ...

Excel VBA Change Event Copy Row to Another Sheet

9:50

Excel VBA Change Event Copy Row to Another Sheet

Переглядів 6349 місяців тому

This video looks at how to execute a Change Event in Excel VBA that copies a row of data to a certain sheet when a change in made in a certain column of that row. In this example the "Trigger/Change" Cell is a dropdown list containing other sheet names that determines which sheet the row gets copied to. Learn More about Excel VBA & Macros by purchasing this Book on Amazon: amzn.to/3xnqT6R Purch...

7:39

Excel Named Ranges in Formulas

Переглядів 3479 місяців тому

This video looks at how to create Named Ranges and then use them inside Excel Formulas. The lesson begins with how to add Named Ranges. The second part of the video shows how to reference the Named Ranges within different formulas/functions. Learn more about Excel Functions & Features with this book at Amazon: amzn.to/3xtLmXp Get a Microsoft Office 365 Personal Subscription with this Amazon lin...

Google Apps Script Create Inventory Tracking System

27:57

Google Apps Script Create Inventory Tracking System

Переглядів 1 тис.9 місяців тому

This video looks at how to create an Inventory Tracking System in Google Sheets using Google Apps Script. The template created in this lesson can add new Inventory purchases to an existing dataset as well as update existing records. It can make calculations to track how much inventory has been used versus how much is left based on a lookup value. Learn more about Google Apps Script with this Be...

Excel Python Group Dates by Month and Year

7:57

Excel Python Group Dates by Month and Year

Переглядів 18210 місяців тому

This video looks at how to use Python in Excel to Group a Full Date Field by just Month and Year. The end of the video covers how to Sort the Month/Year Field by just the Year. Python is currently only available to Office 365 users who have the BETA version. If you have Office 365 and want to get the BETA Version check out the link below for instructions: insider.microsoft365.com/en-us/join/win...

4:37

Excel Filter Function Not In List

Переглядів 1,3 тис.10 місяців тому

This video covers setting up a Filter Function in Excel that returns all records "not" found in a list of values. This is achieved by incorporating the IsNumber and Match Functions into the Filter. The end of the video also shows how to change the output to include anything that "is" in the list. Purchase a Microsoft Office 365 Personal Subscription with this Amazon link: amzn.to/3aV9GtL DISCLA...