ppt课件-staff development daze（员工发展眼花缭乱）.pptVIP

Staff Development Daze June 27 28 Tony Gauvin Schedule Monday June 27? ? ??????????? 9:00 – 12:00? ??????????? Basic Excel 12:00 – 1:00 ???????????? Lunch for all workshop participants 1:00 – 4:00??????????????? Advanced Excel Tuesday June 28 9:00 – 12:00????????????? Basic Access 12:00 – 1:00????????????? Lunch for all workshop participants 1:00 – 4:00??????????????? Advanced Access Thursday June 30? Time TBA (2hrs.)?????? Outlook Highlights All materials available at Difference between Spreadsheets and Databases Spreadsheets (Excel) are electronic ledgers Store, manipulate and present numbers Databases (Access) are electronic file cabinets Receive, store, organize and present data Use the right application Save time and effort Decrease frustration The Spreadsheet abstraction An (near) infinite series of rows and columns called Cells that Store numbers (and other stuff) Store formulas that use other information in other cells and produce a results to be displayed A bunch of other neat stuff Formatting Charting What-if scenarios Advanced Excel (afternoon) Topics Formulas and Functions Formatting Importing and exporting data Working with Large Spread Sheets Anything else anyone wants to cover Advanced Excel Part 1 The 3 F’s Formulas, Functions and Formatting  Objectives Enter a formula using the keyboard and Point mode Recognize smart tags and option buttons Apply the AVERAGE, MAX, and MIN functions Verify a formula using Range finder Format a worksheet using buttons and commands Objectives Add conditional formatting to a range of cells Change the width of a column and height of a row Check the spelling of a worksheet Preview how a printed copy of the worksheet will look Objectives Print a partial or complete worksheet Display and print the formulas version of a worksheet Rename sheets in a workbook Starting and Customizing Excel Click the Start button on the Windows taskbar, point to All Programs on the Start menu, point to Microsoft Office on the All Prog