One of my favorite Excel functions to do business modeling are Cube functions. They act as a more efficient replacement for SUMIFS, GETPIVOTDATA functions that serve to sum aggregated results with various filters applied. Cube functions (CUBEVALUE, CUBEMEMBER, CUBESET) will only work if you have a PowerPivot model or live cube connection in your Excel…
Month: June 2023
Setting up a Wireguard VPN (on Linux)
A VPN (virtual-private-network) allows you to route all your traffic through a computer. This makes your browsing more secure and you can bypass regional-blocked content. Modern-day options include NordVPN, ExpressVPN, etc. but today I am going to show you why and how to create your own VPN using Wireguard. Why? Have you ever heard VPNs…
Sum of all numbers from 1 to n
You all had this experience at least once. You have to calculate the sum of all numbers to n, so naturally you start counting and counting, starting all over again because you made a mistake and finally using a calculator to get the answer. Well I don’t want to ruin your day but you did…