You are here:Courses|Microsoft|MS Office Customised Courses|EXCEL ADVANCED REPORT DEVELOPMENT

EXCEL ADVANCED REPORT DEVELOPMENT

This training is best suited for: SQL programmers, report developers, sophisticated Excel users. This training will help you to learn more about capabilities of Excel’s reporting. This course will pay attention to strategic and technical areas of Excel report development—online transactional processing databases.

Course Objectives :

  • Comprehend the PivotTables.
  • Comprehend and Access the Source Data.
  • Use the Query Wizard
  • Work with SQL in Microsoft Query
  • Create and Use Spreadsheet Reports
  • Use Excel Reports on the Web
  • Design PivotTable Reports
  • Manage PivotTable Data
  • Comprehend the Microsoft Query
  • Explore PivotChart Functionality
  • Work with OLAP Cubes

Course Modules:

  • Take a First Look at Excel’s Reporting Tools
  • PivotTables
  • Access Source Data
  • Query Wizard
  • OLAP Cubes
  • Spreadsheet Reports
  • Excel Reports on the Web
  • Get Start with Microsoft Query
  • Work with SQL in Microsoft Query
  • Design PivotTable Reports
  • Manage PivotTable Data
  • Explore PivotChart Functionality

 

Course Regular Track
(days)
Fast Track
(days)
EXCEL ADVANCED REPORT DEVELOPMENT 3 2
Balance Days  for day of arrival and practice 1 1
Total duration 4 3

Prerequisites:

  • Excel Basic knowledge.

 

 

Our Location

Get In Touch

1st Floor of CHABAH House,

Chabah Bus Stop on the Odokor-Mallam HighWay

Opposite Total Filling Station

P. O. Box DS 2022

Accra, Ghana

Phone: +233 303 393 1256 / +233 302 325 815

Cell: +233 244036 522

Email:[email protected]