Overview/Description There are a number of methods for accessing and using external data with Excel 2010. Creating new or using existing data connections, you can access data from the Internet, Access and SQL Server databases, and Analysis Services. You can also import and export XML data, use Microsoft Query and the Query Wizard to create your own queries, and work from text files. This course explores the concept of data connections, including how to use existing connections to access data and how to create your own. In addition, this course covers how to create a web query to access online...

Overview/Description PowerPoint 2010 can help you make presentations more dynamic by adding audio and video clips to any slide. You can directly insert, edit, and play video in your presentation, as well as add audio clips to create attention-grabbing sound effects. PowerPoint 2010 also has new animation tools and slide transitions which make slide shows more fluid and interesting. All of these features are discussed in this course. Target Audience Individuals and business users with basic computer literacy Expected Duration (hours) 1.0 Lesson ObjectivesUsing Multimedia and Animations in...

Overview/Description To assist you with the various tasks and information that you need to process on a daily basis, Microsoft Outlook 2010 provides the Tasks, Notes, and Journal features to help keep you organized. You can create tasks for yourself or assign tasks to other users. You can create notes for yourself as small reminders, and manage your activities and information using the Journal. This course discusses how the Tasks, Notes, and Journal features can help you to manage your time and stay organized, and it demonstrates how to use them. Target Audience A broad range of business...

Overview/Description Formulas are an integral and important feature of Excel 2010. So ensuring they are correct can save you time and a lot of headaches. Excel 2010 provides you with the tools you need to audit formulas and correct errors that may be found. In addition, using Excel's data validation tools you can restrict the types of data that can be input to your workbooks – preventing data entry errors that could otherwise occur. This course describes Excel 2010's auditing and formula correction features and shows you how to use data validation to avoid worksheet errors. Target Audience...