Overview:
The MORS Certificate in Excel Functions for Data Analysts is a five-day course designed for beginner to mid-level analysts who wish to enhance their Excel skills and see what is new. Participants will learn how to conduct analysis and prepare briefs for decision makers using only Microsoft Office products. The course begins with the basics to provide a strong foundation, then builds up to a more in-depth look at various tools and functions within Excel. On the final day, participants will create and present a Capstone Project that combines everything they have learned throughout the week.
During the first 3 days (Week 1), the course material is taught with in-course work and overnight homework to reinforce the material covered. Between weeks, a practice Capstone Project is presented to provide more opportunities to reinforce the material. Finally, during the last 2 days (Week 2) an actual Capstone Project is presented: the first day of Week 2, each student works the capstone project independently, while the second day, students are grouped into teams to present the results of the Capstone to the instructors.
MORS has partnered with Virginia Tech to offer this certificate. Participants will receive a number Continuing Education Units (CEUs) upon completion, in accordance with the number of contact hours determined by Virginia Tech.
Objectives:
Through a combination of lectures and group work, our expert instructors will introduce participants to a variety of different Excel tools and functions, including:
- Probability, statistics, and simulation
- Creating charts
- Data query and analysis
- Visual basic and dashboards
Requirements: Computer equipped with Excel 2016 or beyond (anything before 2016 will not work), plus three add-ins that will be used in the course: Data Analysis Toolpak, Solver, and Visual Basic Editor
Agenda
|
|
Program
|
Basics, Probability, and Statistics
|
Formatting
Basic Functions
References
Percentiles and Quartiles
Forecasting (Moving Averages, Weighted Averages)
Random Number Generation
Common Probability Functions
|
| Charts & Data Query
|
Main Charts (pie, column, bar & line)
Specialized Charts (control, scatterplot, pareto, histogram, and boxplots)
Pasting excel charts in PPT and Word
Logic and Logic Math
Lookup Functions
Pivot Tables
|
| Macros / VBA & Dashboards
|
|
| Presenting Results to Senior Leaders
|
|
Instructors:
Ms. Trena Lilly
Trena Lilly is an Operations Research Practitioner with degrees from North Carolina A&T State University, University of Maryland, College Park and the George Washington University. She joined the Johns Hopkins University Applied Physics Laboratory (JHU/APL) in June 1997. Ms. Lilly is currently the Deputy Technical Lead for the Next Generation Surface Weapon (NGSW) Study and the Modeling and Simulation (M&S) Verification, Validation and Accreditation (VV&A) Lead for Aegis BMD. Ms. Lilly is a Past President and Fellow of the Military Operations Research Society (MORS).
Mr. Kirk Michealson
Kirk Michealson is an Operations Research Practitioner with Operations Research Analysis (applied math) degrees from the United States Naval Academy and the Naval Postgraduate School. He is also a retired Navy Surface Warfare Officer, retired Lockheed Martin Fellow for Operations Research Analysis, Lean Six Sigma Black Belt, and Past President & current Fellow of the Military Operations Research Society (MORS). He has designed content for a web-based operations research analysis course for the Chief of Naval Operations’ Assessment Division and has taught various courses over his career.
Registration
The "Invoice Me" option can only be used for the registration fee. This option won't appear if you have social tickets, CEU courses or tutorials in your cart. If you need assistance registering please contact Ms. Sarah Madonia, sarah.madonia@mors.org.
| Employer
|
Member
|
Non-Member
|
| MORS Government Sponsor*
|
$2,700
|
$2,800
|
| U.S. Federal Government
|
$2,800
|
$2,900
|
National Research Partner
(IDA Employees Only)
|
$2755
|
$2850
|
| All Others
|
$2,900
|
$3,000
|
*Government Sponsor organizations include Center for Army Analysis, HQDA/DCS Program G-8; Marine Corps Combat Development and Integration; Naval Operations, N81; SAF/SA, Studies and Analysis; OSD, A&S; and DHS S&T/OSE/ORA