Universal Class: Over 500 Online Certificate Courses

Online Class: Excel 2007

no certificate
- OR -
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
  • 21
  • 21
    Exams &
  • 14
    average time
  • 1.4
  • 5,140
    have taken this course

Course Description

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 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!
Show More
  • Completely Online
  • Self-Paced
  • Printable Lessons
  • Full HD Video
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider

Related Courses

  • MS Word 2007
    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 soft...
    0.7 CEUs 7h
  • PowerPoint 2016
    PowerPoint 2016
    PowerPoint 2016 is a presentation creator that can be used to create stunning slideshows and basic videos. It can also be used to create slide presentations, handouts, transparencies, and much more. While creating presentations using some programs c...
    0.7 CEUs 7h
  • Excel 2016
    Excel 2016
    Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an address book, grocery...
    1.2 CEUs 12h
  • QuickBooks 101
    QuickBooks 101
    QuickBooks® Course Introduction QuickBooks® is an accounting software program created by Intuit® for small businesses and self-employed professionals. It can be used for almost all financial business processes. You can use it for ent...
    1.4 CEUs 14h
  • Ultimate Excel Bundle
    Ultimate Excel Bundle
    Learn Excel 2016 Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an addr...
    4.6 CEUs 46h
  • Office 2016: Word, Excel, PowerPoint and Outlook
    Office 2016: Word, Excel, PowerPoint and Outlook
    Microsoft Word 2016: Microsoft Word 2016 is the latest version of the popular word processing software offered as part of the Microsoft Office suite. This course will teach you all the skills you'll need to successfully use Word 2016. You'll learn ...
    3.2 CEUs 32h
  • Math All-In-One (Arithmetic, Algebra, and Geometry Review)
    Math All-In-One (Arithmetic, Algebra, and Geometry Review)
    This self-paced All-In-One Math Course reviews the basics of arithmetic, algebra and geometry. This condensed course covers the following material: Arithmetic: reviewing the use of numbers, signs and symbols, how to perform various operations, how...
    9.5 CEUs 95h
  • Advanced Excel 2016
    Advanced Excel 2016
    Excel 2016 Advanced Skills Course With most software programs on the market today, you can thrive with just a basic knowledge of the tools and options built into the individual program. However, that is not necessarily true when it comes to Excel 20...
    1.7 CEUs 17h
  • JQuery Programming
    JQuery Programming
    JQuery is one of the most popular frameworks on the web that deals with client-side scripting for styling web pages and performing asynchronous events. It's built on the JavaScript language, so anyone familiar with the JavaScript language will pick ...
    0.9 CEUs 9h
  • Microsoft Publisher 2016
    Microsoft Publisher 2016
    Publisher 2016 is Microsoft's entry-level desktop publishing program, allowing you to quickly create publications for the web or print. You can easily create professional-looking publications by either creating them yourself from scratch or using o...
    0.7 CEUs 7h
  • Basic Math 101
    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 ne...
    1.7 CEUs 17h
  • Adobe Captivate
    Adobe Captivate
    Adobe Captivate is a responsive authoring tool that allows you to create eLearning content, such as eLearning courses, software demonstrations, branched scenarios, games, quizzes, and screencasts. The files you create in Adobe Captivate 9 can be exp...
    0.6 CEUs 6h
  • OneNote 2016
    OneNote 2016
    OneNote 2016 is a note-taking program that comes bundled with the Microsoft Office 2016 suite. Whereas MS Word is a word processing program that you can use to create documents, OneNote is simply a note taking program that you can use to take notes ...
    0.5 CEUs 5h
  • Operations Management 101
    Operations Management 101
    Operations Management is a dynamic field in which individuals with the right skills, knowledge and talent can take a business to new heights and have a direct impact on daily operations and company profitability. Nearly 40% of all jobs are in the ar...
    0.5 CEUs 5h
  • Adobe After Effects
    Adobe After Effects
    Adobe After Effects allows you to create videos containing animation and special effects for graphics-related projects. You can use After Effects to animate, alter, and composite media using various tools and optional plug-ins. The program is widely...
    1.0 CEUs 10h
  • Final Cut Pro X
    Final Cut Pro X
    Final Cut Pro X is a video editing and movie making software application created by Apple for OS X. Unlike previously released versions of the video editing program Final Cut, Final Cut Pro X is an all-new application. It has been designed from sc...
    1.0 CEUs 10h
  • Learn HTML - Create Webpages Using HTML5
    Learn HTML - Create Webpages Using HTML5
    This course teaches you how to create webpages from scratch using the most current standard in HTML -- HTML5. HTML5 is the latest standard in web page coding. Whether you're a new or seasoned web designer, you need to know the latest in HTML archite...
    1.0 CEUs 10h
  • Introduction to SQL
    Introduction to SQL
    This comprehensive course teaches and demonstrates all aspects of SQL. While you'll learn everything there is to do with SQL, this course assumes you have no prior SQL experience and is for the complete beginner. Structured Query Language (SQL) is t...
    1.7 CEUs 17h
  • Creating WordPress Websites
    Creating WordPress Websites
    WordPress is a free open source blogging tool and content management system. WordPress can be used to create a traditional blogging site; however, it can also be used to create a standard website for business or personal use. This course focuses o...
    0.5 CEUs 5h
  • Social Media 101: How to Use Facebook, Twitter and LinkedIn
    Social Media 101: How to Use Facebook, Twitter and LinkedIn
    The manner in which we all communicate has been revolutionized by the Internet with the advent of social networking and social media platforms. Millions of people communicate with each other in today's environment via text, email, instant messaging,...
    0.3 CEUs 3h
  • Adobe InDesign 101
    Adobe InDesign 101
    Adobe InDesign is a software program created by Adobe Systems, the same company that creates Photoshop, Illustrator, and a number of other programs. Whereas Photoshop is used for image editing and Illustrator is used for drawing, InDesign is used to...
    1.0 CEUs 10h
  • Adobe Photoshop 101
    Adobe Photoshop 101
    This course will teach you everything you need to know to make full use of the world's most popular graphics editing program -- Adobe Photoshop. Adobe Photoshop is a complex graphics and image editing software and paint program. It has become a main...
    1.0 CEUs 10h
  • Microsoft Word 2016
    Microsoft Word 2016
    Microsoft Word 2016 is the latest version of the popular word processing software offered as part of the Microsoft Office suite. This course will teach you all the skills you'll need to successfully use Word 2016. You'll learn everything you need t...
    0.8 CEUs 8h
  • MySQL
    If you've decided to build a website or need a database, MySQL is an open-source option that's very cost effective and affordable. Without knowing how to install, configure, design and maintain the database, you risk having a poor performing environ...
    1.0 CEUs 10h
  • C# Programming
    C# Programming
    C# is a powerful backend coding language used for Microsoft web and desktop applications. C# is a C-style language, so you can take C# and learn other languages such as Java, C and C++. This course will get you started with C# and the language style...
    1.7 CEUs 17h
  • Adobe Illustrator 101
    Adobe Illustrator 101
    Course Introduction Adobe Illustrator is a powerful drawing software program offered by Adobe. Anyone, regardless of artistic or computer ability, can use Illustrator to draw shapes and lines, create text, or import graphics and pictures. You can ...
    1.0 CEUs 10h
  • Typing and Keyboarding 101
    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 ...
    2.0 CEUs 20h
  • Adobe Lightroom 101
    Adobe Lightroom 101
    Adobe Photoshop Lightroom is a photo editing and management program offered by Adobe, allowing users to manage and edit multiple images at once using the Adobe Photoshop Lightroom interface. This course will teach you the features in Adobe Photosho...
    1.0 CEUs 10h
  • Introduction to JavaScript
    Introduction to JavaScript
    JavaScript is the globally used client-side scripting language for the web. Most browsers support the language by default, so you can get started using JavaScript and HTML with a simple text editor and browser for testing. Client-side, programming l...
    1.0 CEUs 10h
  • Dreamweaver 101
    Dreamweaver 101
    Adobe Dreamweaver is a web design program that gives even the most amateur web designer the ability to create stunning web pages fairly quickly and easily. You don't have to know HTML or any other programming language to be able to use Dreamweaver. ...
    1.0 CEUs 10h
  • Introduction to CSS
    Introduction to CSS
    Ever wonder how the latest website designs are made? Cascading Style Sheets (CSS) are the main coding files used to lay out a website and its design. CSS3 is the latest in styling standards, and it brings several new properties and declarations you ...
    1.1 CEUs 11h
  • Photoshop Elements 101
    Photoshop Elements 101
    Adobe Photoshop Elements is the consumer-based version of the popular Photoshop program that allows you to store, sort, and edit images and photographs. Photography enthusiasts will love Elements ability to organize images and create albums. Photosh...
    1.0 CEUs 10h
  • Payroll Management 101
    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 responsibil...
    0.9 CEUs 9h
  • Pinterest
    Want to learn more about the Pinterest world? You are not alone! Millions of people have sent Pinterest membership numbers sky high. The site is growing in leaps and bounds and people far and wide want to learn how to get in on all the fun. That's w...
    0.3 CEUs 3h
  • Purchasing and Vendor Management 101
    Purchasing and Vendor Management 101
    This concise course is designed to explore the institutional purchasing cycle for consumable materials, raw materials, spare parts, and capital assets. Additionally students will explore and develop a thorough understanding of the supplier/buyer rel...
    0.4 CEUs 4h
  • Adobe Premiere 101
    Adobe Premiere 101
    Adobe Premiere Pro is a video editing program that is part of the Adobe Creative Cloud software collection, as well as Adobe CS6 – or Adobe Creative Suite. Premiere Pro is used to edit videos, including movies, and is quickly becoming the go-t...
    1.0 CEUs 10h

Course Lessons

Average Lesson Rating:
4.3 / 5 Stars (Average Rating) 4.3 / 5 Stars (Average Rating) 4.3 / 5 Stars (Average Rating) 4.3 / 5 Stars (Average Rating) 4.3 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(3,419 votes)

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. 8 Total Points
  • Lesson 1 Video
  • Complete Exam: Lesson 1 : Introduction

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. 6 Total Points
  • Lesson 2 Video
  • Complete Exam: Lesson 2: Getting Started with Excel: Opening a Blank or New Workbook, General Organization

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

Instruction on home navigation, and how to use Insert, Page Layout, and Formulas. 7 Total Points
  • Lesson 3 Video
  • Complete Exam: Lesson 3 : Highlight and Main Functions: Home, Insert, Page Layout, 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. 9 Total Points
  • Lesson 4 Video
  • Complete Exam: Lesson 4 : Highlights and Main Functions: Data, Review, View, Add-Ins

Lesson 5: Using the Excel Help Function

How to use the help function is expalined. 5 Total Points
  • Lesson 5 Video
  • Complete Exam: Lesson 5 : Using The Excel Help Function

Lesson 6: Customizing the Quick Access Toolbar

How to customized the toolbar by the user to hold many different commands. 7 Total Points
  • Lesson 6 Video
  • Review Practice Worksheet: HistoricalSalesData.xls
  • Complete Exam: Lesson 6 : Customizing The Quick Access Toolbar

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. 9 Total Points
  • Lesson 7 Video
  • Complete Exam: Lesson 7 : Creating and Using Templates

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. 7 Total Points
  • Lesson 8 Video
  • Review Practice Worksheet: HistoricalSalesData.xls
  • Complete Exam: Lesson 8 : Working with Data: Entering, Editting, Copy, Cut, Paste, and Paste Special, Undo and Rep

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. 9 Total Points
  • Lesson 9 Video
  • Complete Exam: Lesson 9 : Formatting Data and Using the Right Mouse Click

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 7 Total Points
  • Lesson 10 Video
  • Complete Exam: Lesson 10 : Saving, Page Setup, and Printing

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. 6 Total Points
  • Lesson 11 Video
  • Complete Exam: Lesson 11 : Using Headers and Footers

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. 8 Total Points
  • Lesson 12 Video
  • Review Practice Worksheet: MICROSOFT_EXCEL_2007_-_Widget_Histo.xls
  • Complete Exam: Lesson 12 : Manipulating Data Using Names and Ranges, Filters and Sort, and Validation Options

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. 7 Total Points
  • Lesson 13 Video
  • Complete Exam: Lesson 13 : Data From External Sources

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. 7 Total Points
  • Lesson 14 Video
  • Complete Exam: Lesson 14 : Using and Formatting Tables

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. 8 Total Points
  • Lesson 15 Video
  • Complete Exam: Lesson 15 : Using Basic Formulas and Functions

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 8 Total Points
  • Lesson 16 Video
  • Complete Exam: Lesson 16 : Data Analysis Using Charts and Graphs

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. 7 Total Points
  • Lesson 17 Video
  • Complete Exam: Lesson 17 : Managing Worksheets

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. 6 Total Points
  • Lesson 18 Video
  • Complete Exam: Lesson 18 : Securing the Excel 2007 Document (Protect Worksheets and Workbooks)

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 8 Total Points
  • Lesson 19 Video
  • Complete Exam: Lesson 19 : Advanced Formulas and Functions

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. 6 Total Points
  • Lesson 20 Video
  • Complete Exam: Lesson 20 : Advanced Worksheet Features

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. 9 Total Points
  • Lesson 21 Video
  • Review 2 Practice Worksheets
  • Take Poll: What do you think about this course?
  • Take Survey: Program Evaluation Follow-up Survey (End of Course)
  • Complete Exam: Lesson 21 Advanced Data Analysis using Pivottables and Pivotcharts
Total Course Points
Show More

Learning Outcomes

By successfully completing this course, students will be able to:
  • Describe the major features and functions of Excel 2007.
  • Know using the Excel help function.
  • Customize the Quick Access Toolbar.
  • Use templates.
  • Demonstrate working with data.
  • Demonstrate formatting data.
  • Utilize the save, page setup, and print functions.
  • Use headers and footers.
  • Manipulate data using data names and ranges, filters and sort, and validation lists.
  • Create and format tables.
  • Create basic formulas and functions.
  • Use charts and graphs.
  • Manage, insert, and copy worksheets.
  • Secure Excel documents.
  • Use advanced formulas and functions.
  • Create PivotTables and PivotCharts, and
  • Demonstrate mastery of lesson content at levels of 70% or higher.
Show More

Additional Course Information

Online CEU Certificate
  • Document Your Lifelong Learning Achievements
  • Earn an Official Certificate Documenting Course Hours and CEUs
  • Verify Your Certificate with a Unique Serial Number Online
  • View and Share Your Certificate Online or Download/Print as PDF
  • Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media
Document Your CEUs on Your Resume
Course Title: Excel 2007
Course Number: 7550337
Languages: English - United States, Canada and other English speaking countries
Course Type: How To (Self-Paced, Online Class)
CEU Value: 1.4 IACET CEUs (Continuing Education Units)
CE Accreditation: Universal Class, Inc. has been accredited as an Authorized Provider by the International Association for Continuing Education and Training (IACET).
Grading Policy: Earn a final grade of 70% or higher to receive an online/downloadable CEU Certification documenting CEUs earned.
Assessment Method: Lesson assignments and review exams
Instructor: Dr. Metodija Stojanovski
Syllabus: View Syllabus
Duration: Continuous: Enroll anytime!
Course Fee: $50.00 (no CEU Certification) || with Online CEU Certification: $75.00

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
for 6 months
Billed once
This course only
Includes certificate X
Includes CEUs X
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Certificate Course
One Course
Certificate & CEUs
for 6 months
Billed once
This course only
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Platinum Yearly
Best Value
Certificates & CEUs
per year
You save 50%!
Billed once
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 500+
Platinum Monthly
Certificates & CEUs
$59 first month
$29.00 / each consecutive month thereafter
Billed monthly
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete Monthly
No. of courses 500+

Student Testimonials

  • "The whole course was helpful. " -- Rhonda B.
  • "My instructor was very helpful and readily available. I found the video that tied in with each lesson most helpful. " -- Will W.
  • "The video with the class was most helpful." -- Debbie S.
  • "I like the fact that I can read the lesson, watch it as a video and then print it out so that I could review it while on break at work. Thank you, it was a positive experience for me. I will be taking more classes." -- Barbara E.
  • "I liked the way it provided step by step instructions with pictures to make sure you knew what you were doing." -- Samantha C.
  • "The whole course was helpful. Before the course I had zero knowledge of Excel." -- Terry T.
  • View More Testimonials...
Follow Us Online
  • Follow us on Google Plus Follow us on FaceBook Follow us on Twitter Follow us on YouTube
© Copyright 1999-2018 Universal Class™ All rights reserved.