Skip to main content
Western Kentucky University
EMERGENCY ALERT SYSTEM:

WKU WEATHER ALERT:

Classes beginning at 4pm today on the WKU Bowling Green campus are canceled. ALL Thursday and Friday classes on all campuses are also canceled. Online classes will proceed as scheduled. WKU offices will be closed on Thursday, with essential personnel reporting.

WKU Owensboro closed at noon today (Wed., 3/4).

WKU Glasgow evening classes that begin at 5 pm today will be canceled and the WKU Glasgow campus will close at 7 pm.

WKU Elizabethtown-Fort Knox campus will close today at 3 pm and will remain closed Thurs., Fri, and Sat., March 5-7.

Should inclement weather make travel hazardous, residence halls will remain open until Saturday. Follow WKU Housing & Residence Life for updates.

The high school regional basketball tournament games scheduled for tonight have been canceled. Games will be rescheduled for Friday/Saturday. Follow WKU News for the latest updates. #WKUAlert

CWD: Courses: Computer

Print this page

Introduction to Excel 2010

Session Format:

4 Hours Total

Introduction

This course provides the student the foundation needed to utilize a spreadsheet for business applications. Design concepts, databases, charts and macros will be examined thoroughly along with the major built-in functions. Students will design several spreadsheets both in and out of class to solve specific business problems.

Content Outline

  • Getting Started:
    • Understanding the Quick Access Toolbar
    • Backstage View
    • Working with the Ribbon Bar, Tabs and Groups
    • Understanding the Excel Window and Learning what the 7 different shapes of the mouse means in Excel
  • Creating a Workbook with Labels, Values, and Formulas. Entering Data using the AutoFill Handle
  • Introduce the formula auditing Icons

  • Working with Simple Functions. AutoSum, Average, Maximum, Minimum and Date

  • Learning the Additional features of the Auto Fill Handle

  • Saving a Workbook and the different formats to save in

  • Working with Rows and Columns

    • Inserting and Deleting Rows and Columns

    • The Different ways to Adjust the Row Height and Width

  • Working with Worksheets

    • Inserting, Deleting, Naming, Moving and Copying Worksheets

  • Cut, Copying and Pasting Data

  • Formatting a Worksheet and Working with the AutoFormat Command

    • Borders, Shading, Fonts, Currency Formatting, Merge and Center, Aligning Text

    • Clearing Formats

  • Page Layout:

    • Page Orientation, Margins, Scaling, Gridlines

    • Adding Headers and Footers

  • Working with Excel Views

    • Print Layout

    • Page Break Preview- How to Control how the Page Breaks

  • Print Preview and Printing a Workbook, Worksheets

Who Should Attend

This seminar is intended for individuals who are just beginning to use electronic spreadsheets in Excel 2010.

SIMPSON Co. Consortium Training

 

Note: documents in Portable Document Format (PDF) require Adobe Acrobat Reader 5.0 or higher to view,
download Adobe Acrobat Reader.

Note: documents in Excel format (XLS) require Microsoft Viewer,
download excel.

Note: documents in Word format (DOC) require Microsoft Viewer,
download word.

Note: documents in Powerpoint format (PPT) require Microsoft Viewer,
download powerpoint.

Note: documents in Quicktime Movie format [MOV] require Apple Quicktime,
download quicktime.

 
 Last Modified 9/25/14