Vedic square is below. In this, first row and first column are numbers 0 and 9. Other numbers are populated as per logic which you will need to identify. More about Vedic Square at https://en.wikipedia.org/wiki/Vedic_square
Tips & Tricks 151 – Saving in ODS (OpenDocument Spreadsheet) but Don't Need Excel Warning Message – "Do you want….."
Question – Sometimes, I may require to work in different Office Suites and to maintain compatibility, I use Open Document Format. But whenever, I save in Open Document Format (ODS – OpenDocument Spreadsheet), I get the Excel warning like below. I don't need this. What is the way out? Answer – This requires a registry…
Solution – Challenge 55 – Make an Alphabetic Triangle
Below is a possible solution to Challenge 55 – Make an Alphabetic Triangle Put following formula AB4 somewhere and drag to the right.
Challenge 57 – Another Word Challenge – Palindrome or Not
We earlier had challenges related to Pangram, Isogram and Anagram. This time, it is about Palindrome. A Palindrome is a word / sentence that reads the same from backward also as it reads from forward. Some of the famous Palindromes are
Excel Quiz 35
Tips & Tricks 150 – Save Each Worksheet as Different Workbooks
You have got a workbook and you want to save each worksheet as different workbook – You can adopt following method to do so if worksheets are not many in number. 1. Right click on a worksheet tab 2. Move or Copy 3. Select new book 4. Save this new workbook 5. Do it for…
Solution – Challenge 54 – Make a Sequence like A_B__C___D____E_____F……
Below is a possible solution to the challenge Challenge 54 – Make a Sequence like A B C D E F…… Put below formula as array formula in a cell and drag down =IFERROR(CHAR(MATCH(ROWS($1:1),(ROW($1:$26)*(ROW($1:$26)+1))/2,0)+64),"")
Challenge 56 – Cryptography Challenge 5 – Fully Functional Caesar’s Shift Cipher Decrypter
We made ourselves familiarized with Caesar's Shift in Challenge 39 – Cryptography Challenge 1 – Caesar's Shift Cipher and made its decrypter in Challenge 53 – Cryptography Challenge 4 – Caesar's Shift Cipher Decrypter. We also made a fully functional encrypter in Challenge 40 – Cryptography Challenge 2 – Fully Functional Caesar’s Shift Cipher based on…
Downloads 09 – Template 09 – Stakeholder Register
< The template can be downloaded from Template 09 – Stakeholder Register > This is a fairly detailed template which you can shorten if you wish. But the recommendation is to use the full template to get complete benefit from Stakeholder Analysis.
Article 43 – Optimize, Troubleshoot and Improve Performance in Excel (non VBA)
Below points will help you in following to optimize your excel sheet Reduce time taken to calculate / recalculate Reduce time taken to open / close workbook Reduce file size Below points may not be valid in many circumstances so you will have to see the suitability of a recommendation but most of the time,…