Hello Friends! What-IF Analysis is the way/process to check the affect of values in a formula.
Recently I came across a situation to find the row number for duplicate values.
In SQL Server there is a inbuilt function ROW_NUMBER() read more but in Excel there is no direct function as such.
Hello Friends! Today we’ll be seeing a very simple and very useful way to find out the errors in Excel sheet. This is very handy if you have a sheet with 100’s of rows and columns and can save lot of time.
Your Product Sales is Affected by Shelf Space?
Did you notice that every time you go to a supermarket to buy something, you notice the middle shelf before the top and bottom shelves. This is contradictory to the typical sequential behavior where we like to start from one end and end at another. Of course, many a times we start from one end of the market and go around to the other end but each time we start from one of the shelves which usually is the middle one. Read more
Pivot tables are one of the most notable features of Microsoft Excel. And it’s easy to see why once you are familiar with the feature. To a beginner, they may seem a bit mysterious or intimidating. But once you learn a few basics to get started, you will be well on your way to visualizing your data in new and useful ways.
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.
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.
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.