Janet Benincosa's 21st Century Tools: Excel


		Janet Benincosa's 21st Century Tools ©2006 Janet Benincosa Home - Site Map
		HOW DO I...?
		Microsoft Excel For FREE Office 2007 Microsoft Excel tutorials online at Microsoft.com For Office 2003: Excel for Beginners Keyboard Shortcuts Introduction to Excel How to do a Mail Merge in Microsoft Word using data in Excel Basics How do I use the standard toolbar? How do I use the formatting toolbar? How do I use the calculator in Excel? How do I freeze panes for viewing? How do I change the number of default worksheets? How do I uses keyboard shortcuts for borders? How do I compare worksheets side-by-side? How do I view multiple sheets? How do I hyperlink to a worksheet? How do I import WVEIS data into Excel? How do I create labels using addresses in Excel? Security How do I protect with a password? How do I change or remove a password? How do I lock some cells? How do I hide a formula? How do I mask the data in a worksheet? How do I protect the structure of a workbook? How do I protect the formatting of a workbook? Formatting How do I make the data fit on one page? How do I insert a checkmark into a cell? How do I copy headings to multiple pages? How do I change page breaks? How do I insert a picture into a header? How do I format dates? How do I format currency? How do I create a pop-up message? How do I use Auto-Fill? How do I use Auto-Format? How do I use the format painter? How do I select a range of cells? How do I enlarge chart titles? How do I combine columns? How do I separate names in a column? How do I reverse the order of first and last names? Color How do I add color to cells? How do I add color to a border? How do I add color to gridlines? How do I modify the color palette? How do I shade a cell until data is entered? How do I color a cell, based on data entry? Charts How do I create a chart? How do I change the appearance of a chart? How do I make a 3-D chart? How do I rotate a chart? Saving How do I save a worksheet as a web page? How do I create a data form? How do I save as an interactive worksheet? Printing How do I make a worksheet fit on one page? How do I center a worksheet on the page? How do I print multiple worksheets? How do I print a multiple-page worksheet? How do I print only a section of a worksheet? How do I display row and column headings? How do I display column headings? How do I print gridlines? How do I print formulas? Professional Development by ©2006 Janet Benincosa