707 SW Washington St #1100
Portland, OR 97205
USA
Want to take your career to the next level?
Practical, Hands-on Training for Advanced Excel Formulas & Functions
Microsoft Excel 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 college students, recent grads, and professionals haven’t mastered Excel or have the adequate Excel skills employers are seeking. 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 intimidating stigma around it.”
If you walk through the finance or accounting department at any major corporate office, you will see computer screens filled with Excel spreadsheets outlining financial results, budgets, forecasts, and plans used to make big business decisions. Marketing and Product profesionals using Excel to list customer and sales targets; managing 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 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 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.
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
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.