MS_Office_Excel_Agenda

Excel 2008 Excel 2008 Atomic Learning Tutorials

__ Sheets __ Pre-formatted sheets to checkbook, track investments, expense report, and perform other common tasks. Show Ledger 5, 11 Explore others __Charts__ No Chart Wizard,Types of Charts - Tutorials __Toolbox__ Formatting Palette - content sensitive, Formula Builder
 * View:** Ruler, Formula and StatusToolbars: Formatting, Standard
 * Gallery** :

__Excel Practice__ Mad Minute Totals xlsx file -

Rename sheet - Class 1 Autofill days of the week Change days of week columns widths Functions: Total column =SUM(B3:F3) Function Builder: Functions: Pass/Study =IF(G4>156,"Pass","Study") Border s Headers and Footers – Title, place image Views – Custom Views 1st All 2nd Pass/Study Filter Pass / Study

Make a copy of class 1 sheet rename to Class 2 Rename students 6-10 Change 5 scores – watch the totals change Make changes to both sheets – complete weekday name

Add a new worksheet Totals Formula to publish totals calculations from another page Week 1 – class 1 Total ='Class 1'!G8 Week 2 Class 2, etc. Print Area - **Page setup:** Sheets, Margin

Make a chart – Use Toolbox - Formatting Palette 

Comparing Countries xlsx file - Data - Filter Autofilter Sort by Population Create formulas Control-Option to choose non-adjacent cells Chart 2 non-adjacent cells

University of Wisconsin - Eau Claire - [|Microsoft Office 2008 Excel Documentation]
 * Resources**

Agenda