Primary Navigation
Want to create or adapt books like this? Learn more about how Pressbooks supports open publishing practices.
Book Contents Navigation
Week 1 Overview
Week 1 Learning Materials
Week 2 Overview
Week 2 Learning Materials
Week 3 Overview
Week 3 Learning Materials
Week 4 Overview
Week 4 Learning Materials
Week 5 Overview
Week 5 Learning Materials
Week 6 Overview
Week 6 Learning Materials
Course Lab Overview
Week 1 Lab - Personal Monthly Budget Worksheet
Week 2 Lab - Starting Inventory Worksheet
Week 3 Lab - Overhead Cost Analysis
Week 4 Lab - Food Cost Analysis
Week 5 Lab - Pricing Analysis
Week 6 Lab - Financial Analysis
Excel Workbooks
Launching Excel (Video)
Excel Worksheet Management
Worksheet Management (Video)
Ribbon and Toolbars
Ribbon and Toolbar (Videos)
Column and Rows
Columns and Rows (Video)
Cells
Cells (Videos)
Cell Formatting
Multiple Examples of Cell Formatting, Alignment, and Actions (Videos)
Entering Data
Entering Data (Video)
Basic Formulas
Basic Formulas (Video)
AutoSum
AutoSum (Video)
Printing Worksheets
Print Preparation (Video)
Format Painter
Format Painter (Video)
Inserting and Deleting Column and Rows
Inserting and Deleting Column and Rows (Video)
Comma and Monetary Styles
Comma and Monetary Styles (Video)
Relative References (Copy and Paste Formulas)
Relative References (Copy and Paste Formulas) (Video)
Function Basics
Function Basics (Video)
SUM Function
SUM Function (Video)
MAX and MIN Functions
MAX and MIN Functions (Video)
Functions: AVERAGE
Functions: AVERAGE (Video)
Chart Basics
Chart Basics (Videos)
Column Charts
Column Chart (Videos)
Pie Charts
Pie Charts (Videos)
Insert / Delete / Group Worksheets
Deleting, Grouping, and Freezing Panes (Videos)
Tables
Tables (Video)
Sort and Filter
Sort and Filter (Video)
PEMDAS, The Mathematical Order of Operations
PEMDAS, The Mathematical Order of Operations (Video)
COUNT and COUNTA Statistical Functions
COUNT and COUNTA Statistical Functions (Video)
Worksheet Management – Moving and Copying worksheets
Moving and Copying an Excel Worksheet (Video)
Absolute Cell References
Absolute Cell Reference - Video
Functions for Personal Finance
Functions (Video)
Chart Formatting
Chart Formatting (Video)
H5P Testing
“Excel PMT() Function Basics” by Peter Casey. Retrieved from: https://youtu.be/yoqXEkuPSAs Standard YouTube license.
Previous/next navigation
COM112 – Fundamentals of Spreadsheets Copyright © by The American Women's College. All Rights Reserved.