Indiana University Southeast

Jeff Barnes, Adjunct Faculty
Academic Homepage

http://homepages.ius.edu/jesbarne | jesbarne@ius.edu | (812) 207-6045

Home | Excel (Old Book)


A212 - Spreadsheet Applications (Excel)


Excel Links:


 

About this Class
This course introduces the student to spreadsheet techniques used in creating professional looking worksheets. The student will use formulas, functions, charts, graphs, and logical functions.  Advanced topics include the use of database functions, advanced filtering, importing data into a spreadsheet, creating pivot tables, integrating the features of Excel with other software applications, and enhancing Excel with Visual Basic for Applications.

This class assumes familiarity with Windows and file management. If you need to brush up on it, the first 2 chapters of the book are an excellent tutorial.  You can also review the Office and File Management tutorials in the Document Library.

You'll need a USB drive (thumb drive) for the class. You don't need a large (expensive) drive - the student data files are less than 64 MB.  Instructions on copying the files to your thumb drive can be found in the Document Library.

Optional Software:  Microsoft Office 2007.  It is not required that you purchase this software. It is available in the computer labs on campus. However, if you wish to purchase Microsoft Office 2007, check with the University bookstore as it carries the complete version at a very nominal price (which you won’t see anywhere else).

Course Objectives

  • Create and format an Excel Worksheet and Workbook.

  • Create and manage multiple Worksheets and Workbooks.

  • Create and analyze charts and graphs.

  • Create and use a template.

  • Solve complex problems using Excel.

  • Create data tables and scenario

  • Integrate Excel with other applications.

  • Create custom formats with Excel.

  • Develop pivot tables for the WWW.

  • Enhance Excel with Visual Basic for Application code.

Course Outline
The purpose of this course is to provide you with a comprehensive understanding of the basics to more advanced features of the latest version of Excel, from creating professional-looking workbooks to using templates, creating multiple worksheets, and developing customized applications with macros and Visual Basic. 

By the end of this class, you will understand:

  • Managing Your Files

  • Using Common Features of Microsoft Office 2003

  • Using Excel to Manage Data

  • Working with Formulas and Functions

  • Developing a Professional-Looking Worksheet

  • Working with Charts and Graphics

  • Working with Excel Lists

  • Working with Multiple Worksheets and Workbooks

  • Working with Excel's Editing and Web Tools

  • Developing an Excel Application

  • Data Tables and Scenario Management

  • Using Solver for Complex Problems

  • Importing Data into Excel

  • Enhancing Excel with Visual Basic for Applications

  • Working with Logical Functions, Database Functions, and Advanced Filtering

  • Integrating Excel with Other Windows Programs

  • Creating Custom Formats

  • Saving PivotTables in HTML Format

Class Participation
Class participation is a portion of your grade. You are encouraged to arrive on time and actively participate in class. Your will learn more. Please check for changes and updates to the class with a classmate if you miss a class.

 

Time Management
It is advised that you set aside time each day/week to complete the assigned material for the course. In-class time will be used for lecture, working through the lab material, questions and answers.

 


IU seal, red on white, small

Jeff's Links:

IUS Links:

IU Links:


Block IU Copyright © 2009. All rights reserved.  Any duplication of ideas or logos strictly prohibited without permission.
Last updated: 12/31/2011 09:51:09 -0500 | Please send any comments to: jesbarne@ius.edu
Indiana University Southeast | 4201 Grant Line Rd. New Albany, IN 47150 | (812) 941-2333 | Contact Us

Emergency Information | Campus Police | Maps