Vi ste ovdje
Overview/Description
Excel 2013 allows you to create worksheets and workbooks to manage and manipulate data easily. You can cut, copy, and paste data. You can also navigate within data cells, and worksheets. Not only can you manage the data at this level, you can group, color-code, and organize the worksheets within the workbook. This course will cover creating and opening workbooks, moving around in Excel 2013, moving data, and organizing worksheets. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office...
Overview/Description
Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores formatting cells and text, using tools such as the Format Painter. It shows how to change the way text is presented to make it more visually appealing, including formatting fonts, and applying borders and fills. This course also covers aligning and orienting data, and merging and splitting cells. This course will help...
Overview/Description
Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of data, automatically fill data, and create hyperlinks to various places. This course covers formatting numbers in currency, date, and percentage formats. It also covers ways of automatically filling data through Auto Fill and Flash Fill. Finally, this course covers creating hyperlinks to a website, another place in the workbook, a new document, and e-mail. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies...
Overview/Description
Excel 2013 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the basic concepts and terminology associated with formulas and functions. It also covers various ways of referring to cells and cell ranges and demonstrates how to use basic functions including logical and IF-type functions. This course will help prepare learners for the...
Overview/Description
Using the tables and charts features in Excel 2013, you can create attractive and well-organized representations of worksheet and workbook data. Both tables and charts can be easily inserted and customized. This course demonstrates how to effectively use and customize tables and charts in Excel 2013; it explores available table styles and chart types and the best use of each type. And the course shows how to change the different elements of a table or chart to provide an effective visualization of your data. This course will help prepare learners for the Microsoft...
Overview/Description
Excel 2013 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. 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 are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. This course covers applying conditional formatting, creating custom rules, and creating basic and advanced sparklines. This...
Overview/Description
Excel 2013 makes it easy to save and print workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it as a hard copy or share with someone else. You can save in various formats since Excel 2013 supports many file types. This course covers saving data, and preparing for printing including setting print options, page setup, print titles, headers and footers, and row and column headings. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies...
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.
