Curriculum

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.

Download Degree Plan

First Year: Fall Semester

8W1 Modules:
ACCT 60010 Financial Reporting
INSC 60010 Statistical Models 
MANA 60330 Engaging People 
FINA 60010 Financial Management I
BUSI 66100 Career Management & Professional Development

8W2 Modules:
MARK 60010 Marketing Management
INSC 60600 Supply Chain Concepts
BUSI 60050 Global Business
*FINA 70010  Financial Management II
**INSC 60050 Business Analytics

One Week Intensive:
BUSI 60070     Business Simulation

First Year: Spring Semester

8W1 Modules:
*MARK 70120 Customer Insight or MARK 70770 Marketing Research
*INSC 70430 Supply Chain Operations Management
INSC 60020 Managing Operations & Processes
FINA 60020 Managerial Economics 
Plus: 1.5 – 3 hours of electives

8W2 Modules:
ACCT 60020 Managerial Accounting
MANA 60340  Leading Teams and Organizations
Plus: 3 – 4.5 hours of electives

Second Year
19.5 – 22.5 hours of electives plus
MANA 60630 Strategic Management 8W1, Fall 
MANA 60460 Business Ethics, SW1, Fall
MANA 60230 Legal Environment of Business, 8W2, Fall

*Upper level courses that students should take if concentrating in Finance, Marketing or Supply Chain
 

Download Degree Plan

First Year: Fall Semester

8W1 Modules (Weeks 1-89):
ACCT 60010 Financial Reporting
INSC 60010 Statistical Models 
MANA 60330 Engaging People 
FINA 60010 Financial Management I
BUSI 66100 Career Management & Professional Development

8W2 Modules (Weeks 9-15):
MARK 60010 Marketing Management
INSC 60600 Supply Chain Concepts
BUSI 60050 Global Business
*FINA 70010  Financial Management II
**INSC 60050 Business Analytics

One Week Intensive (Week 16):
BUSI 60070     Business Simulation

First Year: Spring Semester

8W1 Modules:
*INSC 70430 Supply Chain Operations Management
INSC 60020 Managing Operations & Processes
FINA 60020 Managerial Economics 
Plus: 1.5 – 3 hours of electives

8W2 Modules:
ACCT 60020 Managerial Accounting
MANA 60340  Leading Teams and Organizations
Plus: 3 – 4.5 hours of electives

Second Year
19.5 – 22.5 hours of electives plus
MANA 60630 Strategic Management 8W1, Fall 
MANA 60460 Business Ethics, SW1, Fall
MANA 60230 Legal Environment of Business, 8W2, Fall

*Upper level courses that students should take if concentrating in Finance, Marketing or Supply Chain
**Students concentrating in Supply Chain are strongly encouraged to take INSC 60050

Download Degree Plan

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.

Download the Certificate Requirements

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:

* ACCT 70013 must be taken prior to ACCT 70153 unless the student has an accounting undergraduate degree or has taken an extensive number of accounting courses. If the student does not take ACCT 70013, then ACCT 70153 could be taken in the Spring Semester of Year 1 rather than in the Spring Semester of Year 2.

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:

AND 4.5 additional credits from any MBA or MAc elective (7.5 additional credits if the student does not take ACCT 70013).

Total elective credits = 30

* 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:

 
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:

AND 12 credits from any MBA or MAc elective

Total elective credits = 30

Download Concentration Options

FTMBA and PMBA students may elect to complete an industry-based emphasis. The five available emphasis areas are: Business Consulting, Entrepreneurship, Real Estate, 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)

Download Emphasis Options

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

1. Cell References
2. Tables
3. Range Names
4. Functions Overview
   • Date and Time Functions
   • Statistical Functions
   • Text Functions
   • Logical Functions
   • Lookup Functions
5. Flash Fill
6. 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

1. Data Validation
   • Understanding Data Validation
   • Data Validation Rule Setting
   • Data Validation Tool Tips
   • Data Validation Custom Error Messages
2. 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
3. Advanced Charts
   • Waterfall Chart
   • Histogram Chart
   • Pareto Chart
   • Box & Whisker Chart
   • Treeman Chart
   • Sunburst Chart
   • Sparkline Cell Chart
4. 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
5. PivotTable Calculations
   • Customize Subtotals
   • Showing Values as Calculations
   • Calculated Fields
   • Calculated Items
6. PivotCharts
   • Creating a PivotChart
   • PivotChart Control Buttons
   • PivotChart and PivotTable Filters

Download the Degree Plan

Download the Degree Plan

Download the Degree Plan

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:

* ACCT 70013 must be taken prior to ACCT 70153 unless the student has an accounting undergraduate degree or has taken an extensive number of accounting courses. If the student does not take ACCT 70013, then ACCT 70153 could be taken in the Spring Semester of Year 1 rather than in the Spring Semester of Year 2.

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:

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:

 
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:

AND 12 credits from any MBA or MAc elective

Total elective credits = 30

Download Concentration Options

FTMBA and PMBA students may elect to complete an industry-based emphasis. The five available emphasis areas are: Business Consulting, Entrepreneurship, Real Estate, 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)

Download Emphasis Options

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

1. Cell References
2. Tables
3. Range Names
4. Functions Overview
   • Date and Time Functions
   • Statistical Functions
   • Text Functions
   • Logical Functions
   • Lookup Functions
5. Flash Fill
6. 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

1. Data Validation
   • Understanding Data Validation
   • Data Validation Rule Setting
   • Data Validation Tool Tips
   • Data Validation Custom Error Messages
2. 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
3. Advanced Charts
   • Waterfall Chart
   • Histogram Chart
   • Pareto Chart
   • Box & Whisker Chart
   • Treeman Chart
   • Sunburst Chart
   • Sparkline Cell Chart
4. 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
5. PivotTable Calculations
   • Customize Subtotals
   • Showing Values as Calculations
   • Calculated Fields
   • Calculated Items
6. PivotCharts
   • Creating a PivotChart
   • PivotChart Control Buttons
   • PivotChart and PivotTable Filters

Professional MBA students who entered fall 2022

Download the Degree Plan

Professional MBA students who entered spring 2022

Download Degree Plan

Professional MBA students who entered spring 2021

Download Degree Plan

Professional MBA students who entered fall 2020

Download the Degree Plan

Professional MBA students who entered spring 2020

Download the Degree Plan

Professional MBA students who entered fall 2019

Download the Degree Plan

FTMBA and PMBA students may elect to complete an industry-based emphasis. The five available emphasis areas are: Business Consulting, Entrepreneurship, Real Estate, 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)

Download Emphasis Options

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

Download Specialization Options

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

1. Cell References
2. Tables
3. Range Names
4. Functions Overview
   • Date and Time Functions
   • Statistical Functions
   • Text Functions
   • Logical Functions
   • Lookup Functions
5. Flash Fill
6. 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

1. Data Validation
   • Understanding Data Validation
   • Data Validation Rule Setting
   • Data Validation Tool Tips
   • Data Validation Custom Error Messages
2. 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
3. Advanced Charts
   • Waterfall Chart
   • Histogram Chart
   • Pareto Chart
   • Box & Whisker Chart
   • Treeman Chart
   • Sunburst Chart
   • Sparkline Cell Chart
4. 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
5. PivotTable Calculations
   • Customize Subtotals
   • Showing Values as Calculations
   • Calculated Fields
   • Calculated Items
6. PivotCharts
   • Creating a PivotChart
   • PivotChart Control Buttons
   • PivotChart and PivotTable Filters

Accelerated PMBA students who entered summer 2022

 * 1.5 hours of electives need to be completed during an intersession or on an overload basis.

Download the Degree Plan

Accelerated PMBA students who entered spring 2022

Download the Degree Plan

Accelerated PMBA students who entered summer 2021

 * 1.5 hours of electives need to be completed during an intersession or on an overload basis.

Download the Degree Plan

Accelerated PMBA students who entered summer 2020

 * 1.5 hours of electives need to be completed during an intersession or on an overload basis.

Download the Degree Plan

Accelerated MBA students who entered summer 2019

 * 1.5 hours of electives need to be completed during an intersession or on an overload basis.

Download the Degree Plan

FTMBA and PMBA students may elect to complete an industry-based emphasis. The five available emphasis areas are: Business Consulting, Entrepreneurship, Real Estate, 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)

Download Emphasis Options

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

Download Specialization Options

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

1. Cell References
2. Tables
3. Range Names
4. Functions Overview
   • Date and Time Functions
   • Statistical Functions
   • Text Functions
   • Logical Functions
   • Lookup Functions
5. Flash Fill
6. 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

1. Data Validation
   • Understanding Data Validation
   • Data Validation Rule Setting
   • Data Validation Tool Tips
   • Data Validation Custom Error Messages
2. 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
3. Advanced Charts
   • Waterfall Chart
   • Histogram Chart
   • Pareto Chart
   • Box & Whisker Chart
   • Treeman Chart
   • Sunburst Chart
   • Sparkline Cell Chart
4. 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
5. PivotTable Calculations
   • Customize Subtotals
   • Showing Values as Calculations
   • Calculated Fields
   • Calculated Items
6. PivotCharts
   • Creating a PivotChart
   • PivotChart Control Buttons
   • PivotChart and PivotTable Filters

Energy MBA students who entered fall 2022

Energy Core Classes

download the PDF

Energy MBA students who entered fall 2021

download the PDF

Energy MBA students who entered fall 2020

download the PDF

Energy MBA students who entered summer 2019

download the PDF

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

Download Specialization Options

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

1. Cell References
2. Tables
3. Range Names
4. Functions Overview
   • Date and Time Functions
   • Statistical Functions
   • Text Functions
   • Logical Functions
   • Lookup Functions
5. Flash Fill
6. 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

1. Data Validation
   • Understanding Data Validation
   • Data Validation Rule Setting
   • Data Validation Tool Tips
   • Data Validation Custom Error Messages
2. 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
3. Advanced Charts
   • Waterfall Chart
   • Histogram Chart
   • Pareto Chart
   • Box & Whisker Chart
   • Treeman Chart
   • Sunburst Chart
   • Sparkline Cell Chart
4. 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
5. PivotTable Calculations
   • Customize Subtotals
   • Showing Values as Calculations
   • Calculated Fields
   • Calculated Items
6. PivotCharts
   • Creating a PivotChart
   • PivotChart Control Buttons
   • PivotChart and PivotTable Filters

Accelerated Energy MBA students who entered summer 2022

Energy Core Classes

download the PDF

Accelerated Energy MBA students who entered summer 2021

download the PDF

Accelerated Energy MBA students who entered summer 2020

download the PDF

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

Download Specialization Options

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

1. Cell References
2. Tables
3. Range Names
4. Functions Overview
   • Date and Time Functions
   • Statistical Functions
   • Text Functions
   • Logical Functions
   • Lookup Functions
5. Flash Fill
6. 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

1. Data Validation
   • Understanding Data Validation
   • Data Validation Rule Setting
   • Data Validation Tool Tips
   • Data Validation Custom Error Messages
2. 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
3. Advanced Charts
   • Waterfall Chart
   • Histogram Chart
   • Pareto Chart
   • Box & Whisker Chart
   • Treeman Chart
   • Sunburst Chart
   • Sparkline Cell Chart
4. 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
5. PivotTable Calculations
   • Customize Subtotals
   • Showing Values as Calculations
   • Calculated Fields
   • Calculated Items
6. PivotCharts
   • Creating a PivotChart
   • PivotChart Control Buttons
   • PivotChart and PivotTable Filters

Health Care MBA students who entered fall 2021

Click here to download the PDF

Health Care MBA students who entered fall 2020

Click here to download the PDF

Heath Care MBA students who entered summer 2019

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

1. Cell References
2. Tables
3. Range Names
4. Functions Overview
   • Date and Time Functions
   • Statistical Functions
   • Text Functions
   • Logical Functions
   • Lookup Functions
5. Flash Fill
6. 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

1. Data Validation
   • Understanding Data Validation
   • Data Validation Rule Setting
   • Data Validation Tool Tips
   • Data Validation Custom Error Messages
2. 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
3. Advanced Charts
   • Waterfall Chart
   • Histogram Chart
   • Pareto Chart
   • Box & Whisker Chart
   • Treeman Chart
   • Sunburst Chart
   • Sparkline Cell Chart
4. 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
5. PivotTable Calculations
   • Customize Subtotals
   • Showing Values as Calculations
   • Calculated Fields
   • Calculated Items
6. PivotCharts
   • Creating a PivotChart
   • PivotChart Control Buttons
   • PivotChart and PivotTable Filters

Accelerated Health Care MBA students who entered summer 2021

Click here to download the PDF

Accelerated Health Care MBA students who entered summer 2019

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

1. Cell References
2. Tables
3. Range Names
4. Functions Overview
   • Date and Time Functions
   • Statistical Functions
   • Text Functions
   • Logical Functions
   • Lookup Functions
5. Flash Fill
6. 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

1. Data Validation
   • Understanding Data Validation
   • Data Validation Rule Setting
   • Data Validation Tool Tips
   • Data Validation Custom Error Messages
2. 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
3. Advanced Charts
   • Waterfall Chart
   • Histogram Chart
   • Pareto Chart
   • Box & Whisker Chart
   • Treeman Chart
   • Sunburst Chart
   • Sparkline Cell Chart
4. 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
5. PivotTable Calculations
   • Customize Subtotals
   • Showing Values as Calculations
   • Calculated Fields
   • Calculated Items
6. PivotCharts
   • Creating a PivotChart
   • PivotChart Control Buttons
   • PivotChart and PivotTable Filters

Required 6 hours

Optional 3 hours

MANA 72423 U.S. Health Policy 3 hours with one-week domestic travel (intersession)

OR

download the PDF

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

Supply Chain Elective Options

download the PDF

MS Supply Chain students who entered summer 2019

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

1. Cell References
2. Tables
3. Range Names
4. Functions Overview
   • Date and Time Functions
   • Statistical Functions
   • Text Functions
   • Logical Functions
   • Lookup Functions
5. Flash Fill
6. 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

1. Data Validation
   • Understanding Data Validation
   • Data Validation Rule Setting
   • Data Validation Tool Tips
   • Data Validation Custom Error Messages
2. 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
3. Advanced Charts
   • Waterfall Chart
   • Histogram Chart
   • Pareto Chart
   • Box & Whisker Chart
   • Treeman Chart
   • Sunburst Chart
   • Sparkline Cell Chart
4. 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
5. PivotTable Calculations
   • Customize Subtotals
   • Showing Values as Calculations
   • Calculated Fields
   • Calculated Items
6. PivotCharts
   • Creating a PivotChart
   • PivotChart Control Buttons
   • PivotChart and PivotTable Filters

Supply Chain Certificate students who entered summer 2019

Click here to download the PDF