CMAP 1765 Spreadsheet Applications:

This comprehensive course instructs students in both the basic and advanced features of spreadsheet software. Business applications are emphasized to prepare students to use spreadsheets in the business world. Students receive in-depth instruction in formatting; using range names, formulas, and functions; creating charts; performing database management; auditing; creating and using macros; importing/exporting data; creating and using templates; and creating and using workgroup functions. Recommend: CMAP 1200 or computer experience. (3 lect.)

Credits

3 credits

Transfer Status

Transferable to UW.

Major Topics

  • Formatting
  • Formulas and Functions
  • Hyperlinks and Web Pages
  • Charts and Design Elements
  • Lists
  • Range Names
  • Templates
  • Macros
  • Auditing Tools
  • What-if Analysis
  • Data Consolidation
  • Linking
  • Workgroup Features
  • Importing/Exporting Data
  • Custom Formats
  • Filters, Subtotals, and Outlines
  • Data Tables
  • PivotTables, PivotCharts, and PivotChart Reports
  • Interactive Web Pages

Outcomes

In order to successfully complete this course, the student will:

1. Create, modify, and format worksheets.

2. Apply filters (basic and advanced) to lists.

3. Create workbooks using templates.

4. Save workbooks using different names and file formats.

5. Apply styles.

6. Use automated tools to format worksheets.

7. Modify page setup options for worksheets.

8. Insert/delete/modify worksheets.

9. Use 3-D references.

10. Use statistical, date and time, financial, reference, and logical functions in formulas.

11. Create, modify, position, and print charts and graphics.

12. Convert worksheets into web pages [including interactive web pages}.

13. Create hyperlinks.

14. View and edit comments.

15. Import/export data from/to Excel.

16. Retrieve external data and create queries.

17. Create, edit, and apply templates.

18. Create workspaces.

19. Use data consolidation.

20. Create and apply custom number formats.

21. Apply conditional formats and data validation.

22. Customize toolbars and menus.

23. Create, edit, and run macros.

24. Use auditing tools.

25. Use subtotals and filters with lists.

26. Create Extensible Markup Language (XML) Web queries.

27. Create PivotTables, PivotCharts, and PivotTable/PivotChart reports.

28. Forecast values with what-if analysis.

29. Create and display scenarios.

30. Modify passwords, protections, and properties.

31. Create a shared workbook; merge workbooks.

32. Track, accept and reject changes to workbooks.

Other Information

Any information placed here must be adhered to by all instructors:

Contact instructor for information about required textbook.