Unit 4 Competency 3 - Perform spreadsheet applications in the context of the Human Services career cluster.

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 Download Microsoft_Excel_Tutorial.doc

Excel Basics

Getting Started with Excel Links to an external site.

Cell Basics Links to an external site.

Modifying Columns, Rows, and Cells Links to an external site.

Formatting Cells Links to an external site.

Saving Links to an external site.

Worksheet Basics Links to an external site.

Printing Links to an external site.

Excel 2010:  New Features Links to an external site.

Excel 2010:  Intro to Worksheets Links to an external site.

Excel 2010:  Cell References Links to an external site.

Excel 2010: Creating Workbooks Links to an external site.

Excel 2010: Cell Basics Links to an external site.

Excel 2010:  Format Cells Links to an external site.

Excel 2010: Modifying Cells, Rows, and Columns Links to an external site.

 

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 Links to an external site. immediately follows the videos.

Creating Simple Formulas Links to an external site.

Creating Complex Formulas Links to an external site.

Excel 2010:  Simple Formulas Links to an external site.

 Excel 2010:  Complex Formulas Links to an external site.

 

Suggested Objective c:  Demonstrate the use of basic spreadsheet functions

 

Working with Basic Functions Links to an external site.

Excel 2010: Basic Functions Links to an external site.

 

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

 

Common Tasks in Excel

Sorting Data Links to an external site.

Outlining Data Links to an external site.

Filtering Data Links to an external site.

Formatting Tables Links to an external site.

Excel 2010:  Filtering Data Links to an external site.

Excel 2010:  Sorting Links to an external site.

Excel 2010: Freeze Panes Links to an external site.

 

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 Links to an external site..  There are 20 questions on this quiz Links to an external site..  Write down your results and any possible questions you missed.  You will provide your quiz  Links to an external site.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.