コース概要

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

要求

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

 14 時間

参加者の人数



Price per participant

お客様の声 (2)

関連コース

Introduction to Data Visualization with Tidyverse and R

7 時間

Econometrics: Eviews and Risk Simulator

21 時間

HR Analytics for Public Organisations

14 時間

Statistical Analysis using SPSS

21 時間

Talent Acquisition Analytics

14 時間

Advanced R

7 時間

Algorithmic Trading with Python and R

14 時間

Anomaly Detection with Python and R

14 時間

Programming with Big Data in R

21 時間

R Fundamentals

21 時間

Cluster Analysis with R and SAS

14 時間

Data and Analytics - from the ground up

42 時間

Data Analytics With R

21 時間

Data Mining with R

14 時間

Deep Learning for Finance (with R)

28 時間

関連カテゴリー