Plan Szkolenia

Advanced functions

  • Logical functions
  • Math and statistical functions
  • Financial functions

Lookups and data tables

  • Using lookup functions
  • Using MATCH and INDEX
  • Advanced list management
  • Validating cell entries
  • Exploring database functions

PivotTables and PivotCharts

  • Creating Pivot Tables
  • Calculated Item and Calculated Field

Working with External Data

  • Exporting and importing
  • Exporting and importing XML data
  • Querying external databases
  • Linking to a database
  • Linking to an XML data source
  • Analysing online data (Web Queries)

Analytical options

  • Goal Seek
  • Solver
  • The Analysis ToolPack
  • Scenarios
  • Macros and custom functions
  • Running and recording a macro
  • Working with VBA code
  • Creating functions

Conditional formatting and SmartArt

  • Conditional formatting with graphics
  • SmartArt graphics

Wymagania

Good Excel, maths and basic finance knowledge may be beneficial.

 14 godzin

Liczba uczestników



Cena za uczestnika

Opinie uczestników (2)

Szkolenia Powiązane

Introduction to Data Visualization with Tidyverse and R

7 godzin

Econometrics: Eviews and Risk Simulator

21 godzin

HR Analytics for Public Organisations

14 godzin

Statistical Analysis using SPSS

21 godzin

Talent Acquisition Analytics

14 godzin

Advanced R

7 godzin

Algorithmic Trading with Python and R

14 godzin

Anomaly Detection with Python and R

14 godzin

Programming with Big Data in R

21 godzin

Cluster Analysis with R and SAS

14 godzin

Data and Analytics - from the ground up

42 godzin

Data Analytics With R

21 godzin

Data Mining z wykorzystaniem R

14 godzin

Deep Learning for Finance (with R)

28 godzin

Deep Learning for Banking (with R)

28 godzin

Powiązane Kategorie