Certificate in Excel Functions for Data Analysts

Modeling Complex Warfare Workshop

* MORS' website limitedly supports Internet Explorer and Firefox. For best results, use Chrome.

Certificate in Excel Functions for Data Analysts
Tue-Thu 13-15 September 2022: 
Modules 1-6 (Days 1-3)
Tue-Wed 20-21 September 2022:
Capstone Project and Oral Presentation (Days 4-5)
1000 to 1800 EST
On-line

Event Menu

Overview

Every worker must do some basic analysis, make presentations, and submit reports. Many organizations do not have the “fancy” software packages to create documents that instructional designers may have. However, most organizations have the Microsoft Office Suite.

In the past 10-15 years, Microsoft has updated the capabilities in their Office Suite, especially in Excel. This course is designed to present the basic capabilities to prepare and brief presentations and reports that their managers will understand and be able to take appropriate actions.

The student will need to have laptops with the Microsoft Office Suite. During class, the instructor will present an overview of a topic, let the students work on their own to practice the topic, and then go over their results as a class. Then at the end of the course, students will be given a project with a dataset and will have to do some basic analysis, create a brief, and present the brief to the class.

Instructors:

Ms. Trena Lilly
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

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.

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

Registration

Register Payment Options

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