Round up of Excel Tips and Hints

  • Buffer
  • Sharebar
  • Buffer
jethro's picture

As Office 2010 becomes more prevalent in the workplace (most of our clients either have or will be soon updating to it) so the use of the ribbon has become more natural and intuitive for people. It is certainly much more intuitive than the old menu driven interface.

rh2-150x150Play a fun game called Ribbon Hero 2 that allows you to learn the fastest and best ways to do various common tasks in the various Office Apps. My kids are using this to learn the interface and some of these common tasks. I have even learnt some things in the 5 minutes I have spent playing it so far! Download Ribbon Hero 2.

Take the first step in growing your Excel Skills. Microsoft have created a series of learning videos that assist new users to Excel to grow their skills

Learn how to create your own Excel Macros with a free training course. Ideal for the entry level person who wants to explore macro writing for the first time. Note this doesn't create efficient code, but its a start to understanding how the VBA code interacts with Excel.

PowerPivot for Excel - if you have looked or used PowerPivot (See my review of Power Pivot) than this page has some good links for additional resources.

Ribbon

The ribbon is also extensible via code and can be added to or modified as required for specific applications and requirements.

Enable or Disable Custom Ribbon Buttons in Excel 2007-2010. Links from Ron to his site where he shows how to work with the ribbon in VBA.

Avoid losing the state of the global IRibbonUI ribbon object. Frederique explains the problem and points to how to solve it.

Performance

Charles Williams has some great performance related code tips.

Write efficient VBA UDFs using Excel Functions inside a UDF - Part 1

Write efficient VBA UDFs using Excel Functions inside a UDF - Part 2

Lookups

Charley Kyd talks about Excels fastest Lookup Methods the INDEX MATCH dual formula approach is much faster than the single VLOOKUP formula. I have been using this method for some time now to significantly improve calculation times in large workbooks and lookups on data sets.

Daniel Ferry writes on Excel Hero a very good reference guide to using the INDEX and INDEX MATCH functions in numerous scenarios including dynamic range names (in place of volatile functions like OFFSET).

Tushar writes about how to perform Two Dimensional Lookups.

Finally Mikkel Sciegienny explains in depth how to use INDEX MATCH in this user friendly article.

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Anonymous's picture

Thanks for this. I found

Thanks for this. I found Ribbon Hero 2 to be a great way to learn how to work faster with Office.

storage bedford tx 's picture

Thanks for this. I found

Thanks for this. I found Ribbon Hero 2 to be a great way to learn how to work faster with Office.

personal loans's picture

I haven’t checked in here for

I haven’t checked in here for some time because I thought it was getting boring, but the last few posts are really good quality so I guess.

Design Price's picture

thanks for nice tip! by the

thanks for nice tip! by the way, do you know How can we open an .docx file by using office 2003?

jethro's picture

there is a office viewer

there is a office viewer application that will allow you to read them without being able to edit them
see this http://office.microsoft.com/en-au/downloads/office-online-file-converter...