Vi ste ovdje
Overview/Description
Numerous features and tools in Excel 2007 enable you to customize the look and feel of spreadsheets and workbooks, and also the functionality and efficiency of the program itself. Existing templates, themes, and styles can be altered to meet business needs, or you can create custom templates, themes, and styles to further enhance data presentation. Using macros, you can automate common or repetitive tasks, resulting in time savings and increased efficiency in day-to-day tasks. This course covers creating templates in Excel 2007, as well as customizing workbook properties...
Overview/Description
Excel 2007 provides multiple features for organizing and managing data, so you can ensure data is entered correctly and that calculations and formulas are valid. Data organization features enable you to sort, filter, and group and outline data so that you can focus on the key parts of your data. Validation features ensure that data is correct, that it is entered in the proper format, and that formulas are working correctly, all of which are incredibly important for maintaining accurate records. This course explores organizing and subtotaling data in Excel 2007 using the...
Overview/Description
Charts and pictures enable you to present data visually, demonstrating data more effectively than rows and columns of data. In Excel 2007, you can customize charts and their individual elements, as well as pictures and clip art, to create professional and appealing documents. Formatting, both custom and condition-based, enables you to display data in formats that best suit your needs. This course explores modifying charts and pictures and creating and editing custom number formats.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2007 at an...
Overview/Description
Excel 2007 provides powerful data analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. With PivotTable reports you can interactively summarize data, making it easier to analyze and present the results. PivotChart reports provide a graphical view of PivotTable report data. Using Goal Seek and Solver enables you to retrieve required results from formulas by determining the data the formula requires. You can also use additional what-if analysis components, data tables and scenarios, to view how value...
Overview/Description
Enhancements to charting, themes, and styles in Excel 2007 enable you to create attractive and well-organized representations of spreadsheet and workbook data. Charts, themes, styles, and pictures can all be easily inserted and customized from the Ribbon bar. This course demonstrates how to effectively use and customize charts in Excel 2007, and explores available chart types and styles. Using themes and styles to improve presentation, and adding visual elements to workbooks, are also covered.
Target Audience
Personnel at all levels of the enterprise; end-users seeking...
Overview/Description
Excel 2007 provides numerous functions and formulas for performing simple and complex calculations on workbook data. The Ribbon's Formulas tab provides convenient access to groups of data analysis and calculation tools, such as the Function Library, Named Cells, Formula Auditing, and Calculation groups. This course demonstrates how to create and edit formulas, use references and names, and work with tables in Excel 2007. Basic, logical, financial, and date functions are also covered.
Target Audience
Personnel at all levels of the enterprise; end-users seeking competency...
Overview/Description
In Excel 2007, there are a number of options for importing data and sharing data with other applications. Excel 2007 includes built-in functionality for importing text files and creating database queries to retrieve data from a variety of databases. Other applications, such as Access, Word, and Outlook, can also import Excel data. Using XML in conjunction with Excel enables you to further manage and customize workbooks. This course explores creating links, importing text files, and creating database and web queries. Importing Excel 2007 data into other applications and...
Overview/Description
With the introduction of Office Excel 2007, Microsoft has made substantial changes to the user interface of its spreadsheet application. This course will help get you up-to-speed on the new features, and will introduce you to the basic features and functionality of Excel 2007. This will be accomplished through the demonstration of workbook creation and navigation, and worksheet data entry at a user-friendly beginner level.
Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007.
Prerequisites
Some...
Overview/Description
Excel 2007 provides a number of improved tools and new features that allow you to visually enhance the appearance of sheets and workbooks. Cells, rows, columns, sheets, and workbooks can be manipulated and customized using various positioning and formatting features. This course explores the processing of copying and moving cells, columns, rows, and sheets, as well as inserting or removing sheets and modifying workbooks. Formatting tables, textual data, and numerical data, as well as conditional formatting, is also covered.
Target Audience
Personnel at all levels of the...
Overview/Description
SkillSoft Mentors are available to help students with their studies for the Using Excel 2007 exam. You can reach them by entering a Mentored Chat Room or by using the E-mail My Mentor service.
Target Audience
Individuals who are studying the associated SkillSoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.
Prerequisites
Familiarity with the exam objectives listed below and skills and competencies being measured in the associated certification exam.
Expected Duration (hours)
0.0
Lesson...
- 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.
