Save as PDF and send mail in VBA
Hello friends! Today we’ll be learning to creating 1 pdf for every value on a picklist in excel and delivery of the pdf by email. Easy to follow and reusable code.
Read moreTag: Excel Tricks
Filter and copy data to new sheet using VBA
Hello friends! Today we’ll be learning to Filter and copy data to new sheet using VBA. Easy to follow and reusable code.
Read moreCAGR line in Excel Charts
Hello friends!! We’ll be learning how to add CAGR line in bar or Line in single chart in Excel. I’ve attached the workbook to download and reuse.
Read moreTarget vs Actual Chart in Excel
Hello friends!! We’ll be learning how to create bar and stack bar in single chart in Excel. I’ve done something similar in Tableau in my previous post Profit Gap Analysis in Tableau. Also I’ve attached workbook to download and reuse.
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 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.
Learn MS Excel from Excel guide
Hello friends! Recently I came accross with an MS Excel guide which contains almost all the MS Excel functions. I am not sure about the author/source but it’s an excellent guide to self Excel learning.
Read more