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 END:VTIMEZONE BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20181011T002313Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20181103T130000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20181103T100000 DTSTAMP;VALUE=DATE-TIME:20181011T002313Z LAST-MODIFIED;VALUE=DATE-TIME:20181011T002313Z UID:http://calagator.org/events/1250474426 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 .In essence\, you can turn an entire department around just because you know how to manipulate data in order to get an aggregate view. \;\n&# 13\;\nSTRUCTURE OF COURSE \;\n Advanced functions and formulas \;\ n *Logical functions \;\n *Conditional functions \;\n *Financial functions \;\n *Text functions \;\n *Date funct ions \;\n *Array formulas \;\n \;\nLookups and data tables& #13\;\n *Using lookup functions \;\n *Using MATCH and INDEX&# 13\;\n *Creating data tables \;\n \;\nAdvanced data management \;\n *Validating cell entries \;\n *Advanced filtering 3\;\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 3\;\n *PivotCharts \;\n \;\nExporting and Importing Data \; \n *Exporting and importing text files \;\n *Getting external data \;\n \;\nAnalytical Tools \;\n *Goal Seek \;\n *Scenarios \;\n \;\nMacros and Visual Basic \;\n *Running and recording a macro \;\n *Working with VBA code \;\n \;\n ABOUT THE INSTRUCTOR \;\nMartin Jetton has 30+ years of advanced supp ly chain analytics\, predictive analytics\, and statistical consulting e xperience. He's currently a Principal at the Liberty Advisor Group\, whe re he works in advanced supply chain analytics. In his previous role\, h e was the Senior Predictive Consultant at Corios\; where he developed pr edictive models and scorecards\, forecast trends\, identify uncertaintie s\, and assign the ideal strategies to maximize performance. The firm’s clients are in the banking\, brokerage\, credit\, utilities and healthca re industries. \;\n \;\nBENEFITS \;\nNot only are many business professionals using Excel to perform everyday functional tasks in the w orkplace\, an increasing number of employers rely on Excel for decision support.The ability to analyze data is a powerful skill that helps you m ake better decisions. Microsoft Excel is one of the top tools for data a nalysis and the built-in pivot tables are arguably the most popular anal ytic tool. \;\n \;\nMAKE YOUR RESUME STAND OUT \;\nThey are NOT seeing if you simply have Excel as a skill. They are diving deeping whe n it comes to determining which candidate to interview and hire. They lo ok for Pivot Table\, VLOOKUP\, Macros\, VBA\, Conditional Formatting\, C harting and Filtering…These are far more telling of your ability to an e mployer then writing Excel. Someone who writes VLOOKUP\, Pivot Table\, F iltering demonstrates an ability to analyse data and so has eliminated a potential barrier in the mind of the hiring manager reviewing your resu me. In essence\, use actual Excel functions in your Resume! \;\n \ ;\nINCREASE YOUR EARNING POTENTIAL \;\nDid you know that Excel know-h ow can instantly increase your job prospects as well as your starting sa lary? Excel is a transferrable skill that any hiring manager understands is critical. \;\nResearch shows job applicants who know MS Excel mak e $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 workday and $100 per work week\, simply for knowing how to use a si ngle computer program. Moreover\, full-time employees in certain industr ies can see a starting salary bump of anywhere from $1\,000 to $7\,000 p er year based on their Excel skills. That’s not chump change you can ign ore. \;\n \;\nINSPIRING ENTREPRENEUR? \;\nA majority 63 percent of twenty-somethings want to start their own business. How will you sta y organized\, track data\, or forecast your finances if you’re not sprea dsheet-savvy? \;\nMany millennials simply want their first job. But\, what about your performance once someone hires you? The biggest complai nt employers have about millennials is that they lack basic hard and sof t 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 with out stressing. \;\n \;\nWHO SHOULD COME? \;\nPeople whose work is completed through MS Excel\; Software Engineers\, Finance Professiona ls\, HR Professionals\, Marketing Professionals\, Project Managers\, Tec hnology Professionals. \;\n \;\nADDITIONAL BENEFITS? \;\nFOR FU RTHER INFORMATION: 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: Data Management\, data analytics\, d atabase\, data\, data science\, professional development\, tech\, colleg e\, students\, career\, career development\, data analysis\, product man ager\, product management\, education\, recruiter\, human resource\, sta rtups\, Program Manager\, marketing\, marketing data\n\nImported from: h ttp://calagator.org/events/1250474426 URL:http://bit.ly/pdxexceltraining SUMMARY:Practical\, Hands-on Training for Advanced Excel Formulas & Funct ions LOCATION:NedSpace: 707 SW Washington St #1100\, Portland\, OR 97205\, Por tland OR 97205 us SEQUENCE:1 END:VEVENT END:VCALENDAR