Sold out
This bundle includes the following courses:
- Excel Best Practices for PC: Become an Excel Expert
- Applied Excel: Working with Data Sets and Scenario Analysis
10 hours of video content.
Estimated 20 hours to complete.
PREREQUISITES
This course is open to all. To maximize the benefit of this course we recommend an understanding of financial statements and Microsoft Excel.
Excel Best Practices for PC: Become an Excel Expert
Overview
- Basic Excel setup including iterations & calculations settings
- Excel best practices, including common “shortcut” keys and other efficiency tips
- Best practices for building formulas (auto sum, filling, anchoring)
- Customizing toolbars in Excel (including adding icons to your toolbar)
- Auditing formulas and cell references
By utilizing both basic and advanced Excel tools, this course is designed to dramatically improve a participant’s ability to use Excel efficiently. Whether you’re an investment banker, consultant, accountant, or specialist in healthcare, technology or industrials, this class offers the broadest, most valuable Excel skill set of any of course we offer.
A course for
- The financial services industry (investment banking, consulting, research, asset management, brokerage, sales & trading, insurance, private equity, venture capital, entrepreneurship and start-ups)
- Corporate/strategic development or finance group of a corporation
- Marketing, brand management or operations for a corporation or any position responsible for a product or divisional budget, projections and profit/loss statement
- Enhancing their learning in finance and financial statement analysis classes
- Non-finance roles, but interested in gaining a solid foundation in applied corporate finance
- Optimized for PC based Excel
TOPICS COVERED
Complete topics step by step or jump to any of the below at any time.
- Basic Excel setup – macro security, iterations, calculations settings
- Financial modeling essentials – appropriate color schemes, page setup, and customizing toolbars in Excel
- Common shortcut keys and other efficiency tips
- Understanding how to efficiently design historical inputs and forecast financial projections
Applied Excel: Working with Data Sets and Scenario Analysis
OVERVIEW
- Working with Client Data
- Analyzing Data in Excel
- Scenario Analysis
- Macros and User-Friendly Tools
- Pivot Tables
- Data Tables
- Enhancing Model Integrity
- Introduction to VBA & Macros
- Array Formulas
Through practical examples and annotated Excel guides, the course will improve the participant’s ability to use Excel efficiently to parse a large data set and interpret the results. By utilizing both basic and advanced Excel tools, students can dramatically improve their efficiency in data organization, allowing them to spend more time interpreting and sensitizing the data
KEY FEATURES
- Estimated time to complete is 10-15 hours
- Over 6 hours of video based instruction
- Course materials include videos and hands-on Excel exercises.
- Optimized for PC based Excel
- The Excel shortcuts in this course are not optimized for Mac versions of Excel, but this will not detract substantially from the course experience
TOPICS COVERED
Complete topics step by step or jump to any of the below at any time.
- Organization of data: (text to columns, RIGHT, LEFT, UPPER, LOWER, CONCATENATE, etc.)
- Lookup functions (VLookup, HLookup, MATCH)
- Pivot Tables
- Scenario analysis (CHOOSE, OFFSET)
- Introduction to macros and other format controls
- Creations of basic print macros
- Editing of basic VBA code
- Drop-down menus (combo boxes)
- Data validation and creation of dynamic text
- Sensitivity analysis using data tables
Group Orders
We offer discounts for group orders on our self-study products. Group orders are an attractive option for companies or teams looking to upskill together.
Contact us at selfstudy@trainingthestreet.com to learn more about how to save money on group orders.
Browse Our Other Course Bundles Below:
Sold out
Sold out
Sold out
Sold out
Gain your recognition with our digital certificates
Training The Street has been teaching the biggest finance firms for over 20 years. To help unlock your career potential, we offer certificates to provide the recognition you deserve.
After you finish your course, you will receive a certificate which can be easily added to your LinkedIn profile.