The way Microsoft is moving with introduction of Office Scripts it does seem like the Redmond giant will not be planning to invest anymore in expanding VBA, however, will leave it as the designated offline scripting language. The challenge there is that while Office Scripts will become more mature we still need to wait a […] The post VBA to Python – 10 Simple Python vs VBA Examples appeared first on Analyst Cave ..read more

For years now Excel lovers have been anticipating what Microsoft’s move will be in terms of scripting within Microsoft Office. Many users till date are creating automations and small office use applications on top of Excel and other MS Office solutions for the better or worse, simply due to the ease with which you can […] The post Office Scripts vs VBA – Microsoft’s take on VBA in 2022 appeared first on Analyst Cave ..read more

Twitter is currently the 7th most popular Social Platform with millions of Tweets being created daily. Often we can hear on the news from Twitter before it gets published to over news sites. It provides a plethora of data that we as analysts can use to understand peoples sentiment as well as create early warning […] The post How to create a Twitter Power BI dashboard (with Azure) appeared first on Analyst Cave ..read more

Fuzzy text matching is very useful when you want to compare a text string against other strings that don’t have to be identical. You still, however, want to find the one that is closest in terms of words. Fuzzy matching is very useful when e.g. you want to compare a user question against a database […] The post Excel VBA Fuzzy Match text against a table appeared first on Analyst Cave ..read more

Excel UDF aka. User Defined Functions are somewhat of an underappreciated feature in Excel in my own opinion. With the recent announcement and release of the Excel LAMBDA function it almost seems like only now are we able to create our own Excel functions – leveraging on a combination of already existing Excel functions. Let […] The post Excel UDF Tutorial – How to write Custom Excel Functions appeared first on Analyst Cave ..read more

Recently the price of Bitcoin has skyrocketed again and many people keep refreshing their phones and browsers to be on top of current price fluctuations. However, why not use Excel – and for that purpose, how to get Bitcoin in Excel using a formula? There is no ready formula in Excel but it turns out […] The post Bitcoin Price in Excel – How to get Bitcoin price in Excel? appeared first on Analyst Cave ..read more

The MEDIANIF / MEDIAN IF formula is not natively available in Excel as opposed to familiar functions in Excel such as AVERAGEIF or SUMIF. The MEDIANIF function should provide us, for a population of numbers, with the middle number that splits the population into 2 halves. Additionally it should allow us to apply a filter […] The post Excel MEDIAN IF – Median with criteria in Excel appeared first on Analyst Cave ..read more

The Excel Lambda Function is a new powerful addition to the Excel suite of functions, that Microsoft announced not long ago. The Lambda function allows you to define a new Excel function with one or multiple parameters. I see it being especially useful in case of string manipulation or definition of new mathematics/statistical functions. What […] The post Excel LAMBA Function – Create your own Excel Functions! appeared first on Analyst Cave ..read more

You will find everything you need to know on the Excel VBA Find function. The Range Find function allows you to find cells within your Excel worksheet (and workbook) that contain a certain text or value. In this post let us explore the many ways in which you can use the Find function. Looking to […] The post Excel VBA Find – Values, Formulas, Comments in Excel appeared first on Analyst Cave ..read more

The VBA Implements statements specifies that the current VBA Class implements a different Class or Interface. Classes and Interfaces are a must for Object Oriented Programming (OOP). If you are not aware of OOP concepts start with my VBA Class Tutorial first. What is an Interface? Before we start with an example I want to […] The post VBA Implements Tutorial – Defining a Class Interface in VBA appeared first on Analyst Cave ..read more