Learn Everything You Ever Wanted to Know About Excel!
Excel 2007
Learn Everything You Ever Wanted to Know About Excel!
Unlock a world of data-driven possibilities with our transformative Excel 2007 Mastery Course! Designed for those who crave efficiency and innovation, this course is your gateway to transforming raw data into powerful insights. Imagine effortlessly navigating Excel's revolutionary Ribbon interface, constructing stunning datasets, and moving beyond basic spreadsheets to create dynamic analytical tools that speak volumes. This isn't just learning to click buttons--it's about mastering a craft that will set you apart in your career. Our expert-driven course distills years of professional expertise into hands-on, real-world applications, ensuring that you're equipped not only with knowledge but with confidence and proficiency. Whether you're looking to enhance productivity, forecast business trends, or simply streamline daily tasks, Excel 2007 has the features you need, and we have the course to guide you. Join a community of ambitious learners and unlock access to tools and techniques that will propel you and your career to new heights. This course is your essential step into a future where data works for you. Your Excel mastery journey starts here--seize this opportunity now!
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 1-
Lesson 1 : Introduction+
This document 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. Whether you are familiar with previous versions of Excel, or this
Introduce Yourself+
Introduce Yourself
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 2-
Lesson 2: Getting Started with Excel: Opening a Blank or New Workbook, General Organization+
Opening a Blank or New Workbook, General Organization
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 3-
Lesson 3 : Highlight and Main Functions: Home, Insert, Page Layout, Formulas+
In this Section, the Main Tabs -- Home, Insert, Page Layout, and Formulas -- will be discussed in more detail below. Just knowing where the different commands can be found is an important first step to using Excel 2007!
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 4-
Lesson 4 : Highlights and Main Functions: Data, Review, View, Add-Ins+
In this section, the Main Tabs - Data, Review, View and Add-Ins - will be discussed in more detail.
Lesson 4 Activity+
Lesson 4 Activity
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 5-
Lesson 5 : Using The Excel Help Function+
In the far upper right corner of the workbook, there is a question mark with a circle around it. This is Microsoft's standard indication of its Help Function. CLICK on the question mark to open the Excel Help box as seen below. The EXCEL HELP featu
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 6-
Lesson 6 : Customizing The Quick Access Toolbar+
The QUICK ACCESS TOOLBAR contains commonly used commands that stay visible within the worksheet regardless of what Tab or other commands are being used.
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 7-
Lesson 7 : Creating and Using Templates+
Microsoft Excel 2007 provides access to a variety of free TEMPLATES. TEMPLATES are predefined forms and documents that were created to fulfill a specific task or purpose. And, these document templates can be customized as needed for color themes, other re
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 8-
Lesson 8 : Working with Data: Entering, Editting, Copy, Cut, Paste, and Paste Special, Undo and Rep+
This section 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 8 Activity+
Lesson 8 Activity
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 9-
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. 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 10-
Lesson 10 : Saving, Page Setup, and Printing+
This chapter 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 10 Activity+
Lesson 10 Activity
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 11-
Lesson 11 : Using Headers and Footers+
This chapter 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. 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 12-
Lesson 12 : Manipulating Data Using Names and Ranges, Filters and Sort, and Validation Options+
This chapter 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. 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 13-
Lesson 13 : Data From External Sources+
This chapter 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 13 Activity+
Lesson 13 Activity
Lesson 14. Excel 2007 Tables: From Basic Conversion to Advanced Formatting
Lesson Summary 3
Lesson 14-
Lesson 14 : Using and Formatting Tables+
This chapter 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. The first step is to convert the da
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 15-
Lesson 15 : Using Basic Formulas and Functions+
This chapter begins delving into the heart of Excel 2007 -- using formulas and functions to manipulate and analyze data.
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 16-
Lesson 16 : Data Analysis Using Charts and Graphs+
This chapter 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 16 Activity+
Lesson 16 Activity
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 17-
Lesson 17 : Managing Worksheets+
This chapter 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 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 18-
Lesson 18 : Securing the Excel 2007 Document (Protect Worksheets and Workbooks)+
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 18 Activity+
Lesson 18 Activity
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 19-
Lesson 19 : Advanced Formulas and Functions+
This chapter 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. 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 20-
Lesson 20 : Advanced Worksheet Features+
This chapter continues to review advanced areas within Excel 2007 that allow increased management of workbooks and use of features within worksheets. Included in this chapter:
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.
Lesson 21-
Lesson 21 Advanced Data Analysis using Pivottables and Pivotcharts+
This chapter 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. The Pivot Table Wizard
In This Course
14 Hours average completion time
1.4 CEUs
21 Lessons
28 Exams & Assignments
21 Videos
23 Reference Files
Mobile Friendly
Last Updated April 2024
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!
Skills You'll Develop
Secure workbook encryption techniques
External data integration capabilities
Data validation and management proficiency
Dynamic chart creation and customization
Worksheet and workbook organization skills
Data organization and manipulation expertise
Efficient use of Excel 2007 Ribbon interface
Advanced formatting and layout techniques
Template utilization for efficiency
PivotTables for data analysis
Advanced formula and function usage
Skills You'll Develop
Secure workbook encryption techniques
External data integration capabilities
Data validation and management proficiency
Dynamic chart creation and customization
Worksheet and workbook organization skills
Data organization and manipulation expertise
Efficient use of Excel 2007 Ribbon interface
Advanced formatting and layout techniques
Template utilization for efficiency
PivotTables for data analysis
Advanced formula and function usage
More About This Course
Grow Professional Expertise: Acquire valuable Excel skills for career advancement.
Seamless Integration: Connect Excel with various external data sources.
Boost Productivity: Customize toolbars for streamlined workflow.
Unlock Business Potential: Master data management and organization.
Optimize Spreadsheet Design: Apply themes and styles effortlessly.
Engage with Visuals: Create impactful charts and graphics.
Elevate Data Security: Protect your spreadsheets with robust options.
Simplify File Management: Efficiently handle large datasets.
Discover New Features: Explore Excel 2007's modern interface and tools.
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.
AA
"Extraordinarily Helpful"
★★★★★
All of it was helpful.
SO
"Extraordinarily Helpful"
★★★★★
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.
Our site uses cookies for general statistics, security, customization, and to assist in marketing efforts in accordance with our
cookie and privacy policy.
14 Hours average completion time
1.4 CEUs
21 Lessons
28 Exams & Assignments
21 Videos
23 Reference Files
Mobile Friendly
Last Updated April 2024
