COPYRIGHT: Attribution Non-commercial
Samples
- Excel 2003 - tutorial 1
Spreadsheet Basics: Screen Layout, Title bar, Menu bar, Standard Toolbar, Other Tools, Task Pane, Adding and Renaming Worksheets
Modifying Worksheets Moving Through Cells, Adding Worksheets, Rows, Columns, and Cells, Resizing Rows and Columns, Selecting Cells, Moving and Copying Cells, Deleting Rows, Columns, and Cells, Freeze Panes,
Formatting Cells Formatting Toolbar, Format Cells Dialog Box, Formatting Worksheet, Dates and Times, Format Painter, AutoFormat
Formulas and Functions Formulas, Linking Worksheets, Relative, Absolute, and Mixed
Referencing , Basic Functions, AutoSum.
Sorting and Filling Basic Sorts. Complex Sorts. Auto-fill.
Comparing Workbooks Compare Side by Side.
Page Properties and Printing Page Breaks. Page Setup. Margins. Header/Footer. Sheet. Print Preview..Print. - Excel-2003-Tutorial-2
- Charts: Chart Wizard, Chart toolbar, Resizing a chart, Moving a chart, Deleting a chart, Copying a chart to Microsoft Office file, Chart Types, An Overview on Formatting Charts and Cell
Commonly Used Features: Comments, Use Go To, Use Find and Replace, Increase / Decrease Decimals, Protecting your files (password to open),
Saving Excel files as Web pages
E-mail an Excel File: To send by e-mail a single Excel worksheet as a message body, To send by e-mail a single Excel worksheet as an attachment, To send by e-mail an Excel workbook as an attachment, To send by e-mail an Excel workbook for review
Additional
Appendix 1: Shortcut Keys - Microsoft-Excel-2003-Cheatsheet and basic excercises with tips
- Excel-Pivot-Tables-in-Excel-2003
- 423 page book. Learn Excel
Excel 2007 handouts
