Gili In this short tutorial we will learn how you can use Visual Basic for Applications (VBA) to automate the saving of your Excel 365 spreadsheet. Our code will assign a custom file name, consisting of a prefix concatenated with the current date and time. Macro to save workbook with VBA Step #1: Prepare your Excel … Read more
When working with RStudio you define a plot (either with R-base or ggplot2), but the chart doesn’t show up in the Plots tab in RStudio. Most probably, you can solve this issue by explicitly printing your plot: Display R plot if not showing up in RStudio Follow the steps below to print your R-base or … Read more
To fix the R no package called ggplot2 error in RStudio or Jupyter, proceed as following: Read on for a more detailed explanation on how to reproduce and fix the error. Reproducing the no package ggplot error In order to reproduce the error, proceed as following: Here is a screenshot take from RStudio on Windows … Read more
Here’s a question from Daniel: I work as an executive assistant in a multinational company. I have noted that lately some of the Teams meeting requests i get are planned to start later (typically 5 minutes into the hour) or end up earlier than the bottom or top of the hour. Any idea on how … Read more
Here’s a question from our reader Bobbi: When working for my previous employer, we had an hybrid work setup which meant that some of our group meetings were conducted in the office and some offline. I just switch to a new, remote only employer who uses Outlook Calendar and Microsoft Teams. The thing is that … Read more
Today we will learn how to fix error messages that you could find in your R development tool such as RStudio, Jupyter and others, when trying to invoke the tidyverse library without it being installed. Understanding the error Error in library(tidyverse) : there is no package called ‘tidyverse’ Here’s a screenshot from the RStudio Console … Read more
In this tutorial we will learn how to append the contents of a Python list to a pandas DataFrame. We will start by creating a simple DataFrame and a Python list. You can use both to follow along with this example. Assign a Python list to a DataFrame From my experience, the easiest ways to … Read more
In today’s data visualization we will learn how to plot multiple time series on the same chart with pandas. Time series is basically information that is time dependent such as prices, inventory, sales etc’. In our example, we would like to plot revenue, expenses and ultimately profit for a fictitious business. We’ll use a line … Read more
Here’s a question from Daisy: I am using Microsoft Teams on a daily basis to communicate with colleagues and customers. I remember that a couple of days ago, i had a conversation with a customer who asked for a specific report. The thing is that i can’t actually find that conversation in my Teams desktop … Read more
Here’s a question from Dave: as a project manager, I use Microsoft Teams on my Windows 10 computer all day long. Sometimes, instead of typing, i prefer to send a recorded audio message to my colleagues and peers. As this capability is not currently available on Teams for Windows or macOS (as far as i … Read more