Vi ste ovdje
Overview/Description
Within the two Microsoft Office Suite releases available since Office 2003, Microsoft has implemented a number of functionality and interface changes and introduced several new features. The overall Office interface has been changed substantially with the introduction of the Ribbon in Microsoft Office 2007, and collaboration and anywhere access to Office files is a major theme in the Microsoft Office 2010 release. This course examines the new features and enhancements of Microsoft Office 2010, focusing on the perspective of Microsoft Office 2003 users who are migrating...
Overview/Description
Access 2010 and Windows SharePoint Services provide a tightly integrated solution for making Access databases web capable. This course details the primary features that allow for the seamless integration of Access and SharePoint so that data can be shared across corporate networks or the Internet. It demonstrates how to share Access and SharePoint data, and how Access and SharePoint work together with a new feature called Access Services to make entire applications available through SharePoint.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0...
Overview/Description
PowerPoint 2010 provides you with all the tools necessary to create and present engaging and effective presentations. As an advanced user, you can take advantage of features that allow you to customize your animations to create just the right effect. PowerPoint has tools for getting your animations to move at the right speed and in the right order. There are also built-in tools, such as the animation painter, that allow you to easily apply an animation scheme to the entire presentation in one easy step. Once you have perfected your presentation, you can set and rehearse...
Overview/Description
Excel 2010 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the concepts and terminology associated with formulas, and demonstrates how to create and edit them, copy and paste them, and how to check for errors that can arise.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson...
Overview/Description
One of the great features of Excel 2010 is its ability to perform a wide variety of functions to make your use of Excel 2010 easier and more fun. Functions are inbuilt formulas that save you time by allowing you to chose one that suits your needs rather than having to create a complex formula from scratch. This course introduces you to the changes made to functions in Excel 2010, including improved function accuracy and consistency as well as the changes made to some function names that make them more intuitive. It describes the useful feature of Excel's status bar that...
Overview/Description
Excel 2010 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Tables can be used to logically present data in an easy to read fashion and table styles provide a way to make your workbooks more attractive and professional looking. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines, a new feature of Excel 2010 are small charts within a cell that provide a visual...
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
Being able to collaborate with other users to efficiently disseminate information and complete projects is crucial in today's business environment. Excel 2010 provides numerous tools geared specifically toward collaboration, including Excel Web App and integration with SharePoint that allows for data to be easily exported. Excel 2010 data can also be linked to or embedded in other Office 2010 files, and other Office 2010 data can be linked to or embedded into Excel 2010 to create robust and professional content. This course explores the new Excel Web App, including...
Overview/Description
The Excel 2010 function library includes a number of functions in Lookup...
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...