Suggested Objective a: Demonstrate the use of basic spreadsheet format and edit commands

As you have already learned, Excel is a spreadsheet program that is great for number crunching or solving mathematical problems. You can graph and create charts to make information visually appealing. Let's learn how to use Excel. Open the various documents provided below and take notes. You may even watch many videos to help you learn how to use Excel.

Microsoft_Excel_Tutorial.doc

Excel Basics

Getting Started with Excel

Cell Basics

Modifying Columns, Rows, and Cells

Excel 2010: New Features

Excel 2010: Intro to Worksheets

Excel 2010: Cell References

Excel 2010: Creating Workbooks

Excel 2010: Cell Basics

Excel 2010: Format Cells

Excel 2010: Modifying Cells, Rows, and Columns

Suggested Objective b: Demonstrate the use of basic spreadsheet formulas

We have learned some basic and a few advanced features of using Excel 2010. With this section let's take some time to learn how to use formulas and functions in Excel. Click the links below to see the written and picture instructions from GCF Learn Free as well as few videos on this topic. Be sure to take notes as you look at the information. The Excel quiz from GCF Learn Free immediately follows the videos.

Creating Simple Formulas

Creating Complex Formulas

Excel 2010: Simple Formulas

Excel 2010: Complex Formulas

Suggested Objective c: Demonstrate the use of basic spreadsheet functions

Working with Basic Functions

Excel 2010: Basic Functions

Suggested Objective d: Demonstrate other basic spreadsheet commands including sorting and filtering

Common Tasks in Excel

Sorting Data

Outlining Data

Filtering Data

Formatting Tables

Excel 2010: Filtering Data

Excel 2010: Sorting

Excel 2010: Freeze Panes

You have had time to learn about Excel by viewing many written and picture instructions as well as watching videos. Click the link to take GCF Learn Free Excel Quiz. There are 20 questions on this quiz. Write down your results and any possible questions you missed. You will provide your quiz results and the questions you missed in an upcoming assignment. Before you leave this page and the quiz, make sure that you review and understand any items you missed. You need to understand all of the concepts to complete successfully our Excel assignments.