When you bring data from another source into an Excel worksheet, the data often includes rows that you’ll want to delete. Here's the second of two methods.

How to Delete Blank or Unneeded Rows, Method 2

Shortcuts Charley Kyd - 0
Data copied from a web site or imported from a variety of sources often include irrelevant rows of data. For example, the only way to...
How to Work with Dates Before 1900 in Excel

How to Work with Dates Before 1900 in Excel

Dates and Times Charley Kyd - 0
(Download the workbook.) If you work with dates prior to the year 1900, Excel's standard date-handling system will be no help. However, there are several...
Both IPMT and ISPMT return the interest payment for a given period for a loan or investment. But Microsoft's help topics haven't made their differences clear. Here's what you need to know about these two financial functions.

How to Create Even-Payment and Straight-Line Amortization Tables in Excel

Business & Economics Charley Kyd - 0
When you borrow money for a fixed period with periodic payments, you could have two types of loans: even-payment or straight-line. Microsoft recognizes those loan...
Excel's XY (or "scatter") charts provide amazing power. This introduction to XY charts offers a fun way to learn more about this powerful chart type.

Fun with XY (Scatter) Charts in Excel

Charting Methods Charley Kyd - 0
Because I’d been working hard on a project for many months, I once decided to take a break and play around with XY charts…which...
These keyboard shortcuts will help you to things in Excel that are difficult or time-consuming to do any other way.

Five Really Useful Excel Keyboard Shortcuts

Shortcuts Charley Kyd - 0
Most Excel users use some of Excel's shortcuts frequently, like F9, Ctrl + C and Ctrl + V. However, Excel offers other shortcuts that are nearly as useful....
Most loans and many investments are annuities, which are payments made at fixed intervals over time. Here's how to use Excel to calculate any of the five key unknowns for any annuity.

Excel’s Five Annuity Functions

Financial Functions Charley Kyd - 0
“Help!” the message said. “I know the payment, interest rate, and current balance of a loan, and I need to calculate the number of...
You can use Slicers rather than Validation Lists to control any settings in your interactive workbooks. You're not limited to controlling only Tables and Pivot Tables. Here's how to do it.

Interactive Dashboard Magic with Excel Slicers

Charting Methods Charley Kyd - 0
The figure below illustrates an Excel magic trick I created for an Excel Dashboard, using in Excel 2016. The key trick is the method I...
Although Slicers normally are used with PivotTables and Excel Tables, you also can set them up to control any settings in your interactive workbooks, just as you would when you use Validation Lists.

How to Use Excel Slicers to Control Settings in Your Reports and Analyses

Charting Methods Charley Kyd - 0
The figure below is using Slicers to control a setting in a workbook, a setting that tells Excel's Camera tool which of three images...
Conditional formatting with formulas offers power and flexibility for your Excel reports. Here's how to get started.

Conditional Formatting with Formulas

Conditional Formatting Charley Kyd - 0
Excel offers two types of conditional formatting. Although both types are very useful, one of them is more widely used than the other…probably because...
Mortgage lenders give you many options for your interest rate and amortization period. This workbook helps you to choose from among them.

Compare Loan Payment Options in Excel

Downloads Charley Kyd - 0
When you’re comparing your payment options for mortgage loans, your choices can be overwhelming... When in St. Ives, I found a home, Then looked at seven...
1...171819...22Page 18 of 22