Projects that involve both the construction or renovation of a structure or an alteration of part of the environment are considered part of civil engineering.
5 major civil engineering projects:
Water engineering.
Construction and management engineering.
Structural engineering.
Geotechnical engineering.
Transport engineering.
Charting and Presenting Model Output he final stage of the model building process is to present the outcome of the model. You’ve spent a lot of time on the calculations, making sure that the inputs and assumptions are correct and that all your scenarios are lined up ready for the decision makers to use. If […]
Charting and Presenting Model Output Read More »
Using Scenario Manager to Model Loan Calculations Scenario Manager is grouped together with Goal Seek and Data Tables in the What-If Analysis section of the Data tab. Being grouped with other tools that are so useful would lead you to believe that Scenario Manager is also a critical tool to know. However, despite its useful-sounding
Financial Modeling in Excel Using Scenario Manager to Model Loan Calculations Read More »
Applying Scenarios to Your Financial Model ne of the things that makes a financial model a financial model and not a spreadsheet is that it contains hypothetical outcomes or scenarios. When your model has been built properly, using links with data only entered once (see Chapter 4), adding scenarios to your model is a fairly
Financial Modeling in Excel Applying Scenarios to Your Financial Model Read More »
Being Aware of Advanced Functions and Functionality In this chapter, I cover the functions that are most commonly used in financial modeling. If you master this handful of functions, you’ll be able to get started with building and using financial models. As your skills progress, however, you may find that you’re trying to do something
Financial Modeling in Excel Being Aware of Advanced Functions and Functionality Read More »
VLOOKUP and HLOOKUP The lookup functions — VLOOKUP and HLOOKUP — are very often used in build- ing financial models and are often the “go to” function for many modelers and analysts. FIGURE 7-28: The completed sales total table. Despite its popularity, the humble VLOOKUP is often misused and overused because many users — especially
Financial Modeling in Excel VLOOKUP and HLOOKUP Read More »
Getting Familiar with the Most Important Functions You’ve arrived at the meaty part of the chapter. This is where things get interest- ing! In this section, I fill you in on all the functions you’ll rely on most often and give you some examples of how and why to use them. SUM As its name
Financial Modeling in Excel Getting Familiar with the Most Important Functions Read More »
Using Functions in Excel he power of Microsoft Excel lies in its ability to do math for you. (Shh! Don’t tell your high school algebra teacher!) Of course, in order for Excel to work its magic, you need to be able to tell it what you need. And you do that by using formulas and
Financial Modeling in Excel Using Functions in Excel Read More »
Restricting and Validating Data After you finish building a financial model, you may be tempted to keep it to your- self, because you don’t want anyone to mess up your formulas or use the model inappropriately. Models should be collaborative, but you need to build your model in such a way that it’s easy for
Financial Modeling in Excel Restricting and Validating Data Read More »
Using Shortcuts If you’re spending a lot of time modeling in Excel, you can save yourself a lot of time by learning some keyboard shortcuts. For example, when copying and past- ing a cell, you could follow this process: CHAMPIONSHIP MODELING Speed and accuracy in fi modeling are critical. Skilled financial modelers are highly adept at
Financial Modeling in Excel Using Shortcuts Read More »
