Create and edit a Workbook Template, complete with formulas, functions, AutoSum, titles, borders, clip art, etc.,
so you can base new spreadsheets on it. ADVANCED FORMULAS & FUNCTIONS: Use 3-D Formulas to combine data from
multiple spreadsheets located within the same workbook (file). Link
Workbooks to combine data located in separate workbooks (files). Use Functions such as Count, CountIf,
SumIf, and If Statements to calculate text or numeric values. "Nest" one
function within another. Use Conditional Formatting. HLOOKUP & VLOOKUP: Use HLookup and VLookup to look up text
or numeric values contained in rows or columns. VALIDATION: Use Validation to improve speed and accuracy of data entry. Add drop-down lists and pop-up explanation boxes.
Use Pivot Tables to summarize rows of data for reports.
Insert, Move, Edit, and Resize a variety of different charts. Create
Forms to speed up data entry, editing, and searching. Sort and Filter
data. MACROS, HYPERLINKS, COMMENTS, ETC.: Create simple Macros to automate basic tasks, add Hyperlinks to connect spreadsheets to Word documents and other files, add Comments to provide documentation for user.
Protect a Worksheet or Workbook so it cannot be changed, etc. PREREQUISITES: Introduction to Excel or comparable experience. Course handout covers version 2007. Students will
use version 2007 in class. |