CSI 1200 - Introduction to Computing and programming with Excel

Introduction

Fundamentals

• Module A: Getting around
• Module B: Workbook basics
• Summary

Creating worksheets

• Module A: Entering data
• Module B: Formulas
• Module C: Functions
• Module D: Moving and copying data
• Module E: Reference types
• Summary

Formatting

• Module A: Text formatting
• Module B: Number formatting
• Module C: Alignment
• Module D: Borders and highlighting
• Module E: Styles and themes
• Summary

Manipulating data

• Module A: Data entry shortcuts
• Module B: Paste options
• Module C: Inserting, deleting, and hiding
• Summary

Charts

• Module A: Creating charts
• Module B: Chart types and elements
• Summary

Output

• Module A: Managing worksheet windows
• Module B: Printing worksheets
• Module C: Sharing workbooks
• Summary

Settings and templates

• Module A: Workbook options and properties
• Module B: Templates
• Summary

Introduction

Managing workbooks

• Module A: Managing worksheets
• Module B: Customizing Excel
• Summary

Named ranges

• Module A: Using names in formulas
• Summary

Tables

• Module A: Sorting
• Module B: Filtering tables
• Module C: Structured references
• Module D: Validation
• Module E: Transposing data
• Summary

Summarizing data

• Module A: Consolidation
• Module B: Subtotals
• Summary

PivotTables

• Module A: Creating and formatting PivotTables
• Module B: Manipulating PivotTables
• Module C: PivotCharts
• Summary

Presentation features

• Module A: Conditional formats
• Module B: Custom Formats
• Module C: Graphics
• Summary

Advanced charts

• Module A: Special chart types
• Module B: Sparklines
• Module C: Quick Analysis
• Summary

Collaboration

• Module A: Permissions
• Module B: Shared workbooks
• Summary

Introduction

Logical and Lookup Functions

• Module A: Decision-making functions
• Module B: Lookup and reference functions
• Summary

Advanced Formulas

• Module A: Auditing and error-trapping
• Module B: Formula options
• Module C: Arrays
• Summary

Special functions

• Module A: Date and time functions
• Module B: Text functions
• Module C: Other functions
• Summary

Importing and Exporting

• Module A: The Power Pivot Data Model
• Module B: Exporting data
• Summary

Analysis

• Module A: What-if analysis
• Module B: The Analysis Toolpak
• Summary

Macros and Forms

• Module A: Recording macros
• Module B: Running macros
• Module C: Forms
• Summary

Appendix: Exam Objective MO-201

• Exam Objective