Return-Path: Delivered-To: edward@transocean.com Received: from vps.transocean.com by vps.transocean.com (Dovecot) with LMTP id aUEJApmkrllqRQAAInt2oQ for ; Tue, 05 Sep 2017 06:20:25 -0700 Return-path: Envelope-to: edward@transocean.com Delivery-date: Tue, 05 Sep 2017 06:20:25 -0700 Received: from cy105.mta.exacttarget.com ([136.147.181.105]:50634) by vps.transocean.com with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.89) (envelope-from ) id 1dpDlz-0004fi-6c for edward@transocean.com; Tue, 05 Sep 2017 06:20:24 -0700 Received: by cy105.mta.exacttarget.com id hlqi8s163hsh for ; Tue, 5 Sep 2017 13:16:34 +0000 (envelope-from ) From: "Compliance Trainer" To: Subject: How to Perform Data Analysis using Excel Popular Features Date: Tue, 05 Sep 2017 07:16:34 -0600 List-Unsubscribe: MIME-Version: 1.0 Reply-To: "Compliance Trainer" List-ID: <10962064_11987.xt.local> X-CSA-Complaints: whitelistcomplaints@eco.de x-job: 10962064_11987 Message-ID: <52806b23-cb19-4e9e-b56e-451a7bcd121f@xtinmta4414.xt.local> Content-Type: multipart/alternative; boundary="2cDwRKijdt75=_?:" X-Spam-Status: No, score=-0.9 X-Spam-Score: -8 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: onlinecompliancepanel-webinar-mailer-SF-MELISSA-ESQUIBEL-SEP27-EB http://cl.exct.net/?qs=7339de5751419d65dbe359a05c52e6e5be461b4bfb926fa19287458bd6decc1dd9b32bea83e2351a5d80e5adadb49e9a Business Data Analysis in Excel: Simple Steps for Actionable Results LIVE WEBINAR Date: Wednesday, 27 September 2017 Time: 10:00 AM PDT | 01:00 PM EDT [...] Content analysis details: (-0.9 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: transocean.com] 0.0 HEADER_FROM_DIFFERENT_DOMAINS From and EnvelopeFrom 2nd level mail domains are different -0.0 SPF_PASS SPF: sender matches SPF record -0.0 RP_MATCHES_RCVD Envelope sender domain matches handover relay domain -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% [score: 0.0000] 0.0 HTML_MESSAGE BODY: HTML included in message 0.8 KAM_INFOUSMEBIZ Prevalent use of .info|.us|.me|.me.uk|.biz domains in spam/malware 0.2 KAM_LOTSOFHASH Emails with lots of hash-like gibberish X-Spam-Flag: NO This is a multi-part message in MIME format. --2cDwRKijdt75=_?: Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 8bit onlinecompliancepanel-webinar-mailer-SF-MELISSA-ESQUIBEL-SEP27-EB http://cl.exct.net/?qs=7339de5751419d65dbe359a05c52e6e5be461b4bfb926fa19287458bd6decc1dd9b32bea83e2351a5d80e5adadb49e9a Business Data Analysis in Excel: Simple Steps for Actionable Results LIVE WEBINAR Date: Wednesday, 27 September 2017 Time: 10:00 AM PDT | 01:00 PM EDT http://cl.exct.net/?qs=7339de5751419d65dbe359a05c52e6e5be461b4bfb926fa19287458bd6decc1dd9b32bea83e2351a5d80e5adadb49e9a Call 510-857-5896 38780 Tyson Lane Suite 210 Fremont, CA-94536 Save upto 30% on registration* Hurry! offer closes onSeptember 08, 2017 midnight.Call 510-857-5896 to know more. http://cl.exct.net/?qs=7339de5751419d65dbe359a05c52e6e5be461b4bfb926fa19287458bd6decc1dd9b32bea83e2351a5d80e5adadb49e9a http://cl.exct.net/?qs=7339de5751419d656f54da94a05833f77729ca1386df6006dd9b5d0e02373c1526669336d05ebfa617c15499169920d1 mailto:customersupport@onlinecompliancepanel.com The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool. If you have spent hours trying to perform analyses on multiple datasets, frustrated that the methods are either lacking in features, are too complicated, or not terribly durable from refresh to refresh, you will appreciate knowing the simplicity and logical solution of Excel’s new data model. In this course, you will learn how to perform data analysis using Excel’s most popular features. You will learn how to create pivot tables from a range with rows and columns in Excel. You will see the power of Excel pivots in action and their ability to summarize data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data. Key Learning Objectives - Working with external data in Excel - Optimizing datasets to work with powerful analysis tools - Tips for scrubbing data with text functions and other tools - Leveraging classic tools like Pivot Tables, Consolidations and What If Analysis - Working with new tools like, PowerPivot, the new Data Model, Get & Transform - Dashboard fundamentals and a peek at Power BI tools http://cl.exct.net/?qs=7339de5751419d65dbe359a05c52e6e5be461b4bfb926fa19287458bd6decc1dd9b32bea83e2351a5d80e5adadb49e9a View More http://cl.exct.net/?qs=7339de5751419d6575bf8ab9009cd9b72a7c99f6880925940048bfb16f781d7f3a0e016b4be02914d961ac15ff583c19 http://cl.exct.net/?qs=7339de5751419d65dbe359a05c52e6e5be461b4bfb926fa19287458bd6decc1dd9b32bea83e2351a5d80e5adadb49e9a YES I am Attending http://cl.exct.net/?qs=7339de5751419d652f1f9710f6f1994d4e440fc07a8dc16e9f7e1ff65ff572198a2a0c01873988780a0ebeb979c24ab7 NO I Want a Different Course http://cl.exct.net/?qs=7339de5751419d656d5660f135505a809842897c243604de7ef2253fe54c796b4a15186b3c589b6237c5bc9296b1b55b Melissa P Esquibel MCT, President, Melissa P Esquibel LLCMelissa is a Microsoft Certified Trainer and Excel Expert who has worked with spreadsheet tools since their earliest forms. As a business owner, Melissa has learned to leverage her business data for year-over-year success. As an Excel instructor, she has the benefit of knowing just what tools are available to approach nearly any data challenge. http://cl.exct.net/?qs=7339de5751419d656d5660f135505a809842897c243604de7ef2253fe54c796b4a15186b3c589b6237c5bc9296b1b55b View More Similar On-Demand Webinar http://cl.exct.net/?qs=7339de5751419d652f50c172e78dbbcbc63fe15908fcc7b5afcbe94bd42399e4be0090fdbfb523e6b0edc486aa1338d8 Automation Techniques for Excel-based Financial Reports http://cl.exct.net/?qs=7339de5751419d65698a1ba3ac210ef61e884c8394312120b9b811fba91539eab7f70cbf83eb829efc1f27354eb7925e View More Workshop http://cl.exct.net/?qs=7339de5751419d6524e6a80bad52d60fb36783c8644d58bb71d5f74a55427eec08573ee3f74a85da6b6aacd73240037f Statistical Techniques for Medical Device Manufacturers http://cl.exct.net/?qs=7339de5751419d65698a1ba3ac210ef61e884c8394312120b9b811fba91539eab7f70cbf83eb829efc1f27354eb7925e View More http://cl.exct.net/?qs=7339de5751419d650f23b86679069f4be1032498f82f2cd2e03f915e47d8669f3cbb926bdd2a1cc7aef16a94f0bedd2c NEW! SOP Library http://cl.exct.net/?qs=7339de5751419d6575bf8ab9009cd9b72a7c99f6880925940048bfb16f781d7f3a0e016b4be02914d961ac15ff583c19 Please feel free to forward this email to your friends or colleagues This message was sent to edward@transocean.com by www.onlinecompliancepanel.com 38780 Tyson Lane Suite 210 Fremont, CA, 94536, USA Call: +1-510-857-5896 / Fax: +1-510-509-9659 mailto:customersupport@onlinecompliancepanel.com customersupport@onlinecompliancepanel.com. If you do not wish to receive emails from OnlineCompliancePanel Please http://cl.exct.net/unsub_center.aspx?qs=b19724f417e274452baddafbd7c28e14f1c7fe2ba06182a934489ff727dcf552faab64eea06c5a0351bbcb2558bc05b97bf4c251666c929b Unsubscribe or reply to this email with "Unsubscribe Me" as subject line. http://cl.exct.net/profile_center.aspx?qs=b19724f417e274454cf25164c86a71d8a6d1241144e2195b5c45d61a69b2d1f6222b00bef21c4caac0cda19a70f2916e294db88bc489ea48 Update Profile (c) 2017 OnlineCompliancePanel.com --2cDwRKijdt75=_?: Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: 8bit onlinecompliancepanel-webinar-mailer-SF-MELISSA-ESQUIBEL-SEP27-EB
Business Data Analysis in Excel: Simple Steps for Actionable Results
LIVE WEBINAR
Date: Wednesday, 27 September 2017
Time: 10:00 AM PDT | 01:00 PM EDT
OCP_Logo
Call 510-857-5896
38780 Tyson Lane Suite 210 Fremont, CA-94536
Save upto 30% on registration* Hurry! offer closes on
September 08, 2017 midnight.Call 510-857-5896 to know more.
The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool. If you have spent hours trying to perform analyses on multiple datasets, frustrated that the methods are either lacking in features, are too complicated, or not terribly durable from refresh to refresh, you will appreciate knowing the simplicity and logical solution of Excel’s new data model. In this course, you will learn how to perform data analysis using Excel’s most popular features. You will learn how to create pivot tables from a range with rows and columns in Excel. You will see the power of Excel pivots in action and their ability to summarize data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data.

Key Learning Objectives
  • Working with external data in Excel
  • Optimizing datasets to work with powerful analysis tools
  • Tips for scrubbing data with text functions and other tools
  • Leveraging classic tools like Pivot Tables, Consolidations and What If Analysis
  • Working with new tools like, PowerPivot, the new Data Model, Get & Transform
  • Dashboard fundamentals and a peek at Power BI tools
instructorMelissa P Esquibel
MCT, President, Melissa P Esquibel LLC
Melissa is a Microsoft Certified Trainer and Excel Expert who has worked with spreadsheet tools since their earliest forms. As a business owner, Melissa has learned to leverage her business data for year-over-year success. As an Excel instructor, she has the benefit of knowing just what tools are available to approach nearly any data challenge.
View More
Similar On-Demand Webinar 
Automation Techniques for Excel-based Financial Reports 
View More
Workshop 
Statistical Techniques for Medical Device Manufacturers 
View More
NEW! SOP Library
Please feel free to forward this email to your friends or colleagues
This message was sent to edward@transocean.com by
www.onlinecompliancepanel.com
38780 Tyson Lane Suite 210 Fremont, CA, 94536, USA
Call: +1-510-857-5896 / Fax: +1-510-509-9659
customersupport@onlinecompliancepanel.com.

If you do not wish to receive emails from OnlineCompliancePanel Please Unsubscribe
or reply to this email with "Unsubscribe Me" as subject line.
Update Profile
© 2017 OnlineCompliancePanel.com
--2cDwRKijdt75=_?:--