707 SW Washington St #1100
Portland, OR 97205
USA
Join us on Saturday September 15th for a Practical, Hands-on Training: Advanced Excel Formulas and Functions. This training will be taught by Martin Jetton with 30+ years of advanced supply chain analytics, predictive analytics, and statistical consulting experience.
STRUCTURE OF COURSE
Advanced functions and formulas
* Logical functions
* Conditional functions
* Financial functions
* Text functions
* Date functions
* Array formulas
Lookups and data tables
* Using lookup functions
* Using MATCH and INDEX
* Creating data tables
Advanced data management
* Validating cell entries
* Advanced filtering
Advanced charting
* Chart formatting options
* Combination charts
* Graphical objects
PivotTables and PivotCharts
* Working with PivotTables
* Rearranging PivotTables
* Formatting PivotTables
* PivotCharts
Exporting and Importing Data
* Exporting and importing text files
* Getting external data
Analytical Tools
* Goal Seek
* Scenarios
Macros and Visual Basic
* Running and recording a macro
* Working with VBA code
BENEFITS
Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel 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.
MAKE YOUR RESUME STAND OUT
They are NOT seeing if you simply have Excel as a skill. They are diving deeping when it comes to determining which candidate to interview and hire. They look for Pivot Table, VLOOKUP, Macros, VBA, Conditional Formatting, Charting and Filtering…These are far more telling of your 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 reviewing your resume. In essence, use actual Excel functions in your Resume!
INCREASE YOUR EARNING POTENTIAL
Did 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 critical. Research 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 workday and $100 per work week, simply for knowing how to use a single computer program. Moreover, full-time employees in 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 change you can ignore.
INSPIRING ENTREPRENEUR?
A majority 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? Many millennials simply want their first job. But, what about your performance once someone hires you? The biggest complaint employers have about millennials is that they lack basic 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.
ABOUT THE INSTRUCTOR
Martin 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 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.
WHO SHOULD COME?
People whose work is completed through MS Excel; Software Engineers, Finance Professionals, HR Professionals, Marketing Professionals, Project Managers, Technology Professionals.
RSVP Now: http://bit.ly/LearnMicrosoftExcel
