Need free clipart for your Excel spreadsheets or other documents? Microsoft offers a huge library at www.office.com/clipart
Jan 25
Free spreadsheet-based Form 1040 available for 2010 tax year
By David H. Ringstrom, CPA 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. The spreadsheet includes both pages of Form 1040, as well as these supplemental schedules: Schedule A – Itemized Deductions Schedule B – Ordinary Interest and Ordinary Dividends …
Jan 21
Best Format For Clipart
When inserting graphics into an Excel worksheet, make sure to use the BMP format, particularly as opposed to the PNG format.
Jan 20
Time for Smaller Companies to Learn XBRL
You can run, but you can’t hide! The three-year phase-in period for the use of eXtensible Business Reporting Language (XBRL) is about to hit the last group in the cycle. Effective June 15, 2011 smaller reporting companies (and all other remaining filers using U.S. GAAP) must now attach an exhibit with all their periodic filings. …
Jan 18
BlackBerry productivity apps for accountants
By David H. Ringstrom If you’re like me, you’re still holding onto your BlackBerry with a death grip. However, you might also have app envy because, it seems, every week there are 500 new apps released for iPhone and Android. Fear not, as we’ve unearthed productivity apps for you. And if you’re considering retiring your …
Jan 18
iPhone, Android productivity apps for accountants
By David H. Ringstrom A decade or two down the road we may consider “apps” to be the 2010s equivalent of 1980s shoulder pads and big hair. Spend a minute or two in the app store for your mobile device of choice, and you’ll uncover inane apps like iLickIt. Fortunately, there are some actual productivity-boosting …
Jan 18
Microsoft celebrates 25 years of Excel
By David H. Ringstrom Microsoft Excel has come a long way from its humble beginnings in September 1985 as a spreadsheet program for the Mac environment. This year, Microsoft is celebrating 25 years of Excel with a Facebook-based contest that encourages users to post their favorite Excel memory – with a social media twist. …
Dec 06
Beyond VLOOKUP: Mastering Advanced Excel Formulas
Many users rely on VLOOKUP to return data from other locations in a worksheet, but is that the most efficient approach? Click here to read the full text of the article at AccountingWEB.com.
Dec 02
VLOOKUP tips
In this video David Ringstrom discusses some of the ways that he maximizes the VLOOKUP function:
Nov 30
Under the Radar Part 1: Five new features in Excel 2010
By David H. Ringstrom 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. Granted, after about two weeks, and …
Nov 30
Under the Radar Part 2: Five new features in Excel 2010
By David H. Ringstrom In part one of this two-part series, I introduced you to five subtle changes that Microsoft added in Excel 2010 that I’ve found quite helpful. In this second part of the series, I’ll discuss five more features that have boosted my productivity in Excel. As with part one, there’s an accompanying …
Nov 29
Excel 2010 Tips and Tricks: Part 1
Excel guru David Ringstrom shares some of his favorite tips to make your time spent in Excel easy and efficient. David Ringstrom, CPA, shares some new features of Excel 2010. Click here to read the full text of the article at AccountingWEB.com.
Nov 29
Excel 2010 Tips and Tricks: Part 2
Part Two of Excel guru David Ringstrom’s tips guaranteed to turn you into an Excel pro! David Ringstrom, CPA, shares more features of Excel 2010. Click here to read the full text of the article at AccountingWEB.com.
Nov 23
Five More Under the Radar Features in Excel 2010
In this video David Ringstrom discusses 5 more of his favorite new features in Excel 2010:
Nov 23
Five Under the Radar Features in Excel 2010
In this video David Ringstrom discusses a number of new features in Excel 2010: