Vi ste ovdje
Overview/Description
Excel 2010 provides powerful data-analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. Using Goal Seek and Solver enables you to retrieve required results from formulas by determining the data the formula requires. And you can use additional what-if analysis components, data tables and scenarios, to forecast worksheet outcome models and to see how changing values in formulas affect the formula results.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level...
Overview/Description
To automate repetitive tasks, Excel 2010 provides a time saving feature known as a macro. These small programs, created using either a simple macro recorder or by using the more complex VBA language, allow you to record the numerous steps involved in accomplishing a task so that they can be played back automatically when the macro is run. This results in time savings and increased efficiency in day-to-day tasks. This course will introduce you to macros in Excel and show you how to leverage their power to make you work with Excel easier.
Target Audience
End users seeking...
Overview/Description
Adding visual elements to Excel worksheets can help to enhance what can sometimes be dry facts and figures, making it easier to hold the attention of the intended audience. A balance needs to be struck, however, between enhancing and overwhelming when it comes to adding graphics and colors to your Excel workbooks. Excel 2010 provides you with a number of basic and advanced techniques for customizing common elements such as charts, themes, cell styles, and graphics. This course describes many of these techniques and shows you how to implement them to their best effect....
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
Excel 2010 provides multiple features for organizing and managing data, including sorting and filtering tools that are integral to data analysis. Using data organization features, you can sort, filter, and group and outline data so that you can focus on its key parts. Properly arranged data using the commands in the Arrange group allows you to present your data in a logical and easy to understand manner. This course explores organizing data in Excel 2010 using the built-in features. It also covers arranging objects for better viewing as well as the use of hyperlinks to...
Overview/Description
PivotTables are a handy tool for summarizing large amounts of data efficiently and making it more manageable. Sometimes, though, it's useful to be able to filter the data in a PivotTable, and Excel 2010 provides filtering functionality for this specific purpose. For those people who require a more visual representation of data, Excel 2010 provides a new feature called a Slicer, which is basically a graphical representation of a PivotTable filter. Excel also provides a number of ways in which you can apply calculations to the data in PivotTables in the form of summary...
Overview/Description
One of the most powerful tools that Excel 2010 provides is a PivotTable that allows you to dynamically reorganize and display your data. PivotTables can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. PivotTables also allow you to choose and change what you want to summarize, quickly and easily. This course will introduce you to PivotTables and show you the many benefits they provide.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an...
Overview/Description
Excel 2010 provides easy to use and access tools that allow you to review, proof, and protect the workbooks you create and share. The tools for performing these tasks are grouped conveniently on the Ribbon and include the Spelling, Research, and Thesaurus tools; a Translate tool; tools to insert, edit, and review Comments in a worksheet; and tools for tracking changes and protecting workbooks. The various tasks you can perform with these features are covered in this course, along with how and when you would use these tools.
Target Audience
Individuals and business users...
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
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...
- 1 od 2
- ››
Koraci do učenja
Prijavite se, a ako nemate korisničko ime, registrirajte se.
Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.
Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.
Trebate pomoć?
- Česta pitanja - FAQ
- telefon: +385 1 6558 440
- email: support@cognita.hr
- Kontakt forma
Trenutno nema programa koji imaju objavljene termine.
