Course content
The Chief Audit Executive and Senior Auditor can use Excel for a variety of testing, analysis and reporting purposes. This seminar focuses on the use of Excel to enhance the efficiency of the Chief Audit Executive and Senior Auditor in their reporting and analyzing duties.
Course Features
- Lectures 11
- Quiz 0
- Duration 16 hours
- Skill level All levels
- Language English
- Students 0
- Certificate No
- Assessments Yes
Curriculum
- 2 Sections
- 11 Lessons
- 2 Days
Expand all sectionsCollapse all sections
- Designing Reporting Dashboards4
- 2.1Tailor a dashboard to a specific group of users30 Minutes
- 2.2Outfit the dashboard with monitoring elements, such as key metrics, trends and status indicators, and value and variance gauges30 Minutes
- 2.3Types of interactive grids, graphs and pivot tables30 Minutes
- 2.4Reporting and ad hoc query panels to support decision making30 Minutes
- Building Reporting Dashboards7
- 3.1Pivot tables with slicers30 Minutes
- 3.2Conditional formatting to mark KPI’s in red/yellow/ green, and use icon sets to show traffic lights30 Minutes
- 3.3Sparklines and trendlines30 Minutes
- 3.4Dynamic labeling30 Minutes
- 3.5Trending, as well as performance vs. target comparisons30 Minutes
- 3.6Group and bucket data30 Minutes
- 3.7Interactive interface using sliders, slicers and other tools to drill down into the metrics.30 Minutes
