Excel Master Bootcamp- 4小时
介绍...
一个强烈的4小时训练营来帮助您
Become Efficient at Financial Modeling
Limited to 30 Seats
WHAT YOU’LL GET IN THIS VIRTUAL 4-HOUR BOOTCAMP
Get Taught by The Best
教和审查实际行业专业人士。了解关键的房地产建模理论和力学,并了解CRE策略的三种主要类型和结构性交易。课程内容将不断审查和更新。
最佳实践
学习你的东西应该并且不应该这样做在工作中,以确保您以最佳的方式在同事和高级团队成员面前展示自己和您的工作。我们go over common mistakes and errorsanalysts and associates make starting out and give tips to put yourself in a better light.
终身访问WSO的Excel建模课程
With超过100堂课,我们将您从Excel的初学者带到绝对主人,以帮助确保您建立适当的基础for the more advanced financial modeling courses later.
Master Excel Shortcuts
Learn how to save time and enhance productivity,建立高级团队成员的信任和稳定by demonstrating an excellent grasp of Excel. As an analyst or associate, you will "own" the model.
堵水Excel高手训练营——视频预览
涵盖了主题
- 介绍和课程概述
- Flow of the Course
- Setup For Mac Users
- 熟悉Excel
- 介绍
- Worksheet Navigation and Selection
- The Ribbon, Hotkeys, and the Formula Bar
- Worksheets, View/Zoom, and Navigating Menus
- Excel Shortcuts
- 介绍
- Windows快捷方式
- Familiar Shortcuts
- Ctrl vs. Alt
- 注释
- 右后
- 选择性粘贴
- Rows and Columns
- 分组和隐藏
- Common Hotkeys
- Quick Access Toolbar
- Office Hotkeys
- 介绍
- 格式化最佳实践
- Default Formats
- Custom Number Formatting
- 其他格式提示
- Conditional Formatting
- 介绍
- Show and Zoom
- Freeze Panes
- Split Panes and New Window
- 打印和页面布局
- 介绍
- 公式
- 错误
- Basic Math Functions
- 高级数学功能
- Anchoring
- More Math Functions
- 介绍
- Dates in Excel
- Useful Date Functions
- 时间计算
- &和文字
- Dynamic Text Example
- 介绍
- 如果和嵌套
- AND, OR, and XOR
- 比较操作员
- iferror
- Information Functions
- 适当,较低和上部
- LEFT, RIGHT, and MID
- Text to Columns
- SUBSTITUTE
- SEARCH
- 介绍
- VLOOKUP & HLOOKUP
- 索引 +匹配
- VLOOKUP vs INDEX + MATCH
- 数据验证
- Financial Functions Master
- 介绍
- Scenarios
- Data Tables
- Naming Cells
- Formula Auditing
- 介绍
- 数据概述
- 排序
- 过滤
- Pivot Tables
- Inserting and Adjusting Charts
- 选择数据和组合图表
- Other Chart Elements
- Data Labels
- Trendlines and Regression
我们的客户在所有顶级华尔街公司都有职位,包括:
获得独特的课程认证
After completing each course, all students will be granted a WSO Certification for that specific course. Use these certificates as a signal to employers that you have the technical skills to immediately add value to your team.
证明您已经在大学课程之外投入了工作,以使自己更加高效,并掌握在财务职业中取得成功的最关键计划。轻松分享LinkedIn和其他社交媒体网站,以突出您的技能并加强您作为候选人的个人资料。
你多少钱
财务职业价值?
你得到什么 |
价值 |
---|---|
WSO Excel Master Bootcamp 由精英金融专业人士教授的4个小时的现场教学... |
$997 |
WSO Excel Modeling Course 110+ video lessons across 13 Modules taught by a top-ranked bulge bracket investment banker... |
$97 |
总价值 |
$ 1,094 |
Get Unlimited Lifetime Access To The Excel Modeling Course And Attend the 4-Hour Excel Master Bootcamp For 72% Off
$ 1,094
$297
安全结帐
Frequently Asked Questions
顶级投资银行和私募股权基金的专业人士
- MBA学生和企业本科生
- 来源的风险投资分析师和同事
- 万博app网页版投资银行分析师和员工
- Incoming Real Estate Investment Analysts and Associates
- Incoming Private Equity Associates/Analysts
- 公司金融专业人士
- 教和审查actual industry professionals
- 课程内容不断审核和更新
- 提高财务建模效率
- Live-instruction conducted through Zoom
- 终身访问我们的Excel建模课程