Microsoft

CSI 1200 - Introduction to Computing and programming with Excel

(OU-CSI1200.AI3)
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Introduction

2

Fundamentals

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

Creating worksheets

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

Formatting

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

Manipulating data

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

Charts

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

Output

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

Settings and templates

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

Introduction

10

Managing workbooks

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

Named ranges

  • Module A: Using names in formulas
  • Summary
12

Tables

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

Summarizing data

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

PivotTables

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

Presentation features

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

Advanced charts

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

Collaboration

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

Introduction

19

Logical and Lookup Functions

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

Advanced Formulas

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

Special functions

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

Importing and Exporting

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

Analysis

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

Macros and Forms

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

Appendix: Exam Objective MO-201

  • Exam Objective

1

Fundamentals

  • Saving a Workbook
2

Creating worksheets

  • Creating a New Workbook
  • Performing Calculations with Formulas
  • Entering a Function
  • Using Relative, Absolute, and Mixed References
3

Formatting

  • Changing the Date Format
  • Formatting Numbers
  • Merging a Heading
  • Applying a Theme
4

Manipulating data

  • Deleting and Editing the Cell Content
5

Charts

  • Creating a Simple Chart
  • Changing the Chart Color
  • Changing the Chart Style
  • Editing a Legend in the Chart
  • Creating a Column Chart and Switching its Rows and Columns
6

Output

  • Splitting a Large Worksheet
  • Setting Page Margin
  • Setting and Saving the Print Area
  • Adding a Header
  • Saving a Workbook as a PDF File
7

Settings and templates

  • Checking Compatibility
  • Creating a Workbook from a Template
8

Managing workbooks

  • Inserting Hyperlink to an Image
9

Named ranges

  • Creating Names for Cell Ranges
  • Editing Names
10

Tables

  • Sorting Data
  • Sorting by Multiple Columns
  • Filtering Data 
  • Formatting Data as a Table
  • Creating Formulas Using Structured References
11

PivotTables

  • Creating a PivotTable Automatically
12

Presentation features

  • Inserting WordArt
  • Inserting SmartArt
13

Advanced charts

  • Customizing Sparklines
14

Collaboration

  • Adding Comments
  • Merging Shared Workbooks
15

Logical and Lookup Functions

  • Using the IF Function
  • Using the SUMIF Function 
  • Using the SUMIFS Function
  • Using VLOOKUP
  • Using the MATCH Function
16

Advanced Formulas

  • Using an Array Formula
  • Using an Array Function
17

Special functions

  • Performing Calculations Using Date Functions
  • Performing Simple Time Calculations
  • Using the Concatenate Function
  • Calculating the Minimum and Maximum Sales Value
18

Importing and Exporting

  • Importing Data from a File
  • Exporting to a Text File
19

Macros and Forms

  • Creating a Blank Form

Related Courses

All Courses