Name: Business Intelligence with Excel • HURACT
Price: 1200.00 CHF
Availability: InStock

Description

Objectives

The "Business Intelligence with Excel" course explores in depth the potential of Microsoft Excel as a strategic tool for collecting, processing, and leveraging business data. Through an approach that combines theory, practical exercises, and real-world application cases, the course demonstrates how to leverage Excel in an advanced manner to support business decision-making processes based on accurate and timely data analysis. Methodologies and tools for integrating, modeling, and representing data in a clear, dynamic, and interactive manner will be presented. The teaching method emphasizes active learning, collaboration among participants, and the shared construction of knowledge and experience. The course thus represents a comprehensive, up-to-date training experience that is immediately applicable to professional practice.

Recipients

Anyone working in companies, financial institutions or organizations, as well as freelancers, interested in enriching their business intelligence skills and making advanced use of the potential of Excel for data analysis and management.

Take away

The course aims to train students to develop business recommendations for their external and internal customers based on the in-depth analysis and manipulation of data present in company information systems that can commonly be downloaded onto Excel spreadsheets.

Program

Basic notions

Relative and absolute references in formulas
Conditional formatting
Basic level shortcuts

Using filters

Using PivotTables

Using the functions

Functions (e.g. DAY, MONTH, and YEAR)
Text functions to transform and process text strings within a cell (e.g., LEFT, RIGHT, MID, LEN, FIND, TRIM, CONCATENATE, SUBSTITUTE and Text to Columns function ) and their combinations
Information functions (e.g. ISERROR, ISBLANK, ISNUMBER, ISTEXT, ISODD, and ISEVEN)
Logical functions to set conditions (e.g., IF, IFS, AND, and OR)
Mathematical functions for performing complex algebraic calculations (e.g., SUMIF, SUMIFS, COUNTIF, COUNTIFS, TRANSPOSE, SUMPRODUCT, and SUBTOTAL)
Search functions VLOOKUP (false and true variants ), HLOOKUP (false and true variants ), XLOOKUP (false and true variants ), MATCH (false and true variants ), and INDEX

Auditing formula (e.g., Tracking and Verification / Control)

Advanced ADDRESS and INDIRECT search functions

Function combinations

3D functions

Goal seek and solver

“Drop down” menu

Scenario Analysis

Hyperlinks