Public Workshop: Intermediate Excel - Data Analysis
Not currently scheduled
Description:
This three-hour training will provide participants with hands-on Excel training. Participants will be exposed to numerous time savings features such as: pivot tables, vlookup, and what-if-analysis including goal seek and scenario manager. They will learn how to apply these functions to real-world problems to increase productivity and improve efficiency by analyzing large quantities of data and produce user friendly output. This workshop is perfect for those who want to build on the skills they learned in the MDC’s Intermediate Excel course or for the Excel user familiar with the topics being covered.
Learning Outcomes
- Organize worksheet and table data using multiple techniques
- Import/export data using Excel
- Create and use defined names in a workbook
- Use a range of lookup and reference functions
- Understand and create simple PivotTables and Pivot Charts
- Create and work with scenarios and the Scenario Manager
Emily Breit
Emily Breit is a Professor of Finance at Fort Hays State University. She received her PhD. in Finance from Oklahoma State University and her undergraduate and master's degrees in business from Fort Hays State University. She focuses her research on commercial banking, small business lending, corporate governance, economic impact analysis, and pedagogy. She has taught courses in commercial banking, corporate finance, financial and quantitative methods, financial markets and institutions, and investments.