BEGIN:VCALENDAR PRODID;X-RICAL-TZSOURCE=TZINFO:-//Calagator//EN CALSCALE:GREGORIAN X-WR-CALNAME:Calagator METHOD:PUBLISH VERSION:2.0 BEGIN:VTIMEZONE TZID;X-RICAL-TZSOURCE=TZINFO:America/Los_Angeles BEGIN:DAYLIGHT DTSTART:20180311T020000 RDATE:20180311T020000 TZOFFSETFROM:-0800 TZOFFSETTO:-0700 TZNAME:PDT END:DAYLIGHT BEGIN:STANDARD DTSTART:20181104T020000 RDATE:20181104T020000 TZOFFSETFROM:-0700 TZOFFSETTO:-0800 TZNAME:PST END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180409T172726Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180412T190000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180412T173000 DTSTAMP;VALUE=DATE-TIME:20180409T172726Z LAST-MODIFIED;VALUE=DATE-TIME:20180409T172726Z UID:http://calagator.org/events/1250473560 DESCRIPTION:Want to improve your Microsoft Excel skills? Check out this n ew meetup! \;\n \;\nPower Query is the best addition to Excel sinc e Office 2010 but it remains largely unknown. \;\nPlease\, come and s ee a demo of Power Query if you need to do any kind of data-cleansing or data-preparation\, like: \;\n \;\n• Peel the domains out of email addresses \;\n• Convert reports into sortable tables \;\n• Compar e lists \;\n• Stack the data from multiple tabs \;\n \;\nThese common tasks can be done with built-in Power Query features\, whereas\, in the olden days some of these tasks required VBA coding or hours of ma nual effort. \;\n \;\nGaining some Power Query skill is one of the simplest ways to get more from your data. You'll see! \;\n \;\nOz du Soleil is a Microsoft Excel MVP\, author of Guerrilla Data Analysis\ , 2nd Ed.\, and runs the YouTube channel Excel on Fire. Website: http:// ozdusoleil.com/ \;\n \;\nhttps://www.meetup.com/Office365PDX/event s/249004323/\n\nTags: Microsoft Excel\n\nImported from: http://calagator .org/events/1250473560 URL:https://www.meetup.com/Office365PDX/events/249004323/ SUMMARY:Excel User Group: Intro to Power Query - First meeting! LOCATION:Marquam: 811 Naito Parkway\, Suite 600\, Portland Oregon (OR) 97 204 USA SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20181127T003852Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20181212T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20181212T173000 DTSTAMP;VALUE=DATE-TIME:20181127T003852Z LAST-MODIFIED;VALUE=DATE-TIME:20181127T003852Z UID:http://calagator.org/events/1250474600 DESCRIPTION:HAVE SOME EXPERIENCE WITH EXCEL AND WANT TO IMPROVE YOUR SKIL LS? \;\nPractical\, Hands-on Training for Advanced Excel Formulas &am p\; Functions \;\n \;\nDo you have an intermediate understanding of Excel but are keen to break through to real mastery? Want to finally use the programme with ease and confidence at work and become known as a n expert user? Take your Excel skills to the next level with our Advance d Excel course. You’ll soon be crunching data\, using advanced formulas\ , creating impressive graphs and charts like a pro\, plus much more. \;\n \;\nWHY EXCEL MATTERS \;\nWe all know Excel is essential for any business. When efficiently applied it is a powerful tool\, allowing you to manipulate vast amounts of data\, automate tasks and present comp lex information however you see fit. According to Payscale\, “80 percent of job openings require spreadsheet and word-processing software skills . Yet so many people never even give Excel a chance because it has an in timidating stigma around it.” \;\n \;\nSTRUCTURE OF COURSE \;\n Advanced functions and formulas \;\n * Logical functions \;\n * Conditional functions \;\n * Financial functions \;\n * Text functions \;\n * Date functions \;\n * Array form ulas \;\n \;\nLookups and data tables \;\n * Using lookup f unctions \;\n * Using MATCH and INDEX \;\n * Creating data tables \;\n \;\nAdvanced data management \;\n * Validating cell entries \;\n * Advanced filtering \;\n \;\nAdvanced c harting \;\n * Chart formatting options \;\n * Combination charts \;\n * Graphical objects \;\n \;\nPivotTables and P ivotCharts \;\n * Working with PivotTables \;\n * Rearrang ing PivotTables \;\n * Formatting PivotTables \;\n * Pivot Charts \;\n \;\nExporting and Importing Data \;\n * Exporti ng and importing text files \;\n * Getting external data \;\n& #13\;\nAnalytical Tools \;\n * Goal Seek \;\n * Scenarios& #13\;\n \;\nMacros and Visual Basic \;\n * Running and recordi ng a macro \;\n * Working with VBA code \;\n \;\nIf you wal k through the finance or accounting department at any major corporate of fice\, you will see computer screens filled with Excel spreadsheets outl ining financial results\, budgets\, forecasts\, and plans used to make b ig business decisions. Marketing and Product professionals using Excel t o list customer and sales targets\; managing thier sales force and plann ing future marketing plans based on past results. Pivot tables to quickl y and easily summarize customer and sales data by category with a quick drag-and drop. HR professionals using giant spreadsheets full of employe e data and understand exactly where the costs are coming from and how to best plan and control them for the future. Supply logistic professional to manage inventory and forecasts demand. \;\n \;\nIn essence\, y ou can turn an entire department around just because you know how to man ipulate data in order to get an aggregate view. \;\n \;\nABOUT THE INSTRUCTOR \;\nMartin Jetton has 30+ years of advanced supply chain analytics\, predictive analytics\, and statistical consulting experience . He's currently a Principal at the Liberty Advisor Group\, where he wor ks in advanced supply chain analytics. In his previous role\, he was the Senior Predictive Consultant at Corios\; where he developed predictive models and scorecards\, forecast trends\, identify uncertainties\, and a ssign the ideal strategies to maximize performance. The firm’s clients a re in the banking\, brokerage\, credit\, utilities and healthcare indust ries. \;\n \;\nBENEFITS \;\nMAKE YOUR RESUME STAND OUT \;\n& #13\;\nThey are NOT seeing if you simply have Excel as a skill. They are diving deeping when it comes to determining which candidate to intervie w and hire. They look for Pivot Table\, VLOOKUP\, Macros\, VBA\, Conditi onal Formatting\, Charting and Filtering…These are far more telling of y our ability to an employer then writing Excel. Someone who writes VLOOKU P\, Pivot Table\, Filtering demonstrates an ability to analyse data and so has eliminated a potential barrier in the mind of the hiring manager reviewing your resume. In essence\, use actual Excel functions in your R esume! \;\n \;\nWHO SHOULD COME? \;\nPeople whose work is compl eted through MS Excel\; Software Engineers\, Finance Professionals\, HR Professionals\, Marketing Professionals\, Project Managers\, Technology Professionals. \;\n \;\nADDITIONAL BENEFITS? \;\nFOR FURTHER IN FORMATION: PLEASE CONTACT US AT ibeafoundation@gmail.com. \;\n \;\ nSOLD OUT? \;\nThis is one of our high demand classes. In the case\, we sale out\; email us at ibeafoundation@gmail.com and ask when our next course will be in.\n\nTags: career development\, career\, Microsoft Exc el\, tech\, business\, Business Management\, data analytics\, data analy zes\, data\, big data\, predictive analytics\, business development\, fi nance\, accounting\, Data Entry\n\nImported from: http://calagator.org/e vents/1250474600 URL:http://bit.ly/MSExcel122018 SUMMARY:Microsoft Excel – Advanced Level Formulas and Functions LOCATION:NedSpace: 707 SW Washington St #1100\, Portland\, OR 97205\, Por tland OR 97205 us SEQUENCE:1 END:VEVENT END:VCALENDAR