Return-Path: Received: from vps.transocean.com by vps.transocean.com with LMTP id oBiCM0wYMVrbGgAAInt2oQ ; Wed, 13 Dec 2017 04:08:44 -0800 Return-path: Envelope-to: kathleen@transocean.com Delivery-date: Wed, 13 Dec 2017 04:08:44 -0800 Received: from m1.ga.avanteducation.com ([216.153.28.61]:43358) by vps.transocean.com with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.89) (envelope-from ) id 1eP5pv-0001mk-Fq for kathleen@transocean.com; Wed, 13 Dec 2017 04:08:44 -0800 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=avanteducation.com; s=default; t=1513166870; bh=LVirjRK5cBCToPnEvcYS42iRswE=; h=Subject:From:To:Sender:Reply-To:Date:List-Unsubscribe:X-Mailer: X-CampaignID:Message-ID:X-Mailer-Info:MIME-Version:Content-Type; b=XawGFb0HpmiGxyMAhJW0g4oXBm5Wi/A6rsXommS12UTKfxUMamsCA429Y6F8zoC4X mAQoLBaj7j/m5k7LcB4qOzjW9eLte9tmDoE2WAMsiJbjZdmi3ucT9f2zuTXMErDD3t 9QP5IrbO7NNJDDt6Yb9phmlyFsOaqV1zwx0aJQTY= Subject: How to Create Dashboards in Excel From: "Avant Education" To: kathleen@transocean.com Sender: education@avanteducation.com Reply-To: education@avanteducation.com Date: 13 Dec 2017 12:07:50 -0000 List-Unsubscribe: , X-Mailer: GreenArrow Studio (v4.92.3) X-CampaignID: s4:7783-d5d936abcbb91db5 Message-ID: X-Mailer-Info: 8.hVDO.wN3gzM.sWY0hGblVmbARnch52cvNWZh5mLj9Wb.QNxMTN1czN.wN3gTO MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="==69ea513000fc089b92fe698da91bde83" X-Spam-Status: No, score=1.0 X-Spam-Score: 10 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 How To Create Dashboards in Excel Business Intelligence with a Tool You Know [...] Content analysis details: (1.0 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: avanteducation.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 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.0000] 1.2 HTML_TAG_BALANCE_BODY BODY: HTML has unbalanced "body" tags -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 1.8 PYZOR_CHECK Listed in Pyzor (http://pyzor.sf.net/) -0.1 DKIM_VALID Message has at least one valid DKIM or DK signature X-Spam-Flag: NO This is a multi-part message in MIME format. --==69ea513000fc089b92fe698da91bde83 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Avant Resources ********************************* How To Create Dashboards in Excel ********************************* ------------------------------------------ Business Intelligence with a Tool You Know ------------------------------------------ January 17, 2018 at 12 pm ET (11 am CT, 10 am MT, 9 am PT) Live Online Training: 90 minutes -------------------------------- Business intelligence is all about timely insight into the numbers and trends that matter. It doesn't require expensive enterprise software to achieve BI. Microsoft Excel contains the summarization and visualization tools you need to build an amazing visual dashboard. In this training, you will learn exactly how to do it and receive templates, examples and tips to make it happen. Register for Excel Dashboard training ( http://click.avanteducation.com/ga/= click/2-5135577-58-4248-7789-12313-a0746273a5-8c6afa3326 ) 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 ---------------- * Human resource personnel * Accounting professionals * Office administrators * Statisticians * 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-4248-7789-12313-a0746273a5-8c6afa3326 ) 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. Manage Your Subscription ( http://click.avanteducation.com/ga/click/2-51355= 77-58-4248-7789-12315-cfa9b7a123-8c6afa3326 ) or Unsubscribe from this mail= ing list ( http://click.avanteducation.com/ga/unsubscribe/2-5135577-58-4248= -7789-98815c215e47586-8c6afa3326 ) 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= --==69ea513000fc089b92fe698da91bde83 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
3D"Avant

How To Create Dashboards in Excel

 

 

Business intelligence is all about timely insight into the number= s and trends that matter.

It doesn't require expensive enterprise software to achieve BI.

Microsoft Excel contains the summarization and visualization tool= s you need to build an amazing visual dashboard. In this training, you will= learn exactly how to do it and receive templates, examples and tips to mak= e it happen.
 

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.

Manage Your Subscription or 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"" --==69ea513000fc089b92fe698da91bde83--