Return-Path: Delivered-To: edward@transocean.com Received: from vps.transocean.com by vps.transocean.com (Dovecot) with LMTP id YgVBGRaRNlkqGgAAInt2oQ for ; Tue, 06 Jun 2017 04:25:10 -0700 Return-path: Envelope-to: edward@transocean.com Delivery-date: Tue, 06 Jun 2017 04:25:10 -0700 Received: from omp.emails.demystifiedsolutions.com ([129.145.68.57]:55273) by vps.transocean.com with esmtp (Exim 4.89) (envelope-from ) id 1dICbZ-0001ih-9C for edward@transocean.com; Tue, 06 Jun 2017 04:25:10 -0700 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; s=demystifiedsolutions; d=emails.demystifiedsolutions.com; h=MIME-Version:Content-Type:Content-Transfer-Encoding:Date:To:From:Reply-To:Subject:List-Unsubscribe:Message-ID; i=training@emails.demystifiedsolutions.com; bh=WDMHBf5xouF9NUH5Oog1F8SZ/hg=; b=Kbyb1+UhaJViyp78QNKnD+2FALwvi6rKy8FcbJFuIfLiBhKfDy8ER5roipHTJYXPdG9yGtgd64mP W/7DSj8LjU9xzN5KDriZZunoSP+a5vZ1wq6o5EuBGTvhTLZT1taviV3ophwmAmXy8UHU+hFhvVIP k0B3f1KrYbP0Q7OTI70= DomainKey-Signature: a=rsa-sha1; c=nofws; q=dns; s=demystifiedsolutions; d=emails.demystifiedsolutions.com; b=WfJcmL4e2CSnaPqDtYDmpHm3ARDXIkRr6swWGNu/JwD7E8Pq89mnpoPYIQOeaBtdxGcGpBcZPXP5 m7EuGEQn2YXS6U5KGZsyd4//wgO5OGO/zurHy1f8iXPg7NummQx9tYFH1qsqnqG3HhbAqcXYRkyC w6d3geDVd+rbEZ30/BY=; Received: by omp.emails.demystifiedsolutions.com id h6q8gi161agr for ; Tue, 6 Jun 2017 04:24:15 -0700 (envelope-from ) X-CSA-Complaints: whitelist-complaints@eco.de MIME-Version: 1.0 Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Date: Tue, 6 Jun 2017 04:24:15 -0700 To: edward@transocean.com From: "Overview of PivotTables in Excel" Reply-To: "Overview of PivotTables in Excel" Subject: Utilizing Excel Better: PivotTables for Creating Custom Reports Feedback-ID: 9953:284982:oraclersys List-Unsubscribe: , X-sgxh1: LKOHjKxljHgkhJLHgQJhu X-rext: 5.interact2.ErMAliiv3UltuBkhd-t0Kc3NDVdEmmhmLmnU2iJ0nlin_R_8bLw X-cid: pravasiin.319082 Message-ID: <0.0.146.364.1D2DEB76E437596.0@omp.emails.demystifiedsolutions.com> 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: Excel – Building Reports with Pivot Tables – Beyond the Basics Toll Free: +1-888-300-9580 customercare@demystifiedsolutions.com LIVE WEBINAR ON: Excel – Building Reports with Pivot Tables – Beyond the Basics Date: Wednesday, 14 June 2017 | Time: 03:00 PM EDT | 12:00 PM PDT Register Now → [...] 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: oraclecloud.com] 0.0 T_SPF_TEMPERROR SPF: test of record failed (temperror) -0.0 T_RP_MATCHES_RCVD Envelope sender domain matches handover relay domain 1.1 URI_HEX URI: URI hostname has long hexadecimal sequence 0.7 MIME_HTML_ONLY BODY: Message only has text/html MIME parts 0.0 HTML_MESSAGE BODY: HTML included in message 0.0 HTML_FONT_LOW_CONTRAST BODY: HTML font color similar or identical to background -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% [score: 0.0001] -0.1 DKIM_VALID_AU Message has a valid DKIM or DK signature from author's domain 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 <=21DOCTYPE html> Excel =96 Building Reports with Pivot Tables =96 Beyond the Basic= s
<=21--DWLayoutTabl= e-->
<=21--DWLayoutTable-->
<=21--DWLayoutTable-->
<=21--DWLayoutTable-->
3D=22DS_Logo=22

Toll Free: +1-888-300-9580

= customercare=40demystifiedsolutions=2Ecom
LIVE WEBINAR ON:
Excel =96 Building= Reports with Pivot Tables =96 Beyond the Basics
<=21--DWLayoutTabl= e-->
Date: Wednesday, 14 June 2017 =7C Time: 03:00 PM EDT =7C 12:00 PM PDT
= Register Now →
<=21--DWLayoutTable-->
<=21--DWLayoutTable= -->

Pivot Tables are o= ne of the most powerful tools in Excel=92s data analysis and Business Intel= ligence (BI) armory=2E With just a few clicks of the mouse (and no complica= ted formulas=21) you can quickly and easily build reports and charts that s= ummarize and analyze large amounts of raw data and help you spot trends and= get answers to the important questions on which you base your key business= decisions=2E

Areas Cove= red in this Webinar

  • Calculating mo= nth-on-month difference
  • Calculating a = running/cumulative total
  • Displaying a u= nique count
  • Using formulas= to create additional calculated items
  • Slicers =96 th= e new visual way to filter a pivot table
  • GETPIVOTDATA&n= bsp;(function) =96 When to use and when to avoid
  • Creating a piv= ot table from multiple tables or multiple data sources
  • Creating a piv= ot table from external data
  • Using conditio= nal formatting in a pivot table

Learning O= bjectives

In this session, y= ou'll learn how to

  • Calculate diff= erences (e=2Eg=2E month-on-month, quarter-on quarter)
  • Calculate runn= ing/cumulative totals
  • Display a uniq= ue count (e=2Eg=2E number of customers, not number of orders)
  • Use formulas t= o create additional calculated items=2E
  • Create Slicers= which are the new visual way to filter a pivot table=2E
  • Create a pivot= table from multiple tables and multiple data sources, including linking to= external data=2E
Read More=2E=2E=2E
= Register Now →
<= =21--DWLayoutTable-->
<=21--DWLayoutTable-->
3D=22Mike_Thomas_Demystified=22 Mike Thomas
Excel Trainer and Developer of Technical VBA-Based Solutions= at AstraZeneca
<=21--DWLayoutTable-->
<=21--DWLayoutTable-->
Mike Thomas has worked in the IT training business since 1989= =2E He is a subject matter expert in a range of technologies including Micr= osoft Office and Apple Mac=2E In 2012 Mike founded theexceltrainer=2Eco=2Eu= k where he has produced nearly 200 written and video-based Excel tutorials= =2E He has recorded several Excel training courses for pluralsight=2Ecom an= d in his career delivered hundreds of courses and webinars on a wide variet= y of technology-related topics=2E

Mike is a Fellow of The Learning and Performance Institute and h= as worked with and for a large number of global and UK-based companies and = organisations across a diverse range of sectors=2E In addition to training,= he also designs and develops Microsoft Office-based solutions that automat= e key business tasks and processes=2E Read More=2E=2E=2E

*This message was= sent to edward=40transocean=2Ecom by Dem= ystified Solutions Team=2E
This emailer is addressed to and intended only f= or core corporate executives and is not a spam=2E You may call Demystified = Solutions customercare for any additional clarifications or for any other i= ssues with regard to any information contained in this emailer=2E Reply to = this mail ID support=40demystifi= edsolutions=2Ecom
The products and/or services offered under this = program are the sole responsibility and liability of the hosting company an= d related vendors, at their exclusive worth=2E Demystified Solutions does e= ndorse and recommend the quality, suitability for a particular purpose, mer= chantability, delivery and after sale services (if applicable) of the produ= cts and/or services being offered and/or made available under this program= =2E

<=21--DWLayoutTable-->
If you do not wish to receive f= urther such emails from Demystified Solutions; please click Unsubscribeor send us mail to support=40demystifiedso= lutions=2Ecom
Demystified Solutions llc=2E =7C www=2Edemystifiedsolutions=2Ecom
5th floor, 99 Hudson street, Tribeca,New York, USA 10013= =2E
Toll Free: +1 888 300 9580 =7C Customer Support: +1 646 2= 02 1749
customercare=40demystifiedsolutions=2Ecom =7C support=40d= emystifiedsolutions=2Ecom
© 2017 Demystified Solutions llc=2E All Rights Reser= ved