Wall street prep – Excel Crash Course

Salepage link: At HERE. Archive: Total sizes: – include:  Wall street prep – Excel Crash CourseGet Wall street prep – Excel Crash Course at the CourseAvaiFor finance professionals, proficiency In Excel Is a fundamental part of the job description. Whether you currently work In Excel at a beginner or Intermediate level, this course will take you to the next level and turn you into an advanced “power” user.We’ll start with the basics before we quickly introduce you to lesser known time-saving keyboard shortcuts and powerful Excel functions and features that you can immediately put to use on the job. The only way to learn Excel is by doing, so you’ll be completing Excel exercises alongside the instructor at every step of the way.Course ObjectiveWe’ll start with the basics before we quickly introduce you to lesser known time-saving keyboard shortcuts and powerful Excel functions and features that you can immediately put to use on the job. The only way to learn Excel is by doing, so you’ll be completing Excel exercises every step of the wayWhat You Will LearnAccelerate the internalization of the key time-saving shortcuts via exercise-based internalization drills and video-driven guidance.Learn how to incorporate and take advantage of the most popular and helpful Excel functions and table features for financial analysis.Learn to quickly create macro-based shortcuts.Build data tables and perform sensitivity analysis.Enhance the presentation of financial and valuation models by adding forms and toggles to your spreadsheets.Wall Street Prep’s Excel Crash Course is used at top financial institutions and business schools.Full Course AgendaBasic Excel Shortcuts, Navigation & Editing openThe Excel Ribbon & SettingsFormatting in ExcelNavigation Within ExcelEntering and Editing Data in ExcelPaste SpecialCtrl and Alt ShortcutsNaming Cells and RangesAnchoring CellsNaming WorksheetsGrouping & Hiding Columns & RowsGrouping WorkbooksFormula AuditingLogical, Date & Concatenation FunctionsSUM & Average#Ref, #Div/0! & Other Excel ErrorsSimple & Nested IF StatementsIFERROR & ConcatenationDate Functions EOMONTH & EDATEISNUMBER, ISTEXT & Combining with IF to Create OverridesMore Date Functions  YEARFRAC, DAY, MONTH, YEAR & DATEAND & OR FunctionsGet Wall street prep – Excel Crash Course at the CourseAvaiLookup Functions & Data Tables·Combining INDIRECT with &HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEX FunctionsCommon Errors with HLOOKUP, VLOOKUP, CHOOSE, OFFSET & INDEXThe MATCH FunctionCombining H/VLOOKUP, OFFSET, INDEX, CHOOSE with MATCHCreating Drop Down Menus with Data ValidationCombining INDIRECT with MATCHUsing COLUMN and ROW Functions as Counters in Complex FormulasData TablesMath functionsThe SUMPRODUCT FunctionAdvanced SUMPRODUCT:  Adding Criteria & Booleans in ExcelSUMIF/S & AVERAGEIF/SCEILING, FLOOR & ABS FunctionsROUND, ROUNDUP, ROUNDDOWN & COMBIN FunctionThe MIN & MAX FunctionsCOUNT/A & COUNTIF/S FunctionsPresent Value & Future Value FunctionsNPV & XNPV FunctionsIRR & XIRR FunctionsText Functions·Text Functions (LEN, LEFT, RIGHT, MID, REPLACE, etc.)Using Text Functions to Solve Data Extraction ChallengesFlash Fill (Excel 2013 Only)Cell Alignment & Center Across SelectionSorting, Filters, and Pivot TablesSort & SubtotalAutofilterPivot TablesVBA, Recording Macros & Custom Formatting ·  Recording Macros in ExcelConditional FormattingGo To SpecialCreating Dynamic Headers, Custom Formatting & the TEXT FunctionGet Wall street prep – Excel Crash Course at the CourseAvaiSale Page