MABS 101 - Excel

STUDENT LEARNING OUTCOMES                      

Upon completion of this course, a student will be able to:

1. Navigate an Excel worksheet and set specifications with Excel using the Ribbon, tabs, commands, and dialog boxes. 
2. Use the Excel help
3. Plan and design a worksheet.  Enter labels, values, and formulas.
4. Enhance a worksheet by formatting values, text and formula results.  Move cells and ranges.
5. Create formulas with multiple operators and copy formulas with relative and/or absolute cell references.  Include range names in a formula.
6. Use functions to solve common business problems including:
1. Statistical (AVERAGE, COUNT, COUNTA, MAX, MIN)
2. Financial (FV, PMT, RATE)
3. Date and Time (TODAY, NOW, DAY, MONTH, YEAR,WEEKDAY)
4. Lookup and Reference (HLOOKUP, VLOOKUP)
5. Logical (IF, AND, OR)
6. Database (DAVERAGE, DSUM, DCOUNT, DMAX, DMIN)
7. Text Functions (UPPER,LOWER,PROPER,TRIM,LEN,FIND/SEARCH, MID)
7. Manage workbooks by freezing/unfreezing, moving, hiding, protecting worksheet elements.  Link workbooks and audit workbooks.
8. Control workbook print-outs.
9. Plan, design, edit and enhance an embedded chart or separate chart sheet.
10. Plan, create and sort a database list.
11. Manipulate database list data with autofilter or a custom filter.  Summarize database list data with automatic subtotals.
12. Analyze data using “what-if” tools such as goal-seeking, one-way or two-way data tables, and scenario manager.
13. Summarize data with Pivot Tables.
14. Exchange data with other Windows programs.
15. Automate worksheet tasks with macros.