Microsoft Excel Dashboard Crash Course Webinar training seminars presented by Online Compliance Panel register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Microsoft Excel Dashboard Crash Course Webinar  

 Email information about this seminar Microsoft Excel Dashboard Crash Course Webinar by Online Compliance Panel to yourself your manager or associates Email this event... View and register for other training seminars like Microsoft Excel Dashboard Crash Course Webinar by Online Compliance Panel on FindaSeminar.com Find similar training.. Find and register for other training seminars by Online Compliance Panel on FindaSeminar.com Other seminars from Online Compliance Panel

By:

Online Compliance Panel   

For:

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

This Microsoft excel training course will introduce you to Microsoft Excel dashboard that helps to condense large amounts of data into simple summaries. (see full course description)

 

 Seminar / Training class dates & locations

 
 SORT RESULTS BY:

 DATE

LOCATION

SELECTED VENUE DETAILS

Facility Name: 
Address:





Registration Information:

Event cost:  $
USD

class times and cancellation policy

 
 




 From 
 To 
 Click to register by Register by fax for Microsoft Excel Dashboard Crash Course Webinar training seminar Register by mail for Microsoft Excel Dashboard Crash Course Webinar training seminar Register by phone to attend Microsoft Excel Dashboard Crash Course Webinar training seminar

Print payment approval request form Microsoft Excel Dashboard Crash Course Webinar training seminar

Pre-Registration questions? Find answers in our registration FAQ or Request information about upcoming training seminars workshops and conferences in   and other cities listed on FindaSeminar.com Submit a support request

 
 

 

share this page 

print the agenda print agenda for the Microsoft Excel Dashboard Crash Course Webinar seminar

 

 

Training Course Syllabus:


Microsoft Excel Dashboard Crash Course Webinar

Time: 10:00 AM PDT | 01:00 PM EDT

Duration: 120 Minutes

Instructor: David H. Ringstrom

Description:

This webinar will provide an inside out training on the concept of dashboards in Microsoft excel and its advantages. Dashboards empower Excel users to condense large amount of information into easy to read summaries while preserving the ability to dive deep into the details when needed.

The speaker David H. Ringstrom will discuss about using Microsoft Query to set up automated connections to databases, text files, or even other Excel spreadsheets. He will also introduce you on the different techniques for presenting information in dashboard form.

In this session David teaches from Excel 2010. The techniques shown work in the same fashion in Excel 2007 and 2013, and his handouts include alternate instructions for Excel 2003 where applicable. Certain features discussed in this presentation, namely Microsoft Query, are not available in Excel for Mac.

Why Should you Attend:

Attend this webinar to learn how to use features in Excel that minimizes both data integrity risks and spreadsheet maintenance. It will also help you discover the nuance in Excel where the wrong choice of workbook format can disable key features. This webinar will also help you to learn alternatives to manually copying and pasting data that you can manually compile into reports, summaries, and charts.

Objectives of the Presentation:

The key objectives of the presentation are as follows:


  • Create set-and-forget links to text files exported from other programs, such as accounting package.

  • Connect your spreadsheets to text files, Microsoft Access or SQL databases by way of Microsoft Query

  • How Pivot Tables are a key addition to an Excel dashboard, and how the drill-down feature allows users to view additional detail on demand.

  • Explore the Sparklines feature available in Excel 2010 and later, as well as a free add-in that enables this functionality in Excel 2007 and earlier.

  • How the Slicers feature in Excel 2010 and later can enhance dashboard functionality by enabling users to update multiple pivot tables at once.

Seminar Summary:

This Microsoft excel training course will introduce you to Microsoft Excel dashboard that helps to condense large amounts of data into simple summaries. (see full course description)

print this agenda print agenda for the Microsoft Excel Dashboard Crash Course Webinar training seminar

 view dates and locations for this seminar

 

 

 

Custom Search