Overview:
The MORS Certificate in Advanced Excel for Data Analysts is a comprehensive five-day course designed to enhance your Excel skills for advanced data manipulation and analysis. This course is perfect for analysts looking to deepen their understanding of Excel’s capabilities and leverage tools like Power BI for business intelligence. Over the five days, you’ll master techniques in working with complex datasets, building interactive reports, and visualizing data through dashboards.
By the end of this course, participants will be equipped to handle advanced Excel functionalities, create sophisticated business intelligence reports, and apply Excel's tools to solve real-world analytical problems. A capstone project at the end of the course allows you to put all your newfound knowledge into practice.
Requirements: Computer equipped with Excel 2019 or beyond (anything before 2019 will not work), plus Power BI which comes with Microsoft Office.
Objectives:
Through a blend of interactive lectures and practical exercises, participants will gain proficiency in:
- Advanced Data Manipulation: Importing, cleaning, transposing, and organizing complex datasets using data functions, with enhanced sorting and filtering capabilities.
- Expanded Analysis & Data Query Capabilities: Leveraging advanced charts (e.g., funnel, radar, and tornado), project management charts (Gantt, S-curve), and in-cell visualizations like sparklines. Master new logic, lookup functions, and advanced pivot table techniques.
- Power BI Integration: Building business intelligence reports and dashboards using Power BI to visualize data, enabling deeper insights into business operations.
- Creating Excel Dashboards, Templates, and Forms: Develop sophisticated Excel dashboards and design custom templates and forms to enhance workflow and reporting efficiency.
Instructors:
Mr. Kirk Michealson
Kirk Michealson is a retired Navy Surface Warfare Officer and an Operations Research Analyst. He is a retired Lockheed Martin Fellow for Operations Research Analysis and is a Fellow and Past President of the Military Operations Research Society (MORS). He recently fully retired, leaving him time to teach Certificate courses for MORS.
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) |
$2,755 |
$2,850 |
| 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; Secretariat of the Air Force, Studies and Analysis SAF/SA; OSD, A&S; and DHS S&T/OSE/ORA