Transcript Center for Education and Professional Development Spring

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 worksheet
Outlook
● 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 list
Word 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