|
Aug 31, 2024
|
|
|
|
2024-2025 College Catalog
|
CSA 110 - Spreadsheets: Microsoft Excel 3 Credits, 4 Contact Hours 2 lecture periods 2 lab periods Fundamentals of spreadsheet applications using Microsoft Excel. Includes spreadsheet concepts, formulas and functions, formatting worksheets and cells, working with charts and graphics. Also includes Excel lists, managing multiple worksheets and workbooks, collaborating on a workbook, developing an Excel application, data tables and Scenario management, using Solver, importing data, and advanced functions and filtering.
Prerequisite(s): Required score on the Mathematics assessment test. Recommendation: Basic computer skills, completion of WRT 101 , REA 091 or required score on the assessment test before enrolling in this course. If any recommended course is taken, see a financial aid or Veteran’s Affairs advisor to determine funding eligibility as appropriate.
![button image Prior Learning and link to PLA webpage](/mime/media/12/1358/button_prior-learning%20(2).png)
Course Learning Outcomes
- Describe and demonstrate spreadsheet concepts in Excel.
- Construct formulas using Excel functions.
- Format and print worksheets, data, charts and graphics
- Manage multiple worksheets and workbooks.
- Develop an Excel application including data validation and macros.
- Conduct data analysis using data tables.
- Demonstrate the use of advanced logical functions,filtering and lists.
Outline:
- Spreadsheet Concepts and Microsoft Excel
- Using Excel to manage data
- Worksheet navigation and design
- Developing a worksheet
- Entering and editing data
- Working with ranges, rows and columns
- Headers and footers
- Previewing and printing formulas and worksheets
- Formulas and Functions
- Excel functions
- Relative and absolute references
- Paste options
- Insert function dialog box
- Formatting Worksheets and Cells
- Font types and styles
- Cells and cell content
- Cell borders and backgrounds
- Rows and columns
- Background images and sheet tabs
- The printed worksheet
- Working with Charts and Graphics
- Creating charts
- Embedded charts
- Chart styles and types
- Modifying a chart
- Formatting chart elements
- Adding sparklines
- Working with Excel Lists
- Introduction to lists
- Planning and creating a list
- Creating a list range
- Sorting data
- Maintaining a list
- Auto filters and custom filters
- PivotTables, PivotChart, Slicer
- Managing Multiple Worksheets and Workbooks
- Grouping worksheets
- Referencing cells and ranges
- Data consolidation
- Using templates
- Working with linked workbooks
- Using LookUp Tables
- Collaborating on a Workbook and Web Page
- Auditing formulas
- Tracing and fixing errors
- Creating a shared workbook
- Tracking changes
- Merging workbooks
- Non-interactive Web pages
- Creating and using hyperlinks
- Saving a workbook as an XML file
- Developing an Excel Application
- Validating data entry
- Protecting a worksheet and workbook
- Naming cells and ranges
- Working with macros
- Recording and running a macro
- Securing considerations for macros
- Data Tables and Scenario Management
- Cost-volume-profit analysis
- One and two-variable data tables
- Using array formulas
- Scenario manager
- Creating scenario reports
- Using Solver for Complex Problems
- Finding a solution
- Creating a Solver answer report
- Solver models
- Importing Data into Excel
- Importing text files
- Databases and queries
- Advanced Functions and Filtering
- Excel’s logical functions
- Calculating conditional counts and sums
- Advanced filtering
- Working with financial functions
Effective Term: Fall 2023
|
|