Course Descriptions & Syllabi



Find complete words only

Table of Contents | Areas of Study | Business Office Systems | BOFF230 syllabus

Printer Friendy Version


COURSE NUMBER: BOFF230
COURSE TITLE:Excel II
DIVISION:Business
IAI CODE(S):
SEMESTER CREDIT HOURS:3.0
DELIVERY MODE:

COURSE DESCRIPTION:
An advanced course to develop skills in maintaining and enhancing worksheets and reports.  Topics include special effects, working with tables and data features, protecting workbooks, data validation, and Pivot Tables and Charts.  Consolidating data, outlines, macros, analysis tools, collaborating tools, and integrating applications will also be introduced.

PREREQUISITES:
BOFF225

NOTES:

COURSE OBJECTIVES / GOALS:
  • To acquaint students with the concept of:
    • Advanced Formatting
    • Advanced Functions
    • Working With Tables and Data Features
    • Summarizing and consolidating data
  • To acquaint students with the concepts of:
    • Using Excel Analysis Tools
    • Creating and using macros
    • Protecting and Sharing workbooks
    • Intergrating Excel with other offic programs and the web


TOPICAL OUTLINE:
  • Formating Techniques
    • Custom Formatting
    • Conditional Formatting
    • Filtering a worksheet
  •  Advanced Function and formulas
    •  PPMT, PV, NPV
    •  COUNTA, COUNTIF, COUNTIFS
    • SUMIF, AVERAGEIF
    • IF, VLOOKUP, HLOOKUP
    • AND, OR
  • Tables
    • Table Styles
    • Sorting and Filtering
    • Data Tools
    • Subtotaling
  •  Summarizing and Consolidating Data
    • Using range names
    • Linking ranges
    • Consolidate feature
    • Creating PivotTable and PivotChart
    • Sparklines
  • Using Data Analysis
    • Paste with Special Options
    • Goal seek
    • Scenario Manager
    • Data Tables
    • Auditing tools
  • Protecting and Sharing Workbooks
    • Creating and using comments
    • Sharing Workbooks
    • Protecting Worksheets and Workbooks
    • Tracking changes
  • Automating and Customizing Excel
    • Creating and using macros
    • Customizing Quick Access toolbar, ribbon and work area
    • Creating and using templates
  • Sharing Data
    • Importing data
    • Exporting data
    • Distributing workbooks
      • PDF documents
      • XPS documents
      • Web Page
      • Using a skydrive


TEXTBOOK / SPECIAL MATERIALS:
See bookstore website for current book at http://www.dacc.bkstr.com
Flash Drive

EVALUATION:
A point system will be used to determine student grades. Point values will be assigned to all homework, tests, projects, and final exam. The following percentages will be used in determining grades:

93%-100% =A
86%-92% =B
77%-85% =C
70%-76% =D
69%-Below =F

BIBLIOGRAPHY:

REVISION:
Fall 2012

RECORD UPDATED:
2012-12-11 10:16:00