by Paul Kelly | | Excel Specific, Vault Video
Webinar Number: W0039 This webinar features: * Live Coding – The only Excel VBA Webinar where code is written in real time. * How to Create an Excel Table using VBA – learn once, know forever! * How to automatically filter a table using the Worksheet...
by Paul Kelly | | Excel Specific, Most Popular, Vault Video
Webinar Number: W0030 Everybody has heard of Pareto’s 80/20 rule. 80% of your work comes from 20% of your efforts. In Excel VBA, 80 to 90% of your work will involve using Cells and Ranges. If you can master using this area of VBA then everything else you do will...
by Paul Kelly | | Excel Specific, Vault Video
Webinar Number: W0021 This webinar covers using VBA to create and use a Pivot Table. It includes Live VBA Coding How to Create a Pivot Table using VBA Grouping By days, months and years How to add slicers How to add columns and rows How to add values and filters Plus...
by Paul Kelly | | Excel Specific, Vault Video
Webinar Number: W0019 In this webinar, I cover using VBA to send emails. It features: Sending a basic email Adding an attaching Creating a specialized email Class Module Early vs Late Binding Embedding a range in an email Plus Q&A as well as tons of tips and...
by Paul Kelly | | Excel Specific, Vault Video
“It is a capital mistake to theorize before one has data” – Sir Arthur Conan Doyle. Webinar Number: W0003 This webinar is based on this Cells and Ranges article. Related Links Cells and Ranges The Ultimate VBA Tutorial Part One Find command with WildCard...
by Paul Kelly | Jun 3, 2016 | Excel Specific
“Constant effort and frequent mistakes are the stepping stones to genius” – Elbert Hubbard A Quick Guide to the VBA VLookup ParametersType Lookup valueThe value you are searching for Table array The range you are searching through Column indexThe column...
