Return-Path: Delivered-To: dean@transocean.com Received: from vps.transocean.com by vps.transocean.com with LMTP id IBJcHPEO2lq+LQAAInt2oQ for ; Fri, 20 Apr 2018 09:01:53 -0700 Return-path: Envelope-to: dean@transocean.com Delivery-date: Fri, 20 Apr 2018 09:01:53 -0700 Received: from omp.news.grceducators.com ([129.145.68.217]:41358 helo=om-axonstech.rsys2.com) by vps.transocean.com with esmtp (Exim 4.89_1) (envelope-from ) id 1f9YTp-0003AK-Hx for dean@transocean.com; Fri, 20 Apr 2018 09:01:53 -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=TNbo6GoIIB3tORhp+i5mov00NiPBtoenSCBfFpuWWRI=; b=wcdccAelIHUCrZwQ5codflcuvVhkp7aw8L3S5nDpB0DdIwU4WE2rEfSwDG7KSxPgPsxRHjuW3ZfW ua4ZfEe6cUOIh5v6QHeslS53L6RjL6NngsqpreSJc+4PSheFt8oaYNBtsFBxZUp6cFl2hbJh1kwp yHqj5qvRH2gXgzls/++cLCxdp0nxYVygKQDMExNzWYcR/gGN8R9n+7sSAAhqSFN6rF8r1/MPi+kZ NHaNpAjS70eh2qUrbDJ6seZd9dJidfyo7poQ32TtIopvNGS8VFMY1JMs+PhwZSu1hc4s9Y8GiOTX +V5Ut07W4+G8MEz1e+tG90Yt8eqoYDP35N2Kyg== Received: by om-axonstech.rsys2.com id hr87ek2b610h for ; Fri, 20 Apr 2018 09:01:05 -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: Fri, 20 Apr 2018 09:01:05 -0700 To: dean@transocean.com From: =?ISO-8859-1?B?V2ViaW5hciBVcGRhdGVz?= Reply-To: =?ISO-8859-1?B?V2ViaW5hciBVcGRhdGVz?= Subject: Excel Training: Learn the Data Management Features Feedback-ID: 10775:180422:oraclersys List-Unsubscribe: , X-sgxh1: KLHgxljHgkhJLHgQJhu X-rext: 5.interact2.EgHEv-v-hNqUYxHqCSORbBV80Adt0rcju3o3RhTJqEdA3xwq X-cid: axonstech.179002 Message-ID: <0.1.2EF.13A.1D3D8C0CA0F7984.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 Training: Learn the Data Management Features Tuesday, May 15 2018 | 1:00 PM EST | 60 Minutes Course Summary [...] 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: grceducators.com] -0.0 SPF_PASS SPF: sender matches SPF record 0.8 BAYES_50 BODY: Bayes spam probability is 40 to 60% [score: 0.5000] 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.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 1.0 FROM_EXCESS_BASE64 From: base64 encoded unnecessarily 0.0 TVD_PH_BODY_META No description available. 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 Training: Learn the Data Management Features <=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-->
<=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D> <=21=5Bendif=5D--><=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
3D=22Ax=
<=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--><=21--=5Bif mso=5D>
<=21=5Bendif=5D-->
Tuesday, May 15 2018 =7C 1:00 PM EST =7C 60 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-->
Course Summary
<=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-->
T= o be truly proficient in Excel, you must be familiar with these tools to ma= nage data efficiently=2E It's more important as data collection has become = more automated and you're getting swamped with tons of data=2E But what can= you do with all that data? If you are setting up new lists, you need to kn= ow the powerful validation tools that keep out bad data from the start and = how to drastically reduce data entry with drop-down clickable lists=2E

You can do more with = Microsoft Excel worksheets than just calculate data - you can tackle powerf= ul data management needs with ease too=2E With just a bit of know-how, you = can take advantage of the power of Excel to validate data, sort data (based= on content, color, or icon), insert automatic subtotals, filter the data t= o see just what you need to see, restructure columnar data that has been im= properly grouped, eliminate duplicate records in a flash, and use powerful = expanded functions to analyze the data in any list, regardless of size=2E
 
<= strong>Learning Objective
  • Learn the fastest, most efficient ways to sort data; = sort by content, by color, or based on the order of data in a custom list; = sort in random order or by re-arranging columns left-to-right
  • Re-structure improperly grouped columnar data with Fl= ash Fill or the Text to Columns feature
  • Master the myriad ways of filtering data to display j= ust the data you need
  • Eliminate duplicate records from a large database
  • Insert a row of subtotals in a sorted list without te= diously creating new rows and formulas
  • Create drop-down lists to accelerate data entry, with= improved accuracy and consistency
  • Convert lists into tables - gain easier data-handling= and enhanced visual features
  • Learn valuable functions that help you understand you= r data - COUNTIF, SUMIF
<=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
© 2018 GRC Educators
<=21--=5Bif gte mso 9=5D>
<=21=5Bendif=5D-->