Microsoft Office and Sharepoint ®

This book is for anyone who wants to do any application development in Excel. Even for an old hand at Excel development, a brief skim through reveals valuable nuggets of information.

Learn to design and deploy apps with the newest SharePoint® development model.

This work is a collection of tips and tricks that may make using Microsoft Excel 2003 a little easier and interesting to use. This work describes how to easily create a series of numbers, view all the formulas on a worksheet, highlight a cell based on special conditions, use conditional (IF) formulas, count cells that meet your criteria, sum cells that meet only your criteria, hide worksheets, lookup answer in another table, freeze headings, and colour code worksheet tabs.