ETP members contact: etp@butte.edu

9 am - 12 pm

5/7, 5/14, 5/21

Laptops provided

Part I: Getting started with terms and navigating a spreadsheet, entry and editing data a beginning modification to spreadsheets are covered. Upon completion, attendees will be able to: 

• Define a spreadsheet and identify spreadsheet components
• Identify the main components of the excel window
• Open and navigate workbooks
• Create a workbook from a template
• Enter and edit text and values in a worksheet
• Enter and edit formulas in a worksheet
• Save and update a workbook, and save a workbook in a different file format
• Move and copy data in a worksheet
• Move, copy, and view formulas in a worksheet
• Use absolute references in formulas
• Insert and delete ranges, rose, and columns in a worksheet

Part II:

• Apply the SUM function to calculate the sum of values
• Use the AutoSum to enter some functions
• Use the AVERAGE, MIN, MAX, COUNT, and COUNTA functions to find average, minimum, and maximum values, and the count of cells in a range
• Apply text formatting
• Customize column widths, row heights, and alignment, and apply color and border formatting
• Format values as currency, percentages, and ordinary numbers
• Apply conditional formatting based on specific criteria
• Copy formatting, apply cell styles, and use Find and Replace to update the formatting for specific content

Part III:

• Create charts based on worksheet data, and move charts within a workbook
• Customize charts and format chart elements
• Insert a picture into a worksheet
• Use graphics as conditional formatting to represent cell data
• Insert and modify SmartArt graphics
• Preview how a worksheet will look when printed, use the spelling checker, and use find and replace to update data
• Set page orientation, scaling, and margins, and create headers and footers
• Print a worksheet and a selected range

ETP members contact: etp@butte.edu 

9 am - 12 pm

5/28, 6/4, 6/11

Part I - Topics include: managing workbooks and worksheets, advanced methods of spreadsheet formatting and the use of outlining and subtotals are covered. Upon completion, attendees will be able to: 

• Freeze panes, split a worksheet, and hide and display data in window elements.
• Set print titles and page breaks
• Navigate, manage, and print multiple worksheets
• Create 3-D formulas to link worksheets, and add a watch window
• Switch between workbooks, and copy a sheet from one workbook to another
• Create and manage linked workbooks
• Apply built in and custom number formats to display data in specific formats
• Apply and modify themes
• Merge and change orientation of cells to display text in special ways; Transpose data; and add backgrounds and watermarks
• Create outlines to group and organize data, create custom views, and consolidate data from different worksheets
• Summarize the data in a worksheet by creating automatic subtotals

Part II - Topics include: the application of creating names for cells and cell ranges, understanding data structure and tables and web sharing of workbooks and worksheets will be covered. Upon completion, attendees will be able to: 

• Use names to make your formulas easier to understand
• Use the name manager and define 3-D names, which span multiple worksheets
• Organize data logically, sort it by the contents of its columns, and filter it to show only those rows that meet certain criteria
• Create and format tables, and use structured references to include table column names in formulas
• Save a workbook as a web page, and use the auto republish feature to keep the web version of a workbook updated
• Add and remove hyperlinks in a worksheet
• Send workbooks via email

Part III - Topics include: documenting spreadsheets with notes, tags and comments and the creation of workbook/worksheet templates including an extensive review of settings will be covered. Upon completion, attendees will be able to: 

• Use auditing features to trace precedent and dependent cells, and trace errors
• Add and edit comments for a cell and a worksheet
• Protect a workbook or part of a worksheet from unauthorized access or unintentional changes
• Share workbooks, merge versions of a workbook, track changes made by various users, remove personal data from a workbook, and mark a workbook as final
• Change Excel's default application settings
• Create and modify custom templates