Class Syllabus: Introduction to Excel 2003

Office Hours:	Continuous
Course Meeting Times:	Continuous

Course Description

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.

Learning Outcomes

By successfully completing this course, students will be able to:

Create worksheets and workbooks.
Enter information into a spreadsheet
Format a worksheet.
Add elements to a workbook.
Create charts and diagrams.
Use formulas and calculations.
Manage data.
Create lists.
Enable security and protection in ms excel 2003.
Share worksheets and workbooks, and
Demonstrate mastery of lesson content at levels of 70% or higher.

Recommended Books

Featured Courses in Computer Training

1. Excel 2007 ($65.00) Microsoft Excel 2007 is a very popular business productivity application for the management and manipulation of data. more		2. MS Word 2007 ($55.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

3. PowerPoint 2007 ($65.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		4. Effective Presentations ($60.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...
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...
Excel 2007 Microsoft Excel 2007 is a 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 Microsoft Word, Microsoft PowerPo...
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, ...
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...
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...
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...
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 ...
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 ...
Quickbooks 101 QuickBooks 101 is a course geared for the small business and the small business owner. It contains the features that you loved in Quicken, then goes a step further to give small businesses the accounting software they need to take their numbers from an e...
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...
Photoshop Elements Version 7.0 (or earlier) 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...
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...
Intro to PC Troubleshooting and Repair There is no question that computers offer many benefits to their users. Whether they are used for pleasure or business, computers enable us to connect to the world in ways never thought possible. And to get the most out of them, computers need to be set ...
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...
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...
Windows 7 Welcome to Windows 7, the latest operating system introduced by Microsoft. Chances are, you were just getting used to Vista when this came out. And, most likely, some of you are still bound to the old and familiar (now) XP. We know that the though...
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 ...
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 like ...
MS Office 2010: Word, Excel, PowerPoint and Outlook This all-in-one training course provides comprehensive instruction on four popular MS Office programs: MS Word 2010, MS Excel 2010, MS PowerPoint 2010 and MS Outlook 2010. MS Word 2010 Microsoft Word 2010 is the newest update to their popular word pro...
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...
Quicken Deluxe 2010 Quicken Deluxe is a personal finance management tool that provides features that we all need to keep track of where our money is going. However, this software gives you more than just the power to log your finances and manage your bills. It can also ...
Virus Removal and Protection 101 It's amazing how many of us own personal computers at home, belong to Internet networking systems in work environments, and yet don't understand the very basics regarding Internet Security. While we've all heard terms like worms, spyware and Trojan horse...
Internet Specialist 101 The role of an Internet Specialist in today's business marketplace is in exceptionally high demand. The Internet is a global web of interconnected networks that contains an immense amount of information. It has transformed how businesses conduct commer...
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 ...
Photoshop Elements 101 The Photoshop Elements software package is a condensed version of the popular Adobe Photoshop. As the lesser priced version of Adobe's Photoshop, Elements offers all the same features, but just with less options. However, don't let that scare you away fr...
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 i...
Microsoft Project 2007 Microsoft Project 2007 is a project management software that helps project managers better structure, organize, and plan for all their projects. This includes budgets, tasks, resources, assignments, and everything in between. It can create critical pat...
MS Outlook 2010 Outlook 2010 is a personal information software program that's available with the Microsoft Office Suite. Although it's mostly used as an email client, it can also be used for managing tasks, keeping your calendar, managing contacts, taking notes, journa...
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-thi...
MS Publisher 2010 Microsoft Publisher 2010 is a desktop publishing software program that comes with the Microsoft Office suite. While Microsoft Word is a word processing program, Microsoft Publisher is used for page layout and design. You can use Publisher to create brochu...
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...

Areas of Study