My Shopping Cart
 
There are no items in your shopping cart.


Create a Dashboard with Excel (IME761K)

Presented by: Mike Thomas
 
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
Event Description
See the sneak peek before you buy!
 
1.0 CPE

Step-by-Step Instructions to Create Easy, Professional and Attractive Excel Dashboards

Probably some of the most critical tools in your Excel armory are Dashboards and Reports. You can be the management or a personnel, a shareholder or prospective investor – these tools will provide you valuable insights into the Key Performance Indicators (KPIs) which helps measuring business. Often used to provide a visual summary, dashboards enables you as a decision maker, to determine your business’ future direction.

Yes, there are many other tools other than Excel which can create a Dashboard. However, Excel is used and favored commonly due to its power and flexibility, and also because almost everyone have Excel in their computers or mobile devices.

Join this session by Excel expert Mike Thomas and understand how you can build eye-catchy, professional looking dashboards with real-world examples. Know the importance of data cleaning, how to use Pivot Tables, how to display the ‘top x’ and much more. You will also get example worksheets at the end of the session.

Session Highlights:

  • Data sources
  • The importance of Data cleansing
  • Using PivotTables to create summary
  • Displaying the “Top X”
  • Visual communication using charts
  • Using infographic in your dashboard
  • Using formulas to create KPI summary values

 

Who Should Attend

For any user of Excel who wants to learn how to create Excel Dashboard. You should have an intermediate level of Excel knowledge. The training will be delivered using Excel 2016 for Windows. However, much of the functionality is available in Excel 2013 and 2010 and 2016 for Mac.

About Our Speaker(s)

Mike Thomas | Microsoft Excel Technology Training SpeakerMike Thomas
Mike has worked in the IT training business since 1989 where his expertise and experience covers designing, delivering training courses, writing training materials and recording and editing video-based tutorials. Although he is a subject matter expert in a range of Microsoft technologies and has worked extensively with... More info

 
We Also Recommend
Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
  •  
    Event Title: Create a Dashboard with Excel
    Presenter(s): Mike Thomas

 
 
 
 
Our Accreditation Partners
DMCA.com Protection Status
×

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or service@proedtech.com. You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.


Best regards,
The ProEdTech Team