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
Author: Niket Kedia
Tic Tac Toe in Excel using VBA
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.
Advanced Table in Excel using VBA
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.
Interactive Dashboard in MS Excel
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.
File conversion tool: Cometdocs
Hi friends! It’s been long since I write any post. Today we’ll be looking into a very useful tool which is not exactly related to analytics. The tool is Cometdocs. Cometdocs easy to use and focus on wide range of users. But talking form the analytics perspective Cometdocs is amazing products for Teachers, students, researchers, scientists, data journalists etc.
Tableau Tips and Tricks
Today we’ll be learning some tips and tricks in Tableau to make out analysis faster. This we’ll be very helpful to increase your efficiency while working with large amount of data and tight deadline.
Top N values Sub-Category Wise in Tableau
Today we’ll be learning how to create how to show Top N values Sub-Category wise in Tableau. The tutorial will be very useful in many context. Please follow the steps below.
Top N and Bottom N Values in single sheet in Tableau
Today we’ll be learning how to show Top 10 and Bottom 10 values in single sheet. To accomplish this we’ll be using Combined Set functionality of Tableau.