CSA 110 - Spreadsheets: Microsoft Excel

1. Describe and demonstrate spreadsheet concepts in Excel.
2. Construct  formulas using Excel functions.
3. Format and print worksheets, data, charts and graphics
4. Manage multiple worksheets and workbooks.
5. Develop an Excel application including data validation and macros.
6. Conduct data analysis using data tables.
7. Demonstrate the use of advanced logical functions,filtering and lists.

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
   6. Securing considerations for macros
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