CA 118B Excel Basics

Lecture Hours: 3
Credits: 3

Introduces building and editing worksheets, formatting and printing worksheets, working with formulas and functions, and charting in MS Excel. Introduces sorting, filtering, and analyzing list data; enhancing worksheets and charts; and sharing MS Excel files. Includes what-if analysis, macros, PivotTables and PivotCharts, linking, embedding, and exploring MS Excel options.

Prerequisite: BA 131, CA 100 or CIS 101 with a grade of C or better; or consent of instructor.
Student Learning Outcomes:

Create, edit, and print basic worksheets.
Use basic formulas and functions.
Format, modify, and enhance basic worksheets and charts.
Use lists to filter and extract data.
Share files with multiple users.
Manage workbooks and prepare them for Web deployment.
Create simple what-if analyses, PivotTables, and PivotCharts.
Import, export, and link data.
Identify the purpose of Excel options and other features, such as macros.
Independently create a worksheet and chart containing appropriate formulas, functions, and formatting.

Content Outline

Creating, Navigating, and Printing a Spreadsheet
Editing, Copying, and Moving Cell Entries
Using Formulas and Functions
Formatting and Modifying Worksheets
Using Charting Features
Enhancing Worksheets
- Adding, reviewing, and hiding comments
- Making appropriate format choices
Enhancing Charts
- Customizing chart types
- Customizing a data series
- Formatting a chart axis
- Creating data tables
- Enhancing charts with rotation, WordArt, and pictures
Analyzing List Data
- Planning and creating a list
- Finding and deleting records
- Auto Filtering and custom filter
- Sorting, extraction, and printing list data
- Creating subtotals and using grouping
- Applying basic look-up values
Basic Sharing of Excel Files
- Methods of sharing files
- Share workbooks with multiple users
- Share workbooks on the web
- Simple tracking of revisions
Managing Workbooks and Web Preparation
- Freezing, hiding, protecting worksheet areas
- Applying page breaks and numbering
- Creating simple hyperlinks
- Saving as a basic web page
Using Basic What-If Analyses
- Using Scenario Manager
- Creating a two-input data table
Macros
- Planning, recording, and running a simple macro
- Creating shortcut keys for macros
Analyzing Data
- Creating a PivotTable
- Creating a PivotChart
Exchanging Data with Other Programs
- Importing and exporting data
- Linking and embedding
Exploring Excel Options
- Locating Excel options
- Recognizing purpose of Excel options