Advanced Microsoft Excel 2013

Cena

110.00

Lokacija

Beograd,
Online,
In-house

Trajanje kursa

1 dan / 7 sati

Datum

Po dogovoru

Prijava

Plan obuke:

Module 1: Using Pivot Tables

  • Creating Pivot Tables
  • Inserting Slicers
  • Working with Pivot Tables
  • Inserting Pivot Charts
  • More Pivot Table Functionality

Module 2: Auditing Worksheets

  • Tracing Precedents
  • Tracing Dependents
  • Showing Formulas

Mobile 3: Data Tools

  • Converting Text to Columns
  • Linking to External Data
  • Controlling Calculation Options
  • Data Validation
  • Consolidating Data
  • Goal Seek

Module 4: Working with Others

  • Protecting Worksheets and Workbooks
  • Tracking Changes
  • Marking a Workbook as Final

Mobile 5: Recording and Using Macros

  • Recording Macros
  • Running Macros
  • Editing Macros
  • Adding Macros to the Quick Access Toolbar

Module 6: Random Useful Items

  • Sparklines
  • Preparing a Workbook for Internationalization and Accessibility
  • Importing and Exporting Files

Module 7: Microsoft Excel 2013 New Features

Module 8: Microsoft Excel 2013 New Features

  • Using Slicers to Filter Data
  • Creating a PivotTable Timeline
  • Creating a Standalone PivotChart
  • Workspaces in Excel 2013

Benefiti:

  • Video snimak predavanja u periodu od 365 dana posle kraja obuke
  • Pristup laboratorijama u toku trajanja kursa
  • Materijal u elektronskom obliku
  • Zvaničan Microsoft sertifikat o pohađanju kursa

Poželjno predznanje:

  • Familiarity with using a personal computer, mouse, and keyboard.
  • Comfortable in the Windows environment.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.
  • Basic Excel 2013 skills.
  • Basic understanding of security concepts such as authentication and authorization.
  • An understanding of the fundamental principles of using printers.

 

Dalje usavršavanje:

LOOKUP FUNCTIONS (MS50559)