Learn

Civil Engineering Projects

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.

Financial Modeling in Excel Using Scenario Manager to Model Loan Calculations

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 »

Financial Modeling in Excel Applying Scenarios to Your Financial Model

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 »

Financial Modeling in Excel Being Aware of Advanced Functions and Functionality

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 »

Financial Modeling in Excel VLOOKUP and HLOOKUP

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 »

Financial Modeling in Excel Getting Familiar with the Most Important Functions

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 »

Financial Modeling in Excel Using Shortcuts

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 »

Share knowledge