Excel 07 Documentation
Looking for someone that can write a training guide for Microsoft Outlook 2007 on the 40 “how to” items listed below.
The documentation should include step-by-step instructions along with relevant screen shots.
First draft must be complete no later than 2.19.10.
How to select an entire worksheet
How to add new worksheets
How to delete a worksheet
How to name a work sheet
How to insert a row
How to insert a column
How to insert a cell
How to increase or decrease the size of a row
How to increase or decrease the size of a column
How to autofit a column width
How to autofit a row height
How to format cells for font size, color
How to add gridlines to an entire worksheet
How to add a border
How to space text across several columns
How to top, middle and bottom align text in a cell
How to wrap text in a cell
How to indent text in a cell
How to find and replace text
How to insert a picture
How to sort a column from A to Z or Z to A
How to sort a column from A to Z or Z to A
How to sort the contents of an entire worksheet by just the data in one column
How to create a simple formula (For example: Number of Hours Worked * Rate
How to create a formual to sum a column of numbers
How to format cells for currency, text, dates, numbers, time and percentages
How to create a header and footer
How to insert a hyperlink
How to create a column, pie or bar chart
How to change the margin sizes and do a custom margin size
How to change the orientation from landscape to portrait
How to set and clear a print area
How to insert a page break
How to print entire document to 1 page
How to print the same top row on each page
How to print the same first column on each page
How to freeze panes
How to freeze the top row
How to freeze the first column
How to separate the contents of one cell into multiple cells (for exampe; a column that has first and last names that is split into 2 colums