Have any of you seen the new Powerpivot function in Excel 2010? I took the tutorial here http://technet.microsoft.com/en-us/library/ff452206.aspx this is such a valuable tool for combining various excel spreadsheets from various databases into one Pivot Table/Chart.
Hope this info finds interest within you. ~Susan -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anandydr Sent: Wednesday, March 02, 2011 2:10 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Excel Interview Q & A The Favorited question happens to be "VLOOkUP" for me... on every interview this has been asked. The no of parameters (which is 4) and the last parameter (which is 0/1 or False and True). Next come the way to look up on the left which VLOOKUP can't do.. so INDEX and MATCH functions with OFFSET of course... Next would be advanced filters and then Pivot tables... everyone knowledgeable knows that VBA performs slow when compared to inbuilt Excel functions so questions on Macros have been few and far between... -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel