CSA 110 - Spreadsheets: Microsoft Excel

1. Describe and demonstrate spreadsheet concepts in Excel.
2. Create simple formulas using Excel functions.
3. Format and print worksheets and data.
4. Create and format charts including graphics.
5. Plan, create and manage data using Excel’s List features.
6. Manage multiple worksheets and workbooks.
7. Perform workbook collaborations and non-interactive Web pages.
8. Develop an Excel application including data validation and creating macros.
9. Conduct data analysis using data tables and Scenario Manager.
10. Solve complex problems using Solver.
11. Import data from text files, database and queries into Excel.
12. Demonstrate advanced logical functions and filtering.
13. Customizing Excel.

1. Spreadsheet Concepts and Microsoft Excel
   1. Using Excel to manage data
   2. Worksheet navigation and design
   3. Developing a worksheet
   4. Entering and editing data
   5. Working with ranges, rows and columns
   6. Headers and footers
   7. Previewing and printing formulas and worksheets
2. Formulas and Functions
   1. Excel functions
   2. Relative and absolute references
   3. Paste options
   4. Insert function dialog box
3. Formatting Worksheets and Cells
   1. Font types and styles
   2. Cells and cell content
   3. Cell borders and backgrounds
   4. Rows and columns
   5. Background images and sheet tabs
   6. The printed worksheet
4. Working with Charts and Graphics
   1. Creating charts
   2. Embedded charts
   3. Chart styles and types
   4. Modifying a chart
   5. Formatting chart elements
   6. Adding sparklines
5. Working with Excel Lists
   1. Introduction to lists
   2. Planning and creating a list
   3. Creating a list range
   4. Sorting data
   5. Maintaining a list
   6. Auto filters and custom filters
   7. PivotTables, PivotChart, Slicer
6. Managing Multiple Worksheets and Workbooks
   1. Grouping worksheets
   2. Referencing cells and ranges
   3. Data consolidation
   4. Using templates
   5. Working with linked workbooks
   6. Using LookUp Tables
7. Collaborating on a Workbook and Web Page
   1. Auditing formulas
   2. Tracing and fixing errors
   3. Creating a shared workbook
   4. Tracking changes
   5. Merging workbooks
   6. Non-interactive Web pages
   7. Creating and using hyperlinks
   8. Saving a workbook as an XML file
8. Developing an Excel Application
   1. Validating data entry
   2. Protecting a worksheet and workbook
   3. Naming cells and ranges
   4. Working with macros
   5. Recording and running a macro
9. Data Tables and Scenario Management
   1. Cost-volume-profit analysis
   2. One and two-variable data tables
   3. Using array formulas
   4. Scenario manager
   5. Creating scenario reports
10. Using Solver for Complex Problems
    1. Finding a solution
    2. Creating a Solver answer report
    3. Solver models
11. Importing Data into Excel
    1. Importing text files
    2. Databases and queries
12. Advanced Functions and Filtering
    1. Excel’s logical functions
    2. Calculating conditional counts and sums
    3. Advanced filtering
    4. Working with financial functions
13. Customizing Excel
    1. Modifying screen elements such as the QAT, the ribbon, menu, and tabs
    2. Adding tabs to the ribbon
    3. Deleting screen elements
    4. Importing and exporting modification to the Excel screen elements