BCA 121 - Introduction to Excel

1. Demonstrate understanding of the worksheet
   1. Practice how to open, save, close, and retrieve worksheet
   2. Enter text and numbers
   3. Select a range
   4. Use editing procedures
2. Apply formulas with correct cell references
   1. Use relative cell references
   2. Use absolute cell references
3. Use time-saving techniques
   1. Copy formulas with the fill handle
   2. Use AutoSum, AutoFit, AutoCalculate, and Styles
   3. Use Find and Replace
4. Format a Worksheet
   1. Select different font and type size
   2. Change width of columns and height of rows
   3. Demonstrate text attributes
   4. Apply colors, patterns, and borders
5. Utilize spell-check
   1. Activate the spelling checker
   2. Use the spelling dialog box
6. Choose appropriate actions needed to print a report
   1. List steps needed to print
   2. Show procedure for previewing
   3. Outline the available options when printing
   4. Choose appropriate print options
7. Create charts using charting tools
   1. Create a column chart and bar chart
   2. Create a pie chart
   3. Add data labels
   4. Annotate and draw on a chart
   5. Create sparklines
   6. Move an embedded chart to a sheet
   7. Add chart elements
   8. Format a chart
   9. Use Chart Styles
8. Generate formulas and functions
   1. Create formulas with operators
   2. Use functions - SUM, AVERAGE, MAXIMUM, MINIMUM, COUNT, and COUNTA
   3. Build a conditional formula with the IF function
   4. Use OR and NOT logical functions
   5. Use VLookup and HLookup functions
   6. Round a value using a function
   7. Construct formulas with named ranges
9. Use a table to manipulate and analyze data
   1. Sort table data
   2. Filter table data
   3. Summarize data
   4. Find and replace table data
   5. Extract table data
   6. Use Advanced Filter
10. Manage Workbook Data
    1. Freeze columns and rows
    2. Insert headers and footers
    3. Rename and move a worksheet
    4. Save workbooks in different file formats
    5. Save custom views of a worksheet
    6. Add worksheet backgrounds
    7. Group worksheets
    8. Consolidate data using 3-D references