Excel tips

Technology

Excel Tip: Calculating Interest

In his latest article in our Excel Tips series, expert David Ringstrom explains how to calculate interest within a single worksheet cell.
Technology

Managing Excel Add-ins

In his latest article in our Excel Tips series, expert David Ringstrom explains how to manage Excel add-ins, including all the toolbars, ribbons, and headaches that come with them.
Technology

Is This Excel Worksheet Protected?

David Ringstrom's latest Excel tip will show you how to make sure your worksheets are protected.
Technology

Using Clip Art in Excel Charts

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
Technology

Automating Excel Chart Titles

In this, his latest article in our Excel Tips series, expert David Ringstrom shows you how you can further automate your chart with a self-updating title.
Technology

Automate Excel Charts in Two Keystrokes

David Ringstrom shows you the typical way most users add data to a chart. He then shares a simple technique that eliminates this mundane need.
Technology

Excel Tip: Calculating Straight-Line Depreciation

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
Technology

Excel Tip: Automatic Backup of Key Excel Workbooks

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
Technology

Excel Tip: Data Entry Shortcut

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
Technology

Excel Tip: Pasting Text into Excel 2010

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
Technology

Excel Tip: Using Today() versus NOW()

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
Technology

Excel Tip: Text Centering Trick

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
Technology

Excel Tip: Text Boxes

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
Technology

Seven Quick Excel Tips

Here are seven quick Excel tips for: converting data, amortizing tables, spanning Excel across multiple monitors, filtering for blank rows in Excel 2010, recovering unsaved workbooks in Excel 2010, identifying duplicate values in Excel 2007/2010, and recovering damaged Excel workbooks.
Technology

Free Spreadsheet-Based Form 1040 Available for 2011 Tax Year

Glenn Reeves of Burlington, Kansas, recently released his fifteenth annual spreadsheet-based version of the U.S. Individual Tax Return, commonly known as Form 1040. Since 1997, Reeves has pursued this "labor of love," which means he allows any taxpayer to download and use the spreadsheet for free.
Technology

Excel Tip: Table Feature Enables Effective Analysis

Excel 2007 and 2010 users often overlook the useful Table feature, which can streamline data analysis. The feature is a major overhaul of the List feature that has been on the Data menu of earlier Excel versions. This article will introduce you to the Table feature and show you how it can help you work faster.
Technology

Everything you need to know about Excel range names

Are you familiar with the range names feature in Excel? It is one of the most powerful tools that even the most basic Excel user can easily master. Name a cell or a block of cells and then work with those cells in formulae and searches throughout the workbook.
Technology

Excel Tip: Multiple criteria SUM, MIN, and MAX formulas

Most Excel users are familiar with the SUM, MIN, and MAX functions in Excel. Used in their traditional fashion, you provide a range of cells to the function to derive a result. However, in certain cases you may wish to use this functions based on multiple criteria.
Tax

Free spreadsheet-based Form 1040 available for 2010 tax year

Glenn Reeves of Burlington, Kansas, has created a free Microsoft Excel-based version of the 2010 U.S. Individual Tax Return, commonly known as Form 1040.
Technology

Under the Radar Part 1: Five new features in Excel 2010

I have to admit, I was underwhelmed when Office 2010 was released. You’d think that an Excel expert would like nothing more than a shiny new version of Excel, but my initial experience with the new user interface in Excel 2007 left me feeling chastened.

Pages


Already a member? log in here.