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!
Fields with asterisk are required.