This course is designed to prepare students from an introductory Excel to a specialist/expert level of spreadsheet competencies. Excel topics include: creating worksheets with embedded charts; formulas, functions, formatting and web queries; what-if analysis, charting, and working with large worksheets; creating static and dynamic web pages; financial functions, data tables, amortization schedules, and hyperlinks; creating templates and working with multiple worksheets and workbooks; using macros and visual basic for applications; formula auditing, data validation; and importing data, working with PivotCharts, PivotTables, and Trendlines.
- Teacher: Tabitha Young