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
    Columbia State Community College
   
 
  Oct 22, 2017
 
 
    
Center for Workforce Development Course Catalog 2013
[Add to Portfolio]

Computer/Tech - Advanced Excel 2010


This course builds on the skills and concepts taught in Excel 2010: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics. Course manual comes with CertBlaster exam prep software (download). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Excel 2010.

See what we’re currently offering in Computer/Technology by clicking HERE.

Format: Lecture

Section Code: CTCE



[Add to Portfolio]