Installation instructions for the Windows versions of Excel can be found here. What Is An Excel Add-in? An add-in file is an Excel file that contains macros (code) and has the extension “.xla” or “.xlam”.

A step-by-step guide to prepare Excel to analyze stock portfolios. • Why a Spreadsheet? - Discuss Excel for data analysis, including advantages and disadvantages of spreadsheets. • Versions of Excel - Review Excel setup and discuss appropriate versions. • Add-Ins - Install the Data Analysis ToolPak and Solver Add-In. • Data set - Download a free sample data set. • Why not Programming?

- Touch on what happens beyond the spreadsheet. • Next: Return calculations - Learn the three methods for calculating return. By, CFA, March 25, 2018. Install Excel Data Analysis ToolPak and Solver Add-In (17:27) Videos are available at one organized on YouTube (opens in a new browser window). Video Script Welcome. Today's goal is to set up our Excel system and cover other helpful topics related to using a spreadsheet for data analysis. I'm Paul, and I get frustrated by how long it takes to get systems ready before you can get to the fun part, analyzing data.

So here we will walk through the considerations for different operating systems and Excel versions, going step-by-step, to save you time. If this is your first time with us, this tutorial sits within a series of 30 financial modeling tutorials, called Quant 101. The way it works is I ask you to duplicate all of these models on your system as a way to learn fairly advanced Excel skills and to learn about modeling stocks. So if you are sticking around for that, I will also cover how to download and import a free data set used throughout the series. For those watching the video on YouTube, if you want to slow all of this down and see the instructions in print, everything I say here is duplicated on a web page. The first link in the video's Description section goes straight to it.

Overview Let's start with an overview. First, we will run through advantages and disadvantages of spreadsheets for financial modeling. Second, we review my setup and cover appropriate versions of our spreadsheet of choice, Excel, for Windows and Mac users.

Third, we will install the Data Analysis ToolPak for statistical analysis and the Solver Add-in for optimization. Fourth, we cover the one dataset we use throughout the playlist and how to freely download it so you can get started right away. Fifth, I'll quickly discuss what institutional investors use instead of spreadsheets, meaning statistical programming software and their advantages and disadvantages.

And in our next episode we will review the three methods for calculating returns on stocks. Step 1 - Why a Spreadsheet? Download microsoft excel for mac. Before we get started with the technical part, let's take a moment to cover the advantages and disadvantages of spreadsheets which will help us later in our discussion of comparisons with the programming world.

Remember, not all the DVD drives support M-Disc. External cd burner for mac best buy. All the other DVD drive has slots in them where you can enter the Disc, kind of like a SIM Card Slot. But this DVD Drive has a Disc Tray where you can put the Disc, and then press the button on the Drive to insert the Disc in the Drive. Slim External Drive by Asus This DVD drive is a bit different that the others mentioned here.

Advantages of Spreadsheets First, for advantages, spreadsheets are: • Pervasive - They are cheap or free and many people in Finance have already memorized many of the functions. • Easy to learn - The grid and cell format, with columns named with letters, and rows named with numbers, make it easy to draw relationships and make quick calculations, even on modestly large data sets, without having to learn programming. • Easy to visualize - The ability to visualize and customize tables, charts, and fonts make spreadsheets a viable tool for creating presentations. After all, there is a comfort level with being able to see, touch and edit the data. • Built-in functionality - Most beginner and intermediate-level financial and statistical operations can be performed in a spreadsheet.

In later tutorials you will see how conditional logic can be written in cells. Also Visual Basic for Applications, or VBA, can be programmed to automate common tasks.

It is also easy to update cells in a spreadsheet live, like security prices with links to financial data providers. Disadvantages of Spreadsheets Now, for the disadvantages, spreadsheets are: • Error prone - By many estimates, as many as 80% of all spreadsheets contain errors. Adding rows and columns can invalidate cell references, requiring significant modifications. On top of this, many firms do not train users of spreadsheets even when mission-critical functions reside in their work. • Rarely Audited - Auditing spreadsheets is difficult. The cell-by-cell structure requires a review of each cell to be 100% certain of accuracy. Many large financial organizations build elaborate spreadsheets because the users do not have traditional programming expertise.