288
1 821 782

9:19

Excel VBA Wildcard Filter Search

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 Insert Rows from Input Box

This video illustrates how to insert a certain number of rows in Excel VBA based on an input box. The lesson also covers how to set the code up to dynamically insert rows based on the active row in Excel vba.
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
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.
#ExcelVBAInsertRows
#ExcelVBAInsertRowsBasedOnActiveRow
#excelVBAInsertCertainNumberOfRowsBasedOnInputBox

zhlédnutí: 59

Video

9:19

Excel Filter Controlled by Checkboxes

zhlédnutí 425Před 21 dnem

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

9:13

Excel VBA Wildcard Filter Search

zhlédnutí 362Před 4 měsíci

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

zhlédnutí 306Před 4 měsíci

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

zhlédnutí 280Před 5 měsíci

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: czcams.com/video/p9-ffETedgo/video.html Learn more about Excel Functions & Fe...

8:22

Excel Filter as You Type

zhlédnutí 153Před 5 měsíci

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: czcams.com/video/_kiToxyKZY8/video.html Learn more about Excel Fun...

Google Apps Script Group Dates by Month & Year

16:36

Google Apps Script Group Dates by Month & Year

zhlédnutí 169Před 5 měsíci

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

zhlédnutí 291Před 5 měsíci

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

zhlédnutí 383Před 5 měsíci

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

zhlédnutí 313Před 6 měsíci

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

zhlédnutí 151Před 6 měsíci

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

zhlédnutí 702Před 9 měsíci

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

zhlédnutí 384Před 9 měsíci

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

zhlédnutí 1,1KPřed 10 měsíci

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

zhlédnutí 193Před 10 měsíci

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