Review everything you need to know about what to do before your program starts.
Full-time MBA Students
First Year: Fall Semester
8W1 Modules (7.5 hours):
ACCT 60010 Financial Reporting (1.5 hours)
BUSI 66100 Career Management & Professional Development (1.5 hours)
FINA 60010 Financial Management 1 (1.5 hours)
INSC 60010 Statistical Models (1.5 hours)
MANA 60330 Engaging People (1.5 hours)
8W2 Modules (7.5 hours):
BUSI 60050 Global Business (1.5 hours)
* FINA 70010 Financial Management II (1.5 hours)
INSC 60600 Supply Chain Concepts (1.5 hours)
INSC 60050 Business Analytics (1.5 hours)
MARK 60010 Marketing Management (1.5 hours)
One Week Intensive (Week 16):
** BUSI 60070 Business Simulation (1.5 hours)
First Year: Spring Semester
8W1 Modules (up to 10.5 hours):
FINA 60020 Managerial Economics (1.5 hours)
INSC 70430 Supply Chain Operations Management (1.5 hours)
INSC 60020 Managing Operations & Processes (1.5 hours)
* MARK 70120 Customer Insights (1.5 hours) OR
MARK 70770 Marketing Research (1.5 hours)
MBA Electives (1.5 – 3 hours) Neeley & Assoc. recommended
8W2 Modules (up to 7.5 hours):
ACCT 60020 Managerial Accounting (1.5 hours)
MANA 60340 Leading Teams and Organizations (1.5 hours)
MBA Electives (3 – 4.5 hours)
Second Year: Fall
8W1 Modules (up to 6 hours):
MANA 60630 Strategic Management (1.5 hours)
MANA 60460 Business Ethics (1.5 hours)
* MARK 70770 Marketing Research (1.5 hours)
MBA Elective (1.5 hours)
8W2 Modules (up to 6 hours):
ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours)
MBA Electives (3 – 4.5 hours)
Second Year: Spring
Must enroll in 8W1 and 8W2 to maintain student status.
*Recommended for students concentrating in Finance, Marketing, and Supply Chain
**Business Simulation is a 1-week intensive course required at the end of the first semester.
Note: Full-time MBA students are limited to 3 credit hours of compressed electives during Winter or May Terms.
First Year: Fall Semester
8W1 Modules (7.5 hours):
ACCT 60010 Financial Reporting (1.5 hours)
BUSI 66100 Career Management & Professional Development (1.5 hours)
FINA 60010 Financial Management 1 (1.5 hours)
INSC 60010 Statistical Models (1.5 hours)
MANA 60330 Engaging People (1.5 hours)
8W2 Modules (7.5 hours):
BUSI 60050 Global Business (1.5 hours)
* FINA 70010 Financial Management II (1.5 hours)
INSC 60600 Supply Chain Concepts (1.5 hours)
* INSC 60050 Business Analytics (1.5 hours)
MARK 60010 Marketing Management (1.5 hours)
One Week Intensive (Week 16):
** BUSI 60070 Business Simulation (1.5 hours)
First Year: Spring Semester
8W1 Modules (up to 10.5 hours):
FINA 60020 Managerial Economics (1.5 hours)
INSC 70430 Supply Chain Operations Management (1.5 hours)
INSC 60020 Managing Operations & Processes (1.5 hours)
* MARK 70120 Customer Insights (1.5 hours) OR
MARK 70770 Marketing Research (1.5 hours)
MBA Electives (1.5 – 3 hours) Neeley & Assoc. recommended
8W2 Modules (up to 7.5 hours):
ACCT 60020 Managerial Accounting (1.5 hours)
MANA 60340 Leading Teams and Organizations (1.5 hours)
MBA Electives (3 – 4.5 hours)
Second Year: Fall
8W1 Modules (up to 4.5 hours):
MANA 60630 Strategic Management (1.5 hours)
MANA 60460 Business Ethics (1.5 hours)
MBA Elective (1.5 hours)
8W2 Modules (up to 6 hours):
ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours)
MBA Electives (3 – 4.5 hours)
Second Year: Spring
Must enroll in 8W1 and 8W2 to maintain student status.
*Recommended for students concentrating in Finance, Marketing, and Supply Chain
**Business Simulation is a 1-week intensive course required at the end of the first semester.
Note: Full-time MBA students are limited to 3 credit hours of compressed electives during Winter or May Terms.
We are delighted to offer an Analytics Certificate that you have the option to pursue as part of your MBA studies. As you continue to plan your electives in the coming semesters, please take note of the requirements for the certificate.
Requirements
The following 4.5 credit hours are required for an Analytics Certificate:
- INSC 60010 Statistical Models (1.5)
- INSC 60050 Business Analytics (1.5)
- INSC 60070 Data Visualization (1.5)
Students must also complete 3.0 credit hours from the following list of electives. While scheduling decisions are always subject to change, I have indicated the semester and time frame when each of these classes are tentatively scheduled to be offered next.
- BUSI 70200 - Business Intelligence and Accounting Analytics (1.5) – fall daytime
- FINA 70523 - Financial Modeling (3) – spring (probably evening)
- INSC 71110 - Predictive Analytics with SAP (1.5) – intersession
- INSC 71130 - Data Analytics Simulation (1.5) - intersession
- MANA 70970 - People Analytics (1.5) – spring (possibly daytime and evening)
- MARK 70110 - Marketing Analytics (1.5) – spring daytime
- MARK 70200 - Customer Relationship Marketing (1.5) – fall daytime
- MARK 70210 - Analytics for Innovation (1.5) – spring daytime
- MARK 70390 - Digital Marketing Analytics (1.5) – spring daytime
- MARK 70770 - Marketing Research (1.5) – fall evening and spring daytime
- MARK 70720 - New Product Development (1.5) – summer evening and fall daytime
Not all of these classes will be offered at times that work for every student. Our intention is to schedule classes such that every student has the opportunity to complete the certificate over a two year period.
Full-time MBA (FTMBA) students should choose to complete a functionally-based concentration. The FTMBA has five concentrations – Corporate Finance, Investments, Marketing Management, Brand Management and Supply and Value Chain Management.
CORPORATE FINANCE
Goal: To provide students with a firm understanding of the financial techniques that should be employed when evaluating potential corporate projects.
The student must complete 16.5 credits as specified below:
Year 1: Fall Semester (1.5 credits): | |||
FINA 70010 | Financial Management II | 1.5 hrs | 8W2 |
Year 1: Spring Semester (3 credits): | |||
FINA 70420 | Options and Futures Markets | 1.5 hrs | 8W1 |
FINA 70520 | Risk Management and Financial Engineering | 1.5 hrs | 8W2 |
Year 2: Fall Semester (Choose 6 of the following credits): | |||
FINA 70513 | Security Analysis | 3 hrs | REG |
ACCT 70153 | Financial Statement Analysis | 3 hrs | REG |
Year 2: Spring Semester (6 credits): | |||
FINA 70523 | Financial Modeling | 3 hrs | REG |
FINA 70543 | Advanced Financial Management | 3 hrs | REG |
AND 13.5 additional credits from any MBA or MAc elective.
Total elective credits = 30
INVESTMENTS
Goal: To provide students with a firm understanding of risk, return, and related valuation concepts.
The student must complete 16.5 credits as specified below:
Year 1: Fall Semester (1.5 credits): | |||
FINA 70010 | Financial Management II | 1.5 hrs | 8W2 |
Year 1: Spring Semester (6 credits): | |||
FINA 70583 | Financial Analysis I | 3 hrs | REG |
FINA 70420 | Options and Futures Markets | 1.5 hrs | 8W1 |
FINA 70520 | Risk Management and Financial Engineering | 1.5 hrs | 8W2 |
Year 2: Fall Semester (6 credits) | |||
FINA 70513 | Security Analysis | 3 hrs | REG |
ACCT 70153 | Financial Statement Analysis | 3 hrs | REG |
Year 2: Spring Semester (3 credits) | |||
FINA 70523 | Financial Modeling | 3 hrs | REG |
AND complete 9 credits from the following (if not already taken): | |||
FINA 70183* | Educational Investment Fund I | 3 hrs | REG |
FINA 70193 | Educational Investment Fund II | 3 hrs | REG |
FINA 70470 | Real Estate Finance & Investment I | 1.5 hrs | 8W1 Fa |
FINA 70570 | Real Estate Finance & Investment II | 1.5 hrs | 8W2 Fa |
FINA 70970 | Investment Practicum | 3 hrs | REG Sp |
FINA 70970 | Advanced Financial Analysis | 3 hrs | REG |
FINA 70543 | Advanced Financial Management | 3 hrs | REG Sp |
FINA 70593 | Financial Analysis II | 3 hrs | REG Sp |
AND 4.5 additional credits from any MBA or MAc elective.
Total elective credits = 30
* Students must apply and be accepted to enroll in the Educational Investment Fund (EIF) courses. The EIF course is designed to be a two-semester commitment. Students must take FINA 70183 and FINA 70193 in successive semesters to receive credit for the EIF.
BRAND MANAGEMENT
Goal: To prepare students for the responsibilities of managing a product or brand, with a special emphasis on brad management for a consumer packaged-goods company. The Brand Management concentration consists of 12 credits; over the student should complete 30 hours of electives.
Complete 10.5 credits as specified below:
Year 1: Fall Semester: | |||
MARK 60110 | Marketing Management | 1.5 hrs | 8W2 |
Year 1: Spring Semester: | |||
MARK 70110 | Marketing Analytics | 1.5 hrs | 8W1 |
MARK 70120 | Customer Insights | 1.5 hrs | 8W2 |
Year 2: Fall Semester: | |||
MARK 70720 | New Product Development | 1.5 hrs | 8W1 |
MARK 70770 | Marketing Research | 1.5 hrs | 8W1 |
MARK 70730 | Brand Management | 1.5 hrs | 8W2 |
Year 2: Spring Semester | |||
MARK 70210 | Analytics for Innovation | 1.5 hrs | 8W2 |
AND complete 1.5 credits from the following: | |||
MARK 70760 | Services Marketing Strategy | 1.5 hrs | Fall |
MARK 70710 | Design Thinking | 1.5 hrs | Inter |
MARK 70200 | Customer Relationship Marketing | 1.5 hrs | Sp 8W1 |
MARK 70390 | Social Media and Content Marketing | 1.5 hrs | Fa 8W1 |
BUSI 70970 | Power & Influence | 1.5 hrs | Fa 8W2 |
AND 18 credits from any MBA elective
Total elective credits = 30
SUPPLY AND VALUE CHAIN MANAGEMENT
Goal: To prepare students to work in the area of Supply and Value Chain Management at firms with extensive supply, materials, and distribution management activities. Firms in service or manufacturing, retailing, and transportation industries, as well as major consulting and technology companies, are potential employers for supply and value chain graduates.
Complete 15 credits as specified below:
Year 1: Fall Semester (1.5 credits): | |||
INSC 60600 | Supply Chain Concepts | 1.5 hrs | 8W2 |
Year 1: Spring Semester (3 credits) | |||
INSC 70650 | Strategic Sourcing and Procurement | 1.5 hrs | 8W1 |
INSC 70630 | Demand Forecasting Management | 1.5 hrs | 8W2 |
Year 2: Fall Semester (4.5 credits) | |||
INSC 70620 | Supply Chain Info. Tools and Tech. | 1.5 hrs | 8W1 |
INSC 70610 | Logistics and Transportation | 1.5 hrs | 8W2 |
INSC 70640 | Global Supply Chain Management | 1.5 hrs | 8W2 |
Year 2: Spring Semester (6 credits) | |||
INSC 71003 | Project Management | 3 hrs | REG |
INSC 70430 | Supply Chain Operations Management | 1.5 hrs | 8W1 |
INSC 70660 | Supply and Value Chain Strategy | 1.5 hrs | 8W2 |
AND complete 3 credits from the following: | |||
INSC 60070 | Data Visualization | 1.5 hrs | 8W1-2 |
INSC 71020 | Six Sigma Green Belt for Managers | 1.5 hrs | 8W2 Sp |
INSC 70970 | Machine Learning for Business | 1.5 hrs | 8W1 Sp |
INSC 71050 | Leading Supply Chains | 1.5 hrs | 8W1 Sp |
INSC 70970 | Supply Chain Analytics | 1.5 hrs | 8W2 |
MANA 70610 | Essentials of Negotiation | 1.5 hrs | 8W1-2 Sp |
MANA 70760 | Transformational Leadership | 1.5 hrs | 8W2 Fa |
MARK 70720 | New Product Development | 1.5 hrs | 8W1 Fa |
AND 12 credits from any MBA or MAc elective
Total elective credits = 30
FTMBA and PMBA students may elect to complete an industry-based emphasis. The five available emphasis areas are Business Consulting, Entrepreneurship, Health Care, and Energy. Some Emphases may not be available in both the FTMBA and PMBA programs.
CONSULTING
Goal: To prepare students for careers as business consultants who can provide consulting services for a broad range of business activities.
The student must complete 7.5 credits as specified below:
MANA 70773 Consulting Applications (N&A, 3 credits), 1st Year
MANA 70870 Practice and Profession of Consulting (1.5 credits), 2nd Year
INSC 71000 Project Management (3 credits), 2nd Year
AND 1.5 credits from the following:
MANA 70760 Transformational Leadership (1.5 credits)
MANA 70740 Managing Conflict for Results (1.5 credits)
MARK 70770 Marketing Research (1.5 credits)
ENTREPRENEURSHIP
Goal: To prepare students for careers as entrepreneurs by developing their abilities to recognize and evaluate opportunities, acquire resources, create enterprises, and manage entrepreneurial organizations.
The student must complete 6 credits as specified below:
MANA 70513 Venture Ideas (3 credits)
MANA 70523 New Venture Planning (3 credits)
AND 3 credits from the following:
ACCT 70153 Financial Statement Analysis (3 credits)
FINA 70543 Advanced Financial Management (3 credits)
MANA 70610 Essentials of Negotiation (1.5 credits)
MARK 70720 New Product Development (1.5 credits)
TCU Neeley Graduate Programs provides our students interactive, hands-on Excel training presented by DFW Excel Experts. These sessions help students take their Excel skills to the next level, allowing you to understand the business context and connect the business need to a technology solution.
Excel Intermediate Part 1
Overview
This class is designed for people who have a basic knowledge of Excel, and who want to increase their knowledge of the practical uses of Excel. By the completion of this class, participants will have a thorough knowledge of using Excel to manage data in multiple sheets in an Excel workbook. Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions. After taking this class, we highly recommend taking the Excel Intermediate Part 2 class which is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas.
Class Outline
- Cell References
- Tables
- Range Names
- Functions Overview
- Date and Time Functions
- Statistical Functions
- Text Functions
- Logical Functions
- Lookup Functions
- Flash Fill
- Advanced Sorting and Advanced Filtering of Data
Excel Intermediate Part 2
Overview
This class is designed for people who have basic knowledge of Excel, and who want to improve the presentation of data in Excel. Excel provides many tools for analyzing data however it is often a challenge to present the data in a meaningful way for others to use. By the completion of this class participants will have a thorough knowledge of Excel data presentations tools including Data Validation, Conditional Formatting, Advanced Charts, PivotTables, and PivotCharts. This is the second half of our Excel Intermediate Class. The Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions, while the Excel Intermediate Part 2 class is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas. Participants should be familiar with the topics covered in the Excel Intermediate Part 1 class.
Class Outline
- Data Validation
- Understanding Data Validation
- Data Validation Rule Setting
- Data Validation Tool Tips
- Data Validation Custom Error Messages
- Conditional Formatting
- Understanding Conditional Formatting
- Highlight Cell Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- Custom Rules
- Advanced Rules based on Formulas
- Creating a Schedule (Gantt chart) using Conditional Formatting
- Advanced Charts
- Waterfall Chart
- Histogram Chart
- Pareto Chart
- Box & Whisker Chart
- Treeman Chart
- Sunburst Chart
- Sparkline Cell Chart
- PivotTable Fundamentals
- Preparing the Data
- Anatomy of a PivotTable
- Slicing and Dicing with a PivotTable
- Grouping Data
- Sorting Data
- Custom PivotTable Field Names
- PivotTable Slicers
- PivotCache
- Refreshing Data
- PivotTable Calculations
- Customize Subtotals
- Showing Values as Calculations
- Calculated Fields
- Calculated Items
- PivotCharts
- Creating a PivotChart
- PivotChart Control Buttons
- PivotChart and PivotTable Filters
Summer '22 Matriculation |
Accelerated Full-time MBA Degree Plan |
Semester Hours |
|
SU 22 | MARK 60011 Marketing Fundamentals (1 hour) June INSC 60011 Supply Chain Mgmt Fundamentals (1 hour) MB2 or MB4 FINA 60011 Finance Fundamentals (1 hour) MB3 BUSI 60070 Business Simulation (1.5 hours) MB2 or MB4 |
4.5 | |
Year 1 | FL22 | BUSI 66100 Career Mgmt & Prof Development (1.5 hours) 8W1 MANA 60630 Strategic Management (1.5 hours) 8W1 ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours) 8W1 BUSI 60050 Global Environment of Business (1.5 hours) 8W2 MBA Electives (4.5-7.5 hours) Local Internship (non-credit) |
10.5-13.5 |
WINT22 | Optional International trip or Compressed Electives | 3-4.5 | |
SP 23 |
FINA 60020 Managerial Economics (1.5 hours) 8W1 |
13.5-18 |
Summer '23 Matriculation |
Accelerated Full-time MBA Degree Plan |
Semester Hours |
|
SU 23 | MARK 60011 Marketing Fundamentals (1 hour) June INSC 60011 Supply Chain Mgmt Fundamentals (1 hour) MB2 or MB4 FINA 60011 Finance Fundamentals (1 hour) MB3 BUSI 60070 Business Simulation (1.5 hours) MB2 or MB4 |
4.5 | |
Year 1 | FL23 | BUSI 66100 Career Mgmt & Prof Development (1.5 hours) 8W1 MANA 60630 Strategic Management (1.5 hours) 8W1 ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours) 8W1 BUSI 60050 Global Environment of Business (1.5 hours) 8W2 MBA Electives (4.5-7.5 hours) Local Internship (non-credit) |
10.5-13.5 |
WINT24 | Optional International trip or Compressed Electives | 3-4.5 | |
SP 24 |
FINA 60020 Managerial Economics (1.5 hours) 8W1 |
13.5-18 |
Full-time MBA (FTMBA) students should choose to complete a functionally-based concentration. The FTMBA has five concentrations – Corporate Finance, Investments, Marketing Management, Brand Management and Supply and Value Chain Management.
CORPORATE FINANCE
Goal: To provide students with a firm understanding of the financial techniques that should be employed when evaluating potential corporate projects.
The student must complete 16.5 credits as specified below:
Year 1: Fall Semester (1.5 credits): | |||
FINA 70010 | Financial Management II | 1.5 hrs | 8W2 |
Year 1: Spring Semester (3 credits): | |||
FINA 70420 | Options and Futures Markets | 1.5 hrs | 8W1 |
FINA 70520 | Risk Management and Financial Engineering | 1.5 hrs | 8W2 |
Year 2: Fall Semester (6 credits): | |||
FINA 70513 | Security Analysis | 3 hrs | REG |
FINA 70523 | Financial Modeling | 3 hrs | REG |
Year 2: Spring Semester (6 credits): | |||
ACCT 70153 | Financial Statement Analysis | 3 hrs | REG |
FINA 70543 | Advanced Financial Management | 3 hrs | REG |
AND 10.5 additional credits from any MBA or MAc elective (13.5 additional credits if the student does not take ACCT 70013).
Total elective credits = 30
INVESTMENTS
Goal: To provide students with a firm understanding of risk, return, and related valuation concepts.
The student must complete 25.5 credits as specified below:
Year 1: Fall Semester (1.5 credits): | |||
FINA 70010 | Financial Management II | 1.5 credits | 8W2 |
Year 1: Spring Semester (6 credits): | |||
FINA 70583 | Topics in Applied Financial Analysis I | 3 credits | REG |
FINA 70420 | Options and Futures Markets | 1.5 credits | 8W1 |
FINA 70520 | Risk Management and Financial Engineering | 1.5 credits | 8W2 |
Year 2: Fall Semester (Choose 6 of the following credits) | |||
FINA 70513 | Security Analysis | 3 credits | REG |
* FINA 70183 | Educational Investment Fund | 3 credits | REG |
FINA 70523 | Financial Modeling | 3 credits | REG |
Year 2: Spring Semester (6 credits) | |||
** FINA 700013 | Advanced Financial Reporting | 3 credits | REG |
ACCT 70153 | Financial Statement Analysis | 3 credits | REG |
OR complete 6 credits from the following (if not already taken): | |||
FINA 70193 | Educational Investment Fund II | 3 credits | REG Sp |
FINA 70470 | Real Estate Finance & Investment I | 1.5 credits | 8W1 Fa |
FINA 70570 | Real Estate Finance & Investment II | 1.5 credits | 8W2 Fa |
FINA 70543 | Advanced Financial Management | 3 credits | REG |
FINA 70593 | Topics in Applied Financial Analysis II | 3 credits | REG Sp |
FINA 70523 | Financial Modeling | 3 credits | REG Sp |
Total elective credits = 22.5
* Enrollment in the Educational Investment Fund (EIF) is a two-semester commitment. Both FINA 70183 and FINA 70193 must be taken in successive semesters to receive credit for the EIF.
** ACCT 70013 must be taken prior to or concurrently with ACCT 70153 unless the student has an accounting undergraduate degree or has taken an extensive number of accounting courses.
BRAND MANAGEMENT
Goal: To prepare students for the responsibilities of managing a product or brand, with a special emphasis on brad management for a consumer packaged-goods company. The Brand Management concentration consists of 12 credits; over the student should complete 30 hours of electives.
Complete 10.5 credits as specified below:
Year 1: Fall Semester: | |||
MARK 70010 | Marketing Issues and Problems | 1.5 hrs | 8W2 |
Year 1: Spring Semester: | |||
MARK 70110 | Marketing Analytics | 1.5 hrs | 8W2 |
MARK 70120 | Customer Insights | 1.5 hrs | 8W2 |
Year 2: Fall Semester: | |||
MARK 70720 | New Product Development | 1.5 hrs | 8W1 |
MARK 70770 | Marketing Research | 1.5 hrs | 8W1 |
MARK 70730 | Brand Management | 1.5 hrs | 8W2 |
Year 2: Spring Semester | |||
MARK 70200 | Customer Relationship Management | 1.5 hrs | 8W1 |
MARK 70210 | Analytics for Innovation | 1.5 hrs | 8W2 |
AND complete 1.5 credits from the following: | |||
MARK 70710 | Design Thinking | 1.5 hrs | Inter |
MARK 70303 | Marketing Strategy | 1.5 hrs | Fall |
MARK 70390 | Social Media and Content Marketing | 1.5 hrs | 8W1 |
MARK 70970 | Special Topics in Marketing | 1.5 hrs | Spring |
AND 18 credits from any MBA elective
Total elective credits = 30
SUPPLY AND VALUE CHAIN MANAGEMENT
Goal: To prepare students to work in the area of Supply and Value Chain Management at firms with extensive supply, materials, and distribution management activities. Firms in service or manufacturing, retailing, and transportation industries, as well as major consulting and technology companies, are potential employers for supply and value chain graduates.
Complete 18 credits as specified below:
Year 1: Spring Semester (3 credits) | |||
INSC 70650 | Strategic Sourcing and Procurement | 1.5 hrs | 8W1 |
INSC 70630 | Demand Forecasting Management | 1.5 hrs | 8W2 |
Year 2: Fall Semester (6 credits) | |||
INSC 70620 | Supply Chain Information Tools and Technologies | 1.5 hrs | 8W1 |
INSC 70610 | Logistics and Transportation | 1.5 hrs | 8W2 |
INSC 70640 | Global Supply Chain Management | 1.5 hrs | 8W2 |
INSC 70430 | Supply Chain Operations Management | 1.5 hrs | |
Year 2: Spring Semester (4.5 credits) | |||
INSC 71003 | Project Management | 3 hrs | REG |
INSC 70660 | Supply and Value Chain Strategy | 1.5 hrs | 8W2 |
AND complete 3 credits from the following: | |||
INSC 71020 | Six Sigma Green Belt for Managers | 1.5 hrs | 8W2 Sp |
ACCT 70020 | Strategic Cost Analysis | 1.5 hrs | |
FINA 70563 | International Finance | 3 hrs | REG Fa |
MANA 70610 | Essentials of Negotiation | 1.5 hrs | 8W1-2 Sp |
MANA 70760 | Transformational Leadership | 1.5 hrs | 8W2 Fa |
MARK 70720 | New Product Development | 1.5 hrs | 8W1 Fa |
MARK 70140 | Managing Service Excellence | 1.5 hrs | Spring |
MARK 70200 | Customer Relationship Marketing | 1.5 hrs | 8W2 Fa |
MARK 70750 | International Marketing | 1.5 hrs | Spring |
AND 12 credits from any MBA or MAc elective
Total elective credits = 30
FTMBA and PMBA students may elect to complete an industry-based emphasis. The five available emphasis areas are Business Consulting, Entrepreneurship, Health Care, and Energy. Some Emphases may not be available in both the FTMBA and PMBA programs.
CONSULTING
Goal: To prepare students for careers as business consultants who can provide consulting services for a broad range of business activities.
The student must complete 7.5 credits as specified below:
MANA 70773 Consulting Applications (N&A, 3 credits), 1st Year
MANA 70870 Practice and Profession of Consulting (1.5 credits), 2nd Year
INSC 71000 Project Management (3 credits), 2nd Year
AND 1.5 credits from the following:
MANA 70760 Transformational Leadership (1.5 credits)
MANA 70740 Managing Conflict for Results (1.5 credits)
MARK 70770 Marketing Research (1.5 credits)
ENTREPRENEURSHIP
Goal: To prepare students for careers as entrepreneurs by developing their abilities to recognize and evaluate opportunities, acquire resources, create enterprises, and manage entrepreneurial organizations.
The student must complete 6 credits as specified below:
MANA 70513 Venture Ideas (3 credits)
MANA 70523 New Venture Planning (3 credits)
AND 3 credits from the following:
ACCT 70153 Financial Statement Analysis (3 credits)
FINA 70543 Advanced Financial Management (3 credits)
MANA 70610 Essentials of Negotiation (1.5 credits)
MARK 70720 New Product Development (1.5 credits)
TCU Neeley Graduate Programs provides our students interactive, hands-on Excel training presented by DFW Excel Experts. These sessions help students take their Excel skills to the next level, allowing you to understand the business context and connect the business need to a technology solution.
Excel Intermediate Part 1
Overview
This class is designed for people who have a basic knowledge of Excel, and who want to increase their knowledge of the practical uses of Excel. By the completion of this class, participants will have a thorough knowledge of using Excel to manage data in multiple sheets in an Excel workbook. Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions. After taking this class, we highly recommend taking the Excel Intermediate Part 2 class which is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas.
Class Outline
- Cell References
- Tables
- Range Names
- Functions Overview
- Date and Time Functions
- Statistical Functions
- Text Functions
- Logical Functions
- Lookup Functions
- Flash Fill
- Advanced Sorting and Advanced Filtering of Data
Excel Intermediate Part 2
Overview
This class is designed for people who have basic knowledge of Excel, and who want to improve the presentation of data in Excel. Excel provides many tools for analyzing data however it is often a challenge to present the data in a meaningful way for others to use. By the completion of this class participants will have a thorough knowledge of Excel data presentations tools including Data Validation, Conditional Formatting, Advanced Charts, PivotTables, and PivotCharts. This is the second half of our Excel Intermediate Class. The Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions, while the Excel Intermediate Part 2 class is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas. Participants should be familiar with the topics covered in the Excel Intermediate Part 1 class.
Class Outline
- Data Validation
- Understanding Data Validation
- Data Validation Rule Setting
- Data Validation Tool Tips
- Data Validation Custom Error Messages
- Conditional Formatting
- Understanding Conditional Formatting
- Highlight Cell Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- Custom Rules
- Advanced Rules based on Formulas
- Creating a Schedule (Gantt chart) using Conditional Formatting
- Advanced Charts
- Waterfall Chart
- Histogram Chart
- Pareto Chart
- Box & Whisker Chart
- Treeman Chart
- Sunburst Chart
- Sparkline Cell Chart
- PivotTable Fundamentals
- Preparing the Data
- Anatomy of a PivotTable
- Slicing and Dicing with a PivotTable
- Grouping Data
- Sorting Data
- Custom PivotTable Field Names
- PivotTable Slicers
- PivotCache
- Refreshing Data
- PivotTable Calculations
- Customize Subtotals
- Showing Values as Calculations
- Calculated Fields
- Calculated Items
- PivotCharts
- Creating a PivotChart
- PivotChart Control Buttons
- PivotChart and PivotTable Filters
Professional MBA Students
Professional MBA students who entered fall 2023
Fall '23 Matriculation |
Professional MBA Degree Plan | Semester Hours |
|
Year 1 | FL23 | ACCT 60010 Financial Reporting (1.5 hours) 8W1 MANA 60350 Essentials of Motivation (1.5 hours) 8W1 ACCT 60020 Managerial Accounting & Control (1.5 hours) 8W2 BUSI 60050 Global Environment of Business (1.5 hours) 8W2 |
6 |
WINT24 | Optional International Trip or Compressed Elective | ||
SP 24 | FINA 60013 Management of Financial Resources (3 hours) REG INSC 60600 Supply Chain Concepts (1.5 hours) 8W1 MARK 60010 Marketing Management (1.5 hours) 8W2 |
6 | |
May 24 | Optional Compressed Elective | ||
SU 24 | FINA 60020 Managerial Economics (1.5 hours) MB1 INSC 60010 Statistical Models (1.5 hours) MB2 INSC 60020 Managing Operations & Processes (1.5 hours) MB4 MBA Elective (1.5 hours) |
6 | |
Year 2 | FL 24 | ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours) 8W1 INSC 60050 Business Analytics (1.5 hours) 8W2 MBA Electives (3 hours) |
6 |
WINT 25 | Optional Compressed Elective | ||
SP 25 | INSC 60040 Managing Information Technology (1.5 hours) 8W1 MANA 60670 Strategy Formulation (1.5 hours) 8W1 MANA 60680 Strategy Implementation (1.5 hours) 8W2 MBA Electives (1.5 hours) |
6 | |
MAY 25 | Optional Compressed Elective | ||
SU 25 | MANA 60460 Business Ethics (1.5 hours) MB2 BUSI 60070 Business Simulation (1.5 hours) MB2 or MB4 MBA Electives (3 hours) |
6 | |
Year 3 | FL 25 | MBA Electives (6 hours) These electives can also be taken throughout the program |
6 |
Professional MBA students who entered spring 2023
Spring '23 Matriculation |
Professional MBA Degree Plan | Semester Hours |
|
Year 1 | SP 23 | ACCT 60010 Financial Reporting (1.5 hours) 8W1 INSC 60600 Supply Chain Concepts (1.5 hours) 8W1 ACCT 60020 Managerial Accounting & Control (1.5 hours) 8W2 MARK 60010 Marketing Management (1.5 hours) 8W2 |
6 |
MAY 23 | Summer compressed electives | ||
SU 23 | Electives (1.5 hours) FINA 60020 Managerial Economics (1.5 hours) MB1 INSC 60010 Statistical Models (1.5 hours) MB2 INSC 60020 Managing Operations & Processes (1.5 hours) MB4 |
6 | |
Year 2 | FL 23 | MANA 60350 Essentials of Motivation (1.5 hours) 8W1 ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours) 8W1 BUSI 60050 Global Environment of Business (1.5 hours) 8W2 INSC 60050 Business Analytics (1.5 hours) 8W2 |
6 |
WINT 24 | Winter Intersession (Optional International Trip or Compressed Electives) | ||
SP 24 | Electives (1.5 hours) FINA 60013 Management of Financial Resources (3 hours) REG 16W MANA 60670 Strategy Formulation (1.5 hours) 8W1 MANA 60680 Strategy Implementation (1.5 hours) 8W2 |
7.5 | |
MAY 24 | Summer optional compressed electives | ||
SU 24 | Electives (1.5 hours) INSC 60040 Managing Information Technology (1.5 hours) MB1 MANA 60460 Business Ethics (1.5 hours) MB2 BUSI 60070 Business Simulation (1.5 hours) MB2 or MB4 |
6 | |
Year 3 | FL 24 | 31.5 hours are specified above. 42 total hours are required. The additional 10.5 hours may be taken in fall or spring mini-terms, on international trips, or in over-loaded semesters (i.e., semesters of more than 6 hours). If additional hours are needed, they may be taken here. |
Professional MBA students who entered fall 2022
Fall '22 Matriculation |
Professional MBA Degree Plan | Semester Hours |
|
Year 1 | FL22 |
ACCT 60010 Financial Reporting (1.5 hours) 8W1 |
6 |
WINT22 | Optional International Trip or Compressed Elective | ||
SP 23 | FINA 60013 Management of Financial Resources (3 hours) REG INSC 60600 Supply Chain Concepts (1.5 hours) 8W1 MARK 60010 Marketing Management (1.5 hours) 8W2 |
6 | |
May 23 | Optional Compressed Elective | ||
SU 23 | FINA 60020 Managerial Economics (1.5 hours) MB1 INSC 60010 Statistical Models (1.5 hours) MB2 INSC 60020 Managing Operations & Processes (1.5 hours) MB4 |
4.5 | |
Year 2 | FL 23 | ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours) 8W1 INSC 60050 Business Analytics (1.5 hours) 8W2 MBA Electives (3 hours) |
6 |
WINT 23 | Optional Compressed Elective | ||
SP 24 | INSC 60040 Managing Information Technology (1.5 hours) 8W1 MANA 60670 Strategy Formulation (1.5 hours) 8W1 MANA 60680 Strategy Implementation (1.5 hours) 8W2 MBA Electives (1.5 hours) |
6 | |
MAY 24 | Optional Compressed Elective | ||
SU 24 | MANA 60460 Business Ethics (1.5 hours) MB2 BUSI 60070 Business Simulation (1.5 hours) MB2 or MB4 MBA Electives (3 hours) |
6 | |
Year 3 | FL 24 | MBA Electives (6 hours) These electives can also be taken throughout the program |
6 |
Professional MBA students who entered spring 2022
Spring '22 Matriculation |
Professional MBA Degree Plan | Semester Hours |
|
Year 1 | SP 22 | ACCT 60010 Financial Reporting (1.5 hours) MANA 60460 Business Ethics (1.5 hours) MARK 60010 Marketing Management (1.5 hours) INSC 60600 Supply Chain Concepts (1.5 hours) |
6 |
MAY 22 | Summer compressed electives | ||
SU 22 | Electives (1.5 hours) INSC 60010 Statistical Models (1.5 hours) INSC 60020 Managing Operations & Processes (1.5 hours) FINA 60020 Managerial Economics (1.5 hours) |
6 | |
Year 2 | FL 22 | MANA 60350 Essentials of Motivation (1.5 hours) ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours) BUSI 60050 Global Environment of Business (1.5 hours) INSC 60050 Business Analytics (1.5 hours) |
6 |
WINT 23 | Winter Intersession | ||
SP 23 | Electives (1.5 hours) FINA 60013 Management of Financial Resources (3 hours) MANA 60670 Strategy Formulation (1.5 hours) MANA 60680 Strategy Implementation (1.5 hours) |
7.5 | |
MAY 23 | Summer compressed electives | ||
SU 23 | Electives (1.5 hours) INSC 60040 Managing Information Technology (1.5 hours) MANA 60460 Business Ethics (1.5 hours) BUSI 60070 Business Simulation (1.5 hours) |
6 | |
Year 3 | FL 23 | 31.5 hours are specified above. 42 total hours are required. The additional 10.5 hours may be taken in fall or spring mini-terms, on international trips, or in over-loaded semesters (i.e., semesters of more than 6 hours). If additional hours are needed, they may be taken here. |
Professional MBA students who entered spring 2021
Spring '21 Matriculation |
Professional MBA Degree Plan | Semester Hours |
|
Year 1 | SP 21 | Electives (1.5 hours) MANA 60460 Business Ethics (1.5 hours) MARK 60010 Marketing Management (1.5 hours) INSC 60600 Supply Chain Concepts (1.5 hours) |
6 |
MAY 21 | Intersession - Summer Term | ||
SU 21 | INSC 60050 Business Analytics (1.5 hours) tentative schedule INSC 60010 Statistical Models (1.5 hours) INSC 60020 Managing Operations & Processes (1.5 hours) FINA 60020 Managerial Economics (1.5 hours) |
6 | |
Year 2 | FL 21 | MANA 60350 Essentials of Motivation (1.5 hours) MANA 60230 Legal Environment of Business (1.5 hours) BUSI 60050 Global Environment of Business (1.5 hours) ACCT 60010 Financial Reporting (1.5 hours) ACCT 60020 Accounting for Managerial Planning & Control (1.5 hours) |
7.5 |
WINT 22 | Winter Intersession | ||
SP 22 | FINA 60013 Management of Financial Resources (3 hours) MANA 60670 Strategy Formulation (1.5 hours) MANA 60680 Strategy Implementation (1.5 hours) |
6 | |
MAY 22 | Intersession - Summer Term | ||
SU 22 | Electives (3 hours) INSC 60040 Managing Information Technology (1.5 hours) BUSI 60070 Business Simulation (1.5 hours) |
6 | |
Year 3 | FL 22 | 31.5 hours are specified above. 42 total hours are required. The additional 10.5 hours may be taken in fall or spring mini-terms, on international trips, or in over-loaded semesters (i.e., semesters of more than 6 hours). If additional hours are needed, they may be taken here. |
FTMBA and PMBA students may elect to complete an industry-based emphasis. The five available emphasis areas are Business Consulting, Entrepreneurship, Health Care, and Energy. Some Emphases may not be available in both the FTMBA and PMBA programs.
CONSULTING
Goal: To prepare students for careers as business consultants who can provide consulting services for a broad range of business activities.
The student must complete 7.5 credits as specified below:
MANA 70773 Consulting Applications (N&A, 3 credits), 1st Year
MANA 70870 Practice and Profession of Consulting (1.5 credits), 2nd Year
INSC 71000 Project Management (3 credits), 2nd Year
AND 1.5 credits from the following:
MANA 70760 Transformational Leadership (1.5 credits)
MANA 70740 Managing Conflict for Results (1.5 credits)
MARK 70770 Marketing Research (1.5 credits)
ENTREPRENEURSHIP
Goal: To prepare students for careers as entrepreneurs by developing their abilities to recognize and evaluate opportunities, acquire resources, create enterprises, and manage entrepreneurial organizations.
The student must complete 6 credits as specified below:
MANA 70513 Venture Ideas (3 credits)
MANA 70523 New Venture Planning (3 credits)
AND 3 credits from the following:
ACCT 70153 Financial Statement Analysis (3 credits)
FINA 70543 Advanced Financial Management (3 credits)
MANA 70610 Essentials of Negotiation (1.5 credits)
MARK 70720 New Product Development (1.5 credits)
Students in the Professional MBA (PMBA) may choose to complete a functionally-based specialization. The PMBA has three specializations – Finance, Marketing, and Supply and Value Chain Management. Each Specialization is 9 credit hours beyond any related foundational course included in the core.
FINANCE
The student must complete 9 credits from the following:
FINA 70470 Real Estate Finance and Investments I (1.5 credits)
FINA 70570 Real Estate Finance and Investments II (1.5 credits)
FINA 70513 Security Analysis (3 credits)
FINA 70523 Financial Modeling (3 credits)
FINA 70420 Options and Futures Markets (1.5 credits)
FINA 70520 Risk Management and Financial Engineering (1.5 credits)
FINA 70583 Topics in Applied Financial Analysis I (3 credits)
FINA 70593 Topics in Applied Financial Analysis II (3 credits)
AND 10.5 additional credits from any MBA elective
MARKETING
The student must complete 9 credits from the following:
MARK 70130 Creativity and Innovation (1.5 credits)
MARK 70800 Marketing Strategy (1.5 credits)
MARK 70110 Marketing Analytics (1.5 credits)
MARK 70770 Marketing Research (1.5 credits)
MARK 70970 Special Problems: Content Marketing & Social Media (1.5 credits)
MARK 70970 Special Problems: Persuasion & Influence (1.5 credits)
AND 10.5 additional credits from any MBA elective
SUPPLY AND VALUE CHAIN MANAGEMENT
The student must complete 9 credits as specified below:
INSC 70660 Supply and Value Chain Strategy (1.5 credits)
AND 7.5 credits from the following:
INSC 60050 Business Analytics (1.5 credits) (if not taken as part of the core)
INSC 70630 Demand Forecasting Management (1.5 credits)
INSC 70650 Strategic Sourcing and Procurement (1.5 credits)
INSC 70430 Supply Chain Operations Management (1.5 credits)
INSC 70620 Supply Chain Information Tools and Technologies (1.5 credits)
INSC 70610 Logistics and Transportation (1.5 credits)
INSC 70640 Global Supply Chain Management (1.5 credits)
INSC 71003 Project Management (3 credits)
INSC 71020 Six Sigma Green Belt for Managers (1.5 credits)
AND 10.5 additional credits from any MBA elective
TCU Neeley Graduate Programs provides our students interactive, hands-on Excel training presented by DFW Excel Experts. These sessions help students take their Excel skills to the next level, allowing you to understand the business context and connect the business need to a technology solution.
Excel Intermediate Part 1
Overview
This class is designed for people who have a basic knowledge of Excel, and who want to increase their knowledge of the practical uses of Excel. By the completion of this class, participants will have a thorough knowledge of using Excel to manage data in multiple sheets in an Excel workbook. Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions. After taking this class, we highly recommend taking the Excel Intermediate Part 2 class which is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas.
Class Outline
- Cell References
- Tables
- Range Names
- Functions Overview
- Date and Time Functions
- Statistical Functions
- Text Functions
- Logical Functions
- Lookup Functions
- Flash Fill
- Advanced Sorting and Advanced Filtering of Data
Excel Intermediate Part 2
Overview
This class is designed for people who have basic knowledge of Excel, and who want to improve the presentation of data in Excel. Excel provides many tools for analyzing data however it is often a challenge to present the data in a meaningful way for others to use. By the completion of this class participants will have a thorough knowledge of Excel data presentations tools including Data Validation, Conditional Formatting, Advanced Charts, PivotTables, and PivotCharts. This is the second half of our Excel Intermediate Class. The Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions, while the Excel Intermediate Part 2 class is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas. Participants should be familiar with the topics covered in the Excel Intermediate Part 1 class.
Class Outline
- Data Validation
- Understanding Data Validation
- Data Validation Rule Setting
- Data Validation Tool Tips
- Data Validation Custom Error Messages
- Conditional Formatting
- Understanding Conditional Formatting
- Highlight Cell Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- Custom Rules
- Advanced Rules based on Formulas
- Creating a Schedule (Gantt chart) using Conditional Formatting
- Advanced Charts
- Waterfall Chart
- Histogram Chart
- Pareto Chart
- Box & Whisker Chart
- Treeman Chart
- Sunburst Chart
- Sparkline Cell Chart
- PivotTable Fundamentals
- Preparing the Data
- Anatomy of a PivotTable
- Slicing and Dicing with a PivotTable
- Grouping Data
- Sorting Data
- Custom PivotTable Field Names
- PivotTable Slicers
- PivotCache
- Refreshing Data
- PivotTable Calculations
- Customize Subtotals
- Showing Values as Calculations
- Calculated Fields
- Calculated Items
- PivotCharts
- Creating a PivotChart
- PivotChart Control Buttons
- PivotChart and PivotTable Filters
Accelerated PMBA students who entered summer 2022
Summer '22 Matriculation |
Accelerated Professional MBA Degree Plan |
Semester Hours |
|
Year 1 | SU 22 | MARK 60011 Marketing Fundamentals (1 hr) June BUSI 60070 Business Simulation (1.5 hrs) MB2 or MB4 INSC 60011 Supply Chain Mgmt Fundamentals (1 hr) MB2 or MB4 FINA 60011 Finance Fundamentals (1 hr) MB3 |
4.5 |
FL22 | ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hrs) 8W1 BUSI 60050 Global Environment of Business (1.5 hrs) 8W2 INSC 60050 Business Analytics (1.5 hrs) 8W2 MBA Electives (1.5 hrs) |
6 | |
WINT22 | Optional International Trip or Compressed Elective | ||
SP 23 | MANA 60670 Strategy Formulation (1.5 hrs) 8W1 MANA 60680 Strategy Implementation (1.5 hrs) 8W2 MBA Electives (3 hours) |
6 | |
Year 2 | May 23 | Optional Compressed Elective | |
SU 23 | FINA 60020 Managerial Economics (1.5 hrs) MB1 MANA 60460 Business Ethics (1.5 hrs) MB2 MBA Electives (3 hrs) |
6 | |
FL 23 | MBA Electives (6 hrs) | 6 | |
WINT 23 | Optional Compressed Elective | ||
SP 24 | MBA Electives (7.5 hrs) These electives can also be taken throughout the program |
7.5 |
* 1.5 hours of electives need to be completed during an intersession or on an overload basis.
Accelerated PMBA students who entered summer 2023
Summer '23 Matriculation |
Accelerated Professional MBA Degree Plan |
Semester Hours |
|
Year 1 | SU 23 | MARK 60011 Marketing Fundamentals (1 hr) June BUSI 60070 Business Simulation (1.5 hrs) MB2 or MB4 INSC 60011 Supply Chain Mgmt Fundamentals (1 hr) MB2 or MB4 FINA 60011 Finance Fundamentals (1 hr) MB3 |
4.5 |
FL23 | ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hrs) 8W1 BUSI 60050 Global Environment of Business (1.5 hrs) 8W2 INSC 60050 Business Analytics (1.5 hrs) 8W2 MBA Electives (1.5 hrs) |
6 | |
WINT24 | Optional International Trip or Compressed Elective * | ||
SP 24 | MANA 60670 Strategy Formulation (1.5 hrs) 8W1 MANA 60680 Strategy Implementation (1.5 hrs) 8W2 MBA Electives (3 hours) |
6 | |
Year 2 | May 24 | Optional Compressed Elective * | |
SU 24 | FINA 60020 Managerial Economics (1.5 hrs) MB1 MANA 60460 Business Ethics (1.5 hrs) MB2 MBA Electives (3 hrs) |
6 | |
FL 24 | MBA Electives (6 hrs) | 6 | |
WINT 25 | Optional Compressed Elective * | ||
SP 25 | MBA Electives (7.5 hrs) These electives can also be taken throughout the program |
7.5 |
* PMBA students are limited to 4 Compressed Electives offered in the Winter and May terms.
Accelerated PMBA students who entered spring 2022
Spring '22 Matriculation |
Accelerated Professional MBA Degree Plan |
Semester Hours |
|
SP 22 | Electives (3.0 hours) MARK 60010 Marketing Management (1.5 hours) INSC 60600 Supply Chain Concepts (1.5 hours) |
7.5 | |
Year 1 | SU 22 | FINA 60011 Finance Fundamentals (1 hour) MANA 60460 Business Ethics (1.5 hour) FINA 60020 Managerial Economics (1.5 hour) BUSI 60070 Business Simulation (1.5 hours) |
5.5 |
FL 22 | Electives (3 hours) INSC 60050/60060 Business Analytics (1.5 hours) ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours) BUSI 60050 Global Environment of Business (1.5 hours) |
7.5 | |
WINT23 | Winter Intersession - Mini Courses | 3 | |
SP 23 | Electives (3 hours) MANA 60670 Strategy Formulation (1.5 hours) MANA 60680 Strategy Implementation (1.5 hours) |
6 | |
Year 2 | SU 23 | Electives (6 hours) May include 3 hours Study Abroad | 6 |
FL 23 | Electives (3 hours) | 3 |
FTMBA and PMBA students may elect to complete an industry-based emphasis. The five available emphasis areas are Business Consulting, Entrepreneurship, Health Care, and Energy. Some Emphases may not be available in both the FTMBA and PMBA programs.
CONSULTING
Goal: To prepare students for careers as business consultants who can provide consulting services for a broad range of business activities.
The student must complete 7.5 credits as specified below:
MANA 70773 Consulting Applications (N&A, 3 credits), 1st Year
MANA 70870 Practice and Profession of Consulting (1.5 credits), 2nd Year
INSC 71000 Project Management (3 credits), 2nd Year
AND 1.5 credits from the following:
MANA 70760 Transformational Leadership (1.5 credits)
MANA 70740 Managing Conflict for Results (1.5 credits)
MARK 70770 Marketing Research (1.5 credits)
ENTREPRENEURSHIP
Goal: To prepare students for careers as entrepreneurs by developing their abilities to recognize and evaluate opportunities, acquire resources, create enterprises, and manage entrepreneurial organizations.
The student must complete 6 credits as specified below:
MANA 70513 Venture Ideas (3 credits)
MANA 70523 New Venture Planning (3 credits)
AND 3 credits from the following:
ACCT 70153 Financial Statement Analysis (3 credits)
FINA 70543 Advanced Financial Management (3 credits)
MANA 70610 Essentials of Negotiation (1.5 credits)
MARK 70720 New Product Development (1.5 credits)
Students in the Professional MBA (PMBA) may choose to complete a functionally-based specialization. The PMBA has three specializations – Finance, Marketing, and Supply and Value Chain Management. Each Specialization is 9 credit hours beyond any related foundational course included in the core.
FINANCE
The student must complete 9 credits from the following:
FINA 70470 Real Estate Finance and Investments I (1.5 credits)
FINA 70570 Real Estate Finance and Investments II (1.5 credits)
FINA 70513 Security Analysis (3 credits)
FINA 70523 Financial Modeling (3 credits)
FINA 70420 Options and Futures Markets (1.5 credits)
FINA 70520 Risk Management and Financial Engineering (1.5 credits)
FINA 70583 Topics in Applied Financial Analysis I (3 credits)
FINA 70593 Topics in Applied Financial Analysis II (3 credits)
AND 10.5 additional credits from any MBA elective
MARKETING
The student must complete 9 credits from the following:
MARK 70130 Creativity and Innovation (1.5 credits)
MARK 70800 Marketing Strategy (1.5 credits)
MARK 70110 Marketing Analytics (1.5 credits)
MARK 70770 Marketing Research (1.5 credits)
MARK 70970 Special Problems: Content Marketing & Social Media (1.5 credits)
MARK 70970 Special Problems: Persuasion & Influence (1.5 credits)
AND 10.5 additional credits from any MBA elective
SUPPLY AND VALUE CHAIN MANAGEMENT
The student must complete 9 credits as specified below:
INSC 70660 Supply and Value Chain Strategy (1.5 credits)
AND 7.5 credits from the following:
INSC 60050 Business Analytics (1.5 credits) (if not taken as part of the core)
INSC 70630 Demand Forecasting Management (1.5 credits)
INSC 70650 Strategic Sourcing and Procurement (1.5 credits)
INSC 70430 Supply Chain Operations Management (1.5 credits)
INSC 70620 Supply Chain Information Tools and Technologies (1.5 credits)
INSC 70610 Logistics and Transportation (1.5 credits)
INSC 70640 Global Supply Chain Management (1.5 credits)
INSC 71003 Project Management (3 credits)
INSC 71020 Six Sigma Green Belt for Managers (1.5 credits)
AND 10.5 additional credits from any MBA elective
TCU Neeley Graduate Programs provides our students interactive, hands-on Excel training presented by DFW Excel Experts. These sessions help students take their Excel skills to the next level, allowing you to understand the business context and connect the business need to a technology solution.
Excel Intermediate Part 1
Overview
This class is designed for people who have a basic knowledge of Excel, and who want to increase their knowledge of the practical uses of Excel. By the completion of this class, participants will have a thorough knowledge of using Excel to manage data in multiple sheets in an Excel workbook. Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions. After taking this class, we highly recommend taking the Excel Intermediate Part 2 class which is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas.
Class Outline
- Cell References
- Tables
- Range Names
- Functions Overview
- Date and Time Functions
- Statistical Functions
- Text Functions
- Logical Functions
- Lookup Functions
- Flash Fill
- Advanced Sorting and Advanced Filtering of Data
Excel Intermediate Part 2
Overview
This class is designed for people who have basic knowledge of Excel, and who want to improve the presentation of data in Excel. Excel provides many tools for analyzing data however it is often a challenge to present the data in a meaningful way for others to use. By the completion of this class participants will have a thorough knowledge of Excel data presentations tools including Data Validation, Conditional Formatting, Advanced Charts, PivotTables, and PivotCharts. This is the second half of our Excel Intermediate Class. The Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions, while the Excel Intermediate Part 2 class is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas. Participants should be familiar with the topics covered in the Excel Intermediate Part 1 class.
Class Outline
- Data Validation
- Understanding Data Validation
- Data Validation Rule Setting
- Data Validation Tool Tips
- Data Validation Custom Error Messages
- Conditional Formatting
- Understanding Conditional Formatting
- Highlight Cell Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- Custom Rules
- Advanced Rules based on Formulas
- Creating a Schedule (Gantt chart) using Conditional Formatting
- Advanced Charts
- Waterfall Chart
- Histogram Chart
- Pareto Chart
- Box & Whisker Chart
- Treeman Chart
- Sunburst Chart
- Sparkline Cell Chart
- PivotTable Fundamentals
- Preparing the Data
- Anatomy of a PivotTable
- Slicing and Dicing with a PivotTable
- Grouping Data
- Sorting Data
- Custom PivotTable Field Names
- PivotTable Slicers
- PivotCache
- Refreshing Data
- PivotTable Calculations
- Customize Subtotals
- Showing Values as Calculations
- Calculated Fields
- Calculated Items
- PivotCharts
- Creating a PivotChart
- PivotChart Control Buttons
- PivotChart and PivotTable Filters
Professional Online MBA students who entered fall 2022
Fall '22 Matriculation |
Professional Online MBA Degree Plan | Semester Hours |
|
Year 1 | FL22 |
ACCT 60010 Financial Reporting (1.5 hours) 8W1 |
6 |
WINT22 | Optional Compressed Electives | ||
SP 23 | FINA 60013 Management of Financial Resources (3 hours) REG INSC 60600 Supply Chain Concepts (1.5 hours) 8W2 MARK 60010 Marketing Management (1.5 hours) 8W1 |
6 | |
May 23 | Optional Compressed Electives | ||
SU 23 | Electives (1.5 hours) FINA 60020 Managerial Economics (1.5 hours) MB1 INSC 60010 Statistical Models (1.5 hours) MB2 INSC 60020 Managing Operations & Processes (1.5 hours) MB4 |
6 | |
Year 2 | FL 23 | ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours) 8W1 INSC 60050 Business Analytics (1.5 hours) 8W2 MBA Electives (3 hours) |
6 |
WINT 24 | Optional Compressed Elective | ||
SP 24 | INSC 60040 Managing Information Technology (1.5 hours) 8W1 MANA 60670 Strategy Formulation (1.5 hours) 8W1 MANA 60680 Strategy Implementation (1.5 hours) 8W2 MBA Electives (1.5 hours) |
6 | |
MAY 24 | Optional Compressed Electives | ||
SU 24 | MANA 60460 Business Ethics (1.5 hours) MB2 BUSI 60070 Business Simulation (1.5 hours) MB2 or MB4 MBA Electives (3 hours) |
6 | |
Year 3 | FL 24 | 36 hours are specified above. 42 total hours are required. The additional 6 hours may be taken in fall or spring mini-terms, in international trips, or in over-loaded semesters (i.e., semesters of more than 6 hours). If additional hours are needed, they may be taken here. | 6 |
Professional Online MBA students who entered fall 2023
Fall '23 Matriculation |
Professional Online MBA Degree Plan | Semester Hours |
|
Year 1 | FL23 | ACCT 60010 Financial Reporting (1.5 hours) 8W1 MANA 60350 Essentials of Motivation (1.5 hours) 8W1 ACCT 60020 Managerial Accounting & Control (1.5 hours) 8W2 BUSI 60050 Global Environment of Business (1.5 hours) 8W2 |
6 |
WINT24 | Optional Compressed Electives | ||
SP 24 | FINA 60013 Management of Financial Resources (3 hours) REG INSC 60600 Supply Chain Concepts (1.5 hours) 8W2 MARK 60010 Marketing Management (1.5 hours) 8W1 |
6 | |
May 24 | Optional Compressed Electives | ||
SU 24 | Electives (1.5 hours) FINA 60020 Managerial Economics (1.5 hours) MB1 INSC 60010 Statistical Models (1.5 hours) MB2 INSC 60020 Managing Operations & Processes (1.5 hours) MB4 |
6 | |
Year 2 | FL 24 | ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours) 8W1 INSC 60050 Business Analytics (1.5 hours) 8W2 MBA Electives (3 hours) |
6 |
WINT 25 | Optional Compressed Elective | ||
SP 25 | INSC 60040 Managing Information Technology (1.5 hours) 8W1 MANA 60670 Strategy Formulation (1.5 hours) 8W1 MANA 60680 Strategy Implementation (1.5 hours) 8W2 MBA Electives (1.5 hours) |
6 | |
MAY 25 | Optional Compressed Electives | ||
SU 25 | MANA 60460 Business Ethics (1.5 hours) MB2 BUSI 60070 Business Simulation (1.5 hours) MB2 or MB4 MBA Electives (3 hours) |
6 | |
Year 3 | FL 25 | 36 hours are specified above. 42 total hours are required. The additional 6 hours may be taken in fall or spring mini-terms, in international trips, or in over-loaded semesters (i.e., semesters of more than 6 hours). If additional hours are needed, they may be taken here. | 6 |
Professional Online MBA students who entered spring 2023
Spring '23 Matriculation |
Professional MBA Degree Plan | Semester Hours |
|
Year 1 | SP 23 | INSC 60600 Supply Chain Concepts (1.5 hours) 8W1 MARK 60010 Marketing Management (1.5 hours) 8W2 MBA Electives (3 hours) |
6 |
MAY 23 | Summer optional compressed electives | ||
SU 23 | Electives (1.5 hours) FINA 60020 Managerial Economics (1.5 hours) MB1 INSC 60010 Statistical Models (1.5 hours) MB2 INSC 60020 Managing Operations & Processes (1.5 hours) MB4 |
6 | |
Year 2 | FL 23 | ACCT 60010 Financial Reporting (1.5 hours) 8W1 MANA 60350 Essentials of Motivation (1.5 hours) 8W1 ACCT 60020 Managerial Accounting & Control (1.5 hours) 8W2 BUSI 60050 Global Environment of Business (1.5 hours) 8W2 |
6 |
WINT 24 | Winter Intersession (Optional International Trip or Compressed Electives) | ||
SP 24 | Electives (1.5 hours) FINA 60013 Management of Financial Resources (3 hours) REG 16W MANA 60670 Strategy Formulation (1.5 hours) 8W1 MANA 60680 Strategy Implementation (1.5 hours) 8W2 |
7.5 | |
MAY 24 | Summer optional compressed electives | ||
SU 24 | Electives (1.5 hours) INSC 60040 Managing Information Technology (1.5 hours) MB1 MANA 60460 Business Ethics (1.5 hours) MB2 BUSI 60070 Business Simulation (1.5 hours) MB2 or MB4 |
6 | |
Year 3 | FL 24 | ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours) 8W1 INSC 60050 Business Analytics (1.5 hours) 8W2 MBA Electives (7.5 hours) |
10.5 |
FTMBA and PMBA students may elect to complete an industry-based emphasis. The five available emphasis areas are Business Consulting, Entrepreneurship, Health Care, and Energy. Some Emphases may not be available in both the FTMBA and PMBA programs.
CONSULTING
Goal: To prepare students for careers as business consultants who can provide consulting services for a broad range of business activities.
The student must complete 7.5 credits as specified below:
MANA 70773 Consulting Applications (N&A, 3 credits), 1st Year
MANA 70870 Practice and Profession of Consulting (1.5 credits), 2nd Year
INSC 71000 Project Management (3 credits), 2nd Year
AND 1.5 credits from the following:
MANA 70760 Transformational Leadership (1.5 credits)
MANA 70740 Managing Conflict for Results (1.5 credits)
MARK 70770 Marketing Research (1.5 credits)
ENTREPRENEURSHIP
Goal: To prepare students for careers as entrepreneurs by developing their abilities to recognize and evaluate opportunities, acquire resources, create enterprises, and manage entrepreneurial organizations.
The student must complete 6 credits as specified below:
MANA 70513 Venture Ideas (3 credits)
MANA 70523 New Venture Planning (3 credits)
AND 3 credits from the following:
ACCT 70153 Financial Statement Analysis (3 credits)
FINA 70543 Advanced Financial Management (3 credits)
MANA 70610 Essentials of Negotiation (1.5 credits)
MARK 70720 New Product Development (1.5 credits)
TCU Neeley Graduate Programs provides our students interactive, hands-on Excel training presented by DFW Excel Experts. These sessions help students take their Excel skills to the next level, allowing you to understand the business context and connect the business need to a technology solution.
Excel Intermediate Part 1
Overview
This class is designed for people who have a basic knowledge of Excel, and who want to increase their knowledge of the practical uses of Excel. By the completion of this class, participants will have a thorough knowledge of using Excel to manage data in multiple sheets in an Excel workbook. Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions. After taking this class, we highly recommend taking the Excel Intermediate Part 2 class which is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas.
Class Outline
- Cell References
- Tables
- Range Names
- Functions Overview
- Date and Time Functions
- Statistical Functions
- Text Functions
- Logical Functions
- Lookup Functions
- Flash Fill
- Advanced Sorting and Advanced Filtering of Data
Excel Intermediate Part 2
Overview
This class is designed for people who have basic knowledge of Excel, and who want to improve the presentation of data in Excel. Excel provides many tools for analyzing data however it is often a challenge to present the data in a meaningful way for others to use. By the completion of this class participants will have a thorough knowledge of Excel data presentations tools including Data Validation, Conditional Formatting, Advanced Charts, PivotTables, and PivotCharts. This is the second half of our Excel Intermediate Class. The Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions, while the Excel Intermediate Part 2 class is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas. Participants should be familiar with the topics covered in the Excel Intermediate Part 1 class.
Class Outline
- Data Validation
- Understanding Data Validation
- Data Validation Rule Setting
- Data Validation Tool Tips
- Data Validation Custom Error Messages
- Conditional Formatting
- Understanding Conditional Formatting
- Highlight Cell Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- Custom Rules
- Advanced Rules based on Formulas
- Creating a Schedule (Gantt chart) using Conditional Formatting
- Advanced Charts
- Waterfall Chart
- Histogram Chart
- Pareto Chart
- Box & Whisker Chart
- Treeman Chart
- Sunburst Chart
- Sparkline Cell Chart
- PivotTable Fundamentals
- Preparing the Data
- Anatomy of a PivotTable
- Slicing and Dicing with a PivotTable
- Grouping Data
- Sorting Data
- Custom PivotTable Field Names
- PivotTable Slicers
- PivotCache
- Refreshing Data
- PivotTable Calculations
- Customize Subtotals
- Showing Values as Calculations
- Calculated Fields
- Calculated Items
- PivotCharts
- Creating a PivotChart
- PivotChart Control Buttons
- PivotChart and PivotTable Filters
Students in the Professional MBA (PMBA) may choose to complete a functionally-based specialization. The PMBA has three specializations – Finance, Marketing, and Supply and Value Chain Management. Each Specialization is 9 credit hours beyond any related foundational course included in the core.
FINANCE
The student must complete 9 credits from the following:
FINA 70470 Real Estate Finance and Investments I (1.5 credits)
FINA 70570 Real Estate Finance and Investments II (1.5 credits)
FINA 70513 Security Analysis (3 credits)
FINA 70523 Financial Modeling (3 credits)
FINA 70420 Options and Futures Markets (1.5 credits)
FINA 70520 Risk Management and Financial Engineering (1.5 credits)
FINA 70583 Topics in Applied Financial Analysis I (3 credits)
FINA 70593 Topics in Applied Financial Analysis II (3 credits)
AND 10.5 additional credits from any MBA elective
MARKETING
The student must complete 9 credits from the following:
MARK 70130 Creativity and Innovation (1.5 credits)
MARK 70800 Marketing Strategy (1.5 credits)
MARK 70110 Marketing Analytics (1.5 credits)
MARK 70770 Marketing Research (1.5 credits)
MARK 70970 Special Problems: Content Marketing & Social Media (1.5 credits)
MARK 70970 Special Problems: Persuasion & Influence (1.5 credits)
AND 10.5 additional credits from any MBA elective
SUPPLY AND VALUE CHAIN MANAGEMENT
The student must complete 9 credits as specified below:
INSC 70660 Supply and Value Chain Strategy (1.5 credits)
AND 7.5 credits from the following:
INSC 60050 Business Analytics (1.5 credits) (if not taken as part of the core)
INSC 70630 Demand Forecasting Management (1.5 credits)
INSC 70650 Strategic Sourcing and Procurement (1.5 credits)
INSC 70430 Supply Chain Operations Management (1.5 credits)
INSC 70620 Supply Chain Information Tools and Technologies (1.5 credits)
INSC 70610 Logistics and Transportation (1.5 credits)
INSC 70640 Global Supply Chain Management (1.5 credits)
INSC 71003 Project Management (3 credits)
INSC 71020 Six Sigma Green Belt for Managers (1.5 credits)
AND 10.5 additional credits from any MBA elective
Energy MBA Students
Energy MBA students who entered fall 2023
Energy Core Classes
Fall '23 Matriculation |
Energy MBA Degree Plan | Semester Hours |
|
Year 1 | FL23 | BUSI 70970 Energy in the 21st Century (1.5 hours) 8W1 ACCT 60010 Financial Reporting (1.5 hours) 8W1 MANA 60350 Essentials of Motivation (1.5 hours) 8W1 ACCT 60020 Managerial Accounting & Control (1.5 hours) 8W2 BUSI 60050 Global Environment of Business (1.5 hours) 8W2 Energy MBA Elective (1.5 hours) |
9 |
WINT24 | Optional Compressed Elective | ||
SP 24 | FINA 60013 Management of Financial Resources (3 hours) REG FINA 70610 Energy Macroeconomics (1.5 hours) 8W1 INSC 60600 Supply Chain Concepts (1.5 hours) 8W1 MARK 60010 Marketing Management (1.5 hours) 8W2 |
7.5 | |
MAY 24 | MANA 70663 Energy Global Experience (3 hours) | 3 | |
SU 24 | INSC 60010 Statistical Models (1.5 hours) MB2 MANA 60460 Business Ethics (1.5 hours) MB2 BUSI 60070 Business Simulation (1.5 hours) MB2 or MB4 INSC 60020 Managing Operations & Processes (1.5 hours) MB4 |
6 | |
Year 2 | FL 24 | ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours) 8W1 FINA 70620 Energy Corporate Finance (1.5 hours) 8W1 INSC 60050 Business Analytics (1.5 hours) 8W2 MBA Electives (5.5 hours) |
up to 9 |
WINT 25 | Optional Compressed Elective | ||
SP 25 | INSC 60040 Managing Information Technology (1.5 hours) 8W1 MANA 60670 Strategy Formulation (1.5 hours) 8W1 BUSI 70970 Energy Field Study (1.5 hours) 8W2 MANA 70650 Energy CEO Forum (1.5 hours) 8W2 MANA 60680 Strategy Implementation (1.5 hours) 8W2 |
7.5 |
Energy Electives | Typical Term | |
BUSI 70970 | Analysis of Current Events: Oil & Gas | Fall 8W2-Thurs |
MANA 70620 | Energy Legal & Regulatory Issues | Fall 8W1-Tues |
ACCT 70610 | Energy Accounting | Spring 8W1 |
BUSI 70970 | Energy Commodities | Spring 8W2 - Thurs |
BUSI 70970 | Renewable Energy Viability | Winter Intersession |
Energy MBA students who entered fall 2022
Energy Core Classes
Fall '22 Matriculation |
Energy MBA Degree Plan | Semester Hours |
|
Year 1 | SU22 | BUSI 70970 Energy in the 21st Century (1.5 hours) 8W1 | 1.5 |
FL22 | ACCT 60010 Financial Reporting (1.5 hours) 8W1 ACCT 60020 Managerial Accounting & Control (1.5 hours) 8W2 BUSI 60050 Global Environment of Business (1.5 hours) 8W2 |
4.5 | |
WINT22 | Optional Compressed Elective | ||
SP 23 | FINA 60013 Management of Financial Resources (3 hours) REG FINA 70610 Energy Macroeconomics (1.5 hours) 8W1 INSC 60600 Supply Chain Concepts (1.5 hours) 8W1 MARK 60010 Marketing Management (1.5 hours) 8W2 |
7.5 | |
Year 2 | MAY 23 | MANA 70663 Energy Global Experience (3 hours) | 3 |
SU 23 | INSC 60010 Statistical Models (1.5 hours) MB2 MANA 60460 Business Ethics (1.5 hours) MB2 BUSI 60070 Business Simulation (1.5 hours) MB2 or MB4 INSC 60020 Managing Operations & Processes (1.5 hours) MB4 |
6 | |
FL 23 | ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours) 8W1 FINA 70620 Energy Corporate Finance (1.5 hours) 8W1 INSC 60050 Business Analytics (1.5 hours) 8W2 MBA Elective (1.5 hours) |
6 | |
WINT 23 | Optional Compressed Elective | ||
SP 24 | INSC 60040 Managing Information Technology (1.5 hours) 8W1 MANA 60670 Strategy Formulation (1.5 hours) 8W1 BUSI 70970 Energy Field Study (1.5 hours) 8W2 MANA 70650 Energy CEO Forum (1.5 hours) 8W2 MANA 60680 Strategy Implementation (1.5 hours) 8W2 |
7.5 |
Energy Electives | Typical Term | |
BUSI 70970 | Analysis of Current Events: Oil & Gas | Fall 8W2-Thurs |
MANA 70620 | Energy Legal & Regulatory Issues | Fall 8W1-Tues |
ACCT 70610 | Energy Accounting | Spring 8W1 |
BUSI 70970 | Energy Commodities | Spring 8W2 - Thurs |
BUSI 70970 | Renewable Energy Viability | Winter Intersession |
Students in the Professional MBA (PMBA) may choose to complete a functionally-based specialization. The PMBA has three specializations – Finance, Marketing, and Supply and Value Chain Management. Each Specialization is 9 credit hours beyond any related foundational course included in the core.
FINANCE
The student must complete 9 credits from the following:
FINA 70470 Real Estate Finance and Investments I (1.5 credits)
FINA 70570 Real Estate Finance and Investments II (1.5 credits)
FINA 70513 Security Analysis (3 credits)
FINA 70523 Financial Modeling (3 credits)
FINA 70420 Options and Futures Markets (1.5 credits)
FINA 70520 Risk Management and Financial Engineering (1.5 credits)
FINA 70583 Topics in Applied Financial Analysis I (3 credits)
FINA 70593 Topics in Applied Financial Analysis II (3 credits)
AND 10.5 additional credits from any MBA elective
MARKETING
The student must complete 9 credits from the following:
MARK 70130 Creativity and Innovation (1.5 credits)
MARK 70800 Marketing Strategy (1.5 credits)
MARK 70110 Marketing Analytics (1.5 credits)
MARK 70770 Marketing Research (1.5 credits)
MARK 70970 Special Problems: Content Marketing & Social Media (1.5 credits)
MARK 70970 Special Problems: Persuasion & Influence (1.5 credits)
AND 10.5 additional credits from any MBA elective
SUPPLY AND VALUE CHAIN MANAGEMENT
The student must complete 9 credits as specified below:
INSC 70660 Supply and Value Chain Strategy (1.5 credits)
AND 7.5 credits from the following:
INSC 60050 Business Analytics (1.5 credits) (if not taken as part of the core)
INSC 70630 Demand Forecasting Management (1.5 credits)
INSC 70650 Strategic Sourcing and Procurement (1.5 credits)
INSC 70430 Supply Chain Operations Management (1.5 credits)
INSC 70620 Supply Chain Information Tools and Technologies (1.5 credits)
INSC 70610 Logistics and Transportation (1.5 credits)
INSC 70640 Global Supply Chain Management (1.5 credits)
INSC 71003 Project Management (3 credits)
INSC 71020 Six Sigma Green Belt for Managers (1.5 credits)
AND 10.5 additional credits from any MBA elective
TCU Neeley Graduate Programs provides our students interactive, hands-on Excel training presented by DFW Excel Experts. These sessions help students take their Excel skills to the next level, allowing you to understand the business context and connect the business need to a technology solution.
Excel Intermediate Part 1
Overview
This class is designed for people who have a basic knowledge of Excel, and who want to increase their knowledge of the practical uses of Excel. By the completion of this class, participants will have a thorough knowledge of using Excel to manage data in multiple sheets in an Excel workbook. Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions. After taking this class, we highly recommend taking the Excel Intermediate Part 2 class which is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas.
Class Outline
- Cell References
- Tables
- Range Names
- Functions Overview
- Date and Time Functions
- Statistical Functions
- Text Functions
- Logical Functions
- Lookup Functions
- Flash Fill
- Advanced Sorting and Advanced Filtering of Data
Excel Intermediate Part 2
Overview
This class is designed for people who have basic knowledge of Excel, and who want to improve the presentation of data in Excel. Excel provides many tools for analyzing data however it is often a challenge to present the data in a meaningful way for others to use. By the completion of this class participants will have a thorough knowledge of Excel data presentations tools including Data Validation, Conditional Formatting, Advanced Charts, PivotTables, and PivotCharts. This is the second half of our Excel Intermediate Class. The Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions, while the Excel Intermediate Part 2 class is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas. Participants should be familiar with the topics covered in the Excel Intermediate Part 1 class.
Class Outline
- Data Validation
- Understanding Data Validation
- Data Validation Rule Setting
- Data Validation Tool Tips
- Data Validation Custom Error Messages
- Conditional Formatting
- Understanding Conditional Formatting
- Highlight Cell Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- Custom Rules
- Advanced Rules based on Formulas
- Creating a Schedule (Gantt chart) using Conditional Formatting
- Advanced Charts
- Waterfall Chart
- Histogram Chart
- Pareto Chart
- Box & Whisker Chart
- Treeman Chart
- Sunburst Chart
- Sparkline Cell Chart
- PivotTable Fundamentals
- Preparing the Data
- Anatomy of a PivotTable
- Slicing and Dicing with a PivotTable
- Grouping Data
- Sorting Data
- Custom PivotTable Field Names
- PivotTable Slicers
- PivotCache
- Refreshing Data
- PivotTable Calculations
- Customize Subtotals
- Showing Values as Calculations
- Calculated Fields
- Calculated Items
- PivotCharts
- Creating a PivotChart
- PivotChart Control Buttons
- PivotChart and PivotTable Filters
Accelerated Energy MBA students who entered summer 2023
Energy Core Classes
Summer '23 Matriculation |
Accelerated Energy MBA Degree Plan | Semester Hours |
|
Year 1 | SU 23 | MARK 60011 Marketing Fundamentals (1 hour) June INSC 60011 Supply Chain Mgmt Fundamentals (1 hour) MB2 or MB4 FINA 60011 Finance Fundamentals (1 hour) MB3 |
3 |
FL23 | BUSI 70970 Energy in the 21st Century (1.5 hours) 8W1 FINA 70620 Energy Corporate Finance (1.5 hours) 8W1 INSC 60050 Business Analytics (1.5 hours) 8W2 BUSI 60050 Global Environment of Business (1.5 hours) 8W2 Energy MBA Electives (3 hours) |
9 | |
WINT24 | Optional Compressed Elective | ||
SP 24 | FINA 70610 Energy Macroeconomics (1.5 hours) 8W1 MANA 60670 Strategy Formulation (1.5 hours) 8W1 MANA 60680 Strategy Implementation (1.5 hours) 8W2 MANA 70650 Energy CEO Forum (1.5 hours) 8W2 |
6 | |
Year 2 | MAY 24 | MANA 70663 Global Experience - Energy (3 hours) | 3 |
SU 24 | MANA 60460 Business Ethics (1.5 hours) MB2 BUSI 60070 Business Simulation (1.5 hours) MB2 or MB4 MBA Electives (3 hours) |
6 | |
FL 24 | ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours) 8W1 MANA 70660 Energy Field Study (1.5 hours) 8W2 MBA Electives (6 hours) |
9 |
Energy Electives | Typical Term | |
BUSI 70970 | Analysis of Current Events: Oil & Gas | Fall 8W2, Thurs |
MANA 70620 | Energy Legal & Regulatory Issues | Fall 8W1, Tues |
ACCT 70610 | Energy Accounting | Spring 8W1 |
BUSI 70970 | Energy Commodities | Spring 8W2, Thurs |
BUSI 70970 | Renewable Energy Viability | Winter Intersession |
Accelerated Energy MBA students who entered summer 2022
Energy Core Classes
Summer '22 Matriculation |
Accelerated Energy MBA Degree Plan | Semester Hours |
|
Year 1 | SU 22 | MARK 60011 Marketing Fundamentals (1 hour) June INSC 60011 Supply Chain Mgmt Fundamentals (1 hour) MB2 or MB4 FINA 60011 Finance Fundamentals (1 hour) MB3 BUSI 70970 Energy in the 21st Century (1.5 hours) MB4 |
4.5 |
FL22 | FINA 70620 Energy Corporate Finance (1.5 hours) 8W1 INSC 60050 Business Analytics (1.5 hours) 8W2 BUSI 60050 Global Environment of Business (1.5 hours) 8W2 |
4.5 | |
WINT22 | Optional Compressed Elective | ||
SP 23 | FINA 70610 Energy Macroeconomics (1.5 hours) 8W1 MANA 60670 Strategy Formulation (3 hours) 8W1 MANA 60680 Strategy Implementation (1.5 hours) 8W2 MANA 70650 Energy CEO Forum (1.5 hours) 8W2 |
6 | |
Year 2 | MAY 23 | MANA 70663 Global Experience - Energy (3 hours) | 3 |
SU 23 | MANA 60460 Business Ethics (1.5 hours) MB2 BUSI 60070 Business Simulation (1.5 hours) MB2 or MB4 MBA Electives (3 hours) |
6 | |
FL 23 | ENTR 60230 Regulatory Environment for Entrepreneurs and Managers (1.5 hours) 8W1 MANA 70660 Energy Field Study (1.5 hours) 8W2 Electives (3 hours) |
6 |
Energy Electives | Typical Term | |
BUSI 70970 | Analysis of Current Events: Oil & Gas | Fall 8W2, Thurs |
MANA 70620 | Energy Legal & Regulatory Issues | Fall 8W1, Tues |
ACCT 70610 | Energy Accounting | Spring 8W1 |
BUSI 70970 | Energy Commodities | Spring 8W2, Thurs |
BUSI 70970 | Renewable Energy Viability | Winter Intersession |
Students in the Professional MBA (PMBA) may choose to complete a functionally-based specialization. The PMBA has three specializations – Finance, Marketing, and Supply and Value Chain Management. Each Specialization is 9 credit hours beyond any related foundational course included in the core.
FINANCE
The student must complete 9 credits from the following:
FINA 70470 Real Estate Finance and Investments I (1.5 credits)
FINA 70570 Real Estate Finance and Investments II (1.5 credits)
FINA 70513 Security Analysis (3 credits)
FINA 70523 Financial Modeling (3 credits)
FINA 70420 Options and Futures Markets (1.5 credits)
FINA 70520 Risk Management and Financial Engineering (1.5 credits)
FINA 70583 Topics in Applied Financial Analysis I (3 credits)
FINA 70593 Topics in Applied Financial Analysis II (3 credits)
AND 10.5 additional credits from any MBA elective
MARKETING
The student must complete 9 credits from the following:
MARK 70130 Creativity and Innovation (1.5 credits)
MARK 70800 Marketing Strategy (1.5 credits)
MARK 70110 Marketing Analytics (1.5 credits)
MARK 70770 Marketing Research (1.5 credits)
MARK 70970 Special Problems: Content Marketing & Social Media (1.5 credits)
MARK 70970 Special Problems: Persuasion & Influence (1.5 credits)
AND 10.5 additional credits from any MBA elective
SUPPLY AND VALUE CHAIN MANAGEMENT
The student must complete 9 credits as specified below:
INSC 70660 Supply and Value Chain Strategy (1.5 credits)
AND 7.5 credits from the following:
INSC 60050 Business Analytics (1.5 credits) (if not taken as part of the core)
INSC 70630 Demand Forecasting Management (1.5 credits)
INSC 70650 Strategic Sourcing and Procurement (1.5 credits)
INSC 70430 Supply Chain Operations Management (1.5 credits)
INSC 70620 Supply Chain Information Tools and Technologies (1.5 credits)
INSC 70610 Logistics and Transportation (1.5 credits)
INSC 70640 Global Supply Chain Management (1.5 credits)
INSC 71003 Project Management (3 credits)
INSC 71020 Six Sigma Green Belt for Managers (1.5 credits)
AND 10.5 additional credits from any MBA elective
TCU Neeley Graduate Programs provides our students interactive, hands-on Excel training presented by DFW Excel Experts. These sessions help students take their Excel skills to the next level, allowing you to understand the business context and connect the business need to a technology solution.
Excel Intermediate Part 1
Overview
This class is designed for people who have a basic knowledge of Excel, and who want to increase their knowledge of the practical uses of Excel. By the completion of this class, participants will have a thorough knowledge of using Excel to manage data in multiple sheets in an Excel workbook. Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions. After taking this class, we highly recommend taking the Excel Intermediate Part 2 class which is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas.
Class Outline
- Cell References
- Tables
- Range Names
- Functions Overview
- Date and Time Functions
- Statistical Functions
- Text Functions
- Logical Functions
- Lookup Functions
- Flash Fill
- Advanced Sorting and Advanced Filtering of Data
Excel Intermediate Part 2
Overview
This class is designed for people who have basic knowledge of Excel, and who want to improve the presentation of data in Excel. Excel provides many tools for analyzing data however it is often a challenge to present the data in a meaningful way for others to use. By the completion of this class participants will have a thorough knowledge of Excel data presentations tools including Data Validation, Conditional Formatting, Advanced Charts, PivotTables, and PivotCharts. This is the second half of our Excel Intermediate Class. The Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions, while the Excel Intermediate Part 2 class is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas. Participants should be familiar with the topics covered in the Excel Intermediate Part 1 class.
Class Outline
- Data Validation
- Understanding Data Validation
- Data Validation Rule Setting
- Data Validation Tool Tips
- Data Validation Custom Error Messages
- Conditional Formatting
- Understanding Conditional Formatting
- Highlight Cell Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- Custom Rules
- Advanced Rules based on Formulas
- Creating a Schedule (Gantt chart) using Conditional Formatting
- Advanced Charts
- Waterfall Chart
- Histogram Chart
- Pareto Chart
- Box & Whisker Chart
- Treeman Chart
- Sunburst Chart
- Sparkline Cell Chart
- PivotTable Fundamentals
- Preparing the Data
- Anatomy of a PivotTable
- Slicing and Dicing with a PivotTable
- Grouping Data
- Sorting Data
- Custom PivotTable Field Names
- PivotTable Slicers
- PivotCache
- Refreshing Data
- PivotTable Calculations
- Customize Subtotals
- Showing Values as Calculations
- Calculated Fields
- Calculated Items
- PivotCharts
- Creating a PivotChart
- PivotChart Control Buttons
- PivotChart and PivotTable Filters
Health Care MBA Students
Health Care MBA students who entered fall 2021
Fall '21 Matriculation |
Health Care MBA Degree Plan |
Semester Hours |
|
Year 1 | FL21 | ACCT 60010 Financial Reporting (1.5 hours) ACCT 60020 Accounting for Managerial Planning & Control (1.5 hours) MANA 60350 Essentials of Motivation (1.5 hours) BUSI 60050 Global Environment of Business (1.5 hours) |
6 |
WINT22 | Compressed Electives - Intersession Electives (3 hours) |
3 | |
SP 22 | MANA 72410 The US Health Care System (1.5 hours) FINA 60013 Management of Financial Resources (3 hours) MARK 60010 Marketing Management (1.5 hours) INSC 60600 Supply Chain Concepts (1.5 hours) |
7.5 | |
May 22 | Compressed Electives - Summer Term Electives (3 hours) |
3 | |
SU 22 | INSC 60010 Statistical Models (1.5 hours) INSC 60020 Managing Operations & Processes (1.5 hours) MANA 60460 Business Ethics (1.5 hours) BUSI 60070 Business Simulation (1.5 hours) BUSI 72460 Healthcare Markets (1.5 hours) |
7.5 | |
Year 2 | FL 22 | INSC 72470 Health Care Improvement Science (1.5 hours) MANA 60230 Legal Environment of Business (1.5 hours) MARK 70970 Design Thinking (1.5 hours) INSC 60050 Business Analytics (1.5 hours) |
6 |
WINT 23 | Compressed Electives - Intersession MANA 72423 US Health Care Policy (3 hours) |
3 | |
SP 23 | INSC 60040 Managing Information Technology (1.5 hours) MANA 72480 Challenges in Health Care Leadership (1.5 hours) MANA 60670 Strategy Formulation (1.5 hours) MANA 60680 Strategy Implementation (1.5 hours) |
6 |
Click here to download the PDF
TCU Neeley Graduate Programs provides our students interactive, hands-on Excel training presented by DFW Excel Experts. These sessions help students take their Excel skills to the next level, allowing you to understand the business context and connect the business need to a technology solution.
Excel Intermediate Part 1
Overview
This class is designed for people who have a basic knowledge of Excel, and who want to increase their knowledge of the practical uses of Excel. By the completion of this class, participants will have a thorough knowledge of using Excel to manage data in multiple sheets in an Excel workbook. Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions. After taking this class, we highly recommend taking the Excel Intermediate Part 2 class which is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas.
Class Outline
- Cell References
- Tables
- Range Names
- Functions Overview
- Date and Time Functions
- Statistical Functions
- Text Functions
- Logical Functions
- Lookup Functions
- Flash Fill
- Advanced Sorting and Advanced Filtering of Data
Excel Intermediate Part 2
Overview
This class is designed for people who have basic knowledge of Excel, and who want to improve the presentation of data in Excel. Excel provides many tools for analyzing data however it is often a challenge to present the data in a meaningful way for others to use. By the completion of this class participants will have a thorough knowledge of Excel data presentations tools including Data Validation, Conditional Formatting, Advanced Charts, PivotTables, and PivotCharts. This is the second half of our Excel Intermediate Class. The Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions, while the Excel Intermediate Part 2 class is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas. Participants should be familiar with the topics covered in the Excel Intermediate Part 1 class.
Class Outline
- Data Validation
- Understanding Data Validation
- Data Validation Rule Setting
- Data Validation Tool Tips
- Data Validation Custom Error Messages
- Conditional Formatting
- Understanding Conditional Formatting
- Highlight Cell Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- Custom Rules
- Advanced Rules based on Formulas
- Creating a Schedule (Gantt chart) using Conditional Formatting
- Advanced Charts
- Waterfall Chart
- Histogram Chart
- Pareto Chart
- Box & Whisker Chart
- Treeman Chart
- Sunburst Chart
- Sparkline Cell Chart
- PivotTable Fundamentals
- Preparing the Data
- Anatomy of a PivotTable
- Slicing and Dicing with a PivotTable
- Grouping Data
- Sorting Data
- Custom PivotTable Field Names
- PivotTable Slicers
- PivotCache
- Refreshing Data
- PivotTable Calculations
- Customize Subtotals
- Showing Values as Calculations
- Calculated Fields
- Calculated Items
- PivotCharts
- Creating a PivotChart
- PivotChart Control Buttons
- PivotChart and PivotTable Filters
Required 6 hours
MANA 72410 | Health Care in the U.S. | 1.5 hrs | Spring 8W1 |
BUSI 72460 | Health Care Markets | 1.5 hrs | Summer 6W1 |
INSC 72470 | Health Care Improvement Science | 1.5 hrs | Fall 8W1 |
MANA 72480 | Challenges in Health Care Leadership | 1.5 hrs | Spring 8W1 (2nd year) |
Optional 3 hours
MANA 72423 U.S. Health Policy 3 hours with one-week domestic travel (intersession)
OR
MARK 70710 | Design Thinking | 1.5 hrs |
MANA 70970 | Health Care Finance | 1.5 hrs |
INSC 60050 | Business Analytics | 1.5 hrs |
MARK 70200 | Customer Relationship Marketing | 1.5 hrs |
MARK 70210 | Analytics for Innovation | 1.5 hrs |
MARK 70390 | Digital Marketing Analytics | 1.5 hrs |
MARK 70770 | Marketing Research | 1.5 hrs |
MS Business Analytics Students
MS Business Analytics students who entered summer 2023
Summer '23 Matriculation |
MS Business Analytics Degree Plan | Semester Hours |
|
Summer | SU23 | ACCT 60110 Accounting and Analytics (1.5 hrs) MARK 60110 Marketing and Analytics (1.5 hrs) FINA 60110 Finance and Analytics (1.5 hrs) INSC 60011 Supply Chain Mgmt and Analytics (1.5 hrs) BUSI 60070 Survey of Technology Analytics (1.5 hrs) INSC 60051 Technology Boot Camp (1.5 hrs) |
9 |
Year 1 | FL 23 | BUSI 70970 Ethics and Data Privacy (1.5 hrs) INSC 60070 Data Visualization (1.5 hrs) INSC 60010 Statistical Models (1.5 hrs) INSC 60050 Business Analytics (1.5 hrs) BUSI 66100 Career Management & Professional Development (1.5 hrs) MSBA Electives (up to 3 hrs) |
Up to 10.5 |
WINT 24 | Winter Intersession - Compressed Electives | Up to 3 | |
SP 24 | * ENTR 70970 Capstone (3 hours) REG 16W MSBA Electives (up to 4.5 hours) |
Up to 7.5 |
*Students may apply to participate in Neeley & Associates and those who participate enroll in MANA 70773 Neeley & Associates Consulting. The application process begins during the fall semester.
Electives
Course # | Course Name | Credit Hrs | |
Fall | ACCT 70970 | Accounting Analytics | 1.5 |
BUSI 70200 | Business Intelligence and Analytics | 1.5 | |
MARK 70770 | Marketing Research | 1.5 | |
INSC 70970 | Supply Chain Analytics | 1.5 | |
Winter | MARK 70390 | Digital Marketing Analytics | 1.5 |
INSC 71110 | Predictive Analytics with SAP | 1.5 | |
INSC 70970 | Data Analytics with Alteryx | 1.5 | |
Spring | MARK 70210 | Analytics for Innovation | 1.5 |
MARK 70200 | Customer Relationship Marketing | 1.5 | |
MANA 70970 | People Analytics | 1.5 | |
ACCT 70970 | Business Processes and Risk | 1.5 | |
FINA 70523 | Financial Modeling | 3 | |
MARK 70110 | Marketing Analytics | 1.5 | |
INSC 70970 | Blockchain/Crypto | 1.5 | |
INSC 70970 | Web 3.0 | 1.5 | |
INSC 70970 | Robotic Proc Automation | 1.5 | |
INSC 70970 | Cybersecurity | 1.5 | |
INSC 70970 | Machine Learning for Business | 1.5 |
Supply Chain Management Students
MS Supply Chain students who entered summer 2022
This degree plan will be tailored to the need of each student through Advising with Dr. Cliff Defee
Up to 20% of this program may be fulfilled with courses that are not Supply Chain
2022 MS-Supply Chain Management - 16-Month | Semester Hours |
|
Required Courses |
INSC 60600 Supply Chain Concepts (1.5 hrs) 8W1 & 8W2 INSC 70150 Leading Supply Chains (1.5 hrs) 8W1 INSC 70793 Global Supply Chain Experience (3 hrs) Intercession INSC 70693 Integrative Field Study (3 hrs) REG |
9 |
Electives Courses |
Electives | 21 |
Supply Chain Elective Options
Year 1: Spring Semester | ||
INSC 70630 | Demand Forecasting Management | 1.5 hrs |
INSC 70650 | Strategic Sourcing and Procurement | 1.5 hrs |
Year 2: Fall Semester | ||
INSC 70620 | Supply Chain Information Tools and Tech. | 1.5 hrs |
INSC 70610 | Logistics and Transportation | 1.5 hrs |
INSC 70640 | Global Supply Chain Management | 1.5 hrs |
INSC 70639 | Integrative Field Study | 1.5 hrs |
INSC 70430 | Supply Chain Operations Management | 1.5 hrs |
Year 2: Spring Semester | ||
INSC 71003 | Project Management | 3 hrs |
INSC 70660 | Supply and Value Chain Strategy | 1.5 hrs |
INSC 71020 | Six Sigma Green Belt for Managers | 1.5 hrs |
AND 6 hours from the following: | ||
ACCT 70020 | Strategic Cost Analysis | 1.5 hrs |
MANA 70610 | Essentials of Negotiation | 1.5 hrs |
MAN 70760 | Transformational Leadership | 1.5 hrs |
MARK 70720 | New Product Development | 1.5 hrs |
MARK 70200 | Customer Relationship Marketing | 1.5 hrs |
TCU Neeley Graduate Programs provides our students interactive, hands-on Excel training presented by DFW Excel Experts. These sessions help students take their Excel skills to the next level, allowing you to understand the business context and connect the business need to a technology solution.
Excel Intermediate Part 1
Overview
This class is designed for people who have a basic knowledge of Excel, and who want to increase their knowledge of the practical uses of Excel. By the completion of this class, participants will have a thorough knowledge of using Excel to manage data in multiple sheets in an Excel workbook. Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions. After taking this class, we highly recommend taking the Excel Intermediate Part 2 class which is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas.
Class Outline
- Cell References
- Tables
- Range Names
- Functions Overview
- Date and Time Functions
- Statistical Functions
- Text Functions
- Logical Functions
- Lookup Functions
- Flash Fill
- Advanced Sorting and Advanced Filtering of Data
Excel Intermediate Part 2
Overview
This class is designed for people who have basic knowledge of Excel, and who want to improve the presentation of data in Excel. Excel provides many tools for analyzing data however it is often a challenge to present the data in a meaningful way for others to use. By the completion of this class participants will have a thorough knowledge of Excel data presentations tools including Data Validation, Conditional Formatting, Advanced Charts, PivotTables, and PivotCharts. This is the second half of our Excel Intermediate Class. The Excel Intermediate Part 1 is focused on managing your data through the use of a variety of Excel features and functions, while the Excel Intermediate Part 2 class is focused on presenting your data.
Prerequisites
Participants must have basic knowledge of entering data, formatting and simple formulas. Participants should be familiar with the topics covered in the Excel Intermediate Part 1 class.
Class Outline
- Data Validation
- Understanding Data Validation
- Data Validation Rule Setting
- Data Validation Tool Tips
- Data Validation Custom Error Messages
- Conditional Formatting
- Understanding Conditional Formatting
- Highlight Cell Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- Custom Rules
- Advanced Rules based on Formulas
- Creating a Schedule (Gantt chart) using Conditional Formatting
- Advanced Charts
- Waterfall Chart
- Histogram Chart
- Pareto Chart
- Box & Whisker Chart
- Treeman Chart
- Sunburst Chart
- Sparkline Cell Chart
- PivotTable Fundamentals
- Preparing the Data
- Anatomy of a PivotTable
- Slicing and Dicing with a PivotTable
- Grouping Data
- Sorting Data
- Custom PivotTable Field Names
- PivotTable Slicers
- PivotCache
- Refreshing Data
- PivotTable Calculations
- Customize Subtotals
- Showing Values as Calculations
- Calculated Fields
- Calculated Items
- PivotCharts
- Creating a PivotChart
- PivotChart Control Buttons
- PivotChart and PivotTable Filters
Supply Chain Certificate students who entered summer 2019
2019 Supply Chain Management - Certificate Program without Global Emphasis |
Semester Hours |
|
Required Courses |
INSC 60600 Supply Chain Concepts (1.5 hours) | 1.5 |
Electives Courses |
Supply Chain Electives | 7.5 |
2019 Supply Chain Management - Certificate Program with Global Emphasis |
Semester Hours |
|
Required Courses |
INSC 60600 Supply Chain Concepts (1.5 hours) INSC 70793 Global Supply Chain Experience (3 hours) |
4.5 |
Electives Courses |
Supply Chain Electives | 7.5 |
Click here to download the PDF