Microsoft Excel Unit

We will be using Microsoft Excel to learn about spreadsheets. Most of the lessons and video will come from www.gcflearnfree.org so be sure to study and review at any time.

Test/Quizzes are in RED

A - Excel Basics

  1. Practice - Age Calculator
  2. Lesson - Getting Started with Excel
  3. Lesson - Cell Basics
  4. Lesson - Modifying Columns, Rows, and Cells
  5. Lesson - Formatting Cells
  6. Lesson - Saving
  7. Lesson - Creating Simple Formulas
  8. Lesson - Double Check your Formulas
  9. Lesson - Worksheet Basics
  10. Lesson - Printing
  11. Assignment - IHS DataQuest - Video
  12. QUIZ - Excel Basics

B - Common Tasks in Excel

  1. Lesson - Creating Complex Formulas
  2. Lesson - Working with Basic Functions
  3. Lesson - Outlining Data
  4. Lesson - Sorting Data
  5. Lesson - Filtering Data
  6. Lesson - Formatting Tables
  7. QUIZ - Common Task

C - Doing More With Excel

  1. Lesson - Reviewing and Sharing Workbooks
  2. Lesson - Using Templates
  3. Lesson - Working with Charts
  4. Assignment - Endangered Mammals
  5. Assignment - Chart Creation - Video
  6. Lesson - Working with Chart Data Source
  7. Lesson - Using Conditional Formatting
  8. Lesson - Working with Sparklines
  9. Lesson - Creating PivotTables
  10. Lesson - Using What-If Analysis
  11. QUIZ - Doing More with Excel

D. Excel Project

E. Exam