The page uses Browser Access Keys to help with keyboard navigation. Click to learn moreSkip to Navigation

Different browsers use different keystrokes to activate accesskey shortcuts. Please reference the following list to use access keys on your system.

Alt and the accesskey, for Internet Explorer on Windows
Shift and Alt and the accesskey, for Firefox on Windows
Shift and Esc and the accesskey, for Windows or Mac
Ctrl and the accesskey, for the following browsers on a Mac: Internet Explorer 5.2, Safari 1.2, Firefox, Mozilla, Netscape 6+.

We use the following access keys on our gateway

n Skip to Navigation
k Accesskeys description
h Help
Northern Wyoming Community College District    
NWCCD 2017-18 Catalog 
  
 
  Sep 23, 2017
 
NWCCD 2017-18 Catalog
[Add to Portfolio]

CMAP 1752 - Advanced Spreadsheet


This course is designed to help students become proficient in spreadsheets using leading software application packages. Students build advanced spreadsheet solutions to collate results, research, analyze and present numerical information results as needed in various businesses and scientific projects to improve efficiency and professionalism. The course may help students prepare for Microsoft Office Specialist (MOS) Expert exam 77-728 Excel 2016 Expert: Interpreting Data for Insights.

Prerequisites:
Successful completion of CMAP 1680 Office Productivity Tools, or instructor consent based on student’s assurance they have core spreadsheet skills.

Minimum Student Competencies
Upon completion of CMAP 1752 Advanced Spreadsheet, the student will:

  1. apply advanced format and customization options to create spreadsheets and workbooks.
  2. develop custom spreadsheet formats for workbook and spreadsheet consistency to include, but not limited to, workbook views, page/cell formatting, order and group cells.
  3. create macros and shortcut keys.
  4. create advanced filtering and sorting for tables.
  5. integrate advanced chart elements.
  6. create Pivot Tables and Pivot Charts.
  7. manage multiple workbooks.
  8. link to external data.
  9. develop a Dashboard.


Credits: 1.5

Instructional Method Lecture

Contact Hours: 1.5 hours/week



[Add to Portfolio]