MS+Excel

=__ http://hardlyworking.wikispaces.com/MS+Excel __=

Take Attendance using Instructor Password



On-line Courses in pinrt from University of Minnesota Excel 2007 [] [|Getting Excel Help] [|Excel Keyboard Shortcuts] [|Some Best Practices for Excel] || Excel sample files unzipped from UMinn Class Files
 * **Excel 2007: Managing and Analyzing Data** || Excel Data Class Files || Excel Data Workbook ||
 * **Excel 2007: Spreadsheet Basics** || Excel Basics Class Files || [|Excel 2007 Spreadsheet Basics Workbook]

Class 1 What is a spreadsheet? [|create] google documents; Microsoft Works; paper; Explain to the person next to you what a grocery list spreadsheet would look like -- search: jpg at LDS Family blog by location at store; cookbook by categories ; Peapod (Giant) commercial Find an Excel Template

Instructor + class Design MyClassRecord.xls Instructor Demonstrate creating MyClassRecord.xls ....................Dates down or across? Fill or extend? Class Set up MyClassRecord.xls MS Excel Vocabulary from Column B,1-8: Instructor review + Class exercise

Class 2 Sum, copy, fill, different cursors Using a step-by-step set of insturctions from DC Public Library, create a spreadsheet with my practice schedule

Class 3 fill and series currosrs Budget examples Average, minimum Error checking--enable and disable __Type of errors to look for : adjacent cells not included in equation; data type differences, 9? altogether =__hand-out TBD (acronym) T o B e D one/Determined=

JY brought in a book about Visual approaches to the internet, with full color screen shots.
JY also brought in the book I showed the class, Computing for Senrios. "It is pretty good!" It also has screen shots. The writing fotn is larger than normal and the explanations are in short sentences.

=Class 4= JY also brought in the book I showed the class, **Computing for Seniors**. "It is pretty good!" It also has screen shots. The writing font is larger than normal and the explanations are in short sentences.

Make sure that two new students have //budget.xls// -- open smith.xls - open anynecord.xls - + a worksheet -- copy from anyonerecord.xls paste into the new worksheet name the new worksheet //**budget.xls**// - let's use Auto-sum to make sure that the January column has a formula for Totals let's use the handle at the bottom of January in the Totals to copy over the Totals formula, so that each month has its own total with the right formula

pie chart = wizard - program that asks you questions in order to produce an "object" such as a picture, table, or spreadsheet=

What is a default chart? What is a default? e.g., Default day for daylinght savins time; default chart, default printer.
no wizard Add 10 lines of space underneath your top budget table. Highlight Row 10 to select which item to put in your pie chart. Possible error: not highlighting the desired area before pasting. Insert pie chart. Pick your favorite graphic! oops! Make sure you only highlght the months in Row 10 so that you have exactly 12 pieces in your pie. oops! If you grab (highlight) column A, you'll gert Grand Total as the **default name** of your chart. oops! Did Microsoft forget that the LEGEND or KEY needs to have 12 colors--one for each month. There are only 9 or 10, depending on the chart we generated. Solution 1 from JY: Use Layout 2 to get a full LEGEND across the top, along with %'s. Layout 2 appears on the Upper Left after you generate the chart.

Let's take a look at the ? Help button to learn more about bar charts. Using the Internet Found a book in a public doman site: New perspectives on Microsoft Office 2007: first course By Ann Shaffer, Patrick Carey, Kathy T. Finnegan, Roy Ageloff Found a Microsoft tutorial: [] Found a video:

style: apply new colors in text and background: Red and Black for $ --"in the Red" I owe $ --"in the Black" I have money in my pocket 2007/2003 versions of software Format/accounting mil three decmial places Let's try to get the proper highlighting for British Pounds, I first use format accounting, then I switch back to format currency and once again chosse the red cash loss option.
 * -£25.000 || £100.000 || -£535.000 || £0.000 || £100.000 || -£38.000 || £100.000 || £100.000 || -£535.000 || £100.000 || £100.000 || £65.000 || -£468.000 ||

Find an Excel Template for budget, work schedule, inventory, invoice, medication schedule grocery list [] Download, Accept T&C, Install Remember to rename so we each get a copy! (T&C or Microsfot Service Agreement = Terms and Conditions)

Hand-outs: MS Overview of charting from Help/Create a Chart/Overview gives a six page handout. The 7th page is empty.

Handouts useful? What would you like to see change in the course? Instructor answers questions so that students understand? Instructor should write more clearly? Instructor should speak more slowly? Supervisor: Kimberly Brown X71409
 * Evaluations:**

Practical Advice: naming and file extensions; directory organization; auto-saving; emailing as an attachment Vocabulary Learning modalities: icon for visual learners; text and audio for verbal learners; kinesthetic approaches

Look forward to: Sort witih and without filter

Each session to cover: Index cards: Name, Languages, PRIVATE or SHARE, jobs, previous training or profession, goals for class, I am a visual/verbal/3-D learner Homework: Write out a daily or weekly schedule so that you can put it into a spreadsheet to schedule your time for a library visit in the next week; Bring in s sample budget; Bring in a book or a web-site to share with the class.

//Last revised by grosslearning, MK Gross //

//9 March 2011// //print using default mode, first page only//