Summary:

The Learning segment teaches you to apply filters, use formulas and analyze data.

You will be able to apply your knowledge to create complex business applications and analyses in Microsoft Excel.          

Learning segment 1 : Working with Functions

Summary:

This learning segment introduces the use of Excel 2007 functions.  

Objectives:

• Calculate results with math functions
• Use date and time functions
• Adjust text with functions
• Work with logic and information functions
• Use lookup functions to locate data
• Determine payments with financial functions
• Use statistical functions to determine relationships  

Topics:

• Using functions in Excel
• Calculating with math functions
• Using date and time functions
• Using functions to adjust text
• Making decisions with logical functions
• Testing with information functions
• Finding data with lookup functions
• Calculating payments with financial functions
• Finding relationships with statistical functions    

Learning segment 2 : Using Data Analysis Tools    

Summary:

This learning segment provides an introduction to the commands used to analyze data in Excel 2007.  

Objectives:

• Use What-If analysis in Excel 2007
• Create analyses with Scenario Manager
• Analyse data using Goal SeekInstall Solver  

Topics:

• Using What-If Analysis
• Creating Analyses with Scenario Manager
• Using Goal Seek
• Exploring Solver    

Learning segment 3 : Automating with VBA Macros    

Summary:

This learning segment introduces the use of macros in Excel 2007.  

Objectives:

• Enable the Developer tab on the Ribbon
• Modify macro security settings
• Record and run macros
• Record a macro that uses an advanced filter
• Customize macros for everyday use
• Combine elements of written code with recorded code  

Topics:

• Setting VBA security
• Recording and Running Macros
• Using the End Key
• Filtering with Macros
• Understanding VBA Code
• Writing Macros
• Controlling and Combining Macros                    

Learning segment 4 : Adding Connections and Importing Data    

Summary:

This learning segment provides detail about connecting worksheets and workbooks for automatic sharing and updating. It also provides detail about importing information from the Web, text files, XML data, Access documents, and other files from external data sources.  

Objectives:

• Connect two worksheets in separate workbooks
• Use the Links tab on the Trust Center
• Set up a connection to a Web page
• Import an XML file
• Connect to an Access database using Microsoft Query  

Topics:

• Connecting Two Worksheets
• Connecting Two Workbooks
• Connecting to Data on a Web Page
• Connecting to a Text File
• Connecting to a Database

Features:

• Flash and audio provide animated, interactive Lesson Introductions, Activities, and Simulations.
• Audio accompanies each lesson page throughout the course.
• Show Me Hows allow learners to access instructional demonstrations from all courses in the series.
• Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
• Activities allow learners to apply course concepts in an interactive questioning environment.
• Full-page images allow learners to experience an application as if it were open on their computer
• Exercises allow learners to practice in the actual application being studied.
• A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
• Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
• Search text enables learners to rapidly search all text within a course to easily retrieve information required.
• Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
• A skill assessment generates a customized learning path based on the results of a pre-test.
• A glossary provides a reference for definitions of unfamiliar terms.
•  Bookmarking tracks the learner's progress in a course.  

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.