920009505
info@phrs.com.sa
Prime HR Solutions Prime HR Solutions
  • Consulting
  • Training
  • Assessment
  • HR Outsourcing
  • Why Prime
  • Contact us
  • Consulting
  • Training
  • Assessment
  • HR Outsourcing
  • Why Prime
  • Contact us
  • Home
  • Dashboards on Excel

Page title

Home Next Schedule Courses Dashboards on Excel

Dashboards on Excel

Course Overview 

This is a one day course that will enable attendees to create an interactive dashboard on MS Excel effectively, to create a dashboard that updates by a click of a refresh button, or by pasting new data into the Excel spreadsheet.

Participants will be able to utlize dashboards capabilities of Microsoft Excel and represent information into an easily understandable view with the learning of this course.

Course Duration 

1 Day

Course Content

The course begins with a basic understanding of dashboards and reports; it will cover principles and guidelines for dashboard design, number formatting, effective use of labels, switch the orientation of rows & column, and linking text to a cell. The course will teach about the use of charts; it will educate to create and format a chart, understand and change the chart types, create combination charts, and chart templates.

Furthermore, the user will learn to utilize tools such as chart axes, gridlines, data labels, and pivot tables. Attendees will know how to change summary calculations, suppress subtotals, show or hide data items, create bespoke navigation bars, link dashboards, and use named objects.

The course will teach to leverage handy functions such as the OFFSET function, MATCH function, using IF to organize the data tables, and using OR/AND operators to create Nested IF statements. The course demonstrates the user to create dynamic charts, use table formulas, use VLOOKUPs, OFFSETs, and Name range lists. Therefore, the users will be able to gain through understanding and expertise in the Microsoft Excel dashboards and its offered tools.

Who Should Attend?

This course is extraordinarily beneficial to anyone that works with dashboards, reports, and data. It is an ideal course for all Business intelligence developers.

  • + Add to Google Calendar
  • + iCal / Outlook export

Date

Mar 24 2020
Expired!

Time

8:00 am - 6:00 pm
Category
KN

Share this event

QR Code

LEARN MORE Your People at the your Center of Excellence looking for the state-of-the-art HR setup?
Call our experts now.

Consulting

LEARN MORE
we leverage your workforce capabilities.

Training

LEARN MORE
never be deceived by a good CV writer, let's help you assess your people personalities, abilities, and potential.

Assessment

LEARN MORE
what's may be your daily headache, is our daily joy. Outsource your HR back-office!

HR Outsourcing

LEARN MORE

Related Events

Leave A Reply Cancel reply

Your email address will not be published. Required fields are marked *

Contact US

920009505
info@phrs.com.sa
Abu baker al-Siddiq Road Building 7766, 3rd Floor, Office 8

Useful Links

  • About us
  • Consulting
  • Contact us
  • Training
  • Join us
  • Assessment
  • Terms and Conditions
  • HR Outsourcing
  • Privacy Policy
  • Knowledge nuggets

Social Media

  • Facebook
  • Twitter
  • Linkedin
  • Instagram

Newsletter

Subscribe to get updates right in your inbox. We promise to not send you spams.

Copyright© Prime Human Resource Solution All Rights Reserved.