Cox School of Business

$400 Deposit. The deposit goes towards to the $2000 program fee.

$2,000 Program Fee

Guest Fee for the Dallas Immersion

$300 deposit. The deposit will go towards the program fee.

Wall Street Prep Spring 2024 Excel Workshop

Saturday, March 23rd, 2024

This seminar is designed for intermediate Excel users who would like to power-charge productivity in Excel by learning lesser-known but highly-effective functionality. By the end of the training, you'll have an entire new Excel skillset that you can use immediately on the job.

• Best Practices: intro to macros; basic setup including macro security, iterations & calculations; designing historical inputs & forecast financial projections; shortcuts, auditing formulas

• Formatting & Presentation: utilizing shortcuts & power keys, data validation to create scenario toggles, Incorporating INDEX, MATCH, CHOOSE functions, dynamic formatting.

• Data Analysis: building data tables & presentation best practices; pivot tables

• Large Data Sets: circular references; building Dashboards, error-proofing analysis; auditing across multiple sheets & files; finding & removing phantom links & unused names; handling too many formats in Excel, reducing file size; importing & cleaning of data from various sources, and more!

This amount is a deposit to secure a spot on the Maguire Energy Institute International Trip.
The full amount payment will be required by Nov 1st. If the payment of deposit is no longer possible, please email xtison@smu.edu to get on the waiting list.
If any question, please contact xtison@smu.edu or 214.903.5181