Nabídka tohoto termínu kurzu již není aktuální. Podobné kurzy naleznete zde.

Excel 2013 - Part 3*

Základní info


Duration
Classroom Learning - 1 Day(s)
Online LIVE - 1 Day(s)

Overview
In this course, students will learn some of the more advanced features of Excel, including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analyzing data, and using Excel data in other applications.

Who Should Attend
This course is intended for a student who has experience working with Excel and would like to learn more about creating macros, working with shared documents, analyzing data, and auditing worksheets.

Prerequisite(s) or equivalent knowledge
Excel 2013 - Part 1
Excel 2013 - Part 2
Prerequisite Comments
To ensure success, students should have practical, real-world experience creating and analyzing datasets using Excel 2013. Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment.

Outline
Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
Use 3-D References 
Use Links and External References 
Consolidate Data 
Lesson 2: Sharing and Protecting Workbooks
Collaborate on a Workbook 
Protect Worksheets and Workbooks
Lesson 3: Automating Workbook Functionality
Apply Data Validation 
Work with Forms and Controls 
Work with Macros 
Lesson 4: Applying Conditional Logic
Use Lookup Functions 
Combine Functions 
Use Formulas and Functions to Apply Conditional Formatting
Lesson 5: Auditing Worksheets
Trace Cells 
Search for Invalid Data and Formulas with Errors Watch and Evaluate Formulas
Lesson 6: Using Automated Analysis Tools
Determine Potential Outcomes Using Data Tables 
Determine Potential Outcomes Using Scenarios 
Use the Goal Seek Feature 
Activate and Use the Solver Tool 
Analyze Data with Analysis ToolPak Tools
Lesson 7: Presenting Your Data Visually
Use Advanced Chart Features 
Create Sparklines

Excel 2013 - Part 3*

Vybraný termín:

2.9.2015  Praha Upřesnující informace k termínu

Cena
4 200 Kč + 21% DPH

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je tři a deset ? Součet zapište číslicemi.