Learn Key Computer Applications – FREE

This is an open enrollment course.

Due to the fact that there is NO CHARGE for this course, you must be added to the roster to attend.

Please register online or call 512-610-7600 to be added.

** Also due to this course being free and attendance set at 16, individuals who are on the roster to attend and do not show up will NOT be allowed to any future free classes.

Course Objective: You will create, edit, and enhance standard business documents using Microsoft® Office 2010.

Target Student: This course is intended for individuals who want to gain basic knowledge of working in Microsoft® Office 2010.

Course Objectives: Upon successful completion of this course, students will be able to:

    • Create a basic document using Microsoft Word.
    • Edit documents by locating and modifying text.
    • Format text.
    • Format paragraphs.
    • Add tables to a document.
    • Explore the Microsoft® Office Excel® 2007 environment and create a basic worksheet.
    • Perform calculations.
    • Modify a worksheet.
    • Format a worksheet.
    • Print workbook contents.
    • Organize worksheet and table data using various techniques.
    • Create and modify charts.
    • Get started with PowerPoint.
    • Create a presentation.
    • Format text on slides.

 

Course Content

Lesson 1: Creating a Basic Document
Topic 1A: Explore the User Interface
Topic 1B: Open and View a Document
Topic 1C: Customize the Word Environment
Topic 1D: Obtain Help
Topic 1E: Enter Text
Topic 1F: Save a Document
Topic 1G: Preview and Print a Document

Lesson 2: Editing a Document
Topic 2A: Navigate and Select Text in a Document
Topic 2B: Insert, Delete, or Rearrange Text
Topic 2C: Undo Changes
Topic 2D: Search and Replace Text

Lesson 3: Formatting Text
Topic 3A: Change Font Appearance
Topic 3B: Highlight Text

Lesson 4: Formatting Paragraphs
Topic 4A: Set Tabs to Align Text
Topic 4B: Control Paragraph Layout
Topic 4C: Add Borders and Shading
Topic 4D: Apply Styles
Topic 4E: Create Lists
Topic 4F: Manage Formatting

Lesson 5: Adding Tables
Topic 5A: Create a Table
Topic 5B: Modify the Table Structure
Topic 5C: Format a Table
Topic 5D: Convert Text to a Table or Tables to Text

Lesson 6: Creating a Basic Worksheet
Topic 6A: Explore the User Interface and the Ribbon
Topic 6B: Navigate and Select in Excel
Topic 6C: Obtain Help
Topic 6D: Enter Data and Save a Workbook
Topic 6E: Customize the Quick Access Toolbar

Lesson 7: Performing Calculations
Topic 7A: Create Basic Formulas
Topic 7B: Calculate with Functions
Topic 7C: Copy Formulas and Functions

Lesson 8: Modifying a Worksheet
Topic 8A: Manipulate Data
Topic 8B: Insert and Delete Cells, Columns, and Rows

Lesson 9: Formatting a Worksheet
Topic 9A: Modify Fonts
Topic 9B: Add Borders and Color to Cells
Topic 9C: Change Column Width and Row Height
Topic 9D: Apply Number Formats
Topic 9E: Position Cell Contents
Topic 9F: Apply Cell Styles

Lesson 10: Printing Workbook Contents
Topic 10A: Print Workbook Contents Using Default Print Options
Topic 10B: Set Print Options
Topic 10C: Set Page Breaks

Lesson 11: Organizing Worksheet and Table Data
Topic 11A: Create and Modify Tables
Topic 11B: Format Tables
Topic 11C: Sort or Filter Worksheet or Table Data

Lesson 12: Presenting Data Using Charts
Topic 12A: Create a Chart
Topic 12B: Modify Charts
Topic 12C: Format Charts

Lesson 13: Getting Started with PowerPoint
Topic 13A: Explore the User Interface
Topic 13B: Navigate and View a Presentation
Topic 13C: Use Microsoft PowerPoint Help
Topic 13D: Enter Text
Topic 13E: Save a Presentation

Lesson 14: Creating a Presentation
Topic 14A: Create a Presentation
Topic 14B: Edit Text
Topic 14C: Add Slides to a Presentation
Topic 14D: Arrange Slides
Topic 14E: Work with Themes

Lesson 15: Formatting Text on Slides
Topic 15A: Apply Character Formats
Topic 15B: Apply Paragraph Formats
Topic 15C: Format Text Placeholders

Prerequisites:

Students should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. Students should have completed the following courses or possess equivalent knowledge before starting with this course: Computing Fundamentals