Hi ,
All those who use Excel at work can make use of these techniques :
https://sites.google.com/site/beyondexcel/project-updates/multi-cellarraymodelling
Narayan
Hi ,
I am finding that there is not so much to look out for on the forum ; I spend time learning Power Pivot , or at least I think I am learning !
Today I watched this video :
https://www.youtube.com/watch?v=vpavH7P-Nhs
Narayan
Hi ,
Based on Chandoo's Easter egg workbook , here is a similar workbook , which does not contain the word PANDA ; of course , you can make it appear by entering a 10 digit number in cell D3.
The puzzle is to find out this number.
If you can find this number without a hint , that's great ; in...
Hi ,
Came across this today ; I think the trick about detecting hidden columns is nice.
http://wmfexcel.com/2015/08/29/a-trick-to-sum-visible-columns-only-without-vba/
http://wmfexcel.com/2015/08/22/put-a-dynamic-hint-for-showing-or-hiding-rows-or-columns-hidden-by-data-group/
Narayan
Hi All ,
Just came across this very well done Excel quiz , with well thought out questions ; it's a pity there are so few of them ( Purna , can we have something like this on the forum , with say 25 questions ? )
https://www.wiziq.com/online-tests/22057-test-your-excel-knowledge-updated
Narayan
Hi All ,
Something to download and refer to :
http://www.exceltip.com/wp-content/uploads/2015/05/250-Ms-Excel-Keyboard-Shortcuts.pdf
The parent site link :
http://www.exceltip.com/tips/250-ms-excel-keyboard-shortcuts.html
Narayan
Hi ,
Came across this today ; might be useful to those who don't know.
http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2013/08/08/absolute-structured-referencing-a-nifty-little-trick.aspx
Narayan
Hi All ,
ExcelForum has declared a Dashboard contest ; details are here :
http://www.excelforum.com/2014-excel-dashboard-competition/1042488-2014-excelforum-dashboard-competition.html
Narayan