Course Outline

Introduction

Building a Reporting Model

Report Design And Structure

Pivot Tables

Preparing Spreadsheets Using Summing Functions

Other Reporting Functions

Defining Range Names

Maintenance

Conditional Formats

Charting Techniques

Report Validation

Monthly Reporting Process

Month-To-Date Reporting

Year-To-Date Reporting

12-Month Reporting

Closing Remarks

Requirements

  • Strong working knowledge of Excel
 7 Hours

Number of participants



Price per participant

Testimonials (3)

Related Courses

FinOps

7 Hours

Open Bank Project for Developers

14 Hours

Learning Xero

14 Hours

GnuCash for Business Accounting

7 Hours

Introduction to Fixed Income

14 Hours

A Practical Guide to Successful Pricing Strategies

7 Hours

Basics of Customizing for Financial Accounting: GL, AP, AR in SAP S/4 HANA (S4F12)

35 Hours

Investment Banking: Introduction to Structured Products

21 Hours

Financial Markets and Trading

14 Hours

Financial Markets

14 Hours

Anti-Money Laundering (AML) and Combating Terrorist Financing (CTF)

14 Hours

CRS: Foreign Financial Reporting and Automatic Exchange of Information

14 Hours

eCommerce Fraud Strategy for Managers

14 Hours

Related Categories