Content Based Standards

Competency Based Standards

The Excel Environment II

The worksheet

• Cell ranges
• Referencing arrays of cells

Manipulating data

• Importing data
• Import text wizard
• Quickly entering lists of data
  • Comma separated lists

Worksheet

• ranges and table arrays

Formatting Spreadsheets II

• Editing cells
  • Inserting cells options
  • Deleting cells
  • Merging cells
• Moving data
  • Paste options (the suitcase)
  • Paste special
  • Pasting absolute formulas
• Formatting tables of data
  • Using preset table formats
  • Changing table colors
  • Changing table design
  • Creating professional table designs
• Formatting data
  • Conditional formatting of data
    • Single condition
    • Identical conditions
    • Multiple conditions
  • Using the find and replace functions in excel
    • The find operation
    • The find and replace operation
  • Styles for cells
    • Normal comma
    • Currency
    • Percent
    • icons on the formatting toolbar
    • the format cells menu
  • Working with dates
    • The datevalue() function
    • The datevalue() function II
  • Creating your own styles
  • Auto formatting
  • The format painter
• Cell Comments
  • Adding comments
  • Editing comments
  • Copy comments
  • Removing comments
• Adding text boxes to cells
• Graphic objects
  • Adding Images to cells
    • Inserting and image
    • Moving an image
    • Formatting and image
    • Rotating an image
    • Resizing an image
  • Adding word art to cells
    • formatting word art
  • insert clipart
  • modify clipart
  • group graphic objects
  • Change the order of graphic objects
• Creating a freeze pane
• Using split screen to display separated data

Worksheets

• Creating cell format designs
• formatting data
• Working with word art
• Working with clip art
• Working with images

Project

• A custom calendar
• Seasonal product data sheet

Worksheets

• Switching between worksheets
• Formatting worksheet tabs
• Moving worksheets
• Copying worksheets
• Adding worksheets
• Removing worksheets

Functions and formulas II

• Formula II
  • Good formula
  • Copy and paste formulas
• Functions II
  • The function wizard
  • The Count() function
  • The Slope() function
  • The Intercept function
  • The Interpolate() function
  • The Forecast() function
  • The Correl() function
• Using conditional logic
  • The IF function
    • Conditional statements
    • Conditional tests
    • Using multiple conditions
  • Creating nested IF functions
• Merge data
• Separate text into columns
• Changing text to uppercase
• Date and time functions
• Entering the current date and time
• Entering formulas directly in to cells

Functions and Formulas II

• Use column headings in formulas
• Using formulas that span workbook pages

Worksheets

• Creating functions
• Working with functions

Projects

• My First Budget

Working With Charts II

Graphing data II

• Creating bar charts
• Creating pie charts

Charts II

• Formatting charts
  • Changing chart subtypes
  • Changing data range
  • Time scale data plotting
  • Changing the data series plot order
  • Adjusting perspective in 3d charts
  • Custom chart types
  • Rotating charts
  • Resizing charts
  • Positioning carts
• Creating trend lines
  • First order
  • Second order
  • Polynomial
  • Exponential
• Multiple scatter plots
• Printing charts

Printing

• Page set up
• Set print options
• Print selections
• Print workbooks and worksheets

Auditing spread sheets

• Auditing spreadsheets
• The formular auditing toolbar
• Tracing precedent and dependent cells
• Tracing errors
• Error checking
• Using the watch window
• Cell validation

Outlining spread sheet

• Using outlines
• Applying outlines
• Removing outlines

Consolidating spreadsheets

• Using data consolidation
• Types of consolidation

Forecasting Data

• Risks and benefits of forecasting data
• Why forecast data in business
• Forecasts using formulas
  • Creating forecasts from existing data
  • Forecasts from best case middle case and worst case scenarios
• Forecasts using  moving averages (line of best fit)
  • Calculating moving averages
  • Charting moving averages
  • Creating interactive charts

Introduction to solver

Data Analysis

• Using "what if" analysis
• Creating tables of results
• Writing formulas based on values that meet specific conditions
• Using the report manager to generate reports on scenarios