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 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
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...
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.
