Computer Class Descriptions Center for Education & Professional Development

1. Computer Class Descriptions Center for Education & Professional Development ________________Access Fundamentals● understand Access relational database terminology ● follow the steps required to design simple databases ● create, modify, and work with tables ● create, modify, and work with select queries ● create and modify forms to work with data● create and modify reports to select, organize, and print data Excel Fundamentals● create basic worksheets ● work with cells and data using moving and copying techniques ● perform calculations on data using formulas and functions ● change the appearance of worksheet data using formatting techniques ● work with multiple worksheets within a workbook ● create and modify charts ● set page display and printing options Excel Intermediate● use templates to create workbooks ● sort and filter data ● re-use and share data ● create advanced formulas and audit worksheets ● use PivotTables, PivotCharts, and other tools to analyze data ● use features to collaborate with others Excel Advanced● customize your workbook using data validation, macros, grouping, and outlining● work with multiple workbooks to consolidate data, link cells, export data, and import data ● collaborate by protecting and sharing workbooks, and tracking changes to workbooks● chart non-adjacant data, modify chart items, and create a trendline● use multiple graphic objects to enhance your worksheetOutlook● address, compose, and send messages● attach a file to a message● open, reply, and forward messages● print and delete messages● work with appointments in your calendar ● work with contacts in your contact folder● add tasks to a task listWord Intermediate● create individual form letters using merged data.● prepare envelopes, create standard mailing labels, and merge to lists ● sort various data format alphabetically or numerically● create, modify, and format worksheets in tables to organize text● use templates and styles to create consistent formatted documents ● format text in multiple columns to build a page layout● create and insert graphics to add visual appeal to documents● display text and page numbers using headers and footers