Return-Path: Delivered-To: david@transocean.com Received: from vps.transocean.com by vps.transocean.com with LMTP id 4GiWFps16lnLJAAAInt2oQ for ; Fri, 20 Oct 2017 10:42:51 -0700 Return-path: Envelope-to: david@transocean.com Delivery-date: Fri, 20 Oct 2017 10:42:51 -0700 Received: from qw01012.businesswatchnetwork.com ([65.114.181.12]:43778) by vps.transocean.com with esmtp (Exim 4.89) (envelope-from ) id 1e5bJi-0002Up-Lz for david@transocean.com; Fri, 20 Oct 2017 10:42:51 -0700 Received: from localhost ([127.0.0.1]) by qw01012.businesswatchnetwork.com (-); Fri, 20 Oct 2017 13:42:00 -0400 X-VirtualServer: BWN-CL-01, qw01012.businesswatchnetwork.com, 10.1.250.112 X-VirtualServerGroup: BWN-CL-01 X-MailingID: 33554769::53937::804::29337::2_303088::303088_0_0 X-SMHeaderMap: mid="X-MailingID" X-Destination-ID: david@transocean.com X-SMFBL: ZGF2aWRAdHJhbnNvY2Vhbi5jb20= DKIM-Signature: v=1; a=rsa-sha1; c=simple; d=businesswatchnetwork.com; s=key1; i=@businesswatchnetwork.com; h=Content-Transfer-Encoding:Content-Type:CID:List-Unsubscribe: , MIME-Version: 1.0 Message-ID: <33554769.303088@businesswatchnetwork.com> X-ReportingKey: MJ7G7Y455K24PKLHXJJ263BJJJJ::david@transocean.com::2_303088 Subject: Go From Excel Pivot Tables To Dashboards Date: Fri, 20 Oct 2017 13:41:42 -0400 To: david@transocean.com Reply-To: noreply@businesswatchnetwork.com From: "SalesMktgWatch" X-Spam-Status: No, score=-0.2 X-Spam-Score: -1 X-Spam-Bar: / X-Ham-Report: Spam detection software, running on the system "vps.transocean.com", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see root\@localhost for details. Content preview: National Center for Continuing Education BusinessWatch Network (http://dms2.businesswatchnetwork.com/t/gcH1AAibGiBUVrBAAAKr1UzZeaJH4qaaaaaaBM3UNKwaa?l=A_v8v80G~amp;V=lS3al~25w8lzSvkwUmSv.Uwe~amp;t=U~amp;5=) [...] Content analysis details: (-0.2 points, 3.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- 0.0 URIBL_BLOCKED ADMINISTRATOR NOTICE: The query to URIBL was blocked. See http://wiki.apache.org/spamassassin/DnsBlocklists#dnsbl-block for more information. [URIs: businesswatchnetwork.com] -0.0 SPF_PASS SPF: sender matches SPF record -0.0 RP_MATCHES_RCVD Envelope sender domain matches handover relay domain 0.0 HTML_MESSAGE BODY: HTML included in message -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% [score: 0.0000] 0.0 HTML_FONT_LOW_CONTRAST BODY: HTML font color similar or identical to background -0.1 DKIM_VALID_AU Message has a valid DKIM or DK signature from author's domain 1.8 PYZOR_CHECK Listed in Pyzor (http://pyzor.sf.net/) 0.1 DKIM_SIGNED Message has a DKIM or DK signature, not necessarily valid -0.1 DKIM_VALID Message has at least one valid DKIM or DK signature X-Spam-Flag: NO ------=_NextPart_43D_C87A_72236EBC.4991716C Content-Type: text/plain; charset="UTF-8" Content-Disposition: inline Content-Transfer-Encoding: 7bit National Center for Continuing Education BusinessWatch Network (http://dms2.businesswatchnetwork.com/t/gcH1AAibGiBUVrBAAAKr1UzZeaJH4qaaaaaaBM3UNKwaa?l=A_v8v80G~amp;V=lS3al~25w8lzSvkwUmSv.Uwe~amp;t=U~amp;5=) Webinar: Wednesday November 8th, 2017, 1:00 - 2:30 pm Eastern Price: $199 Go From Excel Pivot TablesTo Dashboards (http://dms2.businesswatchnetwork.com/t/gcH1AAibGiBUVrBAAAKr1UzZeaJH4qaaaaaaBM3UNKwaa?l=A_v8v80G~amp;V=lS3al~25w8lzSvkwUmSv.Uwe~amp;t=V~amp;5=~amp;j=AwBzDt8z) View in your browser (http://dms2.businesswatchnetwork.com/t/gfH1AAibGiBUVrBAAAKr1UzZeaJH4qaaaaaaBM3UNKwaaZeJH4q?l=A_v8v80G~amp;V=lS3al~25w8lzSvkwUmSv.Uwe~amp;n=VinqV~25Cs1jif0gkWif.kgu~amp;d=Ku6~amp;p=~amp;z=?n=1W5l) Your Comprehensive Review of Pivot Tables and Introduction to Excel Dashboards Learn the Easiest Way To Make Analytics Sexy Create Amazing, Interactive, Eye-Catching Excel Dashboards Take Your Career to the Next Level - Harness Excel's 'Wow-Power' Register Today >> (http://dms2.businesswatchnetwork.com/t/gcH1AAibGiBUVrBAAAKr1UzZeaJH4qaaaaaaBM3UNKwaa?l=A_v8v80G~amp;V=lS3al~25w8lzSvkwUmSv.Uwe~amp;t=W~amp;5=~amp;j=AwBzDt8z) Why You Should Attend Excel Dashboards are the new buzzword employers are searching for. If you have, or want a career that involves creating reports in Excel, then you need to know how to build impressive, interactive, visually stunning, Excel dashboards. This practical, 90-minute webinar will leave you with Excel techniques you can immediately put to use making killer dashboards that set your skill level apart from others. Microsoft Excel dashboards are powerful tools that summarize spreadsheet data to render a concise overview of critical business metrics. Dashboards provide an excellent and succinct way to share a "snap shot" view of key performance indicators (KPIs) for both small businesses and enterprise-level organizations. This webinar will update your Excel skills by teaching you how to create impressive Dashboards even if you don't have artistic talent. At the conclusion of this webinar you'll be able to create amazing, interactive Excel dashboards that update at the click of a button and leave a lasting 'wow' impression. The hallmark of an interactive, data-driven dashboard is the ability to see and understand data at the speed of thought. This on-the-job, nut-'n-bolts training webinar will deliver the skills you need to design well-planned Excel dashboards that present answers to questions in real-time, render visually striking displays, turn insight into action, help accomplish your firm's objectives and improve your Excel skills. Easily Monitor Business Performance with Interactive Excel Dashboards You Create... Create dashboards the easy way. Pivot Tables are among the easiest methods of creating Excel dashboards. Why pay thousands to a consultant when you can learn this technique in just 90 fun minutes?   Webinar Agenda - What We Cover and What You Learn * Overview of Excel Dashboard Construction and Methodologies * Dashboard Design Dos and Don'ts * Data Range vs Table or Pivot Table for Dashboard Dynamic Updates * Rapid Pivot Table Review - A Mix of Basics with a Few Advanced Topics * Rapid Set Up - One-Minute Pivot Table Quick Start * Understanding the Pivot Field and Filtering Options * Analyze and Design Tab * Pivot Charts and Slicers * Updating Data - Using Refresh * Speed Tips - When/How To Copy and Paste Pivot Tables and Charts * Pivot Table Example: Analyzing Sales Tends by State, Salesman and Location * Dashboard Example: Pivot Table to Dashboard * Determine Spec Sheet, Layout, and then Copy and Paste Charts * Symmetry: Size and Align Charts Simultaneously with Format Tools * Slicers and the Critical Importance of Report Connections * Logos, Headings and Drawing Tools for Professional Touches * Hyperlinks for Navigation Between Dashboard and Database * Eliminating Gridlines, Headings, Formula Bar and Ribbon for Professional Appearance * The Critical Importance of Testing * KPI Analysis and Management Recommendations Key Learning Objectives - What You Will Learn: * An easy way to take raw data and make it presentable with Excel dashboards * Best Practices Dashboard Design - turning data easy to interpret information * How to use Excel Pivot Tables to build interactive, user-defined dashboards * How to construct a navigational menu using Excel * What charts to use and how to arrange multiple graphs on a dashboard * Determining which KPIs to use in your dashboard * Using the Pivot Table drill down capabilities in your dashboard * Building an optimum dashboard for at-a-glance analysis and decision making * Simple Excel techniques to make powerful dashboards - separate your skill level from others Register Today >> (http://dms2.businesswatchnetwork.com/t/gcH1AAibGiBUVrBAAAKr1UzZeaJH4qaaaaaaBM3UNKwaa?l=A_v8v80G~amp;V=lS3al~25w8lzSvkwUmSv.Uwe~amp;t=X~amp;5=~amp;j=AwBzDt8z) Major subjects * Dashboard design guidelines - Best practices for reporting business practices * Creating Key Performance Indicators (KPIs) * Creating PivotTables, PivotCharts and Slicers to create dashboards * Adding linked tables, charts and slicers (filters) to the data model * Graphical presentation of business performance measures - best practices * Leverage visual analysis for striking visual displays and greater impact * Choosing color and typography * Select visualizations that best communicate the message your KPI needs to convey * Choose the right chart for your data - which type of chart will best display your data. * Improving the user experience - professional-level navigations via links and filters * Fully interactive - the user can filter data and change the view themselves * Displays, key trends, comparisons and data graphically or in small tables * Reviewing the completed dashboard After completing this webinar you will... * Be able to define key performance indicators and build a dashboard in Excel to monitor them. * Learn simple techniques you can apply in Excel to make powerful, visually stunning dashboards * Become known as a Dashboard Superhero with a professional-caliber Excel skill set This webinar is for you if you: * Are interested in building a dashboard, but don't know where or how to begin * Know how to create basic charts but aren't sure how to package them * Already prepare reports of any kind that require updating with new data on a regular basis or; * Work with charts or; work with large volumes of data or; * Import data into Excel from another source or database: Access, Web, Text files etc. or; * Don't know the best way to display your data but want to produce professional quality work * Eventually want to use MS Power BI Who Will Benefit * Financial Professionals Including CFO's, Controllers, Accounting and Finance Managers and Staff * Financial Analysts, Budget Directors and staff, CPAs, auditors, administrators and managers * HR and Sales professionals who prepare reports using Excel * Engineers and Production Managers who prepare reports using Excel * IT Professionals Who Want a CPA/Financial Analyst's Point of View on Analytical Reporting Recommended prerequisites: BWN/NCCE basic level webinars: * Basic Excel charts * Basic Excel Pivot Tables Copyright © 2016 National Center for Cont. Education. All Rights Reserved. Questions: Call Businesswatch Network Events At 978-296-7618 Reservations are required to attend the Webinar. Register Today >> (http://dms2.businesswatchnetwork.com/t/gcH1AAibGiBUVrBAAAKr1UzZeaJH4qaaaaaaBM3UNKwaa?l=A_v8v80G~amp;V=lS3al~25w8lzSvkwUmSv.Uwe~amp;t=Y~amp;5=~amp;j=AwBzDt8z) Best Regards, The Web Events Team BusinessWatch Network Presenter: Joe Weil,CPA, M. Acc. Joe Weil owns the National Center for Continuing Education (NCCE), a nation-wide training firm headquartered in Tallahassee. Joe has led over 400 seminars on Excel and financial topics and several highly acclaimed webinars on the same topics. Joe earned his Master of Accounting Degree at Florida State University and is a CPA. read more... (http://dms2.businesswatchnetwork.com/t/gcH1AAibGiBUVrBAAAKr1UzZeaJH4qaaaaaaBM3UNKwaa?l=A_v8v80G~amp;V=lS3al~25w8lzSvkwUmSv.Uwe~amp;t=Z~amp;5=) Date: Wednesday November 8th, 2017 Time:1:00 - 2:30 pm Eastern Fee: $199 Group Packages Available: please call BusinessWatch Network Events at 978-296-7615 Register Today >> (http://dms2.businesswatchnetwork.com/t/gcH1AAibGiBUVrBAAAKr1UzZeaJH4qaaaaaaBM3UNKwaa?l=A_v8v80G~amp;V=lS3al~25w8lzSvkwUmSv.Uwe~amp;t=a~amp;5=~amp;j=AwBzDt8z) Included in Your Registration Fee: * 90-minute live program * Followed by 30-minute Q&A session * Pre-program documents and slide deck * Complimentary access to a recording of the live event * Access to the instructors email for personalized questions after the presentation. If you no longer wish to receive mailings from NCCE please Click Here (http://dms2.businesswatchnetwork.com/t/gcH1AAibGiBUVrBAAAKr1UzZeaJH4qaaaaaaBM3UNKwaa?l=A_v8v80G~amp;V=lS3al~25w8lzSvkwUmSv.Uwe~amp;t=T~amp;5=) If at any time you would like to change your preferences for the BusinessWatch Network (SM) simply click here (http://dms2.businesswatchnetwork.com/t/gcH1AAibGiBUVrBAAAKr1UzZeaJH4qaaaaaaBM3UNKwaa?l=A_v8v80G~amp;V=lS3al~25w8lzSvkwUmSv.Uwe~amp;t=l~amp;5=~amp;j=lS3al~25w8lzSvkwUmSv.Uwe) for email address david@transocean.com, or send a letter requesting opt-off to: The BusinessWatch Network (SM), Privacy Mailbox 1321, Marblehead, MA 01945 The BusinessWatch Network (SM) supports the DMA Privacy Promise and Guidelines for Ethical Business Practice. We are committed to the proper use of email and to protecting consumers. 24375107 ------=_NextPart_43D_C87A_72236EBC.4991716C Content-Type: text/html; charset="UTF-8" Content-Disposition: inline Content-Transfer-Encoding: 7bit Go From Excel Pivot Tables To Dashboards
National Center for Continuing Education BusinessWatch Network
Webinar: Wednesday November 8th, 2017, 1:00 - 2:30 pm Eastern Price: $199
Yellow Bar
Go From Excel Pivot Tables
To Dashboards 		Excel

 View in your browser

Your Comprehensive Review of Pivot Tables and
Introduction to Excel Dashboards

Learn the Easiest Way To Make Analytics Sexy
Create Amazing, Interactive, Eye-Catching Excel Dashboards
Take Your Career to the Next Level - Harness Excel's 'Wow-Power'

Register Today >>

Why You Should Attend
Excel Dashboards are the new buzzword employers are searching for. If you have, or want a career that involves creating reports in Excel, then you need to know how to build impressive, interactive, visually stunning, Excel dashboards. This practical, 90-minute webinar will leave you with Excel techniques you can immediately put to use making killer dashboards that set your skill level apart from others.

Microsoft Excel dashboards are powerful tools that summarize spreadsheet data to render a concise overview of critical business metrics. Dashboards provide an excellent and succinct way to share a "snap shot" view of key performance indicators (KPIs) for both small businesses and enterprise-level organizations.

This webinar will update your Excel skills by teaching you how to create impressive Dashboards even if you don't have artistic talent. At the conclusion of this webinar you'll be able to create amazing, interactive Excel dashboards that update at the click of a button and leave a lasting 'wow' impression.

The hallmark of an interactive, data-driven dashboard is the ability to see and understand data at the speed of thought. This on-the-job, nut-'n-bolts training webinar will deliver the skills you need to design well-planned Excel dashboards that present answers to questions in real-time, render visually striking displays, turn insight into action, help accomplish your firm's objectives and improve your Excel skills.

Easily Monitor Business Performance with Interactive Excel Dashboards You Create...
Create dashboards the easy way. Pivot Tables are among the easiest methods of creating Excel dashboards. Why pay thousands to a consultant when you can learn this technique in just 90 fun minutes?

  
Presenter:
Joe Weil Joe Weil,
CPA, M. Acc.
Joe Weil owns the National Center for Continuing Education (NCCE), a nation-wide training firm headquartered in Tallahassee. Joe has led over 400 seminars on Excel and financial topics and several highly acclaimed webinars on the same topics. Joe earned his Master of Accounting Degree at Florida State University and is a CPA.
read more...
Date: Wednesday November 8th, 2017
Time: 1:00 - 2:30 pm Eastern
Fee: $199
Group Packages Available:
please call BusinessWatch Network Events at 978-296-7615
Register Today >>
Included in Your Registration Fee:
  • 90-minute live program
  • Followed by 30-minute Q&A session
  • Pre-program documents and slide deck
  • Complimentary access to a recording of the live event
  • Access to the instructors email for personalized questions after the presentation.

Webinar Agenda - What We Cover and What You Learn

  • Overview of Excel Dashboard Construction and Methodologies
    • KPIs and Analytics
    • Dashboard Design Dos and Don'ts
  • Data Range vs Table or Pivot Table for Dashboard Dynamic Updates
  • Rapid Pivot Table Review - A Mix of Basics with a Few Advanced Topics
    • Rapid Set Up - One-Minute Pivot Table Quick Start
    • Understanding the Pivot Field and Filtering Options
    • Analyze and Design Tab
    • Pivot Charts and Slicers
    • Updating Data - Using Refresh
    • Speed Tips - When/How To Copy and Paste Pivot Tables and Charts
    • Pivot Table Example: Analyzing Sales Tends by State, Salesman and Location
  • Dashboard Example: Pivot Table to Dashboard
    • Determine Spec Sheet, Layout, and then Copy and Paste Charts
    • Symmetry: Size and Align Charts Simultaneously with Format Tools
    • Slicers and the Critical Importance of Report Connections
    • Logos, Headings and Drawing Tools for Professional Touches
    • Hyperlinks for Navigation Between Dashboard and Database
    • Eliminating Gridlines, Headings, Formula Bar and Ribbon for Professional Appearance
    • The Critical Importance of Testing
    • KPI Analysis and Management Recommendations

Key Learning Objectives - What You Will Learn:

  • An easy way to take raw data and make it presentable with Excel dashboards
  • Best Practices Dashboard Design - turning data easy to interpret information
  • How to use Excel Pivot Tables to build interactive, user-defined dashboards
  • How to construct a navigational menu using Excel
  • What charts to use and how to arrange multiple graphs on a dashboard
  • Determining which KPIs to use in your dashboard
  • Using the Pivot Table drill down capabilities in your dashboard
  • Building an optimum dashboard for at-a-glance analysis and decision making
  • Simple Excel techniques to make powerful dashboards - separate your skill level from others
Register Today >>

Major subjects

  • Dashboard design guidelines - Best practices for reporting business practices
  • Creating Key Performance Indicators (KPIs)
  • Creating PivotTables, PivotCharts and Slicers to create dashboards
  • Adding linked tables, charts and slicers (filters) to the data model
  • Graphical presentation of business performance measures - best practices
  • Leverage visual analysis for striking visual displays and greater impact
  • Choosing color and typography
  • Select visualizations that best communicate the message your KPI needs to convey
  • Choose the right chart for your data - which type of chart will best display your data.
  • Improving the user experience - professional-level navigations via links and filters
  • Fully interactive - the user can filter data and change the view themselves
  • Displays, key trends, comparisons and data graphically or in small tables
  • Reviewing the completed dashboard

After completing this webinar you will...

  1. Be able to define key performance indicators and build a dashboard in Excel to monitor them.
  2. Learn simple techniques you can apply in Excel to make powerful, visually stunning dashboards
  3. Become known as a Dashboard Superhero with a professional-caliber Excel skill set

This webinar is for you if you:

  • Are interested in building a dashboard, but don't know where or how to begin
  • Know how to create basic charts but aren't sure how to package them
  • Already prepare reports of any kind that require updating with new data on a regular basis or;
  • Work with charts or; work with large volumes of data or;
  • Import data into Excel from another source or database: Access, Web, Text files etc. or;
  • Don't know the best way to display your data but want to produce professional quality work
  • Eventually want to use MS Power BI

Who Will Benefit

  • Financial Professionals Including CFO's, Controllers, Accounting and Finance Managers and Staff
  • Financial Analysts, Budget Directors and staff, CPAs, auditors, administrators and managers
  • HR and Sales professionals who prepare reports using Excel
  • Engineers and Production Managers who prepare reports using Excel
  • IT Professionals Who Want a CPA/Financial Analyst's Point of View on Analytical Reporting

Recommended prerequisites: BWN/NCCE basic level webinars:

  1. Basic Excel charts
  2. Basic Excel Pivot Tables

Copyright © 2016 National Center for Cont. Education. All Rights Reserved.

Register Today >>

Questions: Call BusinessWatch Network Events at 978-296-7618

Reservations are required to attend the Webinar.Register Today

Best Regards,
The Web Events Team
BusinessWatch Network

If you no longer wish to receive mailings from NCCE please Click Here


If at any time you would like to change your preferences for the BusinessWatch NetworkSM simply  click here for email address david@transocean.com, or send a letter requesting opt-off to: The BusinessWatch NetworkSM, Privacy Mailbox 1321, Marblehead, MA 01945

DMA Member Logo The BusinessWatch NetworkSM supports the DMA Privacy Promise and Guidelines for Ethical Business Practice. We are committed to the proper use of email and to protecting consumers.

24375107

------=_NextPart_43D_C87A_72236EBC.4991716C--