Article 8 – Calculating Percentage Change between New and Old Value
Many times, I get inspiration to write about articles when I post responses to questions on Microsoft Community. The inspiration to write about this has come from following post – Percentages You will also have many occasions particularly when you are asked to compute percentage change between two values. This is very much encountered in…
Challenge 4 – SUM of Multiplication of Preceding Digits by Succeeding Digits
Let's say you have a number 64934 in a cell A1. Now, the challenge before you is to work out the following SUM through a formula which should be flexible enough to capture any number of digits (Don't limit this to 15 digits maximum as allowed by Excel precision but to any number of digits…
Tips & Tricks 66 – Show the Complete Area of a Worksheet as only Limited Area is being shown
If you can see only limited area of a worksheet 1. Check if the sheet is protected. This you check by going to Review tab and see if Unprotect Sheet Button is appearing. – If Unprotect Sheet Button is appearing sheet is protected. You need to click it and if password is asked, you need…
Tips & Tricks 65 – Show a Limited Area of Worksheet
You have a worksheet and you want to show only a limited area to users. Say you want them to see only A1:G50 and remaining you don't want to show them. Use following steps – 1. Click column H so that entire column is selected. Now CTRL+SHIFT+Right Arrow key so that all columns will get…
Excel Quiz 2
Challenge 3 – Generate a Chessboard in Excel
Below chessboard has been generated in Excel. The challenge before you is to give me steps which will generate this chessboard of 8×8. The approach should be flexible to generate any NxN chessboard (Colouring should not be done manually). Note – You may choose to post the response in comments section.
Tips & Tricks 64 – Show a 0 in place of Blanks in Pivot Table
When you create a pivot table and if a source cell has no value (i.e. cell is blank), in pivot table, it will show a blank. All other results in pivot table are carrying numeric values and you see blanks. It is odd though it doesn't impact the results. But you still prefer to show this…
Article 7 – Generate a Sequence of Numbers
Many times, we have need when we want to generate a sequence of numbers for various purpose. When I started Excel, I simply used to put 1 in A1 and =A1+1 in A2 and dragged down to required number of rows. I, sometimes, still do it. Just old habits die hard. Over a period of…