Premium ¡89% de ahorro!

Microsoft Excel 2016 Advanced Training - CPD Certified & IAO Approved

Virtual

Precio Emagister

$ 194.987 $ 1.818.363

*Precio estimado

Importe original en GBP:

£ 43 £ 401

  • Tipología

    Curso

  • Nivel

    Advanced

  • Metodología

    Virtual

  • Horas lectivas

    7h

  • Inicio

    Fechas a escoger

Descripción

Microsoft Excel is used in businesses throughout, starting from engineering to diverse fields such as medicine. It is one of the top three best known Microsoft Office tools and probably the best spreadsheet program out there. However there is a steep learning curve to its advanced features, which you can now master from this Microsoft Excel 2016 Advanced Training course.
This course will help you learn some of the advanced features of the 2016 version of Excel. As such it starts out with a bang as you learn to automate worksheet functionality, along with how to update worksheet properties, create and edit macros, apply conditional formatting, and add data validation criteria. Next you discover ways to trace cells, troubleshoot invalid data and formula errors, watch and evaluate formulas, and create a data list online. Furthermore, you will learn to analyze and present data through statistical analysis, creating Sparklines and scenarios, and more. You will also learn how to work with multiple workbooks, export excel data, and import and export XML data.
Using this course correctly will lead you to master some of the most advanced features of Excel 2016 and essentially develop key skills that will help you stand out from the crowd.

Información importante

¿Esta formación es para mí?: There is no experience or previous qualifications required for enrolment on this course. It is available to all students of all academic backgrounds.

¿Qué pasará tras pedir información?: On receiving your request an academic officer from the course will call you to explain everything about the course, including how you can sign up, payment options and enrollment periods

Precio a usuarios Emagister:

Instalaciones y fechas

Ubicación

Inicio

Online

Inicio

Fechas a escoger Matrícula abierta

¿Qué aprendes en este curso?

  • Excel
  • Import and Export
  • XML training
  • XML
  • Microsoft Excel
  • Import Export
  • Web
  • Export
  • Import
  • Microsoft excel training
  • MS Excel
  • MS Excel
  • Microsoft excel training

Programa académico

COURSE CURRICULUM

Automating Worksheet Functionality

  • Update Workbook Properties
  • Activity-Update Workbook Properties
  • Create and Edit a Macro
  • Activity-Create and Edit a Macro
  • Apply Conditional Formatting
  • Activity-Apply Conditional Formatting
  • Add Data Validation Criteria
  • Activity-Add Data Validation Criteria

Auditing Worksheets

  • Trace Cells
  • Activity-Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Activity-Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Activity-Watch and Evaluate Formulas
  • Create a Data List Outline
  • Activity-Create a Data List Outline

Analyzing and Presenting Data

  • Create Sparklines
  • Activity_Create Sparklines
  • Create Scenarios
  • Activity-Create Scenarios
  • Perform a What-If Analysis
  • Activity-Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak
  • Activity-Perform a Statistical Analysis with the Analysis ToolPak
  • Create Interactive Data with Power View
  • Activity-Create Interactive Data with Power View

Working with Multiple Workbooks

  • Consolidate Data
  • Activity-Consolidate Data
  • Link Cells in Different Workbooks
  • Activity-Link Cells in Different Workbooks
  • Merge Workbooks
  • Activity-Merge Workbooks

Exporting Excel Data

  • Export Excel Data
  • Activity-Export Excel Data
  • Import a Delimited Text File
  • Activity- Import a Delimited Text File
  • Integrate Excel Data with the Web
  • Activity-Integrate Excel Data with the Web
  • Create a Web Query
  • Activity-Create a Web Query

Importing and Exporting XML Data

  • Import and Export XML Data
  • Activity-Import and Export XML Data

Precio Emagister

$ 194.987 $ 1.818.363

*Precio estimado

Importe original en GBP:

£ 43 £ 401