With the introduction of Office Excel 2007, Microsoft has made substantial changes to the user interface of its spreadsheet application. This course will help get you up-to-speed on the new features, and will introduce you to the basic features and functionality of Excel 2007. This will be accomplished through the demonstration of workbook creation and navigation, and worksheet data entry at a user-friendly beginner level.
Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007.
Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
Lesson Objectives
Course Overview
Spreadsheets and Excel 2007
- match basic Excel 2007 features with their functions
- recognize how to use the Help feature in a given scenario
Create and Navigate Workbooks in Excel 2007
- create a new Excel workbook in a given scenario
- open an existing Excel workbook in a given scenario
- navigate through an Excel workbook
Enter Data and Text in Excel 2007
- enter data in an Excel worksheet in given scenario
Save Work in Excel 2007
- save a new workbook
- distinguish between the common file formats used to save work in Excel 2007
Creating and Saving a Workbook in Excel 2007
|
Key Concepts:
|
|
Desktop Certifications, Microsoft, Microsoft Certified Application Specialist Certification, 77-602 Using Microsoft Office Excel 2007, Desktop Curricula, Microsoft Office 2007, Microsoft Office 2007: Beginning Excel
|
|
|
Course Appears in these Categories:
|
• Desktop Certifications >> Microsoft >> Microsoft Certified Application Specialist Certification
• Desktop Skills >> Microsoft Office 2007 >> Microsoft Excel 2007: Basics
• Continuing Professional Education >> National Association of State Boards of Accountancy (NASBA)
|
|
|
Courses you might be interested in:
|
• Programmability and Administration in Access 2007
• Database Administration in Access 2007
• Importing and Exporting Data and Data Presentation in Access 2007
• Advanced Data Management in Access 2007
• Advanced Formatting in Excel 2007
• Advanced Data Management in Excel 2007
• Advanced Customization in Excel 2007
• Customizing Outlook 2007 and Using the Journal
• Configuring Rules, Alerts, and Junk E-mail Settings in Outlook 2007
• Working with SharePoint, Calendars, and Forms in Outlook 2007
• Creating Custom Slide Shows in PowerPoint 2007
|