Microsoft Excel Level 5 (PivotTable and Dashboard Reporting)

by Keybase Training Solutions

This course is aimed at learners who need to analyse information utilising PivotTables as the foundation for Dashboard reports. Dashboard reports present business information as a clear, concise picture that is easy to read, understand, and update.

R6100

Contact the Institutes

Fill this form

Advertisement

Keybase Training Solutions Logo

img Duration

2 Days

Course Details

PivotTable and Dashboard Reporting

What Can You Expect?

This course is aimed at learners who need to analyse information utilising PivotTables as the foundation for Dashboard reports. Dashboard reports present business information as a clear, concise picture that is easy to read, understand, and update.

A variety of results can be condensed into a single page for comparison purposes, simplifying and reducing the time taken to report on organisational performance.

 

What Is Required From You?

Learners should have successfully completed Excel courses to an intermediate level or possess the equivalent knowledge. They should also have the ability to create mathematical formulas and formulas using basic functions (SUM, AVERAGE, COUNT, MAX, MIN). It is important that the learner is working on Microsoft Office 2013 or higher.

 

2 Day Course Content

Preparation of Source Data

  • Databases - What they are and how they work

  • Entering information correctly into Excel

  • Setting up a Database Table in Excel

  • Custom Formats

  • Using FlashFill

  • Using Format as Table

  • Using Conditional Format

  • Creating Sparklines

 

PivotTables

  • Understand the layout of a PivotTable

  • Create a PivotTable

  • Navigate the PivotTable Field Lists

  • Modify Design options of a PivotTable

  • Using Analysis Tools to analyse the information in different ways

  • Customise a PivotTable

  • Create a Formula in a PivotTable

  • Using Slicers

 

PivotCharts

  • Create PivotCharts

  • Format PivotCharts

  • Edit PivotCharts

  • Move and Size PivotCharts

  • Using chart options to change the design and layout of the Chart

 

Dashboard

  • Overview of what a dashboard is

  • Create a Dashboard with PivotTables and Charts

  • Create a Dashboard with PivotCharts Slicers and Timelines

  • Using PowerView to display Charts

  • An Introduction into using PowerPivots

 

What Will I Take Back To Work With Me?

You will be able to work efficiently and effectively within databases and you will be able to produce instant results using your newly founded PivotTable skills and professional dashboards.

  • Moreleta Park Branch

    608 Rubenstein drive, Moreleta Park, Pretoria

Check out more MS Excel courses in South Africa

The Hill Institute Logo

Dashboards & Reporting Using Microsoft Excel

Business professionals are frequently required to prepare management reports, scorecards, and dashboards. Attending this course will help you reach advanced Excel levels allowing you to produce such important reports.

by The Hill Institute
Leading Training Logo

Microsoft PowerPoint (Level 1)

This course will teach you how to create interactive slide shows using this popular presentation program. Microsoft PowerPoint is among the most prevalent forms of persuasion technology.

by Leading Training [Claim Listing ]
Think 360 Logo

Microsoft Outlook (Level 1)

In this course, you will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself, and customize the Outlook interface to suit your working style.

by Think 360 [Claim Listing ]
Lwazi Academy Logo

Computer Studies (MS Office)

Computer Studies (MS Office) course is offered by Lwazi Academy. Lwazi Academy offers a range of computer courses, including national qualifications and short learning programs. You can choose to study anything from basic computer practice to management assistant courses.

by Lwazi Academy [Claim Listing ]
Susca Watts Middelburg Logo

Microsoft Excel (Spreadsheets)

Microsoft Excel (Spreadsheets) Training Course is offered by Susca Watts Middelburg. The Academy focuses holistically on providing students with stimulating and comprehensive qualifications as well as short skills courses recognized nationally and internationally ensuring dynamic careers.

by Susca Watts Middelburg

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy