Results for “ExcelHelpWM” · 2010

Importing CSV Files into Excel

This is a tutorial on how to import CSV files into excel. I recommend using the "text import wizard" because it lets you work with ...

From: ExcelHelpWM

Added: 16 years ago

Views: 198,198

Topic 5 (Part 2 of 2) Corporate Yields: Using Two Way Tables

From: ExcelHelpWM

Added: 16 years ago

Views: 217

Drop down if then and conditional formatting

From: ExcelHelpWM

Added: 16 years ago

Views: 10,190

Topic 1 Part 1 of 2 Bond Basics

This video steps through 3 different ways to price a bond using excel.

From: ExcelHelpWM

Added: 16 years ago

Views: 1,801

Topic 3 Duration

Here we examine Topic 3 on Duration by working through a few ways to calculate duration in excel.

From: ExcelHelpWM

Added: 16 years ago

Views: 4,646

Topic 5 (Part 1 of 2) Corporate Yields: Using Pivot Tables

From: ExcelHelpWM

Added: 16 years ago

Views: 395

Topic 2 (Part 2 of 2) Measuring Yields using Scenario Manager

From: ExcelHelpWM

Added: 16 years ago

Views: 384

Topic 2 (Part 1 of 2) Measuring Yields using Solver

From: ExcelHelpWM

Added: 16 years ago

Views: 3,231

Topic 1 Part 2 of 2 Bond Basics

This video looks at the various ways to sort through data with excel 2007. We look at pivot tables and sort/filter tools.

From: ExcelHelpWM

Added: 16 years ago

Views: 415

Topic 4 Term Structure of IR Regression Analysis

From: ExcelHelpWM

Added: 16 years ago

Views: 481

Naming Cells in Excel 2007

This is a video tutorial on how to name cells, name regions/fields, and the name manager. Naming cells is an important part of ...

From: ExcelHelpWM

Added: 16 years ago

Views: 3,497

Importing data into excel TXT versus CSV

This tutorial summarizes the 3 different ways to import data into excel: Paste - You should almost never "paste" data into excel ...

From: ExcelHelpWM

Added: 16 years ago

Views: 5,860

Using Paste Special outside of Excel

Paste Special is a great tool when you want to copy and paste a formatted table from Excel into Word without losing any ...

From: ExcelHelpWM

Added: 16 years ago

Views: 939

Recording Macros

This video shows you how to record macros. Macros are small programs that you can easily code into Excel to execute repetitive ...

From: ExcelHelpWM

Added: 16 years ago

Views: 446