Earn a certificate (both hard copy and electronic) upon successful completion (additional charges apply). UniversalClass™ offers many wonderful learning tools to help you get the most out of your online course,
including an online portfolio service that manages all your course completions.
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 Lessons
Lesson 1: Introduction to MS Excel 2003
This lesson teaches how to open an excel sheet and introduces the advantages of excel 2003. It explains fields present in title bar and standard tool bar.
Lesson 2: Worksheets and Workbooks
Lesson 2: This lesson educates us on how to create and add workbooks and worksheets. It explains the ways to create, add, delete, hide, and unhide workbooks and worksheets.
Lesson 3: Entering Information into MS Excel 2003
Lesson 3: In this lesson, you will learn to enter data into the worksheet. It shows how to insert, delete, copy, and paste rows and columns. It also provides tips to use splitting and freezing panes.
Lesson 4: Formatting a Worksheet
Lesson 4: This lesson explains the features of formatting the toolbar. It details how one can change the color, size, and the font of the cell. It educates about the significance of auto formatting and the ways to apply that in the excel sheet.
Lesson 5: Adding Elements to a Workbook
Lesson 5: This lesson teaches how to insert images, auto shapes, and other graphic designs from scanner or camera to the worksheet. It provides useful tips to use these applications with examples.
Lesson 6: Charts and Diagrams
Lesson 6: This lesson describes the usage of charts and diagrams in excel sheet. It provides the methods to insert the normal charts and organizational charts with useful tips.
Lesson 7: Formulas and Calculations
Lesson 7: This lesson introduces one of the most useful features of excel sheet: formulae and calculations to minimize our work. It explains the useful methods to define formulae and calculations in excel sheet.
Lesson 8: Managing Data
Lesson 8: This lesson helps us to create worksheet with data form, another important feature of Excel, so that we can create customized error alert and warning alerts. This lesson also describes the formula auditing tool bar.
Lesson 9: Lists
Lesson 9: This lesson educates us about the special features of list command, such as auto filter, toggle, and sorting. It teaches how to create and use list command in Excel sheets.
Lesson 10: Security and Protection in MS Excel 2003
Lesson 10: This lesson explains how to protect our workbook with password. It teaches you to protect, format, lock, and unlock cells in detail. It also describes the security features of Excel 2003.
Lesson 11: Sharing Worksheets and Workbooks
Lesson 11: This lesson teaches how we can share worksheets and workbooks from one file to another in detail. It also explains the uses of online collaboration, merging versions of the same workbook, adding and deleting comments, and the templates.
Optional Certificates Awarded
Certificate of Merit
Certificate of Academic Excellence
Certificates may be awarded by the instructor at his/her own discretion and are based on student merit.
To save your award and have a hard-copy delivered, there is a $30.00 processing fee that covers the customization, printing, and delivery of the award, as well as access to the UniversalClass™ Portfolio Service that documents your achievements online.
Official awards have a serial number that verifies the authenticity of the award (great for employers
to verify your achievement).
This is a non-credit course, and is provided for your personal enrichment.
This course is not intended to be a substitute for any state, government, licensing, or educational requirements.
Choose from 5 Payment Methods
Credit Card Online
Credit Card through FAX
Check/Money Order through Mail
Credit Card over the Phone
PayPal
To use any of these methods you must press the "Join this Course" button on this screen and go through the online registration process in order to generate the correct order form and correctly process your enrollment.
($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
($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
($55.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
($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 EveryoneAccounting & 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...
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 demonstrate and explain in an easy-to-follow self-paced format. This cl...
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...
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 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 ...
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 skill...
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 ...