BEGIN:VCALENDAR PRODID:NingEventWidget-v1 VERSION:2.0 METHOD:PUBLISH BEGIN:VTIMEZONE TZID:America/New_York X-LIC-LOCATION:America/New_York BEGIN:DAYLIGHT TZOFFSETFROM:-0500 TZOFFSETTO:-0400 TZNAME:EDT DTSTART:19700308T020000 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:-0400 TZOFFSETTO:-0500 TZNAME:EST DTSTART:19701101T020000 RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU END:STANDARD END:VTIMEZONE BEGIN:VEVENT UID:2140535:Event:271649 DTSTAMP:20260527T003228Z SUMMARY:Crash Course On Excel: Pivot Tables,Excel Guide - 2020 DESCRIPTION:Overview\n\nPivot Tables have been a mainstay of the Excel program for two decades, and yet they remain a daunting and little un derstood tool. If you are a daily user of Excel, then at some point yo u will be faced with the challenge of data summaries and analysis.\nTh e 1st level of that process is sorting and filtering. And the 2nd leve l is Pivot Tables. Without them, you will be spinning your wheels tryi ng to make sense of data.\nIn this crash course, Andy Lanning will tak e you from intro to advanced; with many tips and tricks along the way! \nThis course will demonstrate the Pivot Table window, the design proc ess, the advanced level features, and also provided is a downloadable PDF guide with step-by-step instructions on each feature covered.\nYou will see various Pivot Table and dashboard examples in order to provi de ideas on handling different projects and data sets.Take this course and benefit from Andy Lanning’s 20+ years of experience. At the fin ish, you will realize how hard you have worked without Pivot Tables he lping you through your projects, and soon rejoice at your new-found ex pertise!\n\nWhy you should Attend\n\nExcel Pivots can be a little conf using until you learn the handy tips in this webinar that will bolster your confidence when summarizing data.\nHave you been leery of Pivot Tables because you might break them? You might \"lose data\"? Or you j ust don't understand how they work?\nAttend this webinar for a crash c ourse in Pivot Tables and you'll be amazed how often you will use Pivo ts afterwards.\n\nAreas Covered in the Session\n\n\nQuickly summarize data with Pivot Tables\nManipulate (or Pivot) the Pivot Table for vary ing results\nGroup data by custom number ranges and data ranges\nCreat e a calculated field within the Pivot table\nLearn the built in \"Summ arize By\" features\nLearn how to \"drill down\" to details\nLearn how to keep your Pivot table spreadsheet tidy\nLearn why named ranges are a benefit, and why Excel 'tables' can be a drawback to producing mult iple Pivot Tables\nCreate Dashboard tools to assist others who might u se the workbook\nAttach Pivot charts to the tables and Dashboard items \nApply design technique for presentation of data\nLearn the little kn own - but vital - Pivot Table settings\nthat will save time and frustr ation\n\n\nWho Will Benefit\n\n\nAccountants\nAccounts\nAudit\nAviatio n\nBanking\nCFOs\nControllers\nCPAs\nEducation\nEnergy\nFDA\nFinance\n Financial consultants\nHuman Resource\nInsurance\nInvestments\nIT\nLog istics & Supply Chain\nMarketing\nMedical Devices\nPharmaceutical\nRet ail\nSales\nTelecom\n\n\nEvent link : https://www.traininng.com/webin ar/-201242live?medtechiq-SEO\nContact Info\nTraininng.com LLC\nEmail: traininngdotcom@gmail.com\nPhone: US: (510) 962-8903\nPhone: Zurich: + 41 - 43 434 80 33\nWebsite : https://www.traininng.com\n\nFor more inf ormation visit https://medtechiq.ning.com/events/crash-course-on-excel -pivot-tables-excel-guide-2020 DTSTART;TZID=America/New_York:20200407T100000 DTEND;TZID=America/New_York:20200407T130000 CATEGORIES:webinar, training, workshop LOCATION:Online Webinar WEBSITE:https://www.traininng.com/webinar/-201242live URL:https://www.traininng.com/webinar/-201242live CONTACT:5109628903 ORGANIZER:Traininng.com ATTACH;FMTTYPE="image/jpeg":https://storage.ning.com/topology/rest/1.0 /file/get/3846985416?profile=original ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;RSVP=TRUE;CN="Joseph W ilcox":https://medtechiq.ning.com/profile/JosephWilcox END:VEVENT END:VCALENDAR