Excel I & II with Jack Robert Daley


Microsoft Excel for Business I

COMP 9900 – Microsoft Excel for Business I with Jack Robert Daley

Course summary:

  • Introduction to Excel…

  • Format cells in a worksheet

  • Apply a theme to a workbook

  • Create an embedded 3-D Clustered Column chart

  • Apply SUM, AVERAGE, MAX, and MIN functions

  • Create formulas using the keyboard and point mode

  • Verify a formula using Range Finder

  • Use a web query to get real-time data from a web site

  • Design conditional formatting for cells

  • Create absolute cell references in formulas

  • Use the IF function to perform a logical test

  • Create a 3-D Pie chart on a separate chart sheet

  • Answer what-if questions

  • Use Goal Seek to answer what-if questions

  • And, more…

45 hours, Noncredit
PREREQ.: COMP 9905
ADVISE: ESL Level 5/6

COMP 9904 – Excel for Business II with Jack Robert Daley

Course summary:

  • Sort data

  • Filter data

  • Subtotal data

  • Apply IF, VLOOKUP, DATABASE, SUMIF, COUNTIF functions

  • Create a Data Table

  • Apply a table format

  • Query a table

  • Hide and unhide columns, rows, worksheets, and workbooks

  • Protect and unprotect cells in a worksheet

  • Create cell names and range names

  • Use cell names in formulas

  • Apply custom borders and shading

  • Insert and move  page breaks

  • Apply MATCH, INDEX and ROUND functions

  • Create an amortization schedule

  • Apply PMT (Monthly Payment), PV (Present Value), FV (Future Value) functions

  • Create an Excel Template

  • Create a multiple-sheet workbook

  • Create formulas that refer to cells in another worksheet or another Excel workbook file

  • And, more…

45 hours, Noncredit
PREREQ.: COMP 9905, Skills equal to Excel for Business I
ADVISE: ESL Level 5/6

Advertisements

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: