Playing with Colors

http://www.cpearson.com/excel/colors.aspx

Using SumProduct

Sumproduct is by far one of the most powerful and versatile functions provided by Excel. In its most basic form, SUMPRODUCT multiplies corresponding members in given arrays, and returns the sum of those products. This page discusses the classic use of SUMPRODUCT, how creativity and inbuilt flexibility has enabled it to evolve into a far more useful function, and explains some of the techniques being deployed. Finally, some examples of SUMPRODUCT show its versatility.

The link below shows the use of Sumproduct.


http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Excel macro help from MSDN

http://social.msdn.microsoft.com/Forums/en-US/isvvba/threads

Shortcuts using Windows logo key

Press                                   To

Windows logo key                  Display or hide the Start menu

Windows logo key+L              Lock the computer

Windows logo key+BREAK -Display the System Properties dialog box

Windows logo key+D              Show the desktop

Windows logo key+M       Minimize all windows

Windows logo key+SHIFT+M   Restore minimized windows

Windows logo key+E         Open My Computer

Windows logo key+F             Search for a file or folder

CTRL+Windows logo key+F     Search for computers

Windows logo key+F1           Display Windows Help

Windows logo key+R             Open the Run dialog box

Windows logo key+U             Open Utility Manager

Application key                      Display the Shortcut menu for the selected item

Top 10 Navigation Tips for Microsoft Excel

These are my top 10 Navigation Tips … I do them without thinking, but have recently had to show a few younger folks that using your mouse isn’t the most efficient way to navigate Excel.  For anyone else who needs a navigation refresher, these will make working in your spreadsheets much faster:

1. [Ctrl]+[Home] takes you to cell A1
2. [Ctrl]+[End] takes you to the last data cell in your worksheet
3. [Ctrl]+[PgDn] takes you to the next worksheet
4. [Ctrl]+[PgUp] takes you to the previous worksheet
5. [End]+[↑] takes you to the top of the row
6. [End]+[↓] takes you to the bottom of the row
7. [End]+[→] takes you to the furthest right entry in the row
8. [End]+[←] takes you to the furthest left entry  in the row
9. [Ctrl]+[A] selects/highlights all cells that you are using in a worksheet
10. [Shift]+[Spacebar] selects/highlights your row

http://businesstoolsblog.com/

Excel Dashboard

Excel dashboards are excellent way of presenting data... 

Here are few dashboards we can use.

6 part tutorial for Excel Dashboards

http://chandoo.org/wp/2008/08/20/create-kpi-dashboards-excel-1/

Match two excel files

The best tool that will help you to compare,
update and synchronize your Excel spreadsheets.

Synkronizer is an easy-to-use, yet extremely powerful, Excel tool for comparing and synchronizing Excel spreadsheets and Excel databases.

Synkronizer makes your life easier by saving your time and speeding up your data processing. It's a must-have Excel add-in for everyone from power users to beginner users.

http://www.synkronizer.com/