Cademy logoCademy Marketplace

Course Images

Encyclopedia of FAST Modelling

Encyclopedia of FAST Modelling

By F1F9 Academy

4.9(11)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 1 hour

  • All levels

course Content

8 sections•93 lessons
from Adding and deleting worksheet to Borders (6 modules) 6 lessons
  1. 1Adding and deleting worksheets
  2. 2Amending the goal seek macro
  3. 3Analysis toolpak
  4. 4Basic worksheet navigation
  5. 5Blank worksheet
  6. 6Borders
from Calculation Blocks to Counterflows (18 modules)18 lessons
  1. 1Calculation blocks
  2. 2Calculation construction
  3. 3Calculation construction - constants
  4. 4Calculation construction - constants in a data series
  5. 5Calculation construction - trivial calculations
  6. 6Calculation modes
  7. 7Cascading calculations
  8. 82D calculation blocks
  9. 9Checks and alerts
  10. 10Circuit breakers
  11. 11Conceptual modelling
  12. 12Constants
  13. 13Copying across / rule of thumb
  14. 14Copy paste techniques
  15. 15Copy vs Link
  16. 16Copying and pasting temp sheet
  17. 17Corkscrews
  18. 18Counterflows
from Data Picks to Escalation Sheet (11 modules)11 lessons
  1. 1Data picks
  2. 2Data validation
  3. 3Date functions
  4. 4Day counts
  5. 5Dashboard worksheet
  6. 6Deleting rows and content
  7. 7Edit directly in cell
  8. 8Editing a formula
  9. 9Editing VBA code
  10. 10Embedded constants
  11. 11Escalation sheet
from F1F9 macros to Hiding Columns (9 modules)9 lessons
  1. 1F1F9 additional keyboard shortcuts
  2. 2Find and replace
  3. 3Flags
  4. 4Forex rates
  5. 5Formatting numbers
  6. 6Goal seek
  7. 7Group mode
  8. 8Headers, sub headers and sub sub headers
  9. 9Hiding columns
from Import / Export to Move selection after enter (12 modules)12 lessons
  1. 1Import / export
  2. 2Inserting rows and columns
  3. 3Inspecting a macro
  4. 4Intra sectional links
  5. 5IRR XIRR
  6. 6ISNA
  7. 7Keyboard shortcuts and the mouse
  8. 8Look back
  9. 9Macro security and developer tab
  10. 10Managing data sets with Excel defined names
  11. 11MIN MAX
  12. 12Move selection after enter
from Name Ranges in Macros to Running a macro using button (14 modules)14 lessons
  1. 1Name ranges in macros
  2. 2NPV XNPV
  3. 3Offsheet references and Excel defined names
  4. 4Placeholders
  5. 5Precedents and dependents
  6. 6Pyramid structure
  7. 7Quick charts
  8. 8Ratios
  9. 9Reducing worksheet clutter
  10. 10Reviewing a FAST model
  11. 11Row anchored links
  12. 12Row totals
  13. 13Running a goal seek macro
  14. 14Running a macro using buttons
from Scenario Selection to SUMIFS (10 modules)10 lessons
  1. 1Scenario selection (nested IF and CHOOSE)
  2. 2Scenario selection (OFFSET)
  3. 3Scenario selection (INDEX)
  4. 4Selecting, adding and deleting content
  5. 5Sign conventions
  6. 6Sign switch
  7. 7Spaces in formulae
  8. 8SUM
  9. 9SUMPRODUCT
  10. 10SUMIFS
from Two Views of the same Workbook to Writing a Good Label (11 modules)13 lessons
  1. 1Two views of same workbook
  2. 2Template worksheet
  3. 3Template model
  4. 4Time ruler - part 1
  5. 5Time ruler - part 2
  6. 6Using the Alt key
  7. 7Using the function keys
  8. 8Visual basic editor
  9. 9Windows explorer settings
  10. 10Worksheet column design
  11. 11Writing a good label
  12. 12Encyclopedia - How did you get on?
  13. 13Encyclopedia of FAST course feedback

About The Provider

F1F9 Academy

Expert & Certified Financial Modelling courses for best-in-class modelling

Read more about F1F9 Academy

Reviews

+ Add Review