There are 100s of great Excel functionalities that you might have never heared of. Or, might have heared of, but how do I find 'm? Below you will find a selection of Excel tips found on the Internet, brought to you by the ExcelKing.

Disclaimer

Help and How-to for Microsoft Office Excel 2003 Updated : Creating custom functions Although Microsoft Excel includes a multitude of built-in worksheet functions, chances are it doesn't have a function for every type of calculation you perform. Learn how you can create your own functions. Create a custom dictionary Prevent Excel from flagging the spelling of words that aren't in the main dictionary by using a custom dictionary. Analyze data with PivotTable reports After you have built a PivotTable report, you can rearrange it to view your data from alternative perspectives. Using research services in Microsoft Office Excel 2003 Did you know that you can search for definitions, stock quotes, and other related references, and insert them directly in your worksheet? Here's how. Freeze or lock rows and columns Want to view different areas of a worksheet at the same time? Learn how to lock rows or columns in one area by splitting or freezing panes. Rss Feed Reader Increase Online Traffic

Help and How-to for Microsoft Office Excel 2003 Updated : Tracking career opportunities in Excel Hunting for a new job? Excel can help you keep track of career opportunities and other job search information. Print labels by using Excel data in a Word mail merge Want to send a mass mailing to an address list that you maintain in a worksheet? Learn how to use a Microsoft Office Word mail merge to Shading alternate rows on an Excel worksheet To maximize the readability of endless rows of data, try shading alternate rows with different colors or patterns. Roadmap to Excel 2003 training With rich audio and visual components and interactive, hands-on practice sessions, training courses are a great way to become faster, smarter, and more effective at working with Excel. Read this article to find out what courses are available and what they cover. Let Excel be your calculator Instead of reaching for your calculator, use Excel to do the math! RSS Software Increase Website Traffic