AnalystCave Profile Banner
AnalystCave Profile
AnalystCave

@AnalystCave

Followers
1K
Following
37
Media
1K
Statuses
2K

Passionate #Excel, #VBA, #Programming and #Analytics expert. Learn advanced #VBA and #Excel tips and tricks! Creator of the VBA Multithreading Tool

Joined May 2015
Don't wanna be here? Send us removal request.
@AnalystCave
AnalystCave
@AnalystCave
3 years
VBA to Python – 10 Simple Python vs VBA Examples #VBA, #Excel
analystcave.com
Why should you consider moving from VBA to Python. 10 simple examples in VBA and Python to get you started on your Python journey.
0
2
3
@AnalystCave
AnalystCave
@AnalystCave
3 years
Office Scripts vs VBA – Microsoft’s take on VBA in 2022 #VBA #Excel.
1
1
5
@AnalystCave
AnalystCave
@AnalystCave
3 years
Excel VBA Fuzzy Match text against a table #VBA, #Excel
analystcave.com
See how to use VBA create an amazing Fuzzy Matching / Fuzzy Lookup UserForm that can help you to easily match text against a Knowledge Base
0
0
1
@AnalystCave
AnalystCave
@AnalystCave
3 years
How to create a Twitter Power BI dashboard (with Azure) #VBA, #Excel
analystcave.com
Learn how to setup a Power BI to analyze Twitter tweet data. Setup your data capture infrastructure on Azure Databricks using PySpark.
1
1
2
@AnalystCave
AnalystCave
@AnalystCave
4 years
Get Google Maps address coordinates (latitude & longitude) in Excel VBA #VBA, #Excel
analystcave.com
Get any address coordinates in Excel VBA using Google API. Translate your address into latitude and longitude coordinates
0
1
1
@AnalystCave
AnalystCave
@AnalystCave
4 years
Shorter VBA code! #VBA, #Excel
analystcave.com
Learn these tips on how to writer shorter VBA code that is more concise and easier to maintain. Shorter VBA code is easier to read and debug
0
1
2
@AnalystCave
AnalystCave
@AnalystCave
4 years
VBA Substring vs Excel Substring – How to get a Substring in Excel? #VBA, #Excel
analystcave.com
Get substring in Excel or VBA using such functions as Left, Right, Mid, Split and others. Excel Substring vs VBA Substring
0
3
5
@AnalystCave
AnalystCave
@AnalystCave
4 years
Excel VBA Calculate distance between two addresses or coordinates #VBA, #Excel
analystcave.com
Calculate distance between any two addresses or coordinates in Excel VBA using Google Maps API. Calculate Google Maps distance with Excel
0
0
1
@AnalystCave
AnalystCave
@AnalystCave
4 years
AutoFit Excel Rows and Columns #VBA, #Excel
analystcave.com
Excel AutoFit - How to AutoFit Excel rows and columns by resizing them to the contents. Automatically resize Excel rows or columns.
0
0
1
@AnalystCave
AnalystCave
@AnalystCave
4 years
Making proper VBA Comments #VBA, #Excel
analystcave.com
How to make proper VBA Comments. Single and multiple line VBA Comments. Commenting Subs, Function, code blocks and conditional statements
0
0
1
@AnalystCave
AnalystCave
@AnalystCave
4 years
Automatically save Lync conversations (when feature is blocked) #VBA, #Excel
analystcave.com
LyncLogger: A simple application to automatically save Lync conversations as MS Excel logs
0
0
0
@AnalystCave
AnalystCave
@AnalystCave
4 years
VBA VLOOKUP – Using VLOOKUP in VBA #VBA, #Excel
analystcave.com
How to use VLOOKUP in VBA? Using VLOOKUP in VBA. How to lookup values in VBA using the WorksheetFunction Vlookup or the VBA Dictionary
0
0
2
@AnalystCave
AnalystCave
@AnalystCave
4 years
Working with XML files in VBA (VBA XML) #VBA, #Excel
analystcave.com
How to work with XML files in VBA (VBA XML). Learn how to use XPath and how to traverse the XML Dom with the MSXML2.DOMDocument object.
0
0
1
@AnalystCave
AnalystCave
@AnalystCave
4 years
How to unhide sheets in Excel? Unhide all Sheets in Excel VBA #VBA, #Excel
analystcave.com
Learn how to unhide sheets in Excel. Unhide all Sheets in Excel using VBA. How to use xlSheetVisible and xlSheetHidden to show or hide sheets.
0
0
0
@AnalystCave
AnalystCave
@AnalystCave
4 years
Writing files in VBA (txt, xml, csv, binary) #VBA, #Excel
analystcave.com
Write text, csv and binary files to strings using VBA. How to write files VBA in Excel and Access. Write file VBA
0
0
0
@AnalystCave
AnalystCave
@AnalystCave
4 years
Microsoft Excel Shortcut Keys #VBA, #Excel
analystcave.com
Microsoft Excel Shortcut Keys used commonly in Excel. Shortcuts for Workbook, Worksheet, Data, Formatting, Copy Paste Shortcuts and other
0
0
0
@AnalystCave
AnalystCave
@AnalystCave
4 years
Excel VBA Cheat sheet #VBA, #Excel
analystcave.com
VBA Cheat Sheet. VBA syntax, variables, loops, conditions, Classes, Types, Enumerations etc. The best VBA cheat sheet out there!
0
0
0
@AnalystCave
AnalystCave
@AnalystCave
4 years
Excel Pivot Table Tabular layout #VBA, #Excel
analystcave.com
Excel Pivot Table tabular layout. A few simple steps to present your Pivot Table in a pure tabular layout
0
0
0
@AnalystCave
AnalystCave
@AnalystCave
4 years
Personal budget calculation in Excel #VBA, #Excel
analystcave.com
Personal budget calculation. Calculate your monthly budget in an Excel sheet
0
0
1
@AnalystCave
AnalystCave
@AnalystCave
4 years
The VBA Array tutorial #VBA, #Excel
analystcave.com
VBA Array Tutorial - creating, erasing, redefining. One and two-dimensional Excel VBA array, Working with VBA Tables (arrays).
0
2
3