Topic 1

Introduction to Excel and Spreadsheet Software

Header Content Region

Insert text, image or banner ads here, or just delete this text and leave this area blank!

Spreadsheet1 Spreadsheet2 Spreadsheet3 Spreadsheet4

Heading 1

This is an example of the content for a specific image in the Nivo slider. Provide a short description of the image here....

Heading 2

This is an example of the content for a specific image in the Nivo slider. Provide a short description of the image here....

Heading 3

This is an example of the content for a specific image in the Nivo slider. Provide a short description of the image here....

Heading 4

This is an example of the content for a specific image in the Nivo slider. Provide a short description of the image here....

small spreadsheet1 small spreadsheet2 small spreadsheet3 small spreadsheet4
Financial Analysis and Modelling with Microsoft Excel
get in touch

Topic 1: Introduction to Excel and Spreadsheet Software

This topic follows Chapter 1 in your textbook, but includes substantial additional content.

 

Tutorial videos:

01-01 A Brief History of Spreadsheets

01-02 Getting to Know Excel

01-03 Set Up Example - Experiment With Formats

01-04 Simple Formulas - Relative and Absolute Cell References

01-05 Naming Cells and Ranges

01-06 Introducing Functions

01-07 Understanding GEOMEAN

01-08 Charts and Print Setup

(These videos are also available on YouTube with optional captions at this link.)

Supporting materials for this topic:

Topic 1 Setup (download this Excel file to follow along with the tutorials)

The videos refer to Exhibit 1-1 in the textbook, but use the ones from the 6th edition rather that the 7th. The one that is used in the videos is:

Table 1-2 is also used for the net income. That table is here:

The completed Topic 1 Setup worksheet is here

Chapter Problems:

Do Problems 1, 2, and 3 at the end of Chapter 1 in your textbook.

My solutions for these problems for the 8th edition are here.

My solutions for these problems for the 7th edition are here.

The authors' solutions (mine look better) for the 7th edition are here.

My solutions for the 6th edition are here.

The problems are really the same in both editions, but the 7th edition updates the years and data to 2013 and uses different companies for Problem 2 and Problem 3. All of the operation are identical in both editions.

 

slide up button