BUS 220 - Excel for Business

1. Build spreadsheets to solve problems and analyze data for specific business scenarios.
2. Find numerical solutions by writing arithmetic formulas and using basic to advanced built-in functions.  
3. Generate possible outcomes for decision-making scenarios using what-if analysis tools.
4. Format worksheets to display and communicate data clearly and effectively.
5. Present data in visually meaningful ways with charts and other graphical enhancements.
6. Organize data into meaningful arrangements using tables, PivotTables, and sorting/filtering techniques.
7. Manage worksheets and workbooks including protecting workbook data.
8. Create spreadsheets that incorporate efficient construction and time-saving features such as templates, macros, data linking, built-in functions, and conditional formatting.

1. Guidelines for effective spreadsheet development.
2. Techniques for entering data efficiently, proofing/editing data, and checking accessibility.
3. Procedures for writing mathematical formulas.
4. Beginning to advanced functions (statistical, financial, math & trig, lookup, text, date & time, logical) including nesting functions.
5. Formula auditing techniques (trace precedents/dependents, error checking, and evaluating formulas).
6. Formatting techniques (number, text, styles, alignment, cells, page layout, format painter, etc.).
7. Data visualization tools such as charts, sparklines, and illustrations.
8. Data organization with PivotTables and Tables including methods for sorting and filtering data.  
9. Worksheet and workbook management features including the protection of workbook data.
10. Techniques for linking and referencing data between cells, worksheets, and workbooks.
11. What-if Analysis tools including Scenario Manager, Goal Seek, and Data Tables.
12. Efficiency and time-saving spreadsheet tools such as templates, macros, conditional formatting, built-in functions that improve productivity (text, logical, lookup), and other shortcuts.