Embedded Files
To Download the Student Exercise Files to your Flash Drive, visit the website by clicking here
*Note: Your instructor most likely already did this for you in class.
Microsoft Excel
Microsoft Excel
This program is used to create spreadsheets with powerful mathematical formulas to help you calculate accurate numbers. This program is a perfect fit for anyone looking to organize information, create a budget, make attractive charts, or play around with numbers!
In the textbook, you will learn how to navigate in Excel, Create a new Spreadsheet, Freeze Panes, Enter Data, Edit Data, Align Cells, Move & Copy Data, Sort Data, Insert & Delete Rows and Columns, Learn New Formulas, Use Built-In Functions, Copy Formulas & Functions, Create Charts and Use the Design Tool.
Lesson 5: Tracking Firefighter Training
Lesson 5: Tracking Firefighter Training
By the end of this lesson, you will be able to:
- Understand Excel
- Understand What a Cell is
- Understand What a Worksheet is
- Navigate in a Spreadsheet
- Freeze Panes
- Enter Data in a Spreadsheet
- Edit in Excel
- Align Cell Content
- Move & Copy Data
- Sort Data
- Resize Rows & Columns
- Insert a Row & Column
- Save an Excel File
- Print a Spreadsheet
Lesson 6: Budgeting with Calculations and Charts
Lesson 6: Budgeting with Calculations and Charts
By the end of this lesson, you will be able to:
- Define Formulas
- Create Simple Formulas
- Use Built-In Functions
- Utilize AutoSum
- Calculate with AVERAGE, MAX, and MIN
- Copy Formulas and Functions
- Use Charts to Visualize Data
- Use Design Tools
- Format the Text in a Spreadsheet / Cell
- EXTRA: Using Templates in Excel
EXCEL Competency Sheet &
EXCEL Competency Sheet &
Final Projects:
Final Projects:
Excel Competency Sheet:
Excel Competency Sheet:
Excel Final Project: Check Registry Project
Excel Final Project: Check Registry Project
Report abuse