Excel

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

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.
A&A

QuickBooks 2012: What’s New and Improved

If you or your clients use QuickBooks Pro, Premier, or Enterprise, you'll find that QuickBooks 2012's new features will help you gain new insights into financials, get more organized, and save time and steps.
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

Microsoft celebrates 25 years of Excel

Microsoft Excel has come a long way from its humble beginnings 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.
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.
Technology

Under the Radar Part 2: Five New Features in Excel 2010

I introduced you to five subtle changes that Microsoft added in Excel 2010 that I’ve found quite helpful in part one of this two-part series. In this second part of the series, I’ll discuss five more features that have boosted my productivity in Excel.
Technology

Two Ways to Determine Your Top Customers in QuickBooks, Excel

Given the length of the Great Recession, your top customers today might not be the same folks who were your top customers even a couple months ago. In this article I'll demonstrate two ways that you can determine who your top customers are based on total sales.
Technology

Sales/Tax by shipping state in Excel – The power of pivot tables, Part 1

This is the first of two articles wherein Chuck Vigeant demonstrates several ways of approaching Sales and Tax by Shipping State within Excel – one without a pivot table, and one with a pivot table.
Technology

Sales/Tax by shipping state in Excel – The power of pivot tables, Part 2

This is the second of two articles wherein Chuck Vigeant explores the ability to generate a Sales by Shipping State report in Excel.
Technology

Office 2007 Themes Standardize Document Look, Feel

It can be a significant challenge to ensure that your company's documents have the same look and feel, particularly when you're using Excel, Word, PowerPoint, and Outlook together. Fortunately Office 2007's Themes feature can simplify the process.
Technology

Microsoft releases pricing for retail versions of Office 2010

Microsoft is departing from its standard pricing model for its Office 2010 software product by eliminating upgrade pricing. Instead, packaged versions will be licensed for two or three computers, while discounts will be available if a user unlocks a preinstalled version of Office 2010.
Technology

First Impressions of Excel 2010

As you may have heard, the next version of Microsoft's venerable Office suite recently entered "technical preview", or public beta. Excel 2010 seems to offer mostly refinements and only a few wholesale changes.
Technology

Introducing the AccountingWEBinar Series

AccountingWEB is pleased to announce a series of live webinars aimed squarely at the needs of CPAs in public and private practice. This wide-ranging series will cover the following topics:Microsoft ExcelMicrosoft OutlookMicrosoft WordMicrosoft AccessIntuit QuickBooksSage Peachtree AccountingXML/XBRLEach webinar will involve a 50 minute presentation by AccountingWEB staff writer David H. Ringstrom, CPA.
Technology

Three Excel Menus You May Have Overlooked

By David H. Ringstrom, CPASheet NavigationEveryone is familiar with using the arrow buttons in the lower left-hand corner of the Excel screen to push worksheet tabs back and forth across the screen. However, try right-clicking on these buttons instead, and you'll see a menu similar to Figure 1. Simply click on a sheet name to instantly activate that worksheet. 
Technology

Managing Excel Add-Ins

By David H. Ringstrom, CPAAdd-ins are programs that plug-in into Microsoft Excel to add additional functionality. Some add-ins expand Excel's core functionality, while others allow third-party products to add features to Excel's environment. In this article I'll discuss how to enable some of Excel's hidden features, as well as give you some pointers on what to do when third-party add-ins vanish from Excel.Hidden FeaturesExcel ships with several add-ins that you can manually enable. Some of these include: 

Pages


Already a member? log in here.