BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//wp-events-plugin.com//7.2.3.1//EN
TZID:America/Los_Angeles
X-WR-TIMEZONE:America/Los_Angeles
BEGIN:VEVENT
UID:2093@1859oregonmagazine.com
DTSTART;TZID=America/Los_Angeles:20181103T100000
DTEND;TZID=America/Los_Angeles:20181103T130000
DTSTAMP:20181011T201641Z
URL:https://1859oregonmagazine.com/events/ms-excel-advanced-excel-formulas
 -functions-2/
SUMMARY:MS EXCEL - ADVANCED EXCEL FORMULAS &amp\; FUNCTIONS
DESCRIPTION:Want to take your career to the next level?\nPractical\, Hands-
 on Training for Advanced Excel Formulas &amp\; Functions\n\nMicrosoft Exce
 l is perhaps the most important computer software program used in business
  today. That's why so many workers and prospective employees are required 
 to learn Excel to enter or remain in the workplace. Unfortunately many col
 lege students\, recent grads\, and professionals haven’t mastered Excel 
 or have the adequate Excel skills employers are seeking. According to Pays
 cale\, “ 80 percent of job openings require spreadsheet and word-process
 ing software skills. Yet so many people never even give Excel a chance bec
 ause it has an intimidating stigma around it.”\n\nIf you walk through th
 e finance or accounting department at any major corporate office\, you wil
 l see computer screens filled with Excel spreadsheets outlining financial 
 results\, budgets\, forecasts\, and plans used to make big business decisi
 ons. Marketing and Product profesionals using Excel to list customer and s
 ales targets\; managing thier sales force and planning future marketing pl
 ans based on past results. Pivot tables to quickly and easily summarize cu
 stomer and sales data by category with a quick drag-and drop. HR professio
 nals using giant spreadsheets full of employee 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 forecast
 s 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.\n\n
 STRUCTURE OF COURSE:\nAdvanced functions and formulas\n      *Logical func
 tions\n      *Conditional functions\n      *Financial functions\n      *Te
 xt functions\n      *Date functions\n      *Array formulas\nLookups and da
 ta tables\n      *Using lookup functions\n      *Using MATCH and INDEX\n  
     *Creating data tables\nAdvanced data management\n      *Validating cel
 l entries\n      *Advanced filtering\nAdvanced charting\n      *Chart form
 atting options\n      *Combination charts\n      *Graphical objects\nPivot
 Tables and PivotCharts\n      *Working with PivotTables\n      *Rearrangin
 g PivotTables\n      *Formatting PivotTables\n      *PivotCharts\nExportin
 g and Importing Data\n      *Exporting and importing text files\n      *Ge
 tting external data\nAnalytical Tools\n      *Goal Seek\n      *Scenarios\
 nMacros and Visual Basic\n      *Running and recording a macro\n      *Wor
 king with VBA code\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 G
 roup\, where he works in advanced supply chain analytics. In his previous 
 role\, he was the Senior Predictive Consultant at Corios\; where he develo
 ped predictive models and scorecards\, forecast trends\, identify uncertai
 nties\, and assign the ideal strategies to maximize performance. The firm
 ’s clients are in the banking\, brokerage\, credit\, utilities and healt
 hcare industries.\n\nRSVP NOW: http://bit.ly/pdxexceltraining\n\nSOLD OUT?
 \nThis is one of our high demand classes. In the case\, we sale out\; emai
 l us at ibeafoundation@gmail.com and ask when our next course will be in
LOCATION:Nedspace\, 707 SW Washington St. #1100\, Portland\, Oregon\, 97205
 \, United States
GEO:45.5210556;-122.67917970000002
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=707 SW Washington St. #1100
 \, Portland\, Oregon\, 97205\, United States;X-APPLE-RADIUS=100;X-TITLE=Ne
 dspace:geo:45.5210556,-122.67917970000002
END:VEVENT
BEGIN:VTIMEZONE
TZID:America/Los_Angeles
X-LIC-LOCATION:America/Los_Angeles
BEGIN:DAYLIGHT
DTSTART:20180311T030000
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
END:DAYLIGHT
END:VTIMEZONE
END:VCALENDAR