Online Class: Intro to MS Excel - Beginner Level 1
|
 | | |
| | Course Cost: 6 Month Subscription Course (no Certificate) = $40.00 Course with CEU Certificate* = $65.00 | * Instantly download, print, and share your CEU Certificate at course completion (additional shipping/handling charges apply for hard copy delivery).
UniversalClass™ offers many wonderful learning tools including an online portfolio service that manages all your course completions and CEUs.
 Course Description Whether you've used MS Excel before and just want to learn more about Excel or are completely new to the program, this course is designed to teach you the features of MS Excel 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 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, 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. 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.
Course Lessons |  | Lesson 1: Introduction to MS Excel 2003This 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 WorkbooksLesson 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 2003Lesson 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 WorksheetLesson 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 WorkbookLesson 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 DiagramsLesson 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 CalculationsLesson 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 DataLesson 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: ListsLesson 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 2003Lesson 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 WorkbooksLesson 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. |
Additional Information | Course Title | : | Introduction to Excel 2003 | | CEU Value | : | | | Standard | : | Course Adheres to the ANSI/IACET 1-2007 Standard | | Accreditation | : | | | Languages | : | English - United States, Canada, United Kingdom, Australia, New Zealand, and other English speaking countries | | Course Number | : | 7550100 | | Course Type | : | How To | | Course URL | : | | | Course Rating | : |  | | Instructor | : | UniversalClass Staff Instructor | | Syllabus | : | | | Grading Policy | : | Earn a final grade of 70% or higher to receive a CEU Certificate documenting CEUs earned | | Assessment Method | : | Lesson assignments and review exams | | Duration | : | Continuous: Enroll anytime! | | Requirements | : | View Technical Requirements | | Course Fee | : | Basic Course: $40.00 (no CEU Certificate) | | | | | NOT FOR COLLEGE CREDIT 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, certification or educational requirements.
Choose from 5 Secured 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. All financial information is secured and encrypted using Verisign-approved SSL during transmission. |
Student Testimonials - "I was very impressed with responses from the instructor." -- Don S.
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...
| | | |
| |
| |
