DESKBRIGHT
  • SQL
    • Products
    • SQL practice pack
    • Free interview prep
    • Practice SQL interviews Popular
    • Articles
    • SQL interview questions
    • Interview questions on SQL JOINs
    • MySQL interview questions
  • Excel
    • Products
    • Ultimate Excel Book
    • Spreadsheet design course Popular
    • Advanced functions course Popular
    • Excel Mastery Certification Certification
    • View all products...
    • Articles
    • Excel interview questions
    • Getting started
    • Excel function basics
    • Mathematical functions
    • Dates and times
    • String functions
    • Lookup functions
    • Logical functions
    • Charts and graphs
    • PivotTables
    • Advanced formatting
    • Reference
    • Blog
  • Uber analytics test
    • Products
    • Uber testing guide
    • Uber practice test Popular
    • Articles
    • Uber analytics test info
  • About
  • Log in

You've reached the end of your
Advanced Spreadsheet Design course free trial

Whoa, there! You've reached the end of your Advanced Spreadsheet Design course free trial. Thanks so much for trying it out. We hope you enjoyed your free lessons!

If you've enjoyed learning with Deskbright, why not upgrade to the full Advanced Spreadsheet Design course? When you upgrade, you'll unlock all 23 lessons for unlimited viewing.

Upgrade today for $49

Or, view more information on this course

Advanced Spreadsheet Design

    Table of contents Introduction 1
    Introduction
    Prerequisites 5
    Overview of prerequisites Using Tables Cell references INDEX MATCH SUMIF
    What is a model? 3
    Terminology What is a 'model'? Why flexibility is important
    Structuring the spreadsheet 3
    Outputs and inputs Spreadsheet diagrams Diagramming exercise
    Creating the spreadsheet 6
    Wireframing Wireframing exercise Data cleaning Formatting exercise Wiring the sheet Wiring exercise
    Adjustments and analysis 4
    Goal seek Goalseek exercise Sensitivity analysis Sensitivity exercise
    Conclusion 1
    Conclusion
Copyright © - Terms of Service - Privacy Policy