Online Class: Excel 2007

Course Cost: 6 Month Subscription

Basic Course (no certificate) = $35.00
Course with Online Certificate* = $60.00

* Document your course completion with an online certificate (additional shipping/handling charges apply for hard copy delivery). Instantly download, print, and share your certificate and CEUs once awarded. 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, and a Certificate Verification Service you can use so others may view and verify the authenticity of your awards.

Course Description

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 Microsoft Word, Microsoft PowerPoint, and Microsoft Outlook. Other desktop applications such as Microsoft Publisher and Microsoft Tools have also been added in recent releases of Office.

Since its launch in 1985, Microsoft has released 24 Excel application versions for Windows, Macintosh, and OS/2 based computer systems. Each successive release incorporated new functions and features that allowed the user to customize how data was displayed, and to do more and better data management. However, Excel 2007 is by far the most powerful and versatile of them all!

In addition to a whole new look and feel, Excel 2007 has modified its underlying technical foundation that enables businesses to expand the uses, integration and reach of Excel. Microsoft has also has continued to improve security, plug security gaps, and address functional issues. All this has helped to make Excel a very stable and reliable business application.

Many new features await the Excel 2007 user. Below are just a few highlights:

Horizontal "ribbons" that display commands left-to-right instead of the traditional vertical water-flow look.
More rows and columns to help manage your really massive spreadsheets!
Memory management increased from 1GB to 2GB's which allows for faster computations and increased performance.
New options for applying themes and styles which enhance the look of your spreadsheets and graphics. And, Excel now supports up to 16 million colors!
Easier creation and use of formulas.
New Pivot Table User Interface to help the user more effectively use pivot tables.

With the right training and understanding of Excel 2007, businesses and individual users can unlock the world of opportunities that this powerful business application offers. This Excel 2007 Online Training Course does just that and more! It assumes users have no prior experience with Excel or other spreadsheet programs. We start with the basics, and move up from there. So join us today, and lets learn the fundamentals of Excel 2007!

Course Lessons

Lesson 1: Introduction: Organization of this Training Guide, Uses of Excel, New Functions and Features in Excel 2007

This lesson is intended to help the user become familiar with the functions and features of Microsoft's latest release of one of its most popular and powerful business applications.

Lesson 2: Getting Started with Excel: Opening a Blank or New Workbook, General Organization

Instruction on opening a blank or new workbook, and general organization of Excel.

Lesson 3: Highlights and Main Functions: Home, Insert, Page Layout, Formulas

Instruction on home navigation, and how to use Insert, Page Layout, and Formulas.

Lesson 4: Highlights and Main Functions: Data, Review, View, Add-Ins

In this lesson, the Main Tabs - DATA, REVIEW, VIEW, and ADD-INS - will be discussed in more detail.

Lesson 5: Using the Excel Help Function

How to use the help function is expalined.

Lesson 6: Customizing the Quick Access Toolbar

How to customized the toolbar by the user to hold many different commands.

Lesson 7: Creating and Using Templates

Microsoft Excel 2007 provides access to a variety of free TEMPLATES. How to customize the templates as needed for themes, other required fields, logo or company name, and much more, is explained.

Lesson 8: Working with Data: Entering, Editing, Copy, Cut, Paste, Paste Special

This lesson begins to cover the basics of working with data. After all, this one of Excel's primary functions! Data includes text, numbers, equations and formulas, and more. Any of these data can be edited for multiple purposes.

Lesson 9: Formatting Data and Using the Right Mouse Click

Formatting helps to provide important visual interest as well as to structure the data and cells so that meaningful analysis and interpretation can be completed. Poorly formatted worksheets rarely accomplish their goals of managing and presenting data.

Lesson 10: Saving, Page Setup, and Printing

This lesson goes into greater detail to review commands that save the workbook changes, format pages for printing, and then print the workbook output. Page Setup includes functions such as Margins, Orientation, Paper Size, Breaks, Background and Print Ti

Lesson 11: Using Headers and Footers

This lesson describes the procedures for working with Headers & Footers. Headers include text, numbers, and other content that displays at the top of each printed page.

Lesson 12: Manipulating Data using Data Names and Ranges, Filters and Sort, and Validation Lists

This lesson covers several basic procedures for manipulating data, governing how data relates to other data, viewing data in different ways, and ensuring data that is entered is valid for the specific business or other criteria.

Lesson 13: Data from External Sources

This lesson discusses the different data sources and how data can get into an Excel worksheet other than typing or copying and pasting from within the same worksheet.

Lesson 14: Using and Formatting Tables

This lesson discusses how to use the Table functions within Excel 2007. Excel 2007 introduces predefined table formats to help quickly organize data within Excel, as well as display that data to maximize visual appeal.

Lesson 15: Basic Formulas and Use of Functions

This lesson begins delving into the heart of Excel 2007; using formulas and functions to manipulate and analyze data.

Lesson 16: Data Analysis Using Charts and Graphs

This lesson takes data analysis to the next level; turning numbers into visually interesting charts and graphs. Excel 2007 represents the next generation Charts Wizard! The Chart Wizard very quickly enables the creation of interesting, colorful an

Lesson 17: Managing, Inserting, and Copying Worksheets

This lesson includes the procedures for managing worksheets within a workbook. Worksheets can be named, moved around within the workbook, inserted or deleted, and copied either within the same workbook or another workbook.

Lesson 18: Securing the Excel Document (Protect Cells and Workbook)

Excel 2007 provides a couple of mechanisms to minimize unwanted or unauthorized changes to changes to a worksheet or workbook, as well as controlling access to the file itself.

Lesson 19: Advanced Formulas and Functions

This lesson looks at some of the more advanced formulas and functions found within Excel 2007 such as those used in more complex manually entered formulas, one of the many predefined function, or array formulas. Array formulas take Excel 2007 formulas to

Lesson 20: Advanced Worksheet Features

This lesson continues to review advanced areas within Excel 2007 that allow increased management of workbooks and use of features within worksheets.

Lesson 21: Advanced Data Analysis using PivotTables and PivotCharts

This lesson covers a relatively new area in Microsoft Excel that has gained in popularity over the last couple of years because of the increased flexibility and ease of working with larger quantities of data from multiple sources.

Optional Certificates Awarded

Certificate of Appreciation
Certificate of Academic Excellence

In addition to the standard Certificate of Course Completion, Merit Awards may be issued by the instructor at his/her own discretion and are based on student achievement. Merit awards also incur an additional $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 Merit Awards have a serial number that verifies the authenticity of the award (great for employers to verify your achievement).

Request Information

Additional Information

Course Title	:	Excel 2007
CEU Value	:	1.0 (Continuing Education Units)
Course Number	:	7550072
Course Type	:	How To
Course URL	:	http://excel.onlineclasses.com
Course Rating	:
Instructor	:	Sean Mellencamp
Syllabus	:	View Syllabus
Duration	:	Continuous: Enroll anytime!
Course Fee	:	Basic Course: $35
		with CEUs & Certificate: $60

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, 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.

Recommended Books

Featured Courses in Computer Training

1. Business Math 101 ($55.00) This course takes you through an overview of the wonderful world of business mathematics. more		2. Introduction to MS Excel ($60.00) 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. more

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		4. 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

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 ...
Algebra 201: Beginner to Intermediate Level Beginner to Intermediate Algebra is intended for students who need to gather a basic understanding of how to perform Algebra operations. This course will benefit current students and adult learners who need to know how to perform basic Algebra operations...
Basic Math 101 Fear fractions no more. And learn whether to add first or multiply first in a string of operations. Whether you are struggling with basic math functions in a course today, you are taking a new job that demands understanding of math, or you simply need to...
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 ...
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...
Introduction to MS Excel 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...
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...
Math All-In-One (Arithmetic, Algebra, & Geometry Review) This self-paced All-In-One Math Course reviews the basics of arithmetic, algebra and geometry. The condensed course covers the following material: -Arithmetic: ( reviewing the use of numbers, signs and symbols, how to perform various operations, h...
Math Review 101 This course deals with the nuts and bolts of Math. Students will become equipped with a solid foundation of the mathematical tools required to solve more complex mathematical operations. This course would benefit any student (regardless of age) who req...
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 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...

Areas of Study