Return-Path: Received: from vps.transocean.com by vps.transocean.com with LMTP id MALqMxhO+1n9ZgAAInt2oQ ; Thu, 02 Nov 2017 09:55:52 -0700 Return-path: Envelope-to: kathleen@transocean.com Delivery-date: Thu, 02 Nov 2017 09:55:52 -0700 Received: from m1.ga.avanteducation.com ([216.153.28.61]:37461) by vps.transocean.com with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.89) (envelope-from ) id 1eAImI-0006yQ-KD for kathleen@transocean.com; Thu, 02 Nov 2017 09:55:52 -0700 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=avanteducation.com; s=default; t=1509641695; bh=qUyMT6XHcIMyWHNNlOSsZptRulk=; h=Subject:From:To:Sender:Reply-To:Date:List-Unsubscribe:X-Mailer: X-CampaignID:Message-ID:X-Mailer-Info:MIME-Version:Content-Type; b=30bsooBHOlv6PAjpPuFvObbQk52GgpCTRzW8d+fuKfA2HZo6tUv82gLH7HLQ7Avhk ZYjqWMknGv6tvV7cyT6qXIsRMQ0aGJ+bR2egWIiheuDIHT/Ri6BBdZpMe7aHIDIo3S tdFhHT/Ns8e9g3n6yDr8AboWuNOicEsuwBKF8vqo= Subject: Making Dashboards That Truly Excel From: "Avant Education" To: kathleen@transocean.com Sender: education@avanteducation.com Reply-To: education@avanteducation.com Date: 02 Nov 2017 16:54:55 -0000 List-Unsubscribe: , X-Mailer: GreenArrow Studio (v4.92.3) X-CampaignID: s4:7061-383b6807190a607f Message-ID: X-Mailer-Info: 8.hVDO.wNwYTM.sWY0hGblVmbARnch52cvNWZh5mLj9Wb.QNxMTN1czN.wNwYzM MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="==4de015b26f05b1930c319e0996b88c4f" X-Spam-Status: No, score=0.3 X-Spam-Score: 3 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: Avant Resources Creating Dashboards That Excel Discovering the Truth in Your Numbers [...] Content analysis details: (0.3 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 RP_MATCHES_RCVD Envelope sender domain matches handover relay domain 0.0 T_SPF_TEMPERROR SPF: test of record failed (temperror) -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% [score: 0.0000] 0.0 HTML_MESSAGE BODY: HTML included in message 1.2 HTML_TAG_BALANCE_BODY BODY: HTML has unbalanced "body" tags 0.0 HTML_FONT_LOW_CONTRAST BODY: HTML font color similar or identical to background 1.1 KAM_REALLYHUGEIMGSRC RAW: Spam with image tags with ridiculously huge http urls -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 0.1 DKIM_SIGNED Message has a DKIM or DK signature, not necessarily valid X-Spam-Flag: NO This is a multi-part message in MIME format. --==4de015b26f05b1930c319e0996b88c4f Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Avant Resources ****************************** Creating Dashboards That Excel ****************************** ------------------------------------- Discovering the Truth in Your Numbers ------------------------------------- November 21, 2017 at 12 pm ET (11 am CT, 10 am MT, 9 am PT) Live Online Training: 90 minutes -------------------------------- Counting telephone poles as you speed down the highway is one way to estimate how fast you're going. Of course you might miss a sharp turn and hit a cliff while you're doing all that counting. Wouldn't it be better to get clear, instant feedback from a nice bright speedometer? No matter what you manage, there a few very important numbers that you really must know at all times. They could be units sold per week, service tickets per tech, benefit costs per employee per region, leads per marketing campaign. They change, hour-by-hour, week-by-week. The story they tell is the truth about whether you are succeeding or not. Knowing them in real time is the key to decision-making. "Is it working... Yes, should we do more of this... We need to stop THAT -- now." Microsoft Excel is a powerful tool you already know. By applying the basic elements of pivot tables, charts, connectors to external data and using available graphical templates, you can create a visual dashboard that puts you in the pilot's seat. And Mike Thomas, one of the best Excel trainers we know, can show you how -- in 90 minutes. Register for Excel Dashboard training ( http://click.avanteducation.com/ga/= click/2-5135577-58-3818-7063-11286-e512c10036-1cb7af2a3a ) - Key Learning Objectives ----------------------- * Using Excel to gather and summarize the right data * Maintaining self-updating links to databases, spreadsheets, text files, and other data sources * Examples and formulas for dynamic charts, tables and graphs. Areas Covered ------------- * Best practices for setting up data sources * Using Pivot Tables to summarize data * Visual communication using charts * Creating a rolling 30-day summary * Using formulas to create KPI summaries * Creating interactive filters with Slicers * Automating the dashboard with a simple macro * Using protection to prevent accidental changes Bonus Materials --------------- * Downloadable sample workbooks and templates you can review before the training Who Will Benefit ---------------- * Marketing personnel * Human resources personnel * Accounting professionals * Office administrators * Managers * Anybody who deals with large volumes of data at work Your Expert Instructor ---------------------- speaker name Mike Thomas has over 25 years experience designing and delivering face-to-face and virtual training courses. He has authored nearly 200 written and video-based Excel tutorials. He also develops Microsoft Office solutions to automate key business tasks and processes. "The facilitator very clearly presented the creative ways in which data can be presented and managed." -- Desyra Highsmith, Director of Talent Managment, William Paterson University. Register for Excel Dashboard training ( http://click.avanteducation.com/ga/= click/2-5135577-58-3818-7063-11286-e512c10036-1cb7af2a3a ) Topic Information ----------------- This web training is for any user of Excel who wants to learn how to create Excel dashboards. You should have an intermediate level of Excel knowledge and preferably know how to create a basic pivot table. The training will be delivered using Excel 2016 for Windows. However, much of the functionality is available in Excel 2013 and 2010 CONTINUING EDUCATION We are registered with and adhere to the Statement on Standards for Continuing Professional Education programs of the National Registry of CPE Sponsors. Our registration number is 109066. Please check with the governing body of your license and state for specific CPE requirements. Grievances may be forwarded to the company at 650 620 3961. Grievances may also be forwarded to the National Registry of CPE Sponsors-NASBA, 150 Fourth Avenue North, Suite 700, Nashville, TN 37219-2417, 615-880-4200, www.learningmarket.org, e-mail cpe@nasba.org. This message was sent to kathleen@transocean.com. Unsubscribe from this mailing list ( http://click.avanteducation.com/ga/uns= ubscribe/2-5135577-58-3818-7063-98815c215e47586-1cb7af2a3a ) Questions or Comments? Customer Service Line- 877.726.6796 Email Support Team- support@avantresources.com Avant Resources Business Education 4205 Hillsboro Pike, Suite 203, Nashville, TN 37215= --==4de015b26f05b1930c319e0996b88c4f Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
3D"Avant

Making Dashboards That Truly Excel

 

 

Counting telephone poles as you speed down the highway is one way= to estimate how fast you're going. Trouble is, you might miss De= adman's Curve and fly off a cliff while you're doing all that counting. Wou= ldn't it be better to get clear, instant feedback from a nice bri= ght speedometer?

No matter what you manage, there a few very important numbers tha= t you really must know at all times. They could be units sold per week, ser= vice tickets per tech, benefit costs per employee per region, leads per mar= keting campaign. They change, hour-by-hour, week-by-week. The story they te= ll is the truth about whether you are succeeding or not.

Knowing them in real time is the key to decision-making. "Is = ;it working... Yes, should we do more of this... We need to stop THAT -- no= w."

Microsoft Excel is a powerful tool you already know. By comb= ining the basic elements of pivot tables, charts, connectors to extern= al data and using available graphical templates, you can create a visual da= shboard that puts you in the pilot's seat. And Mike Thomas, one of the best= Excel trainers we know, can show you how to make your own self-updating He= ads Up Display -- in 90 minutes.

 

Key Learning Objectives

  1. Using Excel to gather and summarize the right data
  2. Maintaining self-updating links to databases, spreadsheets, text files,= and other data sources
  3. Examples and formulas for dynamic charts, tables and graphs.

Areas Covered

  • Best practices for setting up data sources
  • Using Pivot Tables to summarize data
  • Visual communication using charts
  • Creating a rolling 30-day summary
  • Using formulas to create KPI summaries
  • Creating interactive filters with Slicers
  • Automating the dashboard with a simple macro
  • Using protection to prevent accidental changes

Bonus Materials

  • Downloadable sample workbooks and templates you can review before the t= raining

Who Will Benefit

  • Marketing personnel
  • Human resources personnel
  • Accounting professionals
  • Office administrators
  • Managers
  • Anybody who deals with large volumes of data at work

Your Expert Instr= uctor

=

3D"speaker

Mike Thomas has over 25 years experience designing = and delivering face-to-face and virtual training courses. He has authored n= early 200 written and video-based Excel tutorials. He also develops Microso= ft Office solutions to automate key business tasks and processes.

"The facilitator very clearly presen= ted the creative ways in which data can be presented and managed." -- Desyr= a Highsmith, Director of Talent Managment, William Paterson University.
Topic Information

This web training is for any user of Excel who wants to learn how= to create Excel dashboards. You should have an intermediate level of Excel= knowledge and preferably know how to create a basic pivot table. The train= ing will be delivered using Excel 2016 for Windows. However, much of the fu= nctionality is available in Excel 2013 and 2010
CONTINUING EDUCATION

=3D""<= span style=3D"font-size: 10pt;">We are reg= istered with and adhere to the Statement on Standards for Continuing Profes= sional Education programs of the National Registry of CPE Sponsors. Our reg= istration number is 109066. Please check with the governing body of your li= cense and state for specific CPE requirements. Grievances may be forwarded = to the company at 650 620 3961. Grievances may also be forwarded to the Nat= ional Registry of CPE Sponsors-NASBA, 150 Fourth Avenue North, Suite 700, N= ashville, TN 37219-2417, 615-880-4200, www.learningmarket.org, e-mail cpe@n= asba.org.

This message was = sent to kathleen@transocean.com.

Unsubscribe from this mailing list

Questions or Comm= ents? Customer Service Line- 877.726.6796
Email Support Team- support@avantresources.com

Avant Resources B= usiness Education
4205= Hillsboro Pike, Suite 203, Nashville, TN 37215
3D"" --==4de015b26f05b1930c319e0996b88c4f--