Get in Touch

Course Outline

Advanced Functions

  • Logical functions
  • Mathematical and statistical functions
  • Financial functions

Lookups and Data Tables

  • Utilizing lookup functions
  • Applying MATCH and INDEX functions
  • Advanced list management techniques
  • Validating cell entries
  • Exploring database functions

PivotTables and PivotCharts

  • Creating Pivot Tables
  • Using Calculated Items and Calculated Fields

Working with External Data

  • Exporting and importing data
  • Handling XML data export and import
  • Querying external databases
  • Establishing links to databases
  • Connecting to XML data sources
  • Analyzing online data (Web Queries)

Analytical Tools and Options

  • Goal Seek
  • Solver
  • The Analysis ToolPak
  • Scenarios
  • Macros and custom functions
  • Running and recording macros
  • Working with VBA code
  • Creating custom functions

Conditional Formatting and SmartArt

  • Applying conditional formatting with visual elements
  • Utilizing SmartArt graphics

Requirements

Proficiency in Excel, along with a solid foundation in mathematics and basic finance, will be advantageous.

 14 Hours

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories