Class Syllabus: Introduction to MS Excel
Join Now | Sign In | Shopping Cart
UniversalClass™ - Why not learn something new today?

Class Syllabus: Introduction to MS Excel

Request More Information
Tell a Friend
Office Hours: Continuous
Course Meeting Times: Continuous
 

Course Description

Excel 2003
Whether you've used MS Excel before and just want to learn more about Excel 2003 or are completely new to the program, this course is designed to teach you the features of MS Excel 2003 to have you using it like a pro.  

It's a fact that a lot of people just like you shy away from learning MS Excel because it seems so complicated. Those who do eventually use it only know certain aspects of the program and are not aware of all it can do. But there's good news for you! MS Excel 2003 is even easier to use that past versions with more toolbars and commands to simplify even the hardest of tasks. 

This course is designed to walk you through MS Excel 2003, showing you how to use this popular spreadsheet program to do anything from making a list to calculating complex equations in a simple and easy-to-understand manner. We promise you that even if you've never used a spreadsheet program before, you'll come away with this course with advanced knowledge and comprehension of MS Excel 2003.

Course Requirements

This course will not require you to have previous experience in any particular area but you should have the following:

- Excel version 2003
- a high school reading level.

No books will be required.

Course Outline

 

Lesson 1: Introduction to MS Excel 2003

Opening MS Excel 2003

Navigating MS Excel 2003

Customizing the MS Excel 2003 Toolbars

Cells, Rows, and Columns

Formulas

Sheet Tabs
 
Lesson 2: Worksheets and Workbooks

The Definition of Worksheets and Workbooks

Opening Worksheets and Workbooks

Labeling and Naming Worksheets

Adding and Deleting Worksheets

Hiding/ Unhiding Worksheets

Hiding Columns and Rows

Saving Workbooks

Headers and Footers

About Printing Worksheets and Workbooks

Page Setup

Set Page Margins

Select Print Area

Print a Range of Pages

Print Preview

Printing
 

Lesson 3: Entering Information into MS Excel 2003

About Entering Information into Excel

Entering Labels and Values

Multiple Entries

Copying Cells, Rows, and Columns

Pasting Cells, Rows, and Columns

Inserting and Deleting Rows and Columns

Filling Cells with a Series of Data

Editing Cell Data

Find and Replace, Go To Cell Data

Locking Rows and Columns By Splitting Panes

Locking Rows and Columns by Freezing Panes

Spell Check

Smart Tags

Track Changes
 

Lesson 4: Formatting a Worksheet

Change Font Size and Type

Add Borders and Colors to Cells

Changing Column Width

Changing Row Height

Merge Cells

Apply Number Formats and Create Custom Number Formats

Align Cell Contents

AutoFormats

Conditional Formatting

Styles
 

Lesson Five: Adding Elements to a Workbook

Adding Images

Modifying Images

Changing the Borders of a Picture or an Image

Compressing a Picture

Adding WordArt

Inserting AutoShapes

Adding Clip Art

Creating a Hyperlink

Embedding an object
 

Lesson 6: Charts and Diagrams

Modifying and Moving a Chart

Organizational Charts or Diagrams
 

Lesson Seven: Formulas and Calculations

Definition and explanation of formulas and calculations

Mathematical operators

Creating a formula

References

Absolute, Relative and Mixed Cell References

Using functions
 

Lesson 8: Managing Data

Using a Data Form

Entering Data Using a Data Form

Data Validation

Auditing
 

Lesson 9:  Lists

Creating a List

Inserting Rows and Columns into a List

Adding Up Values

Sorting Lists

Using Filters to Sort Lists

Using List Border to Expand a List

Inserting Columns and Rows Into a List

Totaling and Tallying Data
 

Lesson 10: Security and Protection in MS Excel 2003

Protecting a Workbook

Protecting Worksheets

Allow Users to Edit Ranges

Restrict Users and MS Excel 2003 Security
 

Lesson 11: Sharing Worksheets and Workbooks

Online Collaboration

Set Up a Shared Version of a Workbook

Merging Versions of the Same Workbook

Adding, Editing, and Deleting Comments

Creating and Sharing Templates

Creating a Template


Course Materials

All course material will be provided in the lessons and netlinks. There are no required materials to purchase before taking the class. In order to fully benefit from this course, though, you do need access to Microsoft Excel 2003.

Grading Policy

Lessons will include a lesson review quiz along with one or two assignments. Students will successfully complete this course with 70% or better.

Featured Courses in Computer Training

Excel 2007

1. Excel 2007

($60.00) Microsoft Excel 2007 is Microsoft's latest version of its very popular business productivity application for the management and manipulation of data. more
  MS Word 2007

2. MS Word 2007

($50.00) This Microsoft Word 2007 course is not only designed to give the experienced MS Word user a tour of the new version of Word, but to also introduce new MS Word users to a comprehensive look at the features and utilities that this word processing software offers. more
     
PowerPoint 2007

3. PowerPoint 2007

($60.00) The purpose of this course is to help you understand what PowerPoint 2007 can do for you, whether you are familiar with PowerPoint 2003 or new to the application altogether. more
  Effective Presentations

4. Effective Presentations

($55.00) Speaking in front of a group of people is one of the most common fears people experience. more

Other Related Classes in Computer Training

  • Accounting & Bookkeeping 101 for Everyone Accounting & Bookkeeping 101 for Everyone is a course that covers the fundamentals of accounting with the newcomer in mind. Accounting is more than just memorizing terms and procedures; it's a whole new way of thinking about finances. This course assu...
  • Adobe Flash 101 Adobe Flash CS4 can be a complex program to use and understand, even if you already have basic knowledge. It's very easy to get lost in the interface and confused by the many features it offers. This course was designed to solve the mysteries of Adob...
  • Adobe Photoshop 101 Adobe Photoshop is a complex graphics and image editing software and paint program. Chances are, you've heard of Photoshop frequently in the past even if this will be the very first time that you use the program. Adobe's Photoshop program has become a ...
  • Business Math 101 This course takes you through an overview of the wonderful world of business mathematics. The course is designed for a person of any age and anywhere in the world. All that is required of the learner are a computer, a connection to the internet, a c...
  • Computer Basics 101 Do you find yourself intimidated by computer jargon? Would you like to have a clearer understanding (in non-jargon language) of how your computer works? Computer Basics 101 will both demonstrate and explain how your computer works in an easy-to-follow, ...
  • Dreamweaver 101 Whether this is your first time using Dreamweaver or you've used it in the past, this course will walk you through the program step-by-step and teach you how to use its many features and options to create professional web pages with little more than ...
  • Electronics 101 Whether performing a minor repair, such as your phone or DVD player, or applying for a new and technology focused career, an understanding of the principles directing basic electronics will prove helpful throughout life. This course in basic electronics ...
  • Excel 2007 Microsoft Excel 2007 is Microsoft's latest version of its very popular business productivity application for the management and manipulation of data. Microsoft Excel is often packaged as part of Microsoft Office that includes other applications such as M...
  • How to Create Web Pages These days, everyone can benefit from an online presence, and that means developing a website. This course covers a basic introduction of how to create your own website page-by-page using HTML, a common website coding process. From basic HTML defin...
  • Internet Fundamentals 101 Are you in the dark about how the Internet works? Do you wonder how in the world it is possible to communicate with someone on another continent in the blink of an eye? This straightforward course clearly and plainly lays out the basics of the Internet...
  • Managerial Accounting 101 Managerial accounting is not as widely used as other forms of accounting, nor is it as known. While companies concern themselves with financial accounting methods like audits, budgets and financial statements, they often completely ignore the forward-th...
  • Microsoft Publisher 2007 Microsoft Publisher can be an amazing tool. It can help us complete impressive tasks in a fraction of the time, and help to accomplish things that we could never have done on our own. But you have to know how to use this program. This course will sho...
  • MS Office 2003: Word, Excel, PowerPoint This all in one training course will provide comprehensive instruction on three popular MS Office programs: MS Word 2003, MS Excel 2003, PowerPoint 2003. MS Word 2003 T his course teaches you all the basics of MS Word, from doing simply functions li...
  • MS Office 2007: Word, Excel, PowerPoint and Outlook MS Office 2007 will provide a comprehensive tutorial of these programs- Word, Excel, PowerPoint, and Outlook. MS Word 2007 It doesn't matter if you're new to MS Word or an experienced user, this comprehensive course teaches the most basic features as w...
  • MS Word 2003 It doesn't matter if you've never used MS Word before or you just want to familiarize yourself with MS Word 2003. This course teaches you all the basics of MS Word, from doing simply functions like typing in the text area to formatting text, to give the ...
  • MS Word 2007 This Microsoft Word 2007 course is not only designed to give the experienced MS Word user a tour of the new version of Word, but to also introduce new MS Word users to a comprehensive look at the features and utilities that this word processing software...
  • Outlook 2007 The purpose of this course is to help you understand what Outlook 2007 can do for you, whether you are familiar with Outlook 2003 or new to the application altogether. This course has been developed to be of benefit to new users of Outlook, individuals ...
  • Payroll Management 101 There are many aspects that need to be covered when running a successful business. One of the most important aspects in any business is of course, payroll management. The members of the business involved in payroll management have unique responsibilities...
  • Photoshop Elements 101 The Photoshop Elements software package is a condensed version of the popular Adobe Photoshop. Lesser priced, it contains all the features of Photoshop, but contains fewer options that are much easier to understand. Elements was designed with the consum...
  • PowerPoint 2003 MS PowerPoint 2003 is probably one of the most convenient software applications in the Office suite because it allows you to do so much – easily. Whether you want to create professional presentations for the office or just brush up on your skills...
  • PowerPoint 2007 The purpose of this course is to help you understand what PowerPoint 2007 can do for you, whether you are familiar with PowerPoint 2003 or new to the application altogether. One of the most noticeable changes is the new user interface called the Microsof...
  • Typing and Keyboarding 101 Today, knowing how to type fast is almost a necessity in the business world. More and more corporate-world employees are being asked to create reports, sales letters, business plans, blogs, web content, forecasts and more. Knowing how to type can sav...
  • Writing Basics 101: Spelling, Grammar, Punctuation, Writing Structures Most of us learned spelling and grammar in elementary school and brushed up on the rules occasionally in junior high or middle school. Once we entered high school, it was assumed we knew and remembered all of the essentials -- and slowly we discovered t...
  • Writing Improvement 101 We know that effective writing will help students in their coursework but it's equally important to write well in the workplace. If a job interviewer is considering two qualified candidates, the candidate who can write well will have the edge. If you're ...
 
Request More Information   Tell a Friend