Analytics Tuts

Analytics Tuts

Analytics and Data Visualization Tutorials

  • Linkedin
  • Twitter
  • Pinterest
  • GitHub
  • Home
  • R
  • Tableau
  • Excel
  • SQL
  • Alteryx
  • Python
  • Power BI
  • Automation
    • Airtable
    • Power Automate
  • Hire Me

Tag: Learn VBA

Export to PPT using VBA

September 20, 2020 Niket Kedia Leave a comment

Hello friends! Today we’ll be learning to export to PPT using VBA. Easy to follow and reusable code.

Read more
  • Excel

Save Each Worksheet as a Separate PDF in VBA

January 14, 2020 Niket Kedia Leave a comment

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 more
  • Excel

VBA Tips & Tricks

January 12, 2020 Niket Kedia Leave a comment

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 more
  • Excel

Split data to Workbooks using VBA

December 1, 2019 Niket Kedia 4 comments

Hello friends! It’s been very long I’ve written any article. I was super busy since last 4-5 months.

Read more

  • Excel

Learn MS Excel from Excel guide

February 28, 2017 Niket Kedia Leave a comment

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

  • Excel

Tic Tac Toe in Excel using VBA

February 11, 2017 Niket Kedia 5 comments

Hello friends! I was playing with VBA and create this Tic Tac Toe game in Excel. Comment if you want to learn how to create how to create Tic Tac Toe in Excel using VBA.

Read more

  • Excel

Advanced Table in Excel using VBA

February 4, 2017 Niket Kedia Leave a comment

Hello friends! Today we’ll be learning about the Advanced Table in Excel using VBA. This post will be very using useful. Advanced Table in excel is very useful in many cases and also to replace pivot table in Excel.

Read more

  • Excel

Interactive Dashboard in MS Excel

January 14, 2017 Niket Kedia Leave a comment

Hello friends! this is a post after a long time. Recently I started learning Excel-VBA and I’ve created an Interactive dashboard in excel. I got the inspiration from here. It doesn’t have much use of VBA for that I’ll post tutorials.

I am also attaching the Excel file to reuse and interact with it.

Read more

  • Excel

Find me on Codementor

Codementor badge
Get Data Scientist Handbook Copy
Copyright © 2015-2024 | Analytics Tuts Theme: Dynamic News