Portland Community College | Portland, Oregon

Learn to customize the ribbon; name cells and cell ranges to use in formulas/functions; link workbooks and save workspace; explore data validation options - rules, drop-down lists, etc.; set up advanced filters and discuss ways to use; analyze data with special tools - Scenario Manager, Goal Seek, etc.; make PivotTables and PivotCharts; create simple macros and discuss file types; protect workbook and set password; create and use templates.