To quickly select a contiguous range, click on the first cell in the range and press SHIFT+CTRL+END. Or, for rows use SHIFT+CTRL+left/right arrow, and for columns use SHIFT+CTRL+up/down arrow.
Mar 22
Rounding Numbers To Nearest Multiple
Use MROUND to round a number off to a specific multiple. If cell A1 contains 12.93, in cell B2 =MROUND(A1,0.05) returns 12.95
Mar 19
What Version of Excel is on Your Desktop?
By David Ringstrom Here are seven quick Excel tips for: converting data, amortization 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. Data Conversion Tricks From time to time you may encounter worksheets where …
Mar 19
Excel Tip: Text Boxes
By David Ringstrom, CPA The lowly text box is one of many unsung features in all versions of Excel. While it lurks on the Drawing toolbar of Excel 2003 and earlier, the Text Box icon resides prominently on the Insert tab of Excel 2007 and 2010. Use text boxes anytime you need to …
Mar 07
Seven Quick Excel Tips
By David Ringstrom Here are seven quick Excel tips for: converting data, amortization 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. Data Conversion Tricks From time to time you may encounter worksheets where …
Mar 05
Converting Dates In YYYY/MM/DD Format
To convert yyyy/mm/dd to mm/dd/yy, choose Data, Text to Columns, click Next twice, choose Date, select YMD, and click Finish.
Mar 01
Quick Steps to Take in Advance of Google’s Privacy Policy Changes
By David Ringstrom, CPA If you use any Google products, such as Gmail, Google, YouTube, etc., you’ve probably been bombarded with a blizzard of “hey, this is important, we’re changing our privacy policy” prompts. In theory, Google is simplifying privacy control with a single overarching policy. Cynics, however, may consider this more privacy theater, where we’re …
Feb 03
Free Spreadsheet-Based Form 1040 Available for 2011 Tax Year
By David H. Ringstrom, CPA 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. Reeves’ spreadsheet empowers tax payers …
Feb 02
Excel Tip: Table Feature Enables Effective Analysis
By David H. Ringstrom, CPA Excel 2007 and 2010 users often overlook the useful Table feature, which can streamline data analysis. This feature is a major overhaul of the List feature that has long lurked on the Data menu of earlier versions of Excel. In this article, I’ll introduce you to the Table feature and …
Feb 01
On the Horizon: A New Version of Microsoft Office
By David H. Ringstrom, CPA Microsoft announced that the next version of its flagship productivity suite has entered the “technical preview” phase of its development cycle. This program allows Microsoft customers to test and provide feedback on what’s currently known as Office 15. This testing phase is a precursor to the public beta testing program …
Jan 31
Instant Amortization Table
Add amortization table to any Excel workbook-Right-click worksheet tab, choose Insert, double-click Loan Amortization on Spreadsheet Solutions tab
Jan 28
Excel 2010 Filtering Trick
Filtering a list for blank rows in Excel 2010? Type a single parentheses “(” in the Search box instead of unclicking Select All and scrolling down.
Jan 13
Deloitte Buys Boutique Mobile App Firm
By David Ringstrom Big 4 accounting firm Deloitte started the new year by purchasing Seattle-based Ubermind. The 200-person firm develops mobile apps, e-commerce, and content management solutions for such companies as Apple, Target, Alaska Airlines, TruTV, Amtrak, and REI. The acquisition is designed to complement the range of services that the 180,000 person global services …
Jan 10
Print Scale Trick
Monitor your printout size from anywhere in Excel 2007/10: On Page Layout tab, right-click on Scale, then Add to Quick Access Toolbar.
Jan 10
Spanning Excel Across Multiple Monitors
To span Excel across two monitors: double-click on words Microsoft Excel at the top of screen, grab lower-right corner of window and resize