Return-Path: Delivered-To: louk@transocean.com Received: from vps.transocean.com by vps.transocean.com with LMTP id mB7BLYA4zlpTcAAAInt2oQ for ; Wed, 11 Apr 2018 09:32:00 -0700 Return-path: Envelope-to: louk@transocean.com Delivery-date: Wed, 11 Apr 2018 09:32:00 -0700 Received: from omp.news.grceducators.com ([129.145.68.217]:49254 helo=om-axonstech.rsys2.com) by vps.transocean.com with esmtp (Exim 4.89_1) (envelope-from ) id 1f6If3-0007ZC-8o for louk@transocean.com; Wed, 11 Apr 2018 09:32:00 -0700 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; s=grceducators; d=news.grceducators.com; h=MIME-Version:Content-Type:Content-Transfer-Encoding:Date:To:From:Reply-To: Subject:List-Unsubscribe:Message-ID; i=grceducators@news.grceducators.com; bh=zxThrrMtnMjWqlS/De+STicYX9Z+dj7wiFlp/cG8SHY=; b=g/oUDe6gSTkE8VKS3JOMu9XEGNbv89ySXFtl69wubRCvV5kE8bjQrtJU4n/ECtYRPe6mlgkxcv4n 88ck9iMaJkumWFAeYGHJV6tNN9TC+ohK3tNhO0LNZbJp9aUuA1zW8ahD2Ls1YWafoRsPkbvWEbYq b1Ltmj9cZ6YcD/3qF05s/NuCmVmVE0Qx3VlyVr5z9pWJwuDZ4J/BguZNKf4HY+npNsrLUG6cit/I Vn+J6F6z7vhPD+pZv/gtBfAWi7PLVamPTiRdPpuxW3jWL1FCDPJausuM7iILnWiaZNXgs4h1A4Zr fcoX8EtO6oZUM8Hka336w9uWHW+lahJv679I1Q== Received: by om-axonstech.rsys2.com id hpos7i2b610n for ; Wed, 11 Apr 2018 09:31:13 -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: Wed, 11 Apr 2018 09:31:13 -0700 To: louk@transocean.com From: =?ISO-8859-1?B?V2ViaW5hciB1cGRhdGVz?= Reply-To: =?ISO-8859-1?B?V2ViaW5hciB1cGRhdGVz?= Subject: Excel Speed Tips: Identify the feature that helps you transform filtering tasks Feedback-ID: 10775:165322:oraclersys List-Unsubscribe: , X-sgxh1: thmsxljHgkhJLHgQJhu X-rext: 5.interact2.Ens0-8URyAw3moSGKn4S4ufn1LDfPzN1gTjqRuNed1LaQeg X-cid: axonstech.154462 Message-ID: <0.1.15F.985.1D3D1B281985BFE.0@om-axonstech.rsys2.com> X-Spam-Status: No, score=2.4 X-Spam-Score: 24 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 Speed Tips: Identify the feature that helps you transform filtering tasks 740-870-0321 Excel Savvy : Speed Tips Part 2 [...] Content analysis details: (2.4 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: mailinblue.com] -0.0 SPF_PASS SPF: sender matches SPF record 0.8 BAYES_50 BODY: Bayes spam probability is 40 to 60% [score: 0.4083] 0.0 HTML_FONT_LOW_CONTRAST BODY: HTML font color similar or identical to background 0.0 HTML_MESSAGE BODY: HTML included in message 0.7 MIME_HTML_ONLY BODY: Message only has text/html MIME parts 0.0 AC_DIV_BONANZA RAW: Too many divs in a row... spammy template 0.1 DKIM_SIGNED Message has a DKIM or DK signature, not necessarily valid -0.1 DKIM_VALID_AU Message has a valid DKIM or DK signature from author's domain -0.1 DKIM_VALID Message has at least one valid DKIM or DK signature 1.0 FROM_EXCESS_BASE64 From: base64 encoded unnecessarily X-Spam-Flag: NO <=21DOCTYPE html PUBLIC =22-//W3C//DTD XHTML 1=2E0 Transitional//EN=22 =22h= ttp://www=2Ew3=2Eorg/TR/xhtml1/DTD/xhtml1-transitional=2Edtd=22> Excel Speed Tips: Identify the feature that helps you transform f= iltering tasks <=21--=5Bif gte mso 11=5D><=21=5Bendif= =5D--><=21--=5Bif =21mso=5D><=21--> <=21--<=21=5Bendif=5D--><=21--=5Bif gte mso 15=5D>96<=21=5Bendif=5D--><=21--=5Bif gte mso 9=5D>96<=21=5Bendif=5D-->
<=21--=5Bif gte mso 9= =5D>
<=21=5Bendif=5D-->
3D=22=22
<=21--=5Bif mso 15=5D> <=21=5Bendif=5D--><=21--=5Bif mso 15=5D> <=21=5Bendif=5D--><=21--=5Bif mso 15=5D>
<=21=5Bendif=5D-->
3D=22=
740-870-0321
<=21--=5Bif mso 15=5D>
<=21=5Bendif=5D-->
<=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
<=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
<=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
3D=22=22
<=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
<=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
Excel Savvy : Speed Tips Part 2
<=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
<=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
FRIDAY APRIL 27 2018  =7C 12:00 PM EST  = =7C 90 MINUTES
<=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
<=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
This follow-up session to Speed Tips Part 2 is packed= with even more ways to save time and effort in Excel=2E Excel expert David= Ringstrom, CPA, demonstrates shortcuts that allow you to streamline repeti= tive tasks and redundant data entry, embed lists you use frequently, transf= orm filtering tasks, and more=2E In addition, David explains the benefits a= ssociated with Excel=92s Text Box feature, the Personal Macro Workbook, and= the Quick Analysis feature=2E

Learning Objectives:
  • Applying formatting to multiple locations within a wo= rksheet by way of the Format Painter feature=2E
  • Avoid retyping data or clunky formulas by way of Exce= l=92s Text to Columns command=2E
  • Avoiding frustration by understanding the nuances bet= ween Enter and Edit modes=2E
  • Discovering how to quickly access folders and workboo= ks, regardless of whether they=92re stored on your computer or on a network= =2E
  • Discovering the Custom Lists feature in Excel, which = enables you to embed frequently used lists into Excel=92s Options dialog bo= x for use with any spreadsheet=2E
  • Editing =2EPDF documents in Word 2013 and later=97use= ful for unlocking data you wish to edit in Excel=2E
  • Eliminating duplicates from a list with just a few mo= use clicks=2E
  • Making the same edits on multiple worksheets at once = by grouping worksheets=2E
  • Mastering the nuances=97and the power=97of Excel=92s = Transpose feature=2E
  • Navigating large workbooks with ease by way of a hidd= en menu as well as keyboard shortcuts=2E
  • Pasting a table as a raw list elsewhere in a workbook= =2E
  • Separating first/last names into two columns without = using formulas or retyping=2E
David demonstrates every technique at least twice: fi= rst, on a PowerPoint slide with numbered steps, and second, in Excel 2016= =2E He draws your attention to any differences in Excel 2013, 2010, or 2007= during the presentation as well as in his detailed handouts=2E David also = provides an Excel workbook that includes most of the examples he uses durin= g the webcast=2E

<=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
<=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
REGISTER NOW
<=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
Event Marketing =7C GRC Educators =7C 740-870-0321 =7C support=40grcedu= cators=2Ecom =7C www=2Egrceducators=2Ecom =7C 806 Clark Street, P=2EO Box 1= 71, Philo, OH-43771 USA
 
<=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
© 2018 GRC Educators
<=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
<=21--=5Bif gte mso 9=5D>
<=21=5Bendif=5D-->