jump to navigation

Excel Professional February 15, 2007

Posted by admin in : February 2007 Professional Development, Excel , add a comment

I. Intro – What Can Excel do for me
II. Workbook – Header and Footer; Columns and Rows
III. Worksheets – Insert, delete, rename, copy
IV. Cell Reference – Naming procedure
V. Cell Formatting – Font, font size, color, bold, italic, underline, borders, alignment, wrap text, number, currency, text.
Battleship with cell formatting
VI. Column & Row Formatting – Resize width and height
VII. Setup a Budget Worksheet;

1. Cell A1 Enter text ‘Family Monthly Budget – 2007
2. Highlight Cells A1 through O1.
3. Select Merge and Center tool
4. Cell A2 enter ‘Expenses’
5. Cell B2 enter January
6. Auto Fill February through December
7. Cell N2 enter text ‘Year to Date Totals‘ & Wrap Text
8. Cell O2 enter text ‘Average Monthly Expense‘ & Wrap Text
9. Beginning in Cell A2 enter one of the following expense items in successive cells: Rent, Phone, Electricity, Gas, Water, Cable, Waste Removal, Maintenance, Supplies, Food, Entertainment. The last entry should be Monthly Totals
10. In Column B, January, enter a dollar amount to correspond with each of the expense items listed in Column A
11. For February write a formula using cell references to calculate a projected 10% increase in January expenses
12. Calculate the Monthly Totals – Use Sum function
13. Calculate the Year to Date Totals for each expense item – Use Sum function
14. Calculate the Average Monthly Expense – Use Average Function
13. Create borders on cells
14. Insert > Row above Monthly Totals and add an entry for Transportation with a corresponding expenditure
15. Window > Freeze and Unfreeze panes

VIII. Edit > Move or Copy Sheet > Copy.
IX. Rename Worksheets: 2007; 2008; 2009
Color Code Tabs
X. Page Setup (File menu) – portrait or landscape?
100% or fit to one page wide by 1 page tall?
Print area?
Columns to repeat at top?
Rows to repeat at left?
XI. File > New > Templates – Microsoft Office Online
Family Budget
XII. Tutorials – Atomic Learning
http://www.atomiclearning.com/excel_2003_intro

Excel Gradebook February 15, 2007

Posted by admin in : February 2007 Professional Development, Excel , 1 comment so far

I. Intro – What Can Excel do for me
II. Workbook – Header and Footer; Columns and Rows
III. Worksheets – Insert, delete, rename, copy
IV. Cell Reference – Naming procedure
V. Cell Formatting – Font, font size, color, bold, italic, underline, borders, alignment, wrap text, number, currency, text.
Battleship with cell formatting
VI. Column & Row Formatting – Resize width and height
VII. Setup a Gradebook Worksheet;

1. Cell A1 Enter text ‘Gradebook for 6th Grade Math – Trimester 1
2. Highlight Cells A1 through L1.
3. Select Merge and Center tool
4. Cell A2 enter ‘Student Name’
5. Cell B2 enter Quiz 1
6. Auto Fill Quiz 2 through 10
7. Enter at least 5 students names in the A column
8. Enter Quiz scores for each student in Quiz 1 Column B
9. For Quiz 2 write a formula using cell references to calculate Quiz 1 scores – 2
8. Calculate the total score for each student – Use Sum function
9. Calculate the average score for each Quiz – Use Average function
10. Create borders on cells
11. Window > Freeze and Unfreeze Panes

VIII. Edit > Move or Copy Sheet > Copy.
IX. Rename Worksheets: Trimester 1; Trimester 2; Trimester 3

Color Code Tabs

X. Inserting and Deleting Columns and Rows
XI. Page Setup (File menu) – portrait or landscape?

100% or fit to one page wide by 1 page tall?
Print area?
Columns to repeat at top?
Rows to repeat at left?

XII. File > New > Templates – Microsoft Office Online

Gradebook
Family Budget

XIII. Tutorials – Atomic Learning
http://www.atomiclearning.com/excel_2003_intro