Excel Speedup & Optimization Tips by Experts [Speedy Spreadsheet Week]
As part of Speedy Spreadsheet Week, I have emailed few renowned Excel experts and asked them to share their tips & ideas to speedup Excel. Today, I am glad to present a collection of the tips shared by them. Read the Excel optimization & speeding up tips shared by Hui, Luke, Narayan, George, Gregory & Jordon.
Formula Forensic No. 015 – Cornelia’s Price Rises
Cornelia wanted to cumulatively increases prices to a lot of products.
See how it was accomplished using an Array Formula to assist.
Formula Forensic 014 – Faseeh’s Formula
“I have a large list which includes blanks, I want to retrieve the list without the blanks”
Faseeh, responded with a neat array formula.
Today Formula Forensics pulls Faseeh’s Formula apart to see what makes it tick.
Reporting Scenarios using Offset
Project Managers often report financial numbers to the management. In a dynamic world, these numbers are usually based on a lot of factors that may or may not be under your control. So the top management demands that the numbers be reported as per different economic scenarios – Optimistic, Normal or Pessimistic. It is important […]
Free Picture Calendar Template – Download and make a personalized calendar today!
Here is something fun, personalized and delicious to start your new year. A Picture Calendar built in Excel!
Using this you can print a 12 month calendar with your own photos. Its fun to use, easy to set up and looks great. Read more to understand how this works & download the template.
2012 Calendar – Excel Template [Downloads]
Here is a new year gift to all our readers – free 2012 Excel Calendar Template.
This calender has,
» One page full calendar with notes, in 4 different color schemes
» 1 Mini calendar
» Monthly calendar (prints to 12 pages)
» Works for any year, just change year in Full tab.
Go ahead and download the FREE 2012 Calendar and Enjoy.
Formula Forensics 006. Palindromes
Palindrome: – A palindrome is a word, phrase, number, or other sequence of units that can be read the same way in either direction, with general allowances for adjustments to punctuation and word dividers (“Wikipedia”).
This week in Formula Forensics we’re having a look at determining if a cell contains a palindrome.