![The Excel Cave](/img/default-banner.jpg)
- 288
- 1 821 782
The Excel Cave
United States
Registrace 7. 08. 2019
Excel Functions, VBA, & Google Sheets Videos are included in this channel.
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
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
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...
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...
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
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...
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
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
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
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...
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
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
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...
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
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
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...
Google Sheets Query on Range List Criteria
zhlédnutí 1,2KPřed 10 měsíci
Google Sheets Query on Range List Criteria
Excel Python Query by Date Range (Updated)
zhlédnutí 149Před 11 měsíci
Excel Python Query by Date Range (Updated)
Google Apps Script Overwrite Existing Sheet
zhlédnutí 523Před rokem
Google Apps Script Overwrite Existing Sheet
Excel VBA Create Inventory Tracking System
zhlédnutí 537Před rokem
Excel VBA Create Inventory Tracking System