Excel I & II with Susan Meyer

EXCEL II with Susan Meyer

*** A continuation of Excel I ***

COURSE SUMMARY:

  • Create cell names and range names
  • Use cell names in formulas
  • Apply PMT, FV, IF,VLOOKUP functions
  • Create a Data Table
  • Apply custom borders and shading
  • Hide and unhide columns, rows, worksheets, and workbooks
  • Create an Excel table
  • Apply a table format
  • Sort data
  • Filter data
  • Subtotal data
  • Apply DATABASE, SUMF, COUNTIF functions
  • Create a multiple-sheet workbook
  • Create an Excel Template
  • Create formulas that refer to cells in another worksheet

COURSE: COMP 9904

45 hours, Noncredit
PREREQ.: COMP 9905

RECOMMEND: COMP 9900 Excel I
ADVISE: ESL Level 5/6

 

 

 

 

 

 

 

City College of San Francisco, CCSF John Adams Campus

Tuition Free computer classes in San Francisco

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: