Send email from Excel without VBA
Hello friends! Today we’ll be learning how to send email from excel using HYPERLINK formula without VBA.
Read moreTag: Machine Learning
Alteryx Tips & Tricks – Part 1
Hello friends!! We’ll be learning few quick and very helpful Alteryx tips & tricks. I’ve attached the reusable Alteryx workflows to download. I’ll be adding more tips to the list.
Read moreConsolidate files using VBA
Today we’ll be learning how to consolidate multiple excel files present in a folder save the output file using VBA. We’ll use FileSystemObject in VBA to achieve this.
Read moreSplit data to Workbooks using VBA
Hello friends! It’s been very long I’ve written any article. I was super busy since last 4-5 months.
Quick and Easy Analytics revision
Hello Friends! I’ll be sharing different resources to quickly revise analytics concepts. Sometimes if you don’t use some concepts for time you may forget and need a quick revision. Here I’m listing out few links you can use to revise.
Exploratory data analysis (EDA) in R
Hello friends! today we’ll be see how to do exploratory data analysis (EDA) in R. EDA is an approach to analyse data and start with it read more. I’ve used medical cost data from Kaggle.
Reshaping data in R
Reshaping data is one of the important steps for data analysis and data transformation. Today we’ll see few of the methods and function in R. The tutorials is easy to follow. I’m using mtcars dataset which is available in R.
ggplot2 in R
Today we’ll be learning about one of the most popular packages in R and which is ggplot2: An Implementation of the Grammar of Graphics. I’m using iris data set which is available in the R. ggplot2 create plot in multiple layers. I’ve used ggplot to create correlation heatmap. I’ve provided more resources in the end of the blog.