Skip to content

Excel Skills for GBS

Search
  • Home

Monthly Archives: July 2022

Sensitivity Table Calculations

July 7, 2022 jrummel

Use Named Ranges to build a table of results for the possible answers to the problem.

Sensitivity analysis with Goal Seek

July 7, 2022 jrummel

Explore what would happen for the other answers to the problem.

Now convert to the required square miles measure

July 7, 2022 jrummel

For the whole population, the result needs to be in square miles, and here we find the answer to the question.

Initial calculations in square feet

July 7, 2022 jrummel

At the person level, the most convenient unit of measure is feet, so we start there

Assumptions for model

July 7, 2022 jrummel

First we put the assumption for the model in cells at the top of the sheet, rather than inserting those assumption into the middle of formulas.

Introduction to Basic Modeling Problem

July 7, 2022 jrummel

The problem to model is shown here

Here is a video describing the problem

Content Areas

  • Home
    • General Layout of Excel
    • Excel Menus
    • Navigating in a Workbook
    • Working with Cells
    • Getting Data into Excel
    • Graphs
    • Useful Excel Functions
      • Logical Functions
      • Text Functions
      • Date And Time Functions
      • Lookup Functions
      • Mathematical Functions
      • Statistical Functions
    • Basic Excel Modeling
    • Advanced Excel Modeling
    • Modeling for Multiple Decisions
    • Additional Software for Excel
    • Macros

Categories

  • Uncategorized

Recent Posts

  • Random numbers in Excel
  • Sums of cells
  • Mathematical functions
  • Rounding numbers
  • Sensitivity Table Calculations

Archives

  • November 2022
  • July 2022
  • June 2022
  • August 2021
  • July 2021
  • June 2021
  • April 2021

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Proudly powered by WordPress