Vi ste ovdje
Overview/Description
To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.
Target Audience
Individuals seeking practice in a structured testing environment,...
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
The Excel 2010 function library includes a number of functions in Lookup...
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...
Overview/Description
You can customize the look and feel of workbooks and the program's functionality and efficiency using Excel 2010's numerous features and tools. You can modify existing themes and styles to meet business needs, or you can create custom themes and styles to further enhance data presentation. Custom number formats allow you even more control over the presentation and usefulness of your workbooks and conditional formatting gives you the power to apply individual formatting based on custom rules that meet your specific needs. This course explores some of the more advanced ways...
- ‹‹
- 2 od 2