Vi ste ovdje
Overview/Description
Excel 2010 provides a large variety of statistical functions that allow you to perform data analysis on worksheet data, several cube functions that allow you to return information from cubes, and the means of working with arrays. In addition, using the Developer tab, you can further customize an Excel workbook to increase its functionality with form and ActiveX Controls. This courses discusses various statistical functions, include those designed to work with averages, determine the median, pinpoint rank and percentages, and sample populations. In addition, this course...
Overview/Description
As both business and home users move toward working in more electronically collaborative environments, the need to share Excel workbooks and to have multiple users edit them simultaneously has increased. Excel 2010 allows you to share workbooks over a network, distribute them by e-mail, and share them online. You can make use of Information Rights Management (IRM) to ensure that users cannot copy or forward workbook content, as well as to expire files and enforce corporate information dissemination policies. You can also specify that users can only edit specific ranges in...
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...