Microsoft Office
Using Word at UCSB [11/27/2012]
Location: SSMS 1304
Prerequisite:
Experience working in the Windows operating system (which includes familiarity with such terms as memory, files, icons, input, output and storage devices; and such skills as using a mouse to point, click and drag, launching an application, saving and opening a file).
Description:
Most of us use MS Word as our word processor, but it right out of the box it is a powerful publishing tool. This workshop highlights some of the futures currently used by some departments to achieve impressive results. We will explore Mail merging, styles [including balloons styles!], commenting, references, table of contents, breaks, great tips and other features. This hands-on workshop promises to change your ideas of what MS Word can do for you while creating documents for your department.
Upon completion of this workshop, participants should be able to:
· Understand the different types of page breaks.
· Create and Use custom styles.
· Create tables of contents.
· Create and use the Screenshot, References, and Building Blocks tools
· Create custom mail merge letters.
Introduction to Excel 2010
Date/Locations:
Tuesday, 10/16/12 @ SSMS 1304
Thursday 10/25/12 @ Phelps 1517
Prerequisite:
Experience working in the Windows operating system (which includes familiarity with such terms as memory, files, icons, input, output and storage devices; and such skills as using a mouse to point, click and drag, launching an application, saving and opening a file).
Description:
This workshop is applicable to all versions of Excel. In this session, designed for the novice spreadsheet user, you will learn the basics of worksheets using Excel. Topics covered include creating spreadsheets, entering values vs. text, tips and technical terms associated with spreadsheets.
Upon completion of this workshop, participants should be able to:
· Create a basic worksheet by entering text, values, and formulas.
· Create formulas by using Excel built-in functions.
· Move, edit, and copy data using a variety of shortcuts, buttons or menus.
· Change the appearance of worksheet data by using a variety of formatting techniques.
· Prepare a document for printing using a variety of printing options.
· Use the three-dimensional aspect of the Excel workbook environment by creating formulas that refer to cells on multiple worksheets. Save an Excel workbook in multiple formats.
Intermediate Excel 2010
Date/Locations:
Thursday 10/18/12 @ Phelps 1517
Thursday 11/01/12 @ Phelps 1517
Tuesday, 11/13/12 @ SSMS 1304
Prerequisite:
Familiarity with Excel basics (e.g., entering, correcting, and formatting cells).
Description:
In this workshop you will learn some of Excel’s advanced data management features and. Topics covered include creating a database or table in Excel; using a data form for data entry; sorting; using filters and filtered lists; summarizing data; creating charts; popular functions and formulas.
Upon completion of this workshop, participants should be able to:
· Sort information using the sort and filter features.
· Understand how formulas and functions work, where to find and use them.
· Understand and create tables.
· Create charts that graphically represent worksheet data. Modify charts.
Using Excel at UCSB [Tuesday, 12/04/2012]
Location: SSMS 1304
Prerequisite:
Experience working in the Windows operating system (which includes familiarity with such terms as memory, files, icons, input, output and storage devices; and such skills as using a mouse to point, click and drag, launching an application, saving and opening a file).
Description:
Come and see how your peers are use MS Excel to do their jobs. This workshop will feature how to do weighted averages, a ledger system and data filtering to achieve interesting reports. In looking at some real life samples we will cover: formulas and functions; tables, filters, pivot tables, and simple macros.
Upon completion of this workshop, participants should be able to:
· Find, and use functions.
· Understand, create and use tables.
· Understand and use advanced filtering.
· Understand, create and use pivot tables.
Introduction to Access 2010 [Tue10/23/2012]
Location: SSMS 1304
Prerequisite:
Experience working in the Windows operating system (which includes familiarity with such terms as memory, files, icons, input, output and storage devices; and such skills as using a mouse to point, click and drag, launching an application, saving and opening a file). Participants should have at least 6 months experience with some other Microsoft application (experience with MS Excel is particularly helpful).
Description:
This workshop provides an overview of database management and relational databases and introduces you to various Access objects. You will learn essentials such as basic database design principles, how to create a database, working with tables, defining fields and properties, filtering techniques, creating forms and reports using the wizard, and using data from sources external to Access (spreadsheets, text files, and other databases). You will also learn techniques for working with datasheets, editing and formatting data and how to get started quickly by taking advantage of the various "Wizards" that come with Access.
Upon completion of this workshop, participants should be able to:
· Understand database concepts and terminology in Access.
· Design and create tables.
· Enter and manipulate data in tables.
· Create data queries.
· Create data forms for viewing and inputting data.
· Create reports that summarize and group data.
· Perform database maintenance procedures.
