Certificate in Excel Functions for Data Analysts

Modeling Complex Warfare Workshop

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

4-7 May 2020

Add to Calendar


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 have 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 bring laptops with a current version of Microsoft Office Suite (Office 2013 or earlier will not work for this class). 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.They will have to do some basic analysis, create a brief, and present the brief to the class.


Ms. Trena Lilly

Trena Lilly is an Operations Research Practitioner with degrees from North Carolina A&T State University, from 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). Read full bio.

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. Read full bio.


LCDR Matthew Powers, USN

Matt Powers received his MS in OR from the Naval Postgraduate School’s Operations Research program in September 2012, where he received the Chief of Naval Operations Award for Excellence in OR. He began his OR career in October 2012 at the Joint Center for International Security Force Assistance, known as JCISFA, at Ft. Leavenworth, KS, where authored the JCISFA Assessments Handbook. In October 2015, Matt reported to the Joint Staff, Joint Lessons Learned Division in Suffolk, VA where he was named Lead Military Analyst of the Research and Analysis section. Matt’s most recognized Joint Staff contribution was his development of an Excel-based text analysis tool, combining advanced Excel formulas and VBA code, that rapidly transforms large collections of text data into relevant information for near real-time identification of lessons applicable to multiple functional and organizational lessons learned communities. Read full bio.


Download/Print Latest Agenda

Agenda at a Glance

Monday, 4 May 2020: Basics, Probability & Statistics
1000-1500 EDT
Introductions and Course Information
Excel Basics: Part 1
Excel Basics: Part II
Probability & Statistics: Part I
Probability & Statistics: Part II
Day 1 Wrap-Up

Tuesday, 5 May 2020: Charts & Data Query
1000-1500 EDT
Day 1 Review and Day 2 Preview
Creating Charts: Part 1
Creating Charts: Part II
Data Query: Part 1
Data Query: Part II
Day 2 Wrap-Up

Wednesday, 6 May 2020: Dashboards & Presenting Results
1000-1500 EDT
Day 2 Review and Day 3 Preview
Visual Basic / Dashboards: Part I
Visual Basic / Dashboards: Part II
Presenting Results to Senior Leaders Part I
Presenting Results to Senior Leaders Part II
Presenting Results to Senior Leaders Part III
Day 3 Wrap-Up

Thursday, 7 May 2020: Capstone Project
1000-1800 EDT
Days 1-3 Review & Capstone Preview
Capstone Project Self Study
Capstone Briefs


Payment Options

The "Invoice Me" option can only be used for the registration fee. If you need assistance registering please contact Ms. Tina Yan, tina.yan@mors.org

   Member Non-Member
MORS 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