Online Class: Excel 2007

This course demystifies Excel 2007, exploring its powerful tools like expanded rows, cutting-edge ribbons, and vibrant color support, making it indispensable for modern data manipulation. With no prior knowledge required, learners can confidently transform their spreadsheet skills from basic to proficient.

Self-Paced, Online Class

Library Subscription

21

Lessons
28

Exams &
Assignments
14

Hours
average time
1.4

CEUs

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!

Courses Frequently Bought Together:

QuickBooks 101

Microsoft Excel Level 1

Microsoft PowerPoint Level 1

Areas of Study

Course Lessons

Lesson 1. Excel 2007 Essentials

Excel 2007 offers significant enhancements and new features, making it a powerful tool for data manipulation and business needs. This training guide is divided into Overview, General, and Advanced sections to help users unlock its full potential, with practical exercises and quizzes to test learning. 10 Total Points

Lesson 1 Video
Review Practice Worksheet: Lesson-1-Downloadable-9656.pdf
Lesson discussions: Reasons for Taking this Course
Complete Assignment: Introduce Yourself
Assessment: Lesson 1 : Introduction

Lesson 2. Excel 2007: Launching and Understanding the Basics

Excel 2007 introduces a shift in menu layout by incorporating the Ribbon, which organizes commands into Tabs, each housing functional groups. The MS Office Button provides access to file management tasks, while the Quick Access Toolbar can be personalized for efficiency, ensuring smooth navigation through workbook functionalities. 6 Total Points

Lesson 2 Video
Review Practice Worksheet: Lesson-2-Activity-9657.pdf
Assessment: Lesson 2: Getting Started with Excel: Opening a Blank or New Workbook, General Organization

Lesson 3. Exploring Core Excel Functions: Home, Insert, Page Layout, and Formulas

Emphasizing data organization, the Insert tab includes PivotTables and charts, alongside the Page Layout tab which manages themes and print settings. This integration helps refine the visual output and structural setup of worksheets. 7 Total Points

Lesson 3 Video
Review Practice Worksheet: Lesson-3-Activity-9658.pdf
Assessment: Lesson 3 : Highlight and Main Functions: Home, Insert, Page Layout, Formulas

Lesson 4. Key Functions of Excel Tabs: Data, Review, View, Add-Ins

The DATA tab offers a suite of tools for importing and organizing data from various sources, facilitating sorting, filtering, data validation, and analysis. The REVIEW tab provides proofing and comment management while offering the protection of workbook contents through its robust security features. 10 Total Points

Lesson 4 Video
Review Practice Worksheet: Lesson-4-Downloadable-9659.pdf
Complete: Lesson 4 Activity
Assessment: Lesson 4 : Highlights and Main Functions: Data, Review, View, Add-Ins

Lesson 5. Mastering Excel Assistance

Excel's Help Function, denoted by a circled question mark, offers a user-friendly interface for accessing predefined topics and a search function for specific queries. The system supports online connectivity for expanded resources and offers printing and navigation tools, ensuring efficient information retrieval. 5 Total Points

Lesson 5 Video
Review Practice Worksheet: Lesson-5-Downloadable-9660.pdf
Assessment: Lesson 5 : Using The Excel Help Function

Lesson 6. Mastering the Quick Access Toolbar in Excel: A Comprehensive Guide

Enhancing productivity in Excel, the Quick Access Toolbar lets users quickly select and execute tasks with commands like save, print, and undo always visible. Customization can be achieved via the dropdown menu next to the Printer icon, or by right-clicking other Ribbon commands to add them. 7 Total Points

Lesson 6 Video
Review Practice Worksheet: HistoricalSalesData.xls
Assessment: Lesson 6 : Customizing The Quick Access Toolbar

Lesson 7. Efficiently Create and Use Templates in Microsoft Excel 2007

In Excel 2007, templates are predefined formats facilitating easy task completion and can be accessed from different sources such as recently used or online. Users can create a customized workspace by modifying these templates to fit personal or business needs, streamlining their workflow. 9 Total Points

Lesson 7 Video
Review Practice Worksheet: Lesson-7-Activity-9661.pdf
Assessment: Lesson 7 : Creating and Using Templates

Lesson 8. Efficient Excel Data Operations

Excel's capabilities in data management are unlocked through understanding manual entry, formula creation, and the application of Copy, Cut, and Paste commands. Users are trained to overwrite existing data, utilize Paste Special for customized pasting, and execute Undo/Redo functions. 8 Total Points

Lesson 8 Video
Review Practice Worksheet: HistoricalSalesData.xls
Complete: Lesson 8 Activity
Assessment: Lesson 8 : Working with Data: Entering, Editting, Copy, Cut, Paste, and Paste Special, Undo and Rep

Lesson 9. Mastering Data Layout: Formatting and Right Click Techniques

By mastering data formatting, one can significantly improve worksheet functionality and analytical output. Key focus areas in this chapter include font customization, alignment strategies, number formatting, style refinement, and theme application, with handy right-click tips. 9 Total Points

Lesson 9 Video
Review Practice Worksheet: Lesson-9-HomeWork-9662.pdf
Assessment: Lesson 9 : Formatting Data and Using the Right Mouse Click

Lesson 10. Page Setup and Output Perfection

Focused on workbook efficiency, the lesson explains saving techniques, page arrangement, and print functions, enhancing document management. By mastering Save, Print Area, and Page Setup, users can achieve professional-grade outputs tailored to presentation needs. 8 Total Points

Lesson 10 Video
Review Practice Worksheet: Lesson-10-Activity-9663.pdf
Complete: Lesson 10 Activity
Assessment: Lesson 10 : Saving, Page Setup, and Printing

Lesson 11. Headers & Footers Made Easy

Excel provides header and footer customization through the Header & Footer Tools, accessible via the Insert Tab. Users can add text, dates, or predefined elements and view these changes in Print Preview to ensure proper formatting. 6 Total Points

Lesson 11 Video
Review Practice Worksheet: Lesson-11-Activity-9664.pdf
Assessment: Lesson 11 : Using Headers and Footers

Lesson 12. Mastering Data Management: Names, Filters, and Validation Explained

This lesson elaborates on defining cell references using the Name Manager and Name Box, filtering and sorting data intelligently, and applying validation techniques. These strategies help tailor data management processes to fit precise business requirements, ensuring data accuracy and simplicity. 8 Total Points

Lesson 12 Video
Review Practice Worksheet: MICROSOFT_EXCEL_2007_-_Widget_Histo.xls
Assessment: Lesson 12 : Manipulating Data Using Names and Ranges, Filters and Sort, and Validation Options

Lesson 13. Navigating the Maze of External Data Sources

In this lesson, Excel's functionality to handle data inputs from various external sources like web pages and text files is examined, focusing on the meticulous use of copy-paste options. Structured handling and formatting adjustments are key to accurate data assimilation. 8 Total Points

Lesson 13 Video
Review Practice Worksheet: Lesson-13-Downloadable-9665.pdf
Complete: Lesson 13 Activity
Assessment: Lesson 13 : Data From External Sources

Lesson 14. Excel 2007 Tables: From Basic Conversion to Advanced Formatting

Lesson Summary 3 7 Total Points

Lesson 14 Video
Review Practice Worksheet: Lesson-14-WorkSheet-9666.pdf
Assessment: Lesson 14 : Using and Formatting Tables

Lesson 15. Formulas and Functions Essentials

Mastering Excel 2007 involves learning to use functions and formulas to automate data calculations. The lesson provides step-by-step instructions on basic operations and advanced functions for comprehensive data analysis. 8 Total Points

Lesson 15 Video
Review Practice Worksheet: Lesson-15-HomeWork-9667.pdf
Assessment: Lesson 15 : Using Basic Formulas and Functions

Lesson 16. From Data to Display: Enhance Your Analysis with Charts

This lesson guides learners in mastering the Chart Wizard in Excel 2007, offering a seamless experience in converting rows and columns into engaging visual charts. The module delves into functionalities including Quick Edits, Design Modifications, and Layout Customizations to optimize data presentation. 9 Total Points

Lesson 16 Video
Review Practice Worksheet: Lesson-16-WorkSheet-9668.pdf
Complete: Lesson 16 Activity
Assessment: Lesson 16 : Data Analysis Using Charts and Graphs

Lesson 17. Efficient Workbook Organization

Master the art of worksheet management by learning to rename and recolor tabs for clarity, and execute strategic moves or copies within a workbook. You'll also grasp the essentials of adding or removing sheets, with reminders about the permanency of deletions. 7 Total Points

Lesson 17 Video
Review Practice Worksheet: Lesson-17-WorkSheet-9669.pdf
Assessment: Lesson 17 : Managing Worksheets

Lesson 18. Securing Your Excel 2007 Workbook: A Comprehensive Guide

Excel 2007 facilitates meticulous access control through various protection methods, including specific cell permissions, workbook encryption, and the use of passwords. The lesson explores these features in depth, equipping users with the knowledge to enhance data protection and workspace security. 7 Total Points

Lesson 18 Video
Review Practice Worksheet: Lesson-18-WorkSheet-9670.pdf
Complete: Lesson 18 Activity
Assessment: Lesson 18 : Securing the Excel 2007 Document (Protect Worksheets and Workbooks)

Lesson 19. Advanced Excel Formulas: A Comprehensive Guide

Focusing on Excel 2007, this lesson introduces advanced features such as complex formula entry and array formulas, enabling users to perform multifaceted computations within datasets. Key functions such as IF, COMBIN, and PMT are detailed for tasks ranging from determining profit to calculating potential lottery combinations and loan payments. 8 Total Points

Lesson 19 Video
Review Practice Worksheet: Lesson-19-WorkSheet-9671.pdf
Assessment: Lesson 19 : Advanced Formulas and Functions

Lesson 20. Excel's Advanced Worksheet Features

The lesson focuses on Excel 2007's advanced worksheet features, helping users manage large datasets effectively through outlining, linking, and consolidation. Users learn to apply subtotal functions, reference data from other workbooks, and consolidate worksheets into a single master workbook. 6 Total Points

Lesson 20 Video
Review Practice Worksheet: Lesson-20-Downloadable-9672.pdf
Assessment: Lesson 20 : Advanced Worksheet Features

Lesson 21. Excel Pivot Tables 101

Unveiling the potential of Excel 2007's Pivot Table Wizard, the lesson facilitates advanced handling of large datasets from varied sources. The guide offers detailed steps on creating, customizing, and leveraging PivotTables and PivotCharts for in-depth data insights and visualization. 9 Total Points

Lesson 21 Video
Review 2 Practice Worksheets
Lesson discussions: What do you think about this course?; Program Evaluation Follow-up Survey (End of Course); Course Comments
Assessment: Lesson 21 Advanced Data Analysis using Pivottables and Pivotcharts

162

Total Course Points

Learning Outcomes

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

Create and manage charts using Excel 2007’s enhanced chart creation features, including templates and special effects.
Define and demonstrate the use of new Excel 2007 enhancements, including writing formulas, sorting, and filtering.
Define the steps to launch Microsoft Excel 2007 using different methods, demonstrating successful access to the application.
Identify and explain the functions and layout of key areas in the Excel 2007 workbook, such as the Ribbon and Formula Bar.
Define and apply appropriate font styles and sizes using the HOME tab to enhance worksheet readability in Excel 2007
Demonstrate insertion of charts from the INSERT tab to visually represent data within an Excel 2007 worksheet
Define the process for importing data from a web page into a worksheet using the DATA TAB commands.
Demonstrate the ability to apply and clear filters on a data range using the SORT & FILTER options in Excel.
Demonstrate the ability to navigate the Excel Help function by using the search feature and predefined quick reference links for topic exploration.
Explain how to utilize the print and font adjustment features in Excel Help to enhance the readability and accessibility of selected information.
Demonstrate the ability to customize the Quick Access Toolbar by adding, removing, or rearranging commonly used commands in Excel.
Identify the steps to modify worksheet content using commands from the Quick Access Toolbar effectively.
Demonstrate the ability to create and customize Excel templates by utilizing built-in and online resources effectively.
Demonstrate mastery of lesson content at levels of 70% or higher.

Additional Course Information

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

Course Title: Excel 2007

Course Number: 7550337

Languages: English - United States, Canada and other English speaking countries

Category:

UniversalClass.com > Computers & Technology > Microsoft Office Courses

Availability: This course is accessible online throughout all states, including California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. It's also available in top English-speaking countries like the United Kingdom, Canada, Australia, and New Zealand.

Last Updated: April 2024

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.

Student Testimonials

"Very nice, very helpful." -- Becky S.
"This was a great class. I look forward to taking some of the other computer classes in the near future. I found the later lessons most helpful as I've used Excel since its infancy. The advanced stuff is the most fun." -- Fiona E.
"All of it was helpful. " -- Arnold A.
"Having no prior experience with EXCEL all of it was new to me. I was extremely pleased with both the instructor and the course material." -- Jackie C.
"The information about tables and charts was most helpful. I knew they were available, but did not know how to use them AT ALL before this class. Now, I will begin using them." -- Sandra O.
"The course was clear and well organized, the video was most helpful. " -- Rita Y.
"THE WHOLE COURSE WAS HELPFUL. Keep it up, hope we will be seeing each other soon." -- Jimmy W.
"It was very descriptive and great visual examples were given. Thank you very much--I really enjoyed taking the course on my own free time!" -- Cindy A.
"This is my first online course and it helped me to get good knowledge in Excel which increased the confidence level in me." -- Devi K.
"The whole course was helpful. Before the course I had zero knowledge of Excel." -- Terry T.