Analyzing large amounts of data (Excel advanced)
  • Compliance and regulatory frameworks - Know regulatory, financial, risk and ethical frameworks (Sarbanes-Oxley system, AMF and SEC regulations, etc.).
  • Data analytics, statistics, data analysis - Fundamental knowledge of statistics, data analysis (including correlation, regression and categorizing) and forecasting methods - Growth (decline) - Index calculations.
  • Modelling, simulation, scenarios - Know business modeling, simulation, optimization, what-if analysis

Target audience

- Accountants
- Accounting managers
- Auditeurs internes
- Chartered Accountants, Statutory Auditors
- Consolidation and Accounting Directors
- Consolidators
- Financial managers

1 day

New training

Prerequisites

It is recommended to have and intermediate to advanced level in Excel. Bring your own laptop.

Objectives

– Know how to quickly extract significant elements from a large database in Excel
– Be able to build dynamic summaries and insightful analyses

Contenu

> Data description:

– Counting, frequency, data distribution under criteria
– Reminders: average, median, quartiles, weighted average, qualitative and quantitative data, discrete or continuous data variable, variance and standard deviation
– Text to figures (or reverse) functions to standardize data and build reports and analyses

> Data analysis and decision tools

– Simulations with scenario function
– Goal seek and solver function
– Table function
– Use of forecasts and trend analyses
– Application: case studies in management accounting

> Extracting data and manipulating large databases

– Selecting and visualizing data: filter, group/ungroup – Text to column.
– Sort functions and slicer tool
– Advanced lookup functions and other database search functions: offset and match
– Pivot Table: building Pivot tables and charts. Building calculated fields. Grouping measures by date, value criteria, etc.

> Data visualization:

– Main graphs possibilities and trend analysis
– Conditional formatting, applying style and themes.
– Summary case study

Why should you attend?

The quantity of data available on organization grows every day. In particular, extracting data from information system (ERP, for instance) is easy and almost instantaneous. The main challenge is now for everyone to grasp and make sense of the data for business purposes.
This training introduces a very practical approach, leveraging the use of Excel’s advanced functions.

Training methods and assessment

Interactive and concrete illustrations with many examples drawn from business case studies
Assessment questionnaire.
A training certificate is delivered at the end of the session.

The trainer is available by e-mail to answer any follow-up questions participants may have

Price

1020 € Excl. VAT – 1224 € Incl. VAT

Médias

Témoignages

Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum.

Jonathan C.
Entreprise
Formation