Wall street prep – Excel Crash Course
Archive : Wall street prep – Excel Crash Course
For finance professionals, proficiency In Excel Is a elementary part of the job description. Whether you in the intervening time work In Excel at a beginner or Intermediate diploma, this course will take you to the following diploma and change you into a complicated “power” client. We’ll start with the basics sooner than we quickly introduce you to lesser recognized time-saving keyboard shortcuts and extremely efficient Excel capabilities and choices which you would immediately put to utilize on the job. The solely choice to check Excel is by doing, so that you just’ll be ending Excel exercise routines alongside the coach at every step of the best way by which.
Course Objective
We’ll start with the basics sooner than we quickly introduce you to lesser recognized time-saving keyboard shortcuts and extremely efficient Excel capabilities and choices which you would immediately put to utilize on the job. The solely choice to check Excel is by doing, so that you just’ll be ending Excel exercise routines every step of the best way by which
What You Will Learn
- Accelerate the internalization of the vital factor time-saving shortcuts by means of exercise-based internalization drills and video-driven guidance.
- Learn strategies to include and profit from the popular and helpful Excel capabilities and desk choices for financial analysis.
- Learn to quickly create macro-based shortcuts.
- Build data tables and perform sensitivity analysis.
- Enhance the presentation of financial and valuation fashions by together with varieties and toggles to your spreadsheets.
Wall Street Prep’s Excel Crash Course is used at prime financial institutions and enterprise schools.
Full Course Agenda
Basic Excel Shortcuts, Navigation & Editing open
- The Excel Ribbon & Settings
- Formatting in Excel
- Navigation Within Excel
- Entering and Editing Data in Excel
- Paste Special
- Ctrl and Alt Shortcuts
- Naming Cells and Ranges
- Anchoring Cells
- Naming Worksheets
- Grouping & Hiding Columns & Rows
- Grouping Workbooks
- Formula Auditing
- Logical, Date & Concatenation Functions
- SUM & Average
- #Ref, #Div/0! & Other Excel Errors
- Simple & Nested IF Statements
- IFERROR & Concatenation
- Date Functions EOMONTH & EDATE
- ISNUMBER, ISTEXT & Combining with IF to Create Overrides
- More Date Functions YEARFRAC, DAY, MONTH, YEAR & DATE
- AND & OR Functions
Get Wall street prep – Excel Crash Course on #
Lookup Functions & Data Tables
- ·Combining INDIRECT with &
- HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX Functions
- Common Errors with HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX
- The MATCH Function
- Combining H/VLOOKUP, OFFSET, INDEX, CHOOSE with MATCH
- Creating Drop Down Menus with Data Validation
- Combining INDIRECT with MATCH
- Using COLUMN and ROW Functions as Counters in Complex Formulas
- Data Tables
Math capabilities
- The SUMPRODUCT Function
- Advanced SUMPRODUCT: Adding Criteria & Booleans in Excel
- SUMIF/S & AVERAGEIF/S
- CEILING, FLOOR & ABS Functions
- ROUND, ROUNDUP, ROUNDDOWN & COMBIN Function
- The MIN & MAX Functions
- COUNT/A & COUNTIF/S Functions
- Present Value & Future Value Functions
- NPV & XNPV Functions
- IRR & XIRR Functions
Text Functions
- ·Text Functions (LEN, LEFT, RIGHT, MID, REPLACE, and so forth.)
- Using Text Functions to Solve Data Extraction Challenges
- Flash Fill (Excel 2013 Only)
- Cell Alignment & Center Across Selection
Sorting, Filters, and Pivot Tables
- Sort & Subtotal
- Autofilter
- Pivot Tables
- VBA, Recording Macros & Custom Formatting · Recording Macros in Excel
- Conditional Formatting
- Go To Special
- Creating Dynamic Headers, Custom Formatting & the TEXT Function
Get Wall street prep – Excel Crash Course on #
Wall street prep – Excel Crash Course Download, Excel Crash Course Download, Excel Crash Course Groupbuy, Excel Crash Course Free, Excel Crash Course Torrent, Excel Crash Course Course Download, Wall street prep – Excel Crash Course Review, Excel Crash Course Review