Correlation matrix in Excel, Python and R
Hello friends!! today we’ll learn to make correlation matrix in Excel, Python and R. Also we’ll be creating correlation matrix heatmap in Excel, Python and R.
Read moreCategory: Excel
Get the Sum of Filtered Data in Excel
Hello friends!! We’ll be learning to do calculation and do aggregation on filtered data in Excel. We’ll achieve this using the SUBTOTAL() function in Excel.
Read moreSave Each Worksheet as a Separate PDF in VBA
Hello friends!! We’ll be learning quick way to convert Excel sheets to PDF in VBA . These quick VBA tip will help you to save lot of time.
Read moreSend email from Excel without VBA
Hello friends! Today we’ll be learning how to send email from excel using HYPERLINK formula without VBA.
Read moreVBA Tips & Tricks
Hello friends!! We’ll be learning few quick and very helpful Excel VBA tips & tricks. These few VBA tips will help you to save lot of time.
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.
What-IF Analysis in Excel
Hello Friends! What-IF Analysis is the way/process to check the affect of values in a formula.