Dashboard and Business Reports using Excel Certification
5.0 /5- Offered byPrinceton Academy
Dashboard and Business Reports using Excel Certification at Princeton Academy Overview
Duration | 3 days |
Total fee | ₹4,130 |
Mode of learning | Online |
Credential | Certificate |
Dashboard and Business Reports using Excel Certification at Princeton Academy Highlights
- Earn a certificate of completion from Princeton Academy
Dashboard and Business Reports using Excel Certification at Princeton Academy Course details
- Advanced and dynamic data validations
- Design outstanding visualization charts
- Develop master level report solutions using advanced form controls and buttons
- Record, write and edit powerful macros that will perform routine tasks in no time
- All business professionals are required to prepare some kind of a scorecard or a dashboard
- Attending this workshop will help you reach advanced levels in Excel which you will need to produce such an important tool
- The workshop starts with pivot tables, the most important tool ever created to perform data reporting, analysis and reconciliation
- It then continues with high level modelling techniques, integration and report visualization, and it ends with automation
Dashboard and Business Reports using Excel Certification at Princeton Academy Curriculum
Essential Reporting Requirement Skills
Pivot tables and pivot charts
Advanced pivot techniques
Multiple consolidation ranges
Connecting to access databases
Advanced Data Structuring Techniques
Custom and advanced data validation
Creating and managing innovative conditional formatting
Charting and Visualization Techniques
Creating dynamic labels
Working with formula-driven visualizations
Using fancy fonts
Leveraging symbols in formulas
Working with sparklines
Slicers and timelines
Creating unconventional style charts
Fancy thermometer charts
Colored chart bars
Power BI
Building report Solutions
Conceptualizing and understanding report solutions
Developing a report solution
Configuring spreadsheet report data options
Enabling background refresh
Form controls data modeling tools
Option-button modeling
Check-box data models
Combo and group-box
Dashboard Macros
Simple & Complex Macros
Dynamic Dashboards using Macros
Other courses offered by Princeton Academy
Student Forum
Anything you would want to ask experts?