All the other languages, that are not VBA, Python or C#.
Sometimes, but only sometimes we are having text in a markdown that looks like this: And instead of going and opening each one separately, we can do the following in a Chrome browser: F12 Open the console for writing Write …
How to open all hidden text (triangles) in markdown? Read more »
Python can be used for various tasks. One of these is Monte Carlo simulation for future stock analysis. In the video below this is exactly what is happening. 🙂 Instead of explaining the video and its code (available also in …
Data wrangling with Excel and Pandas is actually quite useful tool in the belt of any Excel professional, financial professional, data analyst or a developer. Really, everyonecan benefit from the well defined libraries that ease people’s lifes. These are the …
Welcome to the world of sine and cosine! These two functions are the backbone of trigonometry, and they’re much simpler than they seem. In this article, we will explore the unit circle, the home of sine and cosine, and learn …
Sine and Cosine – A friendly guide to the unit circle Read more »
Ever heard of the Rule of 72? It’s a classic finance shortcut that tells you how many years it takes for an investment to double at a given interest rate—without reaching for a calculator! Pretty much, if you want to …
Automated stock diagrams with Python is actually a rather useful idea, if you want to see how your portfolio is distributed. Just by using 2 columnes – “Ticker” and “Shares” in a CSV file, you can obtain a lot of …
The field of geometry offers tools that have withstood the test of time, empowering us to understand and solve a variety of triangular problems. Among these, the Pythagorean Theorem and the Law of Cosines are cornerstone concepts. This article provides …
If you remember some advanced math problems with triangles, where you have some cevians and medians, that split a triangle’s side into a 4:3 ration and you have to find the ratio of the split of the two cevian itself, …
Solving Triangle Medians and Cevians with Python Read more »
Have you ever had a feeling you need to solve an inequality like this one ((x+6)^3)/(7-x)^5>0 and you did not know how to start? In the video at the bottom of the page I am showing the few steps needed, …
Getting a list of all folders within a given folder is actually a single line command. Writing it to Excel is usually another line. Getting all files, within these folders is not a lot as well. However, having a tool …
Python – Getting an Excel List of all Folders and Files in them Read more »
Plotting 2d and 3d vectors into a 3d space can be actually fun. Using mainly the code from Math for Programmers, I am presenting in this video an example of plotting 2d into 3d and back, using identity matrix and …
Linear Algebra – Drawing with Vectors – 3d and 2d Read more »
Creamer’s rule for a solution of linear equations states pretty much the following: Using this interesting picture from the German Wikipedia, I have created the following video, explaining a bit the Rule of Mr. Cramer: The video goes through the …
Python – Cramer’s Rule for Linear Equations – With YouTube Video Read more »
Ok, so the golang language does not exactly have the word “while” in it. Anyway, the do-while and while-do loops can be easily implemented with a for loop. The main difference between the do-while and while-do is that in the …
The idea here would be to show some git log tricks and to develop the article, whenever I find something more and more worthy. Before starting this one, please remember that exiting vim editors in the command prompt is with …
Getting N-th string between two substrings might sound a bad idea, until you do not need it. And with VBA, you better have something prepared. So, imagine the following XML (from this article here): <FootballInfo> <row> <ID>1</ID> <FirstName>Peter</FirstName> <LastName>The Keeper</LastName> …
VBA – Get Substring Between 2 Substrings – Locate value of Nth XML Read more »
This is a short step-by-step introduction on how to build virtual environment in Python and how to use it. Virtual envirnments keep dependencies, required by the specific project separated. Thus, it is the “clean and clear” place of the project, …
They say practice makes perfect and in order to improve my data visualization skills I recently took up a weekly challenge. There are multiple ones depending on your interest and tool of choice, most of them advertised on Twitter. Whether …
=VLOOKUP and =INDEX(MATCH(),MATCH()) are well known formulas, if you need to get some value corresponding to another value from a specific column. The problem comes, when you are having more than one column or row, and you need to locate the …
Excel – Get Top Row of a Multi Row / Mult Column Range Read more »
Formatting a substring of a string in an Excel Cell is actually quite a challenging task. There are two ways to do it – select part of the substring that you wish to format and change its color. Then make …
Some time ago I have decided to go a little deeper into SQL. And by some time ago I probably mean some years. Anyhow, in this article I will present the ways I know to make XML out of SQL …
In this article I will simply let you know, that vitoshacademy.com has its own google extension now – it simply shows you the last 10 articles in the site and it lets you know if there is a new one. …
Google Chrome Extension – Building a simple extension for VitoshAcademy.Com Read more »
Plenty of Regular Expressions tools are available in the net. Most of them are free and quite quick. I have actually never thought that building such a tool can be done rather quickly, as far as the RegEx is part …
Working with JS may be difficult for a beginner. Or for someone like me, who dares to think of himself as a … let’s call it not a beginner. 🙂 One of the strangest staff there, if you are coming from the …
JavaScript – A function returning a function returning a function Read more »
Although VitoshAcademy is not an Academy, there should be some educational stuff. Thus, in this article I have decided to put something educational. 🙂 Let’s see how to make a simple selector in jQuery, which updates below some text, based …
Some time ago a king needed money. So he gathered his advisors and told them to think of a new task. One of them offered to tax stupidity. The king asked one question – how. The guy came up with a …
Let’s start from the very beginning in jQuery. Somewhere in the beginning there are events and buttons. So, I will start from there, explaining how to Trigger events and what is the difference between trigger and triggerHandler. Trigger triggers the event completely …
Building web sites is for at least 20 years a thing. Even I am able to build one, using WordPress without some advanced IT skills. Lately, I was into jQuery and thus I found something really meaningful and well written …
When you code in JS, there is always some time that you need to create some html list with JS from array or list or something else. I knew the trivial way with a simple for loop, but when I put myself …
JavaScript – Create Ul and LI elements with JS (With chained function) Read more »
The last month I am writing mainly small pieces of code for JavaScript, because I think I start to like the language somehow (and I took 3 books for review in JS and so far I have only reviewed one). …
JavaScript – Some code for inheritance in JavaScript Read more »
Making a module in JS is kind of interesting. Especially, if you expect something like a class like in VBA or C#. Well, it has nothing to do with it, it is just a function, assigned to a variable. In …