## Excel for MBA Students

This course was developed for MBAs in response to the need for Excel functions that would typically be used throughout an MBA program. This course is a series of digitized videos where the instructor reviews each function. The student will also be given a spreadsheet that is used to follow along and practice each function after viewing it on screen. After completing each section, the student completes a quiz along with a comprehensive module final exam. The module is divided into 4 sections: Basics, Manipulating Data, Analyzing Data and Statistics. Functions in this course include:

## Basics

• Add or delete a column
• Add or delete a row
• Copy
• Formatting a cell
• Formatting numbers
• Formulas – letter
• Formulas parentheses
• Locking a cell
• Paste
• Paste special
• Selecting a range

• Average
• Charting
• COUNT
• COUNTA
• COUNTIF
• COUNTIES
• Max
• Min
• Printing
• Sort Data
• SUM
• SUMIF
• SUMIFS

## Analyzing Data

• Data tables
• Goal seek
• Hardcoding numbers
• Multiple regression
• Pivot tables
• Solver

## Statistics

• AND Function
• Binomial Distribution
• IF
• IRR
• LINEST
• MEDIAN
• Normal distribution
• NPV
• Standard deviation
• Trend
• Variance

Register during daytime hours and take the course on your schedule.

GBP Foundation Course: Excel for MBA Students

Registration Fee: \$150.00