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:20140309T020000 RDATE:20140309T020000 RDATE:20150308T020000 RDATE:20160313T020000 RDATE:20170312T020000 RDATE:20180311T020000 TZOFFSETFROM:-0800 TZOFFSETTO:-0700 TZNAME:PDT END:DAYLIGHT BEGIN:STANDARD DTSTART:20141102T020000 RDATE:20141102T020000 RDATE:20151101T020000 RDATE:20161106T020000 RDATE:20171105T020000 TZOFFSETFROM:-0700 TZOFFSETTO:-0800 TZNAME:PST END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20141021T164006Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141029T094500 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141029T081500 DTSTAMP;VALUE=DATE-TIME:20141021T164006Z LAST-MODIFIED;VALUE=DATE-TIME:20141021T164006Z UID:http://calagator.org/events/1250467201 DESCRIPTION:Data is changing everything\, including what it takes to win in business. Are you ready? Are you savvy about your data? If not\, you' re not alone. The roadblocks are formidable: too much data from too many sources\; not enough data understanding on the business side\; low qual ity data or incomprehensible data\; limited analysis tool sets. \;\n& #13\;\nWhat does it take to master your data? What does that look like a nd how do you get there as painlessly as possible? Why is Power BI such a smart way to go? \;\n \;\nJoin CSG Pro to look at a new paradigm for building your organizational data expertise. We'll talk technology and tools\, but we'll be focused on strategy. \;\n \;\n \;\n• Learn what skill base you need \;\n \;\n• Learn what management c ommitment looks like \;\n \;\n• Learn why (and how) Power BI is a fast track way to get there \;\n \;\n• Understand how to start s mall for a big payout \;\n \;\nThis seminar is geared toward direc tor\, VP and C level executives who think strategically about their busi nesses data. \;\n \;\nIf you're a data steward or analyst\, this would be a great event to bring your boss to. We show the value of these new powerful business analytics tools. \;\n \;\nPlease register via the website link. (FREE\, and Breakfast is included) \;\n \;\n \;\nAbout the presenter\, CSG Pro: \;\n \;\nCSG Pro specializ es in building custom business software and interactive tools that allow you to collaborate and connect with colleagues\, customers and vendors. Based in Portland\, Oregon and maintaining a presence in Boise\, Idaho\ , CSG Pro has served leading companies and public agencies since 1993.\n \nTags: BI\, analytics\, Excel\, Power BI\n\nImported from: http://calag ator.org/events/1250467201 URL:http://www.csgpro.com/archive/2014/10/fast-tracking-data-mastery-powe r-bi-pdx/ SUMMARY:Fast Tracking Data Mastery with Power BI LOCATION:Microsoft Portland Office (Pearl District): 1414 NW Northrup St\ , Suite 900\, Portland OR 97209-2798 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20160224T021642Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20160324T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20160324T183000 DTSTAMP;VALUE=DATE-TIME:20160224T021642Z LAST-MODIFIED;VALUE=DATE-TIME:20160224T021642Z UID:http://calagator.org/events/1250469867 DESCRIPTION:We'll have two talks from Microsoft/Revolution Analytics: \;\n \;\n- Joseph Rickert on R at Microsoft \;\n- John Lam on A L ap Around R Tools for Visual Studio \;\n \;\nDoors open ~6 pm\, ta lks start at 6:30 pm\n\nTags: r\, data science\, programming\, microsoft \, Visual Studio\, Excel\, spreadsheets\n\nImported from: http://calagat or.org/events/1250469867 URL:http://pdxrlang.com/ SUMMARY:pdxrlang meetup: R at Microsoft and R in Visual Studio LOCATION:Mozilla: 1120 NW Couch St.\, Suite 320\, Portland Oregon 97209 U S SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20171019T182010Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20171118T130000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20171118T100000 DTSTAMP;VALUE=DATE-TIME:20171019T182010Z LAST-MODIFIED;VALUE=DATE-TIME:20171019T182010Z UID:http://calagator.org/events/1250472696 DESCRIPTION:Want to take your career to the next level? \;\nPractical\ , Hands-on Training for Advanced Excel Formulas &\; Functions \;\n \;\nMicrosoft Excel is perhaps the most important computer software program used in business today. That's why so many workers and prospecti ve employees are required to learn Excel to enter or remain in the workp lace. Unfortunately many college students\, recent grads\, and professio nals haven’t mastered Excel or have the adequate Excel skills employers are seeking. According to Payscale\, “ 80 percent of job openings requir e spreadsheet and word-processing software skills. Yet so many people ne ver even give Excel a chance because it has an intimidating stigma aroun d it.” \;\n \;\nIf you walk through the finance or accounting depa rtment at any major corporate office\, you will see computer screens fil led with Excel spreadsheets outlining financial results\, budgets\, fore casts\, and plans used to make big business decisions. Marketing and Pro duct profesionals using Excel to list customer and sales targets\; manag ing thier sales force and planning future marketing plans based on past results. Pivot tables to quickly and easily summarize customer and sales data by category with a quick drag-and drop. HR professionals using gia nt spreadsheets full of employee data and understand exactly where the c osts are coming from and how to best plan and control them for the futur e. Supply logistic professional to manage inventory and forecasts demand . \;\nIn essence\, you can turn an entire department around just beca use you know how to manipulate data in order to get an aggregate view.&# 13\;\n \;\nSTRUCTURE OF COURSE: \;\nAdvanced functions and formula s \;\nLogical functions \;\nConditional functions \;\nFinancial functions \;\nText functions \;\nDate functions \;\nArray form ulas \;\nLookups and data tables \;\nUsing lookup functions \;\ nUsing MATCH and INDEX \;\nCreating data tables \;\nAdvanced data management \;\nValidating cell entries \;\nAdvanced filtering \ ;\nAdvanced charting \;\nChart formatting options \;\nCombination charts \;\nGraphical objects \;\nPivotTables and PivotCharts \; \nWorking with PivotTables \;\nRearranging PivotTables \;\nFormatt ing PivotTables \;\nPivotCharts \;\nExporting and Importing Data&# 13\;\nExporting and importing text files \;\nGetting external data 3\;\nAnalytical Tools \;\nGoal Seek \;\nScenarios \;\nMacros an d Visual Basic \;\nRunning and recording a macro \;\nWorking with VBA code \;\n \;\nBENEFITS \;\nNot only are many business profe ssionals using Excel to perform everyday functional tasks in the workpla ce\, an increasing number of employers rely on Excel for decision suppor t.The ability to analyze data is a powerful skill that helps you make be tter decisions. Microsoft Excel is one of the top tools for data analysi s and the built-in pivot tables are arguably the most popular analytic t ool. \;\n \;\nMAKE YOUR RESUME STAND OUT \;\nThey are NOT seein g if you simply have Excel as a skill. They are diving deeping when it c omes to determining which candidate to interview and hire. They look for Pivot Table\, VLOOKUP\, Macros\, VBA\, Conditional Formatting\, Chartin g and Filtering…These are far more telling of your ability to an employe r then writing Excel. Someone who writes VLOOKUP\, Pivot Table\, Filteri ng demonstrates an ability to analyse data and so has eliminated a poten tial barrier in the mind of the hiring manager reviewing your resume. In essence\, use actual Excel functions in your Resume! \;\n \;\nINC REASE YOUR EARNING POTENTIAL \;\nDid you know that Excel know-how can instantly increase your job prospects as well as your starting salary? Excel is a transferrable skill that any hiring manager understands is cr itical. \;\nResearch shows job applicants who know MS Excel make $22. 66 per hour on average compared to the $20.14 per hour their peers make who don’t know the program. That’s roughly an extra $20 per eight-hour w orkday and $100 per work week\, simply for knowing how to use a single c omputer program. Moreover\, full-time employees in certain industries ca n see a starting salary bump of anywhere from $1\,000 to $7\,000 per yea r based on their Excel skills. That’s not chump change you can ignore.&# 13\;\n \;\nINSPIRING ENTREPRENEUR? \;\nA majority 63 percent of tw enty-somethings want to start their own business. How will you stay orga nized\, track data\, or forecast your finances if you’re not spreadsheet -savvy? \;\nMany millennials simply want their first job. But\, what about your performance once someone hires you? The biggest complaint emp loyers have about millennials is that they lack basic hard and soft skil ls.These skills include things like teamwork and problem solving\, but a lso basic administrative skills like MS Word and Powerpoint. Once you’re hired\, you want to meet the basic requirements of your role without st ressing. \;\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 Lib erty Advisor Group\, where he works 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 assign the ideal strategies to maximize performance. The firm’s clients are in the banking\, brokerage\, credit\ , utilities and healthcare industries. \;\n \;\nWHO SHOULD COME?&# 13\;\nPeople whose work is completed through MS Excel\; Software Enginee rs\, Finance Professionals\, HR Professionals\, Marketing Professionals\ , Project Managers\, Technology Professionals. \;\n \;\nADDITIONAL BENEFITS? \;\nFOR FURTHER INFORMATION: PLEASE CONTACT US AT ibeafoun dation@gmail.com. \;\n\n\nTags: technology\, business\, project\, pro ject management\, microsoft\, Excel\, MS Excel\, functions\, formulas\n\ nImported from: http://calagator.org/events/1250472696 URL:https://www.eventbrite.com/e/ms-excel-advanced-excel-formulas-functio ns-tickets-37470410005 SUMMARY:MS EXCEL - ADVANCED EXCEL FORMULAS & FUNCTIONS LOCATION:Union Bank Tower: 707 Southwest Washington Street\, Portland OR 97205 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180821T061552Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180915T130000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180915T100000 DTSTAMP;VALUE=DATE-TIME:20180821T061552Z LAST-MODIFIED;VALUE=DATE-TIME:20180821T061552Z UID:http://calagator.org/events/1250474139 DESCRIPTION:Want to take your career to the next level? \;\nPractical\ , Hands-on Training for Advanced Excel Formulas &\; Functions \;\n \;\nMicrosoft Excel is perhaps the most important computer software program used in business today. That's why so many workers and prospecti ve employees are required to learn Excel to enter or remain in the workp lace. Unfortunately many college students\, recent grads\, and professio nals haven’t mastered Excel or have the adequate Excel skills employers are seeking. According to Payscale\, “ 80 percent of job openings requir e spreadsheet and word-processing software skills. Yet so many people ne ver even give Excel a chance because it has an intimidating stigma aroun d it.” \;\n \;\nIf you walk through the finance or accounting depa rtment at any major corporate office\, you will see computer screens fil led with Excel spreadsheets outlining financial results\, budgets\, fore casts\, and plans used to make big business decisions. Marketing and Pro duct profesionals using Excel to list customer and sales targets\; manag ing thier sales force and planning future marketing plans based on past results. Pivot tables to quickly and easily summarize customer and sales data by category with a quick drag-and drop. HR professionals using gia nt spreadsheets full of employee data and understand exactly where the c osts are coming from and how to best plan and control them for the futur e. Supply logistic professional to manage inventory and forecasts demand . \;\n \;\nIn essence\, you can turn an entire department around j ust because you know how to manipulate data in order to get an aggregate view. \;\n \;\nSTRUCTURE OF COURSE \;\n \;\nAdvanced functi ons and formulas \;\n * Logical functions \;\n * Condition al functions \;\n * Financial functions \;\n * Text functi ons \;\n * Date functions \;\n * Array formulas \;\n 3\;\nLookups and data tables \;\n * Using lookup functions \;\ n * Using MATCH and INDEX \;\n * Creating data tables \;\n \;\nAdvanced data management \;\n * Validating cell entries&# 13\;\n * Advanced filtering \;\n \;\nAdvanced charting \;\n * Chart formatting options \;\n * Combination charts \;\n * Graphical objects \;\n \;\nPivotTables and PivotCharts \ ;\n * Working with PivotTables \;\n * Rearranging PivotTables \;\n * Formatting PivotTables \;\n * PivotCharts \;\n& #13\;\nExporting and Importing Data \;\n * Exporting and importin g text files \;\n * Getting external data \;\n \;\nAnalytic al Tools \;\n * Goal Seek \;\n * Scenarios \;\n \;\n Macros and Visual Basic \;\n * Running and recording a macro \ ;\n * Working with VBA code \;\n \;\nBENEFITS \;\nNot only are many business professionals using Excel to perform everyday function al tasks in the workplace\, an increasing number of employers rely on Ex cel for decision support.The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool. \;\n \;\nMAKE YOUR RESUME STAND OUT 3\;\nThey are NOT seeing if you simply have Excel as a skill. They are d iving deeping when it comes to determining which candidate to interview and hire. They look for Pivot Table\, VLOOKUP\, Macros\, VBA\, Condition al Formatting\, Charting and Filtering…These are far more telling of you r ability to an employer then writing Excel. Someone who writes VLOOKUP\ , Pivot Table\, Filtering demonstrates an ability to analyse data and so has eliminated a potential barrier in the mind of the hiring manager re viewing your resume. In essence\, use actual Excel functions in your Res ume! \;\n \;\nINCREASE YOUR EARNING POTENTIAL \;\nDid you know that Excel know-how can instantly increase your job prospects as well as your starting salary? Excel is a transferrable skill that any hiring ma nager understands is critical. \;\nResearch shows job applicants who know MS Excel make $22.66 per hour on average compared to the $20.14 per hour their peers make who don’t know the program. That’s roughly an ext ra $20 per eight-hour workday and $100 per work week\, simply for knowin g how to use a single computer program. Moreover\, full-time employees i n certain industries can see a starting salary bump of anywhere from $1\ ,000 to $7\,000 per year based on their Excel skills. That’s not chump c hange you can ignore. \;\n \;\nINSPIRING ENTREPRENEUR? \;\nA ma jority 63 percent of twenty-somethings want to start their own business. How will you stay organized\, track data\, or forecast your finances if you’re not spreadsheet-savvy? \;\nMany millennials simply want their first job. But\, what about your performance once someone hires you? Th e biggest complaint employers have about millennials is that they lack b asic hard and soft skills.These skills include things like teamwork and problem solving\, but also basic administrative skills like MS Word and Powerpoint. Once you’re hired\, you want to meet the basic requirements of your role without stressing. \;\n \;\nABOUT THE INSTRUCTOR \ ;\nMartin Jetton has 30+ years of advanced supply chain analytics\, pred ictive analytics\, and statistical consulting experience. He's currently a Principal at the Liberty Advisor Group\, where he works in advanced s upply chain analytics. In his previous role\, he was the Senior Predicti ve Consultant at Corios\; where he developed predictive models and score cards\, forecast trends\, identify uncertainties\, and assign the ideal strategies to maximize performance. The firm’s clients are in the bankin g\, brokerage\, credit\, utilities and healthcare industries. \;\n 3\;\nWHO SHOULD COME? \;\nPeople whose work is completed through MS E xcel\; Software Engineers\, Finance Professionals\, HR Professionals\, M arketing Professionals\, Project Managers\, Technology Professionals. 3\;\n \;\nADDITIONAL BENEFITS? \;\nFOR FURTHER INFORMATION: PLEASE CONTACT US AT ibeafoundation@gmail.com.\n\nTags: Excel\, professional\, professional development\, microsoft\, MS Excel\, students\, college\, Data Entry\, data analytics\, finance\, business\, project managers\, sp readsheets\, data\, computers\n\nImported from: http://calagator.org/eve nts/1250474139 URL:http://bit.ly/LearnMicrosoftExcel SUMMARY:MS EXCEL - ADVANCED EXCEL FORMULAS & FUNCTIONS LOCATION:NedSpace: 707 SW Washington St #1100\, Portland\, OR 97205\, Por tland OR 97205 us SEQUENCE:1 END:VEVENT END:VCALENDAR