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.
$95.00
no certificate
- OR -
$120.00
with CEU Certificate*
Start Right Now!
$120.00 (with CEU Certificate)
Taking multiple courses? Save with our platinum program.
 
  • 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:
  • 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
 
 

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

    Lesson Summary 3

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

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

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

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

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

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

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

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

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
Availability: Accessible from any state in the U.S., this course covers key areas such as California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. The course is also offered in English-speaking nations like Australia, Canada, the UK, and South Africa.
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.
Course Fee: $120.00 U.S. dollars

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
$95
for 6 months
 
Add to Cart
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
$120
for 6 months
 
Add to Cart
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
ALL COURSES
Certificates & CEUs
$189
per year
 
Start Now
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 600+
Platinum 2 Years
ALL COURSES
Certificates & CEUs
$299
for 2 years
You save $79.00!
Start Now
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 24 Months
No. of courses 600+
 

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.
View More Testimonials...
 

Related Courses